Hi,
Is there any utility/service present in Jira API that we can use to export the data stored in DB using activeobjects, only for my app while handling app migration events generated by JCMA?
Or do we need to add it, to handle DB tables data export per app as needed?
Thank you,
Parag
Hi @parag,
Thanks for your question. The App migration platform doesn’t provide any service or utility to access the data in Active Objects tables because every app stores their data differently.
You’ll need to extract the data yourself, package it up and send it to the platform using createAppData(). I know Jira server has a library for Active Objects, and I’ll assume whatever your app uses to get to its data will be the same.
Hope this helps,
James.
Thank you @jrichards for the response.
Understood, yes we store our app data in DB tables using Active Objects. And I thought the way Jira exports Active Objects’ table data to XML in backup functionality, there may be some public API available to use for individual apps.
Thank you,
Parag
Hi @parag,
When you do a full XML export, yes the AO table object are exported as XML in the entities.xml. However I wouldn’t recommend using this because it doesn’t respect any context you may have with the export (e.g. it exports all data, every time ignoring chosen projects or users).
It would be better to make sure your export is context aware with the projects (containers) selected. Depending on your data, you can add a timestamp to each export so the second export may only requires newly updated content - however, this is very dependent on your app and data model.
Regards,
James.
Hi @jrichards ,
Yes, using complete export will not honor the partial or incremental export as migration utility allows to migrate selected projects or users. But we were thinking, as a first migration path, having an in-app complete export data option in some format e.g. XML, and then import that on the cloud app. This export/import of our app data will be done after all other Jira data like users/projects/issues are imported on the cloud version.
For this approach, it would have been easy for us, if there was public java API to export app data stored in Active Objects, was available.
Thank you,
Parag
Hi @parag,
Might be an idea to ask in the Jira Server discussion board about exporting AO tables. The Jira Server APIs are published Atlassian Jira - Server 8.13.9 API … having a quick look, something like this for imports DefaultBackupXmlParser (Atlassian Jira - Server 8.13.9 API) but not for export. I’m sure there’s something there, I’m just not sure what it is.
Most Partners export their code as JSON blobs using their own export code so they have full control, and makes parsing easier.
Regards,
James.
Thank you @jrichards for all your inputs, will check DefaultBackupXmlParser, but mostly will go with custom export/import for app.
Thank you,
Parag