MongoDB to Excel

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous · Accepted solution]

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.