Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are some common import problems?

April 26, 2017common import problems

0

Posted

What are some common import problems?

1 Answer

0

Posted

There are several common file import problems you should check: • Make sure you have a comma or tab between each and every field in the record (comma or tab delimited text). • Put double-quotes around each field in the record. This is not required. However, sometimes data can contain unexpected commas (such as in “Smith, Jr.”). • Make sure each line ends with a carriage return/line feed. This a frequent problem when the import file has been generated on a mainframe or mini computer. • Do not add extra spaces around data. • Remember that dollar amounts must have a decimal point and two digits to the right of the decimal. 101 is wrong. 101.00 is correct. • Do not include currency symbols or commas in dollar amounts. $1,000.00 is wrong. 1000.00 is correct. • Check your import template. You should not be able to see double-quotes in the field view in the upper-right of the import dialog. If you see double quotes, check the Has Double Quotes box.