+11I have created an import to add item notes. This adds text to the Item Notes field on installed items, but they do not appear as Item note on service orders. If I manually add text in the Item Note field, on the other hand, Item Note is shown on the service.
(I apologize for language)
So I suspect there is an issue with the import. Any tips:
Best answer by Phil Seifert
Hi Bjørn,
If you review the item_text table after modifying the notes via the front end, you will find that two columns are populated:
As the first one only worked for the installed items module, I believe the other column is for other modules to pull the data. Therefore you should make a mapping for back_end_env instead of notes_rt:
When I did this with a new import, it populated both columns just like the UI does and should work for you.
+24Hi Bjørn,
If you review the item_text table after modifying the notes via the front end, you will find that two columns are populated:
As the first one only worked for the installed items module, I believe the other column is for other modules to pull the data. Therefore you should make a mapping for back_end_env instead of notes_rt:
When I did this with a new import, it populated both columns just like the UI does and should work for you.
+11Just tested that - works like a charm. Thanks, Phil!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.