What formats of data can be imported?
What format can data be imported? I have a Palm application Autobase that exports into tab delineated text files. I was wondering if CSV files (for which I would convert my backup files into) could be imported.
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?CSV files can be imported, yes. Try it out at the Car Care import webpage before you buy Car Care to format your data for the import webpage properly: if you've done it correctly, you should get a vehicle code and password at the end.
Car Care import webpage: http://www.karlbecker.com/carcare/imp...
One note: currently, comma-separated files do not support "quoted" literals, so you cannot put a quote around some text that contains a comma. Example:
Valid input:
Odometer,Entry Type,Notes
1045,Gas,New York NY
Invalid input:
Odometer,Entry Type,Notes
1045,Gas,"New York, NY"
The import webpage will look at that and say "oh, there are four items on this line, not three." I plan to change this in the future, but for now that's how it behaves.
The company says
this answers the question
-
Inappropriate?You can not put ' in entires (ie Bob's Warehouse). The import tool will drop that line. This is in tab delimited at least.
---
Also it is annoying that the file read tool will recognize more dates than the import tool.
For example 2007-02-10 11:00 works. February 10, 2007 will get read in as 2007-February-10 0:: but when imported it gets 0000-00-00 00:00:00. This is fine, but annoying that one tool recognizes the format and the second does not.
Would be nice if you sample data include an example of all the fields - like date.
Loading Profile...


