Solved

Multiple XML files including filename

  • 8 August 2023
  • 9 replies
  • 88 views

Badge

Hi I am using TimeXtender 20.10.37.64 incl. ODX server. I am trying to get some data from XML files with a wildcard which have the filename as a reference to another file. I am using the Cdata XML connector. I managed to get the data from both files in TimeXtender but can’t find a way to include the original file name to the table/query. Is there a standard option for this or maybe a workaround? Hope someone can help me.

icon

Best answer by Thomas Lind 9 August 2023, 15:19

View original

9 replies

Userlevel 6
Badge +5

Hi @Michel van Drunen 

Can you please explain what you mean by “filename as a reference to another file”?

If you are looking to get the source file name/URI as an additional column, please follow the steps below:

1. Enter “IncludeResourceColumns=True” in the other property for the data source and click OK.

2. Execute the sync and transfer task

3. Synchronize Objects in the ODX

4. Locate the DSA table and click on it, you should now see the new field in the data movement pane. Drag the field into the table

5. After deploying and executing the table, you should now see the resource URI field if you preview the table.

 

Badge

Hi Christian,

Yes that was were I was looking for.
I have tried your solution but it doesn’t work for me.
Are there any other settings relevant for it to work?

Kind regards Michel

Userlevel 6
Badge +5

@Michel van Drunen which version of the provider are you using? Can you please try upgrading to the latest (i.e. XML 2023 23.0.8600.0)?

Badge

Hi Christian,

I use the same provider (XML 2023 23.0.8600.0).

My connection string:

Culture=nl-nl;Generate Schema Files=OnUse;Location=D:\TimeXtender;Other="IncludeResourceColumns=True";Row Scan Depth=0;Type Detection Scheme=None;URI="C:\Users\2Foqus\Desktop\RMA   54421_ 406521.xml";URI Separator=,;Use Lake Formation=False

Regards Michel

Userlevel 5
Badge +5

@Michel van Drunen 

I think it might be the Generate Schema Files option that makes it not work.

Try to turn it off and see what happens.

Also, if you point at a specific file it will only show that as the URI, you will likely have to point at a folder where the similar files are stored.

Badge

Thomas,

Have done multiple tests with other settings but no succes. Other="IncludeResourceColumns=True";URI="C:\Users\2Foqus\Desktop\RMA   54421_ 406521.xml"

Regards,

Michel

Userlevel 5
Badge +5

Hi Michel

If you want to use it in a RSD file, it should be possible to see it if you add the following in the info area.

<api:info title="RMA" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">
..
<attr name="_ResourceURI" xs:type="string" readonly="true"/>
</api:info>

You will have to generate the file first I assume.

Badge

Hi Thomas,

That works fine.
Thanks!

Userlevel 5
Badge +5

Great. We had a ticket regarding this in July, so the ability to do this was the result of that and to show the file path in an Azure Blob container.

Reply