Import XML comments and work notes into activities journal field

[Ryan15]

I'm trying to do a data migration from a global app to it's new scoped version. I'm exporting all the required fields to xml then importing it using a transform map. Mapping the fields is no problem since all the fields are more or less the same but the problem I'm having is with the activities. I know it's a journal field and I can find the comments and work notes on the sys_journal_field table but I noticed you can export comments and work notes to the xml. So my first question is: How do I input this information into the source records activities journal field using the transform script? Second: Can I use the comments and work notes from the xml, or is it better to pull from the sys_journal_field table?

[Allen Andreas]

Hi,

When moving the actual records...I assume you're inserting those as new records in to your app then adjusting things like the dates and such to match the original information? It's a bit tricky since you're lifting and dropping information from several different places and so you have the sys_audit table, sys_history_line table, sys_journal_field table, etc. that you'd want to consider for the move.

I know if moving Incident records (for example) from one instance to another, so they have the same table and everything, to get everything to sync up properly, there was 4 tables roughly you needed to bring in records from. The three I mention above and then the Incident table of course.

Check those other tables and consider everything. You'd have to see where the sys_id of the record is being applied and then match that up to the new sys_id for the same record info in your app.

Please mark reply as Helpful/Correct, if applicable. Thanks!