xECM 21.4 - Integration Service

Long29
Long29
in Extended ECM Integration #1

Hello everyone,

I am new to the xECM product family and is currently working with Integration Service to archive files from Sharepoint. My use case is that I would like my files to be archived in specified Business Workspaces on Content Server. Here are some of the constraints:

  • The precised location (sub-folders) within a Business Workspace will be specified by the meta-data of the file from Sharepoint (Based on the existing folder structure on Sharepoint).
  • If the subfolder does not exist, it will be created.
  • If the Business Workspace does not exist, it will be created automatically according to the meta-data of the file (the name of the document library).

At a quick glance, Integration Service does not provide a solution for such use case OOB. I would like to ask which direction should I go about in creating a customized solution addressing this use case (as it is not very clear for me at the moment)? All answers and suggestions are welcomed.

Thank you in advance!

Tagged:

Comments

  • Appu Nair
    Appu Nair Member
    edited March 7, 2022 #2

    The XECM product AFAIK gives you a hidden golden freebie called the WR pack. There are many settings in the BWS setup screen for eg if you go to your system and click on one of the BO's the link that starts with 2.Assuime you map a property in leading app like Sharepoint assume you pass in values SiteId and assetnum and assume the runtime values are BEDFORD and 1001 the system can use that to map to a Livelink category and attribute and you may ask So? you want to look at its corresponding Workspace settings so one would hit a back and click the far right hyperlink(the workspaces are the livelink specific business rules) you want to look at the section called Workspace Creation Settings and the Location/ Sub Location path. This is your opportunity to use metadata from your leading application so if I put [1625737:Site] using the mapping the I will get something like a folder called Enterprise:Enterprise Asset Management:Assets:Maximo:Bedford so it gives you an opportunity to create folders using dynamic tags.Please see the help for Configuring Connected Workspaces Using patterns for the location path

    Ok say if none of these fit your bill then I would use WR and specifically a WR Trigger so the intention is like this,as soon as the WS or the subfolder you want or manipulate is created the WR trigger will report that DataID 12345 was created. You then use tag logic to make whatever you want this is a programmers tool so one need to actually look at what is possible with the OOB capabilities of XECM.

    Hope that gives you something to look at.


    Another thing that I thought of adding say if you want to do something different other than a trigger event because once the workspace is created all the dataIds are in Livelink so the system will not give you the newly formed dataid to work on, but Livelink's schema is very widely known and the XECM relations are very easy to find so if i wanted to manipulate an existing workspace I would create a report on the existing Workspace I want and then once I have that I will be able to use the same WR tag language to do any manipulation. This forum on WR will give you starter samples/worked out sql, logic etc.

    https://forums.opentext.com/forums/support/categories/cs-WebReports-and-ActiveView

    BTW Livelink is now called Content Server

Categories

image
OpenText CE Products
Extended ECM
Docs & APIs