topic Re: XML files in Talend Studio

XML files

Soumya_M — Fri, 15 Nov 2024 22:05:11 GMT

Hello, I extracted a xml file schema, which i use to read other xml files having the same xml schemas. The job sequence stands like -

tFilelist - tFileInputXml - tConvertType - tPostgresqloutput. But the issue is, all xml files from the input folder are not read by tFileInputxml component - as few are getting skipped, even though all the files have same schema. May i know what's the issue ? Why are the files not being read the xml component ?

Re: XML files

Anonymous — Mon, 20 Feb 2023 02:04:56 GMT

For debugging, Check the 'die on error' box on tFileInputXML component, the job will throws out the error and die. Read the error messages and investigate the cause.

Regards

Shong

Re: XML files

Soumya_M — Mon, 20 Feb 2023 05:17:39 GMT

Hi Shong, I did check box the die on error, but i did not get any error. But issue remains the same, the file is not read by tFileInputXML component. Any any other solution ?

Re: XML files

Anonymous — Mon, 20 Feb 2023 09:13:52 GMT

I suspect the files are not found by the tFlistList, double check your filemask, print the current file name on the console to see which files are found!

Regards

Shong

Re: XML files

Soumya_M — Mon, 20 Feb 2023 10:13:09 GMT

Hi,

the files are read but no records are getting loaded to the tables. Even though the files have records, it's shown as 0 records

Re: XML files

Anonymous — Tue, 21 Feb 2023 05:51:54 GMT

Hello,

Could you please show us your tFileInputxml component setting screenshot?

Please make sure that you did set tFileInputXML component with the following file name:

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Best regards

Sabrina

Re: XML files

Soumya_M — Tue, 21 Feb 2023 08:04:50 GMT

Yes, i did set the path, It's the same like you have mentioned.

Re: XML files

Anonymous — Tue, 21 Feb 2023 09:34:17 GMT

Hello,

Would you mind posting your tFilelist and tFileInputxml component setting screenshots here? Please mask your sensitive data as well.

Maybe you could try to restart your job (save firstly) to see if it works?

Best regards

Sabrina

Re: XML files

Soumya_M — Tue, 21 Feb 2023 13:18:42 GMT

I saved and restarted my job, no results.

Re: XML files

Anonymous — Wed, 22 Feb 2023 02:36:12 GMT

You don't set the fielmask, you have to set the filemask, eg: "*.xml"

Re: XML files

Soumya_M — Wed, 22 Feb 2023 05:26:01 GMT

I tried executing by setting the filemask, even then it's not read by the tFileInput component

Re: XML files

Anonymous — Wed, 22 Feb 2023 07:41:05 GMT

How many xml files in the directory? Can you show an example file? Maybe you don't configure the mapping correctly on tFileInputXML component.

Re: XML files

Soumya_M — Thu, 23 Feb 2023 05:34:40 GMT

I shall check that one

Re: XML files

Anonymous — Thu, 02 Mar 2023 07:51:04 GMT

I suspect you don't configure the right the loop xpath query, can you show us an example file and a screenshot of basic settings of tFileInputXML?

Regards

Shong