A user remotely enters invoices and export the batch under CSV format. Then she sends the exported batch as an attachment via e-mail to her main office. All their customer numbers are 3 digits in length.

Main office will import the batch and post it. Everything went ok, until they added some new customers with 4-digit numbers, say 1008. While posting that batch, the programme will drop "8" the 4th digit and allocate the transactions to customer number 100. Very strange. Need your help.

Zafi

Hi Zafi,

If this is CSV format, then this is not possible because customer numbers can have up to 6 characters and string fields are contained in quotes. Make sure that this is the case.

Do the import files get edited in Excel? This can cause problems with CSV-formatted files and also string fields that contain strictly numeric characters (which happens to be the case with these customer numbers).

Also with Excel, make sure that column widths are 'auto-fit' - I have seen strange things when a column is shrunk in Excel and all information in the cell is not able to be displayed. This can be avoided by selecting the whole sheet and choosing to auto-fit columns.