150
I am trying to utilize the Description Internet button for an item where I can input a long description in the additional information field of the Internet Information window. The Inventory item destination adapter does not link to this field. How would I modify my integration so that I may insert or modify descriptions in that field?
*This post is locked for comments
Leslie, you're up!! :)
I've done some minor scripting in integration manager but nothing too complicated. How complex would this be? Is there an example I could follow?
Geoff, you'll need to take Leslie's approach then. Table Import only works for new records. It does not do updates to existing records. The other option would be to do a dump of existing item data out of SY01200, edit the records to add your long description field, delete the contents of SY01200 where type - ITM, then use Table Import to re-integrate the records. Of course, do this in a test database first.
I love Table Import - I use it to integrate Extended Pricing data since IM has no adapter for such.
The table import worked well for a few items but existing items were rejected. I need to be able to update the sy01200 inetinfo field
Yay Frank!
Good ole' Table Import Utility. Love it, and it's fast. I don't know why they junked the 'direct to table' adapter in IM, but the old faithful Table Import is still there.
If Geoff wants to make this table import part of his IM integration, that would be possible by adding a quick piece of VB script to the integration. Personally, I think that would make it more streamlined. Bonus, he could even do an update using VB Script.
Kind regards,
Leslie
Do a Table Import into SY01200 with 'ITM' as the Master Type. All you need is Item Number (SY01200.Master_ID) and SY01200.INETINFO for your extended description text.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (