Easy Import - Incidents

trmiller
Kilo Expert

I am trying to import incidents from our legacy system using Easy Import. All fields work except Comments and Work Notes. I can see them in the import set, but not the record. I have completed the following already with no luck:

  1. In the navigation filter, enter sys_properties.list.
  2. Go to glide.import_template.field_types_to_ignore.
  3. In the Value field, remove the journal and journal_input field types (for work notes and comments):

I also tried creating a new journal field on the INC table but it does not show up in the template.

2 REPLIES 2

Anurag Tripathi
Mega Patron
Mega Patron

Hi Thomas,



I think since the journal fields don't actually save value in the incident table directly but rather on the sys_journal_fields table, that is why it is not showing up in your import, trying to open sys_journal_fields and export the relative entries separately and import in your target instance.


-Anurag

My solution ended up being a new string field with a max length of 4000. I simply called it FootPrints Notes (FootPrints being our legacy system). I actually like this better so the old notes don't end up being included in future notifications, etc as part of the comments and work notes fields from SN. Once all these tickets are dead, we will simply mark that field inactive.