Hello everyone. I have created a flow that watches for excel files in a folder, then writes the data from the excel file to an MSSQL database.
For a strange reason, my flow does not read the data from the excel file. It appears to be "empty".
This is the flow-
When I attach a debug node to the "sheet" node I receive a msg.payload undefined response.
When I attach the debugger to the "sheet to json" node I receive a msg.payload empty response.
What am I missing? I use the same flow construction on other flows and they work great.
I highly appreciate any help.
Edit:
Just tested it with other excel formats that I use and it works. That means something off in my file. Cant seem to lay my finger on it. Any advice?
This is the watch node-
It actually does manage to identify the file, the issue is that it says that msg.payload is empty eventhough there is data in it.
This is the full message debug from the watch node.
Are you getting multiple messages from the Watch node? That can happen because it tells you about the generation of temporary files, and in addition it can tell you before the file write is fully complete, so you may get multiple messages for the same file.
Thats because the other part of my flow adds a timestamp to the filename and then moves it to another folder.
For the sake of the screenshot I copied and pasted the file from the other folder back to the watched folder.
Yes I am getting multiple messages from the watch node.
What happened is that I copied a used file from the "archive" folder. The file had the original file name + timestamp.
I then pasted it to the watched folder. That explains why the name is different in the File node output.
After approximatly 4 hours of trying to figure out whats wrong, I came to the realization that theres nothing wrong in the flow. The problem is in the specific Excel file I had been working with.
After copying the format to a new excel file, it worked.