Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
dhalpin
Posts: 258
Registered: 11-26-2008
0

VI not picking up the right column

We've had several large imports (SO, PO, AR, AP) using visual integrator this week and for the most part it is going well. However, a few times we noticed that VI is picking up data in the column before the column specified on the job. This is not for every item. It's only for a handful and it's sporadic. To get it to work, we tricked the job but putting the same data in both columns, but since it's happened on more than one of our jobs, we thought we'd mention it to see if anyone else has had a similar issue. Also, is there any way to hold the formatting of a .csv file? Everytime we do an import we have to format columns for zip codes, divisions etc and it never holds. if you go back into the spreadsheet all the formatting has to be done again else records will fail. Mas90 Version 4.40.1. Import file is a .csv.

Sage MAS Partner
6538
Posts: 70
Registered: 12-14-2008
0

Re: VI not picking up the right column

a .csv file does not contain formatting.  it is basically a text document separated by commas instead of tabs.  To see what your csv file actually looks like you should view it in notepad.  Also, note that opening it in Excel and then saving to a csv can cause data corruption since Excel will try to reformat the cells (typically an issue with dates and phone numbers) and when you resave to a csv it can sometimes keep the modified format.