Skip to main content
Solved

Astea: Issue with Item Notes import

  • December 9, 2024
  • 2 replies
  • 34 views

bskallerud
Sidekick (Customer)
Forum|alt.badge.img+11

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: 

 

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:

  • 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.

View original
Did this topic help you find an answer to your question?

2 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • 1317 replies
  • Answer
  • December 9, 2024

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.


bskallerud
Sidekick (Customer)
Forum|alt.badge.img+11
  • Author
  • Sidekick (Customer)
  • 206 replies
  • December 9, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings