CSV Import Utility Installation? - It doesnt say how to install any where?

[PriceTrim]

Any clue how to install either of these 2. They dont have directions any where that I see?

http://www.oscommerce.com/community/contributions,607/category,all/search,csv

or

http://www.oscommerce.com/community/contributions,401/category,all/search,csv

...... If you have installed either of these, can u give me a quick run through or post the directions please....

[mitchind]

Haven't used it but noticed that the author's name is in the file

Matt Anderson (mra@vt.edu)

[YvetteKuhns]

Download and unzip the file. There is actually only one file named index.php that has the instructions in the top of the file. Be sure to read the limitations. You were probably expecting a readme.txt file. ;)

[mitchind]

They dont have directions any where that I see?
You're right - I wouldn't really call them instructions. It doesn't tell you where you have to put the file - or if it replaces a file. Best bet is the author

[YvetteKuhns]

http://www.oscommerce.com/community/contributions,607/page,4

This script is standalone from the administration modules, is contained in one file, and is run by viewing it in your web browser (don't forget to secure the folder where it resides!).

Make a secure folder on your browser such as CVSimport, then type http://www.yourdomainname.com/CVSimport/index.php to run the script.

:)

[mitchind]

Good job :)

I'm glad that least one of us can read ;)

[YvetteKuhns]

I can spell TWO! :D

[Skunkboy]

Spelling .. yes. Grammar .. now that's a different subject. :cool:
[/hijack]

[YvetteKuhns]

Spelling .. yes. Grammar .. now that's a different subject.

Actually, I can be grammatically correct, but sometimes that can make me appear stuffy or confuse the person to which I am speaking. Or the person I am speaking to. ;)

[stevel]

"the person to whom I am speaking" :D

[YvetteKuhns]

"the person to whom I am speaking"

"the person with whom I am speaking"

:D

[PriceTrim]

Ok, thanks this really helped A LOT worked the first time around as far as uploading and testing the script. Now, all I need to know is, how do I find out the format to put my CSV for OsCommerce?

For instance, Row A (down) Item Name, Row B (down) Price, ect. Same with side numbers, does any one have the correct format for this? Or does this script do it automatically.

[YvetteKuhns]

Check the output of your script. I think it does it automatically, but since I didn't try it, I am not sure. Post here to let us know what it does. Thanks.

[PriceTrim]

You can view the file.CSV file in the subfolder to see the actual format. I need to configuire all the MySQL stuff and figuire out what permissions to CHMOD it too, an then I will test it out again to make sure its fully working.

I just have to search to find where the temp stuff is on the actual database for this line in the script.

$db_server = ""; // mySQL server address
$db_user = ""; // mySQL user
$db_pword = ""; // mySQL user password
$db_name = ""; // Database name
$db_table = ""; // Temp import table name

Soon as I figuire that one out I will be good to go!

[coldhead]

just modify the bits you have shown...

$db_server = "mysql??.powweb.com"; // mySQL server address, change ?? to suit.

$db_user = "yourmysqlusername"; // the mySQL user you have defined for the osCommerce database.

$db_pword = "yourmysqlusernamepassword"; // ditto the mySQL user password.

$db_name = "osCommerce"; // if that is in fact the osCommerce Database name.

$db_table = "anytemptablenameyouwant"; // Temp import table name, used to import the csv into b4 updating proper tables I presume.

Hope this helps.

[PriceTrim]

did every thing, an its still only saying 1 product uploaded.... an theres a good 50 or so products in my CSV file...

If any one has already figuired this out and knows how to install it quickly, can you let me know if it has to be in the osCommerce folder, an any other details... right now its just not working...

[tresrhnter]

I use the easypopulate contrib to upload a csv file to my oscommerce store. it also creates a froogle feed.