How can I export the catalog item variables

[jaouad_essabir]

Hello,

When I created a request from the service portal, the request is saved in the "Requested Item" table and i display the variables entered like below:

How can i export all this variables to external systems ?

I use "System Export Set" module :

But, i can't find the variables when i defined the export using "Requested Item" table ?

Would you have an idea how to export these variables ? using mid-server or other ?

Thanks for your help

Regards

[Ivano B]

Hi Jaouad

Have a look to this answer

Export variables from a request item with export definitions

Apparently it is not possible because export set only supports the export of whole tables and not its relationships to others.

Variables are not included in this export method either unlike a standard report.

It is suggested to create a new table as staging area where to store the variables.

I hope this will help/answer your question and in case it does please mark it

Cheers

R0b0

[Community Alums]

Hi Jaouad,

You can do it by exporting the many to many table: "variable ownership sc_item_option_mtom", so in th fields use the dot walking to select the variables and thier values (question - value), after that use the filter to precise the Item and the variables you want to export.

Lyes

Hope this helps.

Mark helpful / correct based on impact 

[Henalu]

This works quite well, thanks!

[AbdulAzeez]

Can you try to update anything in the catalog item like short description after creating an update set which captures the complete catalog item in update set later you can complete the update set and import in other instance

Mark helpful / correct based on impact 

Abdul Azeez