Pages: [1]
Print
Author Topic: Difficulty importing Data file  (Read 372 times)
Custom Mosaics
Pre-Sales
Newbie
*
Posts: 3


« on: July 29, 2010, 11:52:22 AM »

I am getting the following error when I go to import my data.

DATA UPLOAD TERMINATED
The number of fields in your data file is GREATER
than the number of fields specified in your Import Profile.

I can't fing anywhere in the documentation how to append the import profile.

when I upload the us_filter.txt file it uploads fine as well as the all_courses.txt file.  however I get that message when I try to upload my data.  it is a csv file created in excel saved to a .txt file in notepad.  Any help is appreciated.  Thanks
Logged
Support
Administrator
Jr. Member
*****
Posts: 93



« Reply #1 on: July 29, 2010, 12:50:02 PM »

The number of fields in your data file probably falls short of the number LiteRadius is expecting. When you uploaded us_filter.txt, with the default upload profile, there is a one-to-one match between the columns of data in us_filter.txt and the number of defined columns in the upload profile (location_id, name, address_1, address_2, etc.).

If your data file doesn't have at least the same number of fields as us_filter.txt, then LiteRadius won't upload the file.

For example if you have the following data file with one record:
Quote
1,Fast Company, 123 Main St., Rochester, NY, 14602, 585-555-5555

Then the upload profile would need to be:
Quote
location_id, name, address_1, city, state, postal_code, phone, IGNORE, IGNORE,......, IGNORE
Logged
Custom Mosaics
Pre-Sales
Newbie
*
Posts: 3


« Reply #2 on: July 29, 2010, 01:10:18 PM »

Thanks,  that was it.  I didn't make the connection of having to match up the fields before trying to upload the data file.  I appreciate the quick reply.
Logged
Pages: [1]
Print
Jump to: