Integrations CSV Import - need filename wildcard

15Views
Last Post 12 December 2018
Topic Is Solved

votes

Stew Stremel posted this 10 December 2018

posted 10 December 2018

In integrations I am trying to import a CSV file from a SFTP server. The source files are created with the following format:

GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMddhhmmss}.csv

and placed there for us to pick up. Is there the ability to use a wildcard? aka:

GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMdd}*.csv

Is there anyway to accomplish this or does the system HAVE to have an exact match on the file name?

csv import

3 Comments

Order By: Standard | Newest | Votes

votes

Mariia Zaharova posted this 11 December 2018

posted 11 December 2018

Mariia Zaharova

Admin

Hello Stew,

Unfortunately, file masks with wildcards are not supported. The recommended file masks are:

GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMdd}.csv

GFPVAN_RHSC_DiscreteOrderDownload_1.0_{yyyyMMddhh}.csv

Please note, it's not recommended to use seconds or fractions of seconds, and even minutes in the mask, since it's not guaranteed that package will run in exactly the specified time. When Skyvia is under peak load, package run may be delayed for a few seconds. And even if the difference of the package run time and the date/time in the file name is minor, the package run will fail.

See https://skyvia.com/resources/docs/index.html?importing_csv_files_via_mask.htm

We will definitely consider the possibility to improve file masks for such cases and reply you back as soon as possible.

Best regards,

Mariia

votes

Stew Stremel posted this 11 December 2018

posted 11 December 2018

Stew Stremel

Ok,

thanks I will structure per day - and - for dealing with inbound files this would be a very good feature to have.

votes

Mariia Zaharova posted this 12 December 2018