Adapt Csv File

Adapt Csv File
Hi,

The main job of this project is the adaptation of the csv file to be automatically imported to our store every x hours.

The program must perform 3 functions for this:

– Adapt a csv file that one of our supplier give us.

– Find and download some information of our products to be completed the second list that other provider give us.

– Build the final csv file with these two parts, having previously defined the selection of products and prices to be exhibited permanently in the store.

Please note: We need to contact only with professionals with proven experience in this type of work. All aditional details will be provided privately.

Thanks!

Joomla Drupal Or WordPress Sit

Joomla Drupal Or WordPress Sit
I’m wiling to pay $90-140 for this work. It must be done in 15 days or less. My client is going to purchase a drupal, joomla, or wordpress template for her site. This template will need to be installed and the look will need to be modified anyway she wants for her property type site. You will also need to plugin this broker software. That company says you can just plug in the code anywhere.

Oscommerce Site

Oscommerce Site
I’m willing to pay $100-$160 for the work.

I need an oscommmerce site made form a jpg. Sadly all the client has is a jpg not a psd. I can give you a simple free oscommerce template fi you want to work on it, but really you can make the other pages of the site look anyway you want This will just be the homepage design to go off of. Any design changes the client wants will need to be made.
Also of course this will need to be installed on the client’s server.
The client is going to use authrize.net or another merchant account for the payment.

I don’t have all the pricing at this time. The above are websites of the products I will have. I won’t have all these products. I would probably say I would have no more than 500 products total including vitamins/herbals and other front shop pharmaceuticals.

Re the concept page I sent you, here is the last email I sent the previous designer + I’ve attached a link for the concept page links.

1) “Feeling Better with Pharma Health” should also be in upper and lower case.

2) “Action Buttons” should be in this order

Rx BUY

DRUGS HEALTH

-as per original email and our conversation this week, I would like there to be a square (instead of a rectangle) and in the middle of each square I would like a round large button -like the buttons on a plan cockpit or a race car-
the description of the button would go around it in a circular fashion above and below the botton

-the square could be Green with Gold Letters, the button could be White with Red Key Word (Rx, BUY etc). When the key word is pushed or the mouse hovers over the button, it can change from white to Red Button with White key words.

The specific wording around the Buttons are as follows:

Rx – Fill or Refill Your (above button in circular fashion)
Prescriptions ( below the button in circular fashion

BUY – Purchase National Brand & Generic (above)
Over the Counter Items, Vitamins & Herbals (below)

DRUGS – Drug Information on Prescription, OTC (above)
, Supplements and Herbals (below)

HEALTH – Health Topics & Information (above)
on Disorders and Conditions (below)

The Rx button will not open to an online store – it will open to 2 choices New Prescription – which will just have typed information and how to get it filled for example http://www.globaldrugs.com/pharmacy/clsearch.htm and Refill Prescription – which will be a form with typed information plus a grid similar to https://www.globaldrugs.com/refill.htm i.e. a spot for patients name, address phone number, Rx number and name of drug (total of 12 lines), choice of delivery or pick up,etc

BUY – will open up to the online store which could initially be divided into 2 sub categories 1) Over the Counter Products and 2) Vitamins and Herbals

DRUGS and HEALTH – will open into each respective category under the Medline Plus database

-remove the pictures on the rectangular buttons and these pictures could be used after the buttons are pressed if appropriate

3) Category Headers at the top – we discussed making them into a shape of a capsule with bigger font – it looks like not enough room so just replace Over the Counter and Natural Remedy with the words Front Shop Products or simply Front Shop
-maybe you can move Location and Hours on the top left corner – opposite side to View Cart/Sign In/item in Cart – this would give more space for larger capsule buttons.

-colour of these could be Hunter or Emerald Green with Gold Letters and they could change to Gold Capsule with Green Letters when hovering over each

-we also talked about making the heading smaller (I don’t know if this was done) and increasing the font size of the various words
-also I’m noticing the medline search bar doesn’t need to have Search Medline Plus twice – is it possible to make those 2 bars look more similar

4) Picture – I mentioned to remove the words on the picture and have a line underneath the picture where I could input text
, also, the pictures would change as a slide show

5) keys on the side – I would like them to be a Gold Key with Green Letters, I’ve attached the spreadsheet which I sent before for the corresponding links to these buttons , some however (the first three) are not links – they are specific to my store and will open into subcategories with corresponding text (description of services). In this case, perhaps these first 3 buttons could be distinguished from the remainining ones underneath – perhaps these 3 buttons could be a capsule shape similar to the headings going across left to right.

6) Since there is room under the square with facebook, hotmail, etc – please insert OCP logo and certificate of accrediation there – this will be a link to the college of pharmacists website as well as a scan or adobe document of my stores pharmacy license.

7) – we talked about a spot for flyers, events, etc that could be loaded up using Adobe

8) I think if you used the colours I suggested – GOLD, Hunter (Dark) or Emerald Green for the buttons (except for the red I requested), then I think the lime colour would fit in well. I think right now there is way too much mustard (yellow) colour then I would like. Instead of that, try using the Lime to fit in along with the Gold and Hunter/Emerald Colours and I think it would be more of what I’m looking for as it would match the colours I use in my store.

9) Reg the Product Page – again Prescriptions would not open up to the online store – the online store would be made up of 2 categories 1) Over the Counter as well as 2) Vitamins/Herbals

Over the Counter has the following categories:

Acne
Allergies
Arthritis
Asthma
Blood Pressure Care
Cholesterol Care
Diabetes Care
Cough, Cold, Flu & Congestion
Digestive Care
Feminine & Family Planning
Eyes, Ears, Nose & Throat
Hair & Scalp Care
Home Testing Products
Infections of Skin
Pain & Fever Control
Skin Care
Smoking Cessation
Sleep Aids
Weight Management & Nutrition
Wart Removal
Personal Care
Household Items
Dental Care
Baby Care
First Aid & Injury Supports
External Pain Relief
Gifts & Clothes
Medication Compliance Aids
Home Health Products

(above can be in alphagetical order)

Natural Remedy Wellness Centre has the following categories

Vitamins
Herbals

-each category could have an associated picture that could be automatically chosen as you suggested

Openrange+zencart Integration

Openrange+zencart Integration
Hi
I need some help in intergrating 2 databases as follows.
1) Database 1 contains the products manufacturing codes , manufacturer name and prices.(its zencart database)
2) Database 2 is from data providing ompany, this contains detail product descriptions, images link, products attributes, manufacturer name and codes but no product price or stock information.

I need to integrate both databases so that ustomer at my site can have a detailed presentation of the products.

Regards

Fix My Mysql Query

Fix My Mysql Query
I need someone to provide me with the proper MySQL syntax for the query described below.

When running my current query code (listed below), I’m receiving the following error in MySQL:

[Err] 1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) and entry_horse.entryID = T2.entryID(+) and entry_horse.entryID = T3.entryID(‘ at line 13

### My query code:

SELECT student.studentID, student_name, count_of_tests_started_by_student, count_of_tests_failed_by_student,
count_of_tests_passed_by_student, count_of_tests_currently_incomplete_by_student
FROM
( SELECT COUNT(*) AS count_of_tests_started_by_student, studentID FROM test GROUP BY studentID ) AS T1,
( SELECT COUNT(*) AS count_of_tests_failed_by_student , studentID FROM test WHERE test_result = ‘failed’ GROUP BY studentID ) AS T2,
( SELECT COUNT(*) AS count_of_tests_passed_by_student , studentID FROM test WHERE test_result = ‘passed’ GROUP BY studentID ) AS T3,
( SELECT COUNT(*) AS count_of_tests_incomplete_by_student , studentID FROM test WHERE test_result = ‘incomplete’
GROUP BY studentID ) AS T4 ,
student
where
student.studentID = T1.studentID(+) and student.studentID = T2.studentID(+) and student.studentID = T3.studentID(+)
and student.studentID = T4.studentID(+)

Here’s the details for what I need:

i have two myisam mysql tables (student and test). i need the query to return a row for every student in the student table and each returned row should contain the following columns:

* studentID
* student_name
* count_of_tests_started_by_student
* count_of_tests_failed_by_student
* count_of_tests_passed_by_student
* count_of_tests_currently_incomplete_by_student

The STUDENT table contains:
* studentID primary key (1234)
* student_name (john doe)

The TEST table contains:
* testID primary key (1234)
* studentID (1234)
* test_result (“passed”, “failed”, “incomplete”)

Each student may have any number of TEST table records (zero or more).

In my quest to debug the error in my query code, I’ve tried to get the following simpler query code to work. But, I can not even get the following query to work without getting the MySQL syntax error message:

SELECT student.studentID, student_name
FROM
test ,
student
where
student.studentID = test.studentID(+)

Solid Seo Posts Resource Blog

Solid Seo Posts Resource Blog
Looking for solid seo posts for blog.

We have recently launched a new blog, however, we will also be trading from this blog/website, so we only want good well written, clear english seo posts, or related to seo or domains.

Some of the categories are as follows

* Domain Names
* SEO SEM
* Google Optimisation
* Internet Directories
* Keyword Optimiser
* MSN Optimisation
* SEO Software
* SEO Tools
* Yahoo Optimisation

You may write your copy based upon offerings from other websites, eg if you see an seo tool, simply write a post about it and where to find it. Id it good bad or poor etc

We want brutally honest posts, if its poor say so, if its great, shout about it.

As much work as you can handle.

The work must be your own and copyright free.

Prices per post or price per volume required.

WordPress Plugin (guestlist)

WordPress Plugin (guestlist)
I need a wordpress plugin that allows visitors to submit their names to a guestlist. The guestlist plugin must have an administration section and must be database driven.

The point of the guest list would be for the first x number of customers to add their names to a list so that they can enter the event without waiting in line. A new guest list would be created every week.

Front-End
Users would login and then fill out a simple form (Name, email address and phone number, and how many additional guests they would be bringing).

If a limit has been added to the guest list, for example, only 100 names can be on a guest list, then the plugin would inform the applicant if the guest list is full.

The total number for the guest list should include the actual applicant and his/her guests. A limit should also exist for how many guests an applicant can bring.

Back-End

Ideally, all entries should be accessible from the back-end so that it can be printed off for use the night of the event.

The administrator should be able to add names to the guest list manually too.

A ‘Guest List’ should be treated as an event based on the date it was created.

All entries should be editable. Meaning the administrator should be able to edit each entry in a Guest List.

The plugin should be expandable to include future features that would integrate Customer Loyalty programs and marketing.

Auction Website Makeover

Auction Website Makeover
We have auction website (phpprobid) with enhanced functions and want complete website makeover and extra functions.

Layout must be inviting ,clear and header look something like http://www.daniweb.com/ or http://www.howtoforge.com/

corporate logo

And i want all function and website to be like ioffer.com

this means forms to be easy and adding new functions like shoppingcart and new payment options and many more…

Right now we also have oscommerce importer, which we want to modify, so that shipowner can choose to sell directly from auction website, means buy now only, or to have the buy now button to go to his shop, like affilate websites use

Google AdSense is paying our bill right now, we want to have option to turn it off by the user by paying x amount via sms or phone or other means

integration of vchat, we already got this in, but must integrated into the website, its like messenger, later we can use desktop version of vchat perhaps.

message me for my current layout

i have a ready to start development clone of the script already on my server

Flash Template Customization 2

Flash Template Customization 2
I Have a very easy flash template for customization, I’ve already done many parts of it but since I need the website ready sooner I’m going to give it to a freelancer.
Basic some text changes and picture changes and small structure change.
Attached you can find the proposal word document of required work.
The Template we’ll work on is :
http://www.beautywebtemplates.com/flash-templates/tm-14816-gorgeousness/420/
Please note :
If you bid on this project, you accept and do agree that you’ll get paid ONLY Upon my complete satisfaction of the final work.

“DO NOT BID OVER MY BUDGET PLEASE”.
Have good bidding.

Website Creation & Design

Website Creation & Design
Dear Programmers:
Im looking for a programmer that be able to create a website as scriplance,and bring traffic ,new clients,,the website should be more friendly and must be able to recieve payments from paypal, moneybookers ,alertpay and Liberty reserve. the tabs should be the same,also I need to have a webpanel for administrators.
Thanks Carlos Alvarez