Integrations CSV Import - need filename wildcard

  • 144Views
  • Last Post 12 December 2018
  • Topic Is Solved
0
votes
Stew Stremel posted this 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?

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 11 December 2018

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

 

0
votes
Stew Stremel posted this 11 December 2018

Ok, 

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

0
votes
Mariia Zaharova posted this 12 December 2018

I will definitely post here the results as soon as any available.

 

Best regards,

Mariia

Close