cvs and easy populate help please. DBF to csv to MySql

**prisiri** · 02-21-2005, 03:05 PM

Ok

I did a search, read csv related posts but its still not clicking

I have a databse in dbf. I am trying to upload it using the easy update feature.

I can convert this database to csv. no problem there.

My question is as follows.

My database fields have all diferent names than the csv i downloaded from my OSC store.

Do I have to change the field names in my dbf created database?

Or can I use the field names i want to?

Thanks in advance guys

**neil** · 02-21-2005, 03:49 PM

Yes.
Make a back up copy of your .dbf.

Once you dbf is converted to csv - open it in Excel or similar spredsheet program - Use Edit > Find > Find & Replace to change over your field names.

NOTE: Every product must have a unique id usually Field A - v_products_model & the last field must be EOREOR.

{Easy Populate is a .txt file. In Windows - right click on it & "Open With" Excel.}

Must be saved as a tab delimited text file before inserting it into the database..

**prisiri** · 02-21-2005, 04:31 PM

Cool. Thanks Neil.

Now a bonus question

How do I get the (BLOB) replaced in spreadsheet program, with the actual image name when i open it in excell(actually openoffice)?

thanks again

**neil** · 02-21-2005, 05:03 PM

Good question,
Maybe some reverse engineering to see which BLOB relates to which image or how they are mapped to the individual records.
I'm guessing if you exported the database to excel this may provide you with their file names. Good luck.

**prisiri** · 02-21-2005, 05:59 PM

ha ha

Thanks.

That blob didn't work too good. it wa sabed in csv as blob

I had only 20 records and pics names are basically the model names so it was an easy task.

I still need to figure a way to convert that blob field to actual image name.

I have 300+ records to create so....

I'll let u know what I come up with.

Thanks again.

**neil** · 02-21-2005, 06:37 PM

The field heading for images is v_products_image
Eg. image579.jpg
FTP image579.jpg to the catalog/images directory.
EP locates & displays image579.jpg relevant to that record.

**prisiri** · 02-21-2005, 07:39 PM

Yes I know that.

The problem Im having is with my dbf conversion to XLS MyImages.jpg are converted as (BLOB)

so before uploading i have to manualy alter that fields record.

My dbf program stinks

**prisiri** · 02-22-2005, 07:40 AM

DUH

I have to create a seperate field for the image name in my db.

i had the actual image in my db so I guess it was basically a lnked reference to the image location

Thanks 4 the help

**neil** · 02-23-2005, 02:29 AM

Correct:
In EP you have a seperate field for images - heading is v_products_image
Eg. image579.jpg
FTP image579.jpg to the catalog/images directory.
EP locates or links to image579.jpg.

Note: You can also have widgits/image57.jpg as a reference in your images field of EP (v_products_image)
FTP image57.jpg to the catalog/images/widgits directory.
EP locates or links to image57.jpg in that directory.