Problèmes de lecture XML dans Data Interop Workbench

ChuckColeman

J'ai des difficultés à lire les fichiers XML et à pouvoir sélectionner précisément les données que je veux, sans obtenir plusieurs lignes de sortie avec des champs vides dans Data Interop Workbench. Voici un exemple : <\/P>

Étant donné le fichier XML suivant : <\/P>

<<\/SPAN>document<\/SPAN>><\/SPAN><\/DIV>    <\/SPAN><<\/SPAN>pages<\/SPAN>><\/SPAN><\/DIV>        <\/SPAN><<\/SPAN>page<\/SPAN> title<\/SPAN>=<\/SPAN>"one"<\/SPAN> id<\/SPAN>=<\/SPAN>"001"<\/SPAN>><\/SPAN><\/DIV>            <\/SPAN><<\/SPAN>objects<\/SPAN>><\/SPAN><\/DIV>                <\/SPAN><<\/SPAN>object<\/SPAN> name<\/SPAN>=<\/SPAN>"thing1"<\/SPAN>><\/SPAN><\/DIV>                    <\/SPAN><<\/SPAN>property<\/SPAN> type<\/SPAN>=<\/SPAN>"string"<\/SPAN>><\/SPAN>Thing 1<\/SPAN><<\/>property><\/span>

</object>

</objects>

</page>

<page title="two" id="002">

<objects>

<object name="thing2">

I want to gather the

page title, object name, and property text.

It should output 2 records like the following:

"one", "thing1", "Thing 1"

"two", "thing2", "Thing 2"

As I stated previously, no matter which elements I select in the Feature Set,

I get several lines with blank fields.

I cannot offer any screenshots as Data Interop Workbench is running on a secured system

with no internet connection.

Toute aide serait grandement appréciée.

rsalvaleon

From what I read in your sample, <pages> is an array of page that has a title and a single property.

Your feature path must be set like below. Checking the Property checkbox is probably not needed.  Your list exploder will do the rest of the pivoting. 

The above results to the following;

 

If you are reading the XML from a path, you would not be able to see any option in the Select element to match dialog, so you have to type below in the Elements to Match text box: 

document/pages

Hopefully, this helps, as your sample is very simple and XMLs can be quite complex until you get to know its pattern. Let me know if you have additional questions.