Content Management and Capture

 View Only
  • 1.  Merge Object stores

    Posted Thu December 22, 2022 03:14 AM
    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
    ------------------------------


  • 2.  RE: Merge Object stores

    Posted Tue December 27, 2022 01:57 AM
    Hi,

    unfortunately it is not so easy like merge storage areas just with movecontent sweep job.
    It is possible to reassign objectstores between p8 domains, but to merge objectstores you really need some kind of export/import.

    It is possible to do it with FileNet Deployment manager (but for huge number of documents it is not very comfortable). The best way I see, is just export documents with a key velue (object ID) and then import wit custom API tool, which will retrieve all necessary metadata and permissions from original OS.

    Everythings depends on number of documents and performance required ...


    ------------------------------
    Pavel Silny
    ------------------------------



  • 3.  RE: Merge Object stores

    Posted Tue December 27, 2022 09:31 AM
    Did you try  FDM  ?

    Thanks,
    Mayank

    ------------------------------
    Mayank Tyagi
    ------------------------------



  • 4.  RE: Merge Object stores

    Posted Thu December 29, 2022 06:45 AM
    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
    ------------------------------



  • 5.  RE: Merge Object stores

    IBM Champion
    Posted Fri December 30, 2022 09:19 AM
    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
    ------------------------------



  • 6.  RE: Merge Object stores

    Posted Tue January 17, 2023 10:26 AM
    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
    ------------------------------