By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Preprocessor for csv file

P: n/a
Hi Guys,

Hope someone here could help point me in the right direction for this
little project.

I want to get a online computer store up and running.

I get files once weekly from about 12 different distributors. I might
get ASUS video cards from one distributor and Albatron video cards
from another. The problem I have when importing these files to
oscommerce with easy populate is that one distributor might call video
cards "VGA Cards" and another might call them "Graphics Card".

When I import the list of video cards I end up with two catagories,
when in reality there should of course only be one. This happens on a
variety of things, not just video cards.

I need to do some preprocessing to get the files having uniform groups
before they are imported.

I think I can do this with php and some arrays, but its been a while
since i have done php and a outline of the structure or even a few
lines of code would be a great help.

All the files that I get from the distributors are in csv format.

Thanks heaps in advance,

-Al

Jun 4 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
At Mon, 04 Jun 2007 02:23:26 +0000, BigAl.NZ let h(is|er) monkeys type:
Hi Guys,

Hope someone here could help point me in the right direction for this
little project.

I want to get a online computer store up and running.

You want to get a shop up and running? Are you sure your homework
assignment isn't just telling you you are? It's not forbidden to tell you
have an assignment.

Sh
--
Schraalhans Keukenmeester - sc*********@the.Spamtrapexample.nl
[Remove the lowercase part of Spamtrap to send me a message]

"strcmp('apples','oranges') < 0"

Jun 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.