Exporting Catalog Item Variables to an XML file - Help!

[karl_james]

I really hope someone can help with this. I've seen some fairly similar questions asked but I haven't had a definitive answer as yet.

I need to export the populated catalog item variables to an XML file at the catalog task level or similar. If the system could create the xml file and attach it to the request that would be awesome, but I think the easiest way would be to have a UI action button in the task. I have created the UI action and processor and I've managed to find a script to export the item, but I can't get it to output the variable answers from the form.

Basically when our Call Centre Agents need to send a letter to a customer the plan is for them to complete the catalog form, the Quality Control Team will check the letter and click the Export Catalog Item button (UI Action) if the letter is correct. The QA member will place the XML file to a shared folder and an internal process will automatically transfer the file to our printing environment. The printer will read the necessary XML tags and is capable of printing the letter from this file.

Has anyone achieved this?

[karl_james]

We managed to achieve this by using a pivot report as posted in the link below:

https://community.servicenow.com/message/693393#693393

[samiul1]

Hi Karl,

Did you manage to get a resolution on this?

If so, could you share your workaround as I am also having the same requirement.

Thanks heaps in advance!

Regards,

Samiul

[Daniel Oderbolz]

Isn't it possible to export the relevant rows of

sc_item_option_mtom ?

(See also https://community.servicenow.com/community?id=community_question&sys_id=798a8be9db5cdbc01dcaf3231f96...)

Best

Daniel