Media Manager Workflows
Content
This chapter describes how you can import and configure the different workflow examples into the workflow module of the Media Manager. These workflows are needed for the communication between the Product 360 server and the Media Manager.
The example files are located in the folder WorkFlowExamples of the file PIM_<Version>_MediaManager.zip from your Product 360 distribution.
Import
Start the application "Workflow Manager - Informatica Media Manager" and activate the administration mode.
Select the menu entry "Management of Workflows" in the menu "Master data".
Cilck on the button "Import Worklfow".
Select a xml file and click ok.
Workflow: MessageQueue Asset created (AssignDocs)
Filename |
Location |
MessageQueue_Asset_created_(AssignDocs).xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event asset created. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to create (or update) an assignment.
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
AssignDocument F_IMGKOMP.PKOM_PNR |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Asset modified
Filename |
Location |
MessageQueue_Asset_modified.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event asset modified or created. After one of those events an entry in the message queue will be created, which will be consumed from the Product 360 server to update the assigned asset informations.
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
AssetModified F_IMGKOMP.PKOM_PNR |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative created
Filename |
Location |
MessageQueue_Derivative_created.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative created. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to add the derivatives to the assigned documents.
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
NewDerivative F_IMGKOMP.PKOM_PNR|F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative deleted
Filename |
Location |
MessageQueue_Derivative_deleted.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative deleted. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to delete this derivative from the assigned documents.
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
DeleteDerivative F_IMGKOMP.PKOM_PNR|F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative modified
Filename |
Location |
MessageQueue Derivative modified |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative modified. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to modify this derivative at the assigned documents.
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
NewDerivative F_IMGKOMP.PKOM_PNR|F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative definition created
Filename |
Location |
MessageQueue_Derivative_definition_created.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative definition created. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to register this new definition..
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
NewDerivativeSchema F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative definition deleted
Filename |
Location |
MessageQueue_Derivative_definition_deleted.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative definition deleted. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to unregister this definition..
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
DeleteDerivativeSchema F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: MessageQueue Derivative definition modified
Filename |
Location |
MessageQueue_Derivative_definition_modified.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event derivative definition modfied. After this event an entry in the message queue will be created, which will be consumed from the Product 360 server to modify this definition..
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
ModifyDerivativeSchema F_DERIVATE.DEV_ID |
YES NO NO NO |
Replace the computer name localhost with the name of the computer where the MessageQueue is running. |
Workflow: Automatic group assignment
Filename |
Location |
Automatic_group_assignment.xml |
....\Examples\Workflow (Media Manager) |
This workflow listens on the event asset modfied or created. Atfer that event it will be checked wether it is assigned to any group.If not it is added to the group "Unassigned" otherwise it is removed from the group "Unassigned".
Step |
Value(s) |
Change Value(s) |
Comment |
Definition |
<WRFD_STATION>1</WRFD_STATION> |
YES |
ID of the Media Manager Application Server where the Workflow Module is running in the automatic mode. |
Step 1 |
D120001 |
YES |
Select the correct client, which stores the Product 360 assets. |
Step 2 |
'1' 1 F_IMGKOMP, F_IMGKOHI F_IMGKOHI.IMHI_PNR = F_IMGKOMP.PKOM_PNR |
NO NO NO NO |
Sql statement to check if there is any group assignment for this asset. |
Step 3 |
'1' 1 F_IMGKOMP, F_IMGKOHI F_IMGKOHI.IMHI_PNR = F_IMGKOMP.PKOM_PNR and not(F_IMGKOHI.IMHI_IHIE_ID like '006400000000%') |
NO NO NO YES |
Sql statement to check if there is a group assignment for this asset, but not group with the id; 00640000000......... |
Step 4 |
00640000000........ |
YES |
Remove assignment from the unassigned group, This group id has to be changed. |
Step 5 |
00640000000........ |
YES |
Assignment the asset to the unassigned group, This group id has to be changed. |