Error in multiple files import

1

Hi all,

Hoping you can help me solve this issue I’ve been having.

I setup import data step to take all spreadsheets within a folder, except of the ones starting with ‘~$’ (to avoid temporary files) using regular expression as per below:

image
image547×649 164 KB

The number of spreadsheets in this folder varies - some will be added, and some will be deleted on daily basis. I wanted this step to take only the existing files and ignore the past files that have been moved to a different folder or deleted.

Unfortunately this error pops up almost everyday when I’m trying to run the flow:

image
image888×267 38.5 KB

Could anyone please shed a light on what’s happening and how can I prevent this from re-appearing?
Thank you in advance.

Mario

2

Hi Mario,

How often are your spreadsheet files added and deleted?

The list of files that matches the search criteria is calculated at the start of the import action and then files from that list are read one by one. So if a file was deleted after the files list calculation but before the actual import of that file, the “File not found” error will be issued.

3

Hi Andrew,

Thanks for your reply.

The file is added pretty frequently at random times, but deletion is always manual by myself, and I made sure to do it sometime before running the process.

For further clarity, the files are not touched by anyone after being added into the folder to prevent importing issue.

4

Mario,

Is the file specified in the error message present in the folder when the error is raised?

If so - is it possible to import that file in the “Load single file” mode?

5

Hi Andrew,

The file is not present during the import process, as I have archived it.
(Older files will have to be achieved from time to time to prevent file size bloating)

The problem is, because the file was archived (older file - I do not want it imported), logically EasyMorph should not even tried to import it.

To make it more complicated, I actually archived 10~ files, and for some reason EasyMorph only tried to import this particular file.

6

Hi Mario,

Can you please describe when and how the files are archived?
Do the archived files are stored in the same folder?

As for other archived files - EasyMorph will import files one by one and will report the first missing file. It stops the import process after an error and doesn’t check if all the remaining files are actually present.

7

Hi Andrew,

Thank you for the insight.

The files are archived by dragging it into a folder within the same folder.

Sometimes I manually delete files as well due to various reasons - but these are all done prior to running the process.

8

Hi Mario,

We couldn’t reproduce this error.

Can you please try the following workaround?

  • Use the “List of files” action to create a list of files in the target folder
  • Use the “Filter by search” action to filter out temporary files
  • Use the “Import Excel spreadsheet” action in the “Load list of files” mode to
    import spreadsheets.

Will the error persist?

1 Like
9

Hi Andrew,

Thanks for the solution - from two days of testing, it seems that the problem has gone away.
Will let you know if the issue appears again, but so far it’s good!