Readers (CSV / Trimble JobXML) when used with empty directories

Question

Hello all

I have a question regarding readers when used with possible empty directories and resulting error messages.

In a FME workbench, a CSV reader reads all CSV files within a directory and then processes them. If one or more CSV files are present in the defined folder, the Workbench works perfectly. However, if there are no CSV files in the folder at the time of execution, an ERROR is issued:

ERROR |CSV reader: Failed to open file '\\\\Auto-Import\\**\\*.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read it.

With the FME Desktop version 2019.2 that we are currently still using, I was able to set the Workbench to continue running even if an error occurred. However, this is certainly not the most ideal solution. Especially it is difficult to detect actual error messages in the log files.

The Workbench is automatically executed every hour by the task scheduler.

Another problem is that the CSV Reader is part of a Workbench that is supposed to be executed even if there are no CSV files to process at the time of execution. Therefore it is not possible to check if CSV files are available before starting the FME Workbench and if not, the Workbench is not started at all.

Is there a way to work around this error?

I have the same problem in the same workbench with a "Trimble JobXML" reader. But there the solution will probably be identical to that for the CSV Reader.

Thanks in advance

Page 1 / 1

One way to check if the directory contains CSV files is to use the Directory and File Pathnames reader. You then also can use the output as input for a FeatureReader, reading the files the previous reader found.

For the second question, a Creator transformer can be used to initiate any transformer.

One way to check if the directory contains CSV files is to use the Directory and File Pathnames reader. You then also can use the output as input for a FeatureReader, reading the files the previous reader found.

For the second question, a Creator transformer can be used to initiate any transformer.

Thanks @nielsgerrits for the advice!

The solution with the FeatureReader works as a replacement for both the CSV and the Trimble Job XML reader.

Reply

nielsgerrits · Accepted Answer

One way to check if the directory contains CSV files is to use the Directory and File Pathnames reader. You then also can use the output as input for a FeatureReader, reading the files the previous reader found.

For the second question, a Creator transformer can be used to initiate any transformer.

erich_st · Answer

One way to check if the directory contains CSV files is to use the Directory and File Pathnames reader. You then also can use the output as input for a FeatureReader, reading the files the previous reader found.

For the second question, a Creator transformer can be used to initiate any transformer.

Thanks @nielsgerrits for the advice!

The solution with the FeatureReader works as a replacement for both the CSV and the Trimble Job XML reader.

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded