Copy records from global app to scoped app?

[Bob Loblaw]

Hello,

My sanity is slipping, so I'm hoping I can be pointed in the right direction: I'm looking to transfer records from a global app to a scoped version of the same app. Both apps have the same columns. In the scoped version, the documents will be read only, so there's no action/logic/etc. to be taken on them. My final goal is to see the documents (copied from the global app) in a list view in the scoped app. Here's what I tried:

• Export records as XML from global app and import them into scoped app: I tried this and they didn't show up in list view, so I'm guessing they didn't get in. The scoped app has no security on it, so I don't think there are any ACL problems (and I'm going into the scoped app as Admin). I'm guessing the XML has application sys_ids, etc. that reference the global version of the app, so it would take lots of XML tweaking to change it, and not sure if this would solve the problem.
• Created an "application file" from a few data records: tried this, saw that it was imported into my scoped app as "Metadata Snapshot". However, upon trying to import that whole scoped application xml into a new instance, it failed for another reason, so I aborted mission - was I on the right path with this?

My solution: I created a script that will read column values from documents in my global app, then create a new record and copy those values over into the same column in the newly created document in the scoped app. Only problem with that is that I can't copy over the actual audit trail/activities, but I can at least link to sys_audit, sys_history, and sys_email with proof of changes made and emails sent with regard to each document.

Is there an easier way to get the data from a global app to its scoped counterpart? Have I missed some large and obvious method for doing this? Any/all constructive suggestions are welcomed. Thanks!