Precisely Enterworks

 View Only
  • 1.  export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-04-2021 09:09
    we'd like to export data from EnterWorks PIM using an export template triggered by an update to an attribute - has anyone done this or know of a way to do this other than a workflow?
    thanks


    ------------------------------
    Ruthy Sleeth | IT
    New Pig | 814-686-2254
    ------------------------------


  • 2.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-04-2021 09:27

    Hi Ruthy, I am not sure of any way to trigger the export when an attribute gets updated, that would be interesting. 

    As a work-around, I would use a Scheduled Export to run every 5 or 10 min looking for Delta (add/updates)



    ------------------------------
    Vijay Zarapala | Sr Developer
    HD Supply | 6784512789
    ------------------------------



  • 3.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-04-2021 09:34

    Thanks!

    ��

    Ruthy

     






  • 4.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-05-2021 09:04
    Hi.

    I think that Change Notification would be able to do this for you. We're just learning how to use this part of the PIM but I'm sure that @Brian Zupke may have an idea or two to help facilitate this.

    Best,
    -Jon
    ​​

    ------------------------------
    Jon Varo | Manager, Product Information Management
    Fender Musical Instruments Corporation | 480-845-5823
    ------------------------------



  • 5.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-05-2021 10:03

    Thanks Jon –

    I too, am hoping a CN could help.

    ��

    Ruthy

     






  • 6.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Employee
    Posted 11-09-2021 15:57
    All,

    Change notification can certainly be used to trigger an export.  There are several options and depending on circumstances, one may be preferable to the other. 

    One option is to define a CN_Registry rule that launches a work item in a new workflow when the desired change is made that needs to trigger the export.  The work item would be launched in a new workflow that would use the Initiate Scheduled Export to launch the desired scheduled export, passing in any dynamic information that would be required.  This approach works well when there are few records changing that would necessitate the export AND those exports need to be separate for each record changed.  It would NOT be a good option if a large number of records are routinely changed AND the needed export could include all of the records that were changed.

    Another option is to set up a workflow that monitors the repository for changes, looking at the key attributes and their values and/or the timestamps of when those records were last changed.  If any are found, those records can either be added to a Saved Set using the SQL Create Saved Set activity or the Scheduled Export that is launched using the Initiate Scheduled Export activity could use the same criteria to determine what records to include.  If the records to be exported need to have specific attributes changed to qualify, then the Change Notification could set a flag to indicate that the record needs to be included in the next export.  The logic for determining the records to be included would also rely on this flag.  Once the export is generated, there would need to be a dependent job to reset the flag so only subsequent changes to the designated attributes will cause those records to be included in a subsequent export.  This approach works well when there may be a few records changed or a large number of records changed and having a single export include multiple changed records is acceptable AND having some data latency is tolerable.  For example, if the process is set up to check for changes every 15 minutes, then each export would contain only those changes in the last 15 minutes and those changes have a latency of up to 15 minutes.

    Another option would be to set up a scheduled Export that periodically includes the records that qualify. It may still utilize the change notification to set a flag so only those records with specific changes are included (and it would need to launch a subsequent scheduled import to reset the flag on those records).  A key difference with this and the previous option is that no workflow would need to be created, but also this would produce an export at the designated interval whereas the previous option would only produce an export for an interval IF there were any qualifying data changes.

    -Brian


    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 909-900-9179
    ------------------------------



  • 7.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 11-10-2021 07:13

    Thank you for the info, Brian!

    Much appreciated!!

    We may have more questions as we try to implement this.

    ��

    Ruthy

     






  • 8.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Posted 12-01-2021 10:06
    Brian: 

    I have a follow-up question to this-can a change notification triggers a workflow launch?

    We have an attribute where the end-user is supposed to review the record and click send to workflow, and the workflow updates an attribute so we know the record has been reviewed and captures submitted by date and time. In classic, the save and send was more intuitive, however, in the new UI, end users are confused by the Submit Workflow. 

    If they could change the attribute to acknowledge they had reviewed and hit save, could the workflow be launched by a change notification? 


    ------------------------------
    Natalie Scott | Data Governance & Business Process Manager
    Gourmet Foods International | 4042104367
    ------------------------------



  • 9.  RE: export data from EnterWorks using an export template triggered by an update to an attribute

    Employee
    Posted 12-01-2021 12:22
    Natalie,

    It is possible to configure Change Notification to launch a work item in a workflow.  Please see Brown Bag Session 61 - Launching Work Items from Change Notification Events.

    -Brian

    ------------------------------
    Brian Zupke | Senior Technical Support Engineer
    Winshuttle North America | 909-900-9179
    ------------------------------