- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
VI not picking up the right column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
06-10-2010 12:51 PM
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.
Re: VI not picking up the right column
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
06-10-2010 01:35 PM
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.


