Hello,
I've created a VI job to import Sales Orders. All fields work perfectly with the exception of the Quantity and Price. The import log shows both fields as blank, even though the amounts are in the selected columns. I also tried setting the amounts as Assigned, when doing so the quantity did populate but the price did not. Any ideas?
That did it! I should have noticed that! I opened it up and just assumed it was a word wrap issue but low and behold it wasn't. Thanks for the help!
There is a comma and line feed in your image, both of which will cause problems (although you may just have word wrap enabled while taking the image).
The comma I have outlined in red is interpreted as…
Yes the file is in .CSV format. I already checked for commas in the other columns which is not the case. Typing in manually doesn't produce any pop-ups.
There is a comma and line feed in your image, both of which will cause problems (although you may just have word wrap enabled while taking the image).
The comma I have outlined in red is interpreted as the end of that column, with the next field interpreted as the double quote character instead of 4300.
Change your column layout to put the numbers before your comment text and your problems may disappear.
There is a comma and line feed in your image, both of which will cause problems (although you may just have word wrap enabled while taking the image).
The comma I have outlined in red is interpreted as the end of that column, with the next field interpreted as the double quote character instead of 4300.
Change your column layout to put the numbers before your comment text and your problems may disappear.
