Hi, I have a packaged software RTR solution for this where the user can map data between P8 systems, object stores and classes visually. It can be same GCD or multiple, different classes, properties, cardinalities, data types as well. Offered in two footprints a desktop software product and for larger systems client-server offering. Data translation, substitution, de-duplication, regular expressions at the library > class > property level very granular. Easy to import substitution lists as well. Preserves all system fields ID, vsID, date created, etc.
The same software can also clone object store classes, properties and choice lists.
------------------------------
Jay Bowen
------------------------------
Original Message:
Sent: Fri December 30, 2022 09:19 AM
From: Eric Walk
Subject: Merge Object stores
We've done things like this where we still create the documents via the API, but create them as content reference not content transfer. Then we directly update the storage pointer in the database so we don't have to move the content in and out of the storage (especially when it's a fixed content device). But this has a lot of risk and isn't worth it unless the volumes are well into the hundreds of millions or billions. When you're looking at small object stores you should be able to do it via the WSI API in a reasonable amount of time and that's the most reliable option. I agree that FDM is not intuitive or user friendly, but it is the correct OOTB tool for this scenario.
------------------------------
Eric Walk
Director
O: 617-453-9983 | NASDAQ: PRFT | Perficient.com
Original Message:
Sent: Thu December 29, 2022 06:45 AM
From: Christos Chorattides
Subject: Merge Object stores
Thank you both!
I am aware of FDM but I find it very complicated and it is not suitable for my case.
We have a custom Export-Import tool that we use for these cases.
I was just wondering if someone attempted some kind of database table merge, of the required tables. (Filestore are not an issue in my case)
BR
------------------------------
Christos Chorattides
Datatech
Original Message:
Sent: Thu December 22, 2022 03:14 AM
From: Christos Chorattides
Subject: Merge Object stores
Hi,
we need to merge several small object stores into one. (Same doc classes and everything)
Is there a way to do it, without exporting and importing all documents?
BR
------------------------------
Christos Chorattides
Datatech
------------------------------