Export data from one instance to another - not all comments/worknotes

[priisholm]

(Kingston patch3)

Hi guys 🙂

I want to export approx 160 incident with attachments and comments (additional and worknotes) using the "Export > XML"  - function from at filtered view and then import them in another instance using "Import XML".

I have started with 1 incident to see how well it works.

All fields are imported and okay 

All attachments are imported and okay

Only 24 out of 45 "additional comments" / "work notes" are imported.. and they are missing in the XML-file...  Why?

Any ideas?

Thanks
Soren

[Allen Andreas · Accepted solution]

Hi,

To accomplish this and bring over all components correctly, you'll need to not only export the incidents via XML (to grab attachments, etc) but you'll also need to bring over:

sys_history_set

sys_audit

sys_email

and if you're able sys_history_line

so I would add .list to the end of each of those, find the associated records to your incident, and bring those items over.

THEN do the incident XML file last...

[priisholm]

Hi Allen

How do you bring over sys_history_set, sys_audit and sys_email?

It seems that its much "easier" to make you own script, that copy incident-fields, attachment and comments into you own XML..

I saw your question.. did you ever get any answers?

BRs

Soren

[Allen Andreas]

Hi,

You bring them over the same way, you export them via XML.

So you'd search for sys_audit.list and then narrow it down to the items related to your incident (for me I just filtered by date as back when I did all this I was moving items one month at a time) and then once the date is there, right-click column header, export XML, import XML in to whereever you're moving them. Rinse and repeat for the others.

If you're referring to old questions I had, haha, yea I figured it out, on my own....was fun...

So rest assured I know exactly what you're talking about.

How often is this happening for you?

If it's just this one time or here and there, this method will be fine.

[priisholm]

Hi Allan

Its the first time and I hope only time :)!

I just figured out what happend over here..

The XML export (right-click list/view) is actually okay - everything that we expect is in the XML ..

It will not export all the field-changes like status change etc. But that okay with us.. We have agreed as long as we get:

- all attachments

- all fields 

- all add.comments + worknotes 

... then we are happy. I think you needed a little extra information in you import.. ?

Anyway... when SN import the XML - they are created in the new instance with the same date as the incident is created/opened - so when you look at the comments/work_notes ind the new instance they are all mixed up.

I will go to HI and make a complaint about this issue - and then try your approach 🙂

BRs

Soren