Limagito File Mover Software Blog and Filemover News

04 Apr
Exclude some subfolders and the subfolders of the excluded subfolder
Q: Exclude subfolders and the subfolders of the excluded subfolder. I’m connecting to a FTP site, looking through the folders for any files older than 28 days but I want to exclude some sub-folders and the sub-folders of the excluded folder.
My current ‘Directory Filter’ setup doesn’t seem to work:
My current ‘Dir Name’ Exclude filter:
I also changed the Directory Filter Setup – Advanced – Exclude Complete Invalid SubDirs hoping it would skip the sub folders of the GRAPHICS PURGE folder.
Limagito Team: “Reason, SubDir Search Mode (WIN) is for WIN as source only”
But in the log file we see the ‘GRAPHICS PURGE’ folder and its subfolder BUL are not being excluded.

Limagito Team:
It is possible to achieve this but you’ll need to add some extra ‘Dir Name Exclude’ Filters, leave the ones you already had.
GRAPHICS PURGE
*/GRAPHICS PURGE/*
Ads
*/Ads/*
PDF
*/PDF/*
#FileTransfer
If you need any help with this ‘Exclude some subfolders’ request, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Filters exclude, subfolders
04 Apr
Q&A 42: Remove quotation marks around the data in a csv file
Q: Remove quotation marks around the data in a csv file. An Excel file is saved that has quotation marks around the data in the file. Which can be removed by opening Excel and re-saving as the CSV, but this is a manual step at this time. Would we be able to setup a Limagito rule to be able to do something similar for us?
A: Yes this is possible using our XLS as Destination option. XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention so we know we need to handle them differently.
Some screenshots to get you started:
1. Since we only want csv files, be sure the set the ‘Filename Include’ filter to *.csv in the ‘File Filter Setup’.
2. We added XLS as Destination, XLS as Destination also handles CSV files. Just be sure that the source files have .csv as extention.
3. XLS.CSV as Destination setup. The Output File Format will be ‘Text, Delimiter separated values – with CRLF as End Of Line’.
Also ‘Text, Delimiter separated values – with LF as End Of Line’ which was added in version v2021.4.4.0
This way you also can convert:
CSV with CRLF as Source to CSV with LF as end Of Line Destination
CSV with LF as Source to CSV with CRLF as end Of Line Destination
To remove the quotation marks you need to enable ‘Import full csv file as text’ option (Common Tab).
#FileTransfer
If you need any help with this ‘Remove quotation marks’ request, please let us know.
Happy Easter,
Limagito Team
By Limagito-Team Q&A XLS/CSV crlf, csv, linefeed, marks, quotation
28 Mar
HL7 getOrderDocument Request ABN using Limagito File Mover
Q: HL7 getOrderDocument Request ABN using Limagito File Mover. I would like to resume if possible the sending to ‘MyDomain’ with the ABN option. From my understanding we will use the same wrapper which is working well to send to a new url with a document type of ABN. ‘MyDomain’ will review the codes within the HL7 message and determine the patient needs to sign an ABN form. If they do not ‘MyDomain’ will process the order message and result back using the current download. If the patient has to sign ABN form ‘MyDomain’ will kick back the ACK with a code, we will need to download the ABN form and place on the local server for the staff to get the patient to sign. The order will be processed and resulted, the signed ABN form will be placed with the pickup order.
A: We added this option in version v2021.3.28.0. FYI, we are using REST/JSON (not SOAP).
We added some screenshots to get you started. This is how we tested this new option.
Use WIN as Source. Put your HL7 files needed for the getOrderDocument ABN request
Please add two destinations. Important, the first destination should be HTTP and the second destination WIN
HTTP as Destination setup:
Be sure to select the ‘Result Directory’ Folder. Here we’ll put the ABN pdf files if required
Select ‘Content File as HL7 getOrderDocument ABN’ as Content Selection
‘Content File’ option should stay: %SFP%SFN.
This way we’ll use the content of the source HL7 files for the getOrderDocument Request
Add a second Destination, use WIN as Destination.
This is where we’ll move the source .dat HL7 files to when HTTP POST is successful.

Set Function Setup as in the following screenshot:
We enabled the ‘Exit Cyclus on Error’ option so if the HTTP Destination fails (which is the first one), we’ll leave it in the source folder and try again during the next scan.
So when we get a HTTP error we’ll not move it to the second Destination (WIN).
RunTime Log Result:
If you need any help with this ‘HL7 getOrderDocument Request ABN’ issue, please let us know.
Best Regards,
Limagito Team
By Limagito-Team HL7 HTTP ABN, getOrderDocument, HL7