Q: How do I stop the sql extract from writing a file if there are no records? It is writing a file with the header row. Please advise.
A: We added a new option in v2026.8.12.0 for SQL as Source: Minimum Records Needed
So we need at least a minimum of returned records before we’ll write the destination csv file.
Best Regards,
Limagito Team
#sql #managedfiletransfer #filetransfer #filemanagement #limagito
Q: I would like to unzip JPG from a ZIP files. Every ZIP files contain JPG, XML. I would try to extract only JPG files from ZIP, but I can’t do it. All files are extracted, that obliges me to add deletion rule to delete XML files in the target folder. Is it possible to build a rule, and ask for extract only .JPG files from ZIP ?
A: In version v2021.10.8.0 we added a new Extract Mask option in the UNZIP Destination Setup to achieve this. We immediately added an include and exclude Extract Mask.
In this example we set the ‘Extract Include Mask’ to *.jpg so only jpg files form the zip (or other compressed file) will be extracted.
#FileTransfer
Best regards,
Limagito Team
Limagito filemover is an automated file mover solution handling everything from moving, deleting to copying files.
Please don’t hesitate to contact us if you have any questions about our product and services.