2. PHPRunner General questions
  3. Importing Error
This topic is locked

Importing Error

 		5/8/2020 16:42:41
PHPRunner General questions
R
 RBrogen author

Hi All,
I'm trying to import some data into my app via a tab delimited file and I have a column that contains LastName, FirstName. I can't get the import to work because that column contains a comma, but it needs to in order to properly pre-populate the database. Any thoughts on how I can get this to import? Thanks in advance!
Best,

Randy
Sergey Kornilov admin 5/8/2020

I'm not 100% sure what is happening there but you can import this file into Excel first and then import it into your database.
R
 		RBrogen author 5/8/2020



I'm not 100% sure what is happening there but you can import this file into Excel first and then import it into your database.


Thanks for the reply. Unfortunately it drops the leading zeros for the zip code if I import the XLS even if I format the column to be Zip and it shows the leading zero in the spreadsheet. As soon as I go to import it, the data displays without the zero that is being imported.
Sergey Kornilov admin 5/9/2020

I'm pretty sure that after import to Excel you can change column format to text after import to preserve the leading zeroes.
R
 		RBrogen author 5/9/2020



I'm pretty sure that after import to Excel you can change column format to text after import to preserve the leading zeroes.


Yes after you import into Excel you can format column to preserve the leading zero, however, when you then save as a delimited file, and then load that into the import screen, the leading zeros are not displayed in the field mapping nor in the import.