topic Re: MongoDB to Excel in Talend Studio

MongoDB to Excel

Anonymous — Sat, 16 Nov 2024 07:02:31 GMT

I am pulling data from MongoDB using tMongoDBInput and displaying using tLogRow component and it's working fine. But When I try to import the data out tMongoDBInput the output excel is not opening. I am getting error "Excel can't open because file format or the extension is not valid." Please let me know what could be the issue.

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:06:27 GMT

Hi,

Could you please share the job screen shots and the schema screenshots you are using to extract data from MongoDB?

Warm Regards,

Nikhil Thampi

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:13:15 GMT

Hi Nikhil,

Attached are the shots for job desing and tFileOutputExcel properties.

Thanks

Chandra

Mapping.PNG
tFileOutputExcel.PNG

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:21:32 GMT

Hi,

I am actually interested in the column list in the schema which you have created in tMongoDBInput.

Warm Regards,

Nikhil Thampi

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:31:48 GMT

Sorry forgot to attache schema. here it is.

Schema.PNG

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:34:21 GMT

I have just one column called name.

column.PNG

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:39:18 GMT

Hi,

Could you please show the values in inside schema as shown in screenshot?

I assume it has been currently configured as Object type. Could you please check it?

Warm Regards,

Nikhil Thampi

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 19:55:06 GMT

Nikhl,

Attahed is shcema with colum. Please let me know if you need anything else.

Schema in tMongoDBInput .PNG

Re: MongoDB to Excel

Anonymous — Fri, 14 Dec 2018 20:17:14 GMT

It's configured as String.

Re: MongoDB to Excel

Anonymous — Sat, 15 Dec 2018 20:03:48 GMT

Hi Nikhil,

Did you find anything that will fix the issue? Please let me know if you need anything else from me.

Thanks

Chandra

Re: MongoDB to Excel

Anonymous — Sun, 16 Dec 2018 15:08:40 GMT

Hi,

It seems you have not correctly mentioned the node path in your schema. In your schema, the parent node path is empty. I could not see the collection since it is not added in your screenshot. But I guess it is also empty in your component.

Ideally, you need to mention the collection and path in the tMongoDBInput component. Please refer the screenshots for sample flows in help document.

sample collection

tMongoDBInput

Could you please refer the sample scenario from the below link and create your flow accordingly?

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/AVyV~wHR8ddC1EF5nhvVoQ

If the reply has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: MongoDB to Excel

Anonymous — Mon, 17 Dec 2018 00:26:42 GMT

Thanks for your reply. Actually I am having just one column in my collection and there is no parent node. Please see attached shots for collenction details and component details. I am also mentioned collection name in component as well. Actually I can print the values use tLogRow but the issue is when I import the data in excel job gets complete but excel is not opening saying "file format or extension is not valid verify that the file is not corrupted.."

Collection in tMongoDBInput .PNG
Schema.PNG

Re: MongoDB to Excel

Anonymous — Mon, 17 Dec 2018 04:35:43 GMT

Ok. I just want to rule out that possibility.

Just to do verification, could you please try to load in a csv file instead of excel? Or try to stream the output of current tLogrow to the excel file in xlsx format.

Warm Regards,
Nikhil Thampi

Note:- Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: MongoDB to Excel

Anonymous — Mon, 17 Dec 2018 14:12:45 GMT

Thanks Nikhil.

Actually I did try all of this and neither excel or csv was working. However I did found the soulution. I used following to fix and hereafter I can open the excel with imported Mongodb data. Thanks for your help. Not sure if this issue is because of Excel or what.

Fix 1. Change the Excel File Extension
Step 1. Open Microsoft Excel and go the File tab.

Step 2. Click Export and choose Change File Type

Step 3. Change the file extension to .xlsx. Check if Excel can open your file or not.