Limagito File Mover Software Blog and Filemover News

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
25 Mar
Log File keeps increasing although the maximum size is set
Log File keeps increasing although the maximum size is set
Dear users,
We recently installed our file mover at a new customer. From the first moment on we had issues with our History Log option (= logging to file). The log file kept on growing although the maximum logsize and log count were set. We tried many (many) different settings, we even installed our file mover on a second system but the result was always the same. Sometimes the filesize even stayed at zero bytes (using the Windows File Explorer) but when we opened the file it contained log data. We had never experienced this in all those years. After a lot of tests we found a workaround and changed our logging code. Now we count the bytes we write to the log file so we no longer depend on what the Windows Filesize API tells us. We changed this in version v2021.3.20.0.
We really appreciate all the help we got from Jason and Jay.
If you need any help with this ‘Log File keeps increasing’ issue, please let us know.
Best Regards,
Limagito Team
By Limagito-Team Logging log, size