Skip to main content

I 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: 

 

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:

  • notes_ret
  • back_end_env

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.


Just tested that - works like a charm. Thanks, Phil!


Reply