Data Migration

[leachy23]

Hey all, 

We are currently building a custom scoped app to replace a misused OOB CSM module. There is a requirement to migrate all historic tickets along with attachments and Worknotes to the new Application for both Audit and Reference. From a mapping perspective this shouldn't be an issues as Caller, Short description states will be fairly standard, the key things are really Attachments and ticket history.

However I have no experience in a bulk migration like this so not really sure where to begin?

[Ashutosh Munot1]

Hi,

We can do migration of attachment by coping this attachment from your old app to new app records. We can have a fix script to do this. Only thing is we need a identifier between new record and old record so we can copy attachment.

We can also create few worknote/comments (no dictionary change like state change's, emails etc) entries or copy them from old record to new record.

Thanks,
Ashutosh

[Ashutosh Munot1]

Hi, If you got your answer do close this thread. Thanks, Ashutosh

[HugoFirst]

Hello leachy23,

Here's an idea for you, leave the existing data where it is.  Then in your new custom scoped app, load a copy of the data, but add a link to each new record to point to its corresponding record in the OOB table.  This will give users access to the attachments and history of the original records.

The magic is the addition of  a reference field in the new app's table which points to the OOB table with the existing data.

Now you may have the question: How do you create records in the new app which correspond to the records in the old OOB app?

1. Export the OOB table in excel format, be sure to include those fields which transfer to the new record.  Also include the field that acts as a key to the OOB records ( number?). 

2. Then setup an import to the new table with the fields mapped from the columns in the spreadsheet to the fields in the new table.  Map the key to the old records to the reference field in the new record which points to the old, OOB table.

3. Import and transform the data and you will be good to go.  No programming required.

[Muneeswar Kasar]

Its very helpful.