New reply on DataCleaner's online discussion forum
(http://datacleaner.org/forum):
DavidB replied to subject 'Custom XML Datastore Table Structure Not Working? (v
4.0)'
-------------------
Hi Kasper,
Thank you for the reply. Yes, that fixed it! Apologies for the dumb question --
I'm pretty unfamiliar with XPath, and I thought I had had it working in the
professional edition without the prefixed slashes.
One more question for you: are predicates supported in the XPath for setting up
an XML datastore? Again, with simple examples...
XML File:
{{{<?xml version="1.0" encoding="UTF-8"?>
<StoreExport>
<Products>
<Product>
<Code TableFieldID="code" Value="TEST_CODE"> Product 1 Code 1 </Code>
<Code TableFieldID="price" Value="1"> Product 1 Code 2 </Code>
</Product>
<Product>
<Code TableFieldID="code" Value="TWO"> Product 2 Code 1 </Code>
<Code TableFieldID="price" Value="2"> Product 2 Code 2</Code>
</Product>
</Products>
</StoreExport>}}}
conf.xml:
{{{<xml-datastore name="TEST_XML">
<filename>C:\Users\dballardo\My
Documents\Test_XML.xml</filename>
<table-def>
<rowXpath>/StoreExport/Products/Product</rowXpath>
<valueXpath>/StoreExport/Products/Product/Code[@TableFieldID="code"]/@Value</valueXpath>
</table-def>
</xml-datastore>}}}
The goal is to pull out the attribute value "Value" where the "TableFieldID"
attribute matches some string (we are dealing with a lot of strangely formatted
XML docs that we would like to clean!). It seems to work correctly on various
XPath testers, ex: http://www.xpathtester.com/xpath , however when running in
DataCleaner I get <null> values in that column. Do you have any insights?
Thank you!
-David
-------------------
View the topic online to reply - go to
http://datacleaner.org/topic/1059/Custom-XML-Datastore-Table-Structure-Not-Working%3F-%28v-4.0%29
--
You received this message because you are subscribed to the Google Groups
"DataCleaner-notify" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/datacleaner-notify.
For more options, visit https://groups.google.com/d/optout.
