Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 09-20-2008 20:37:03

rocketcity
Member
Registered: 09-01-2008
Posts: 25

Importing categories

Just started working on the trial.. Everything seems to be working.  So far have added some categories and products manually.

No trying to do a bulk upload of the "cat.csv" file I get this error.
Warning: All Raw Database Admin functions are unguided. Deletion of and changes to system data, tables and table columns can result in making this software inoperable. Be careful.

The CSV file you uploaded could not be read. It does not appear to be a properly formatted CSV file that can be used by this import function. Review the CSV File Information section for information on how this file should be formatted and make sure all of the table columns were represented on the first line of the file.

I'm pretty sure I have all the right formats.

Separated by:
Tab
Comma

Text Delimiter:
"
Any ideas to get this working?  Have about 5000 products to upload after this

Brian

Offline

 

#2 09-20-2008 21:32:50

dh783
Moderator
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Importing categories

What os system are you running in?

When importing it needs to be a comma seperated list, and the file imported must contain all of the database column names for the database you want to import.

John

Offline

 

#3 09-20-2008 21:56:34

rocketcity
Member
Registered: 09-01-2008
Posts: 25

Re: Importing categories

John,
I have all the column names as required.  This was done on leopard 10.5   I even tried it on windows Xp also

Offline

 

#4 09-20-2008 22:45:49

dh783
Moderator
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Importing categories

Well if your using a mac and excel then you will need to save the file as CSV (Windows) , which is the only format that will work.

John

Offline

 

#5 09-21-2008 10:55:59

rocketcity
Member
Registered: 09-01-2008
Posts: 25

Re: Importing categories

I have now tried 4 different windows csv editors including excel..   None work!  I give up

Offline

 

#6 09-21-2008 11:26:02

dh783
Moderator
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Importing categories

I am running on a mac and excel works for me as I said saving it in the CSV (Windows) formate. Did you export the the curent entries in the ccp0_cat database and then make your changes in that exported file? I ask just to make sure that you are working on a file with the exact columns names present in your current database.

John

Offline

 

#7 09-21-2008 12:10:40

rocketcity
Member
Registered: 09-01-2008
Posts: 25

Re: Importing categories

John,

Yes I did that.. all the column names are present..  I do not get the option to save as CSV (Windows) format? just the following:

CSV comma delimited
CSV MSDOS
CSV MAC

Offline

 

#8 09-21-2008 12:31:21

dh783
Moderator
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Importing categories

The CSV (Windows) format is specific to the Mac version of Excel, version Service Release 1 in my case. If you tried all the formats listed above and none work then I would just start at the top of the format list and test all the rest, which is what I did in my case to find the one that worked.

John

Offline

 

#9 09-22-2008 09:43:45

rocketcity
Member
Registered: 09-01-2008
Posts: 25

Re: Importing categories

John,
This morning I re downloaded the cat_export file and reentered my new data.. It worked!

Thanks for your help..

Brian

re:  Worked from a Mac using Neooffice CSV

Offline

 

Board footer