Question SQLFileExport MaxFileSize issue

Start
Prev
1
Next
End

nicolasdohet
Topic Author
Offline

12 Dec 2018 09:33 - 12 Dec 2018 09:35 #1 by nicolasdohet

SQLFileExport MaxFileSize issue was created by nicolasdohet

Hi,

I work with 18.3.9 designer
I'm trying to use SQLFileExport in order to split a table in multiple files, with File size 10M max.
I use Sql Exp Filename to define the pattern name , and Sql Exp Max File Size to define 10M
I Got an issue due to the namming of files, because the increment comes after extension files (.csv in my case)
How can i solve it ? renaming files ?
Is it possible to chosse extension pattern for files we create ? (.txt, .csv , ...)

Thanks.

Last edit: 12 Dec 2018 09:35 by nicolasdohet.

Pierre-Olivier Mazen
Offline

13 Dec 2018 17:54 #2 by Pierre-Olivier Mazen

Replied by Pierre-Olivier Mazen on topic SQLFileExport MaxFileSize issue

Hi,

when using Max File Size, the number of the file is added at the end of the file name as you noticed.
The solution would be to rename the files after the generation.

I would suggest to use SQLFileExport without any file extension, and at the end, use a WaitForFile that you would bind to a Move File Action that would add the required extension.

nicolasdohet
Topic Author
Offline

14 Dec 2018 12:56 #3 by nicolasdohet

Replied by nicolasdohet on topic SQLFileExport MaxFileSize issue

Hi Pierre Olivier,

That's what i'm doing actually but i was thinking it's a bit loud.
Ok, i keep on using it.
Is it impossible to fix the problem in the SQLFileExport box ? adding the extension by using metadata or parameter after adding the sequence number ?
Thx.

Pierre-Olivier Mazen
Offline

14 Dec 2018 14:46 #4 by Pierre-Olivier Mazen

Replied by Pierre-Olivier Mazen on topic SQLFileExport MaxFileSize issue

Hi,

yes the enhancement request has been filled to R&D Team.
It will be implemented in a future release of Stambia.

Best,

Start
Prev
1
Next
End