2. PHPRunner General questions
  3. IMPORT PROBLEM
This topic is locked

IMPORT PROBLEM

 		3/12/2009 11:01:01 AM
PHPRunner General questions
M
 melzy author

I am working on a application, not being a saavy php programmer, I am a bit lost.
We need to allow admins to import new dealer records into our dealer master file.
I exported the existing data via the export page of the app.
Used the resulting file as a template to create a import file, field names that were exported are the first record of the .csv file.
However when I try to import the .csv file back in with additional records. I get
Error: in the line errors for all records and the below message.
Number of records: 3

Imported: 0

Not imported: 3
Not sure what the problem is.?
hfg 3/12/2009

One of my biggest issues with importing is with dates. If you use Excel to modify the csv files this can be a headache.
Do an export from you system

Open the csv file using notepad or some other text editor

Note what format the dates are in
I have found that it is important that the format you try to import is the same as what is already there.

Excel, csv and dates don't mix well. If you don't have a lot of records to modify just use the text editor to make the change.
Just a guess
Sergey Kornilov admin 3/12/2009

Mark,
I recommend to post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL and CSV file in question.