Read and store data from event History - event XML column

Avatar

Avatar

Jaspreet_Kaur1

Avatar

Jaspreet_Kaur1

Jaspreet_Kaur1

27-10-2017

Hello all,

I need to extract the data from eventXML (ctx type) from the eventHistory schema, but as this column is in the xml format, I am unable to read in the queryDef or query activity.

I need to read some of the fields from this column dynamically and further export them. Unsure the way to extract.

Any help pls?

Have gone to one of the similar issue threads in this forum, but was not clear to me.

Any help will be appreciated.

Thanks,

Jas

@Jean-Serge Biron

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

30-10-2017

Hi Jaspreet,

When extracting/exporting the file, what kind of file type do you choose ? Xml one ? I don't understand why you get the content.

Regarding how to get specific element/content inside the XML element, sorry I don't know easy way. Eitherr SQL string manipulation (not recommended) or Javascript code manipulating XML element (DOM nodes) (either in the Extract activity/format section or in dedicated JS activity), and of course accurate object elements for specific cases,described in the JSAPI documentation (such as delivery.mailParameters.subject etc).

Regards
JS

Answers (3)

Answers (3)

Avatar

Avatar

jasonw30638826

Avatar

jasonw30638826

jasonw30638826

29-01-2019

Hi Jaspreet,

I have the same issue. I am not able to extract to XLM element to CSV format. It would be the best if I can to extract some specific field inside that XML. Have you figured out a way to archive this?

Thanks,

Jason

Avatar

Avatar

Jaspreet_Kaur1

Avatar

Jaspreet_Kaur1

Jaspreet_Kaur1

27-10-2017

Thanks Jean,

Tried extracting from the extract activity, but not getting any result.Pasted is the screenshot below, where I want to extract the event XML column data which is in the ctx format. And what if I want to extract some specific field inside that XML. is there any syntax you can share?

1334942_pastedImage_0.png

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

27-10-2017

Hi Jaspreet,

As in other threads with same subject, please use the Extract activity in a workflow, or the Export template tool (quite the same) to get the xml type fields (mData/memo fields) exported to a file.

BR
JS