Sage 100

Working with Visual Integrator for a client who downloads a .csv file from their website. The client has recently had changes to their website. Prior to the change, the .csv document the website created worked seamlessly with visual integrator. After the website update the VI job is ignoring the first line of the .csv document the website creates. If I look at a .csv in notepad from before and after the website changes they look identically formatted. The website developer is stumped, as am I. Any ideas?

As a test, can you have the website generate an .xls, and then _you_ convert it to .csv - and try to import.

Are there any exclusions on the Record tab?

You know how the Crystal export to CSV has an option for Standard vs Legacy (which has been deprecated, dontcha know)? I found that if you use Std there is a character at the start of the first line that you can't see and it screws everything up. Perhaps something like that is affecting their export?

No there are not any exclusions. It just ignores the first line like it doesn't exist. THANKS!!

What does the VI log say??

Open the file with NOTEPAD++ to see is that are some control characters in the beginning . you might need to concatenate a record to the front of the file.

Also in NotePad++ look at the character encoding for a working file and a non-functional file.