- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
SO VI Import Comment Line
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-10-2012 06:34 AM
Does anyone have any examples of this in MAS 4.40+? Seems like no matter what I do, I can't get a comment line imported, just regular items. Any help would be appreciated.
Re: SO VI Import Comment Line
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-10-2012 06:56 AM
This should be pretty straight forward. You would just need to have the ItemCode and CommentText fields set (ItemType should set itself, but perhaps this one too). What kind of error is it throwing during the import? Also what does your Records tab look like?
Re: SO VI Import Comment Line
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-10-2012 07:06 AM
Hi Gator,
I agree it should be pretty straightforward, and I've muscled my way through some VI humdingers in the past, but alas, I'm unable to get a comment line in.
My header and detail are on the same line, so, - correct me if I'm wrong - my Records tab should be empty. Basically, I have a column in my source file containing item codes. If the column is empty, I have a condition to assign the item code '\C' (which I agree should automatically set the item type to 4).
Interestingly, no errors are being thrown, the import just completely ignores the comment line - it's not present in the log. I will attempt to set the item type column conditonally, I just wanted to see if there were any tricks I was unaware of in regards to importing comments. Thanks for your input gator.
Re: SO VI Import Comment Line
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-10-2012 07:13 AM
I wonder if the conditional is failing (and I assume you put "/C" and not "\C"). I would try hard-coding all ItemCode to "/C" and see what it does. Does it ignore every line now?
Re: SO VI Import Comment Line
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-10-2012 07:25 AM
OK. I assigned '/C' to every line and it recognized the lines as comments - I had some other conditional replaces on 'item type 1' related fields that must have been throwing it off. I removed all and will now work on getting the conditions back in place working properly. Thanks so much for the suggestions gator - I'll post back when complete to let all know the results.


