- This topic has 3 replies, 4 voices, and was last updated 8 years, 9 months ago by
.
-
Topic
-
I have a system that wants to export data into an Excel file and have Cloverleaf pick up the file for processing via FTP. I have used fileset-FTP protocol in the past for text files (.txt), files that contain hl7 messages (.hl7) and comma delimited files (.csv) I have not been able to get the Excel file (.xlsx) to work. I asked the system to export a .csv file, but they told me that they cannot. I tried using the cp command and the mv command to change the file extension in Cloverleaf, but it does not convert the file. The only way I can get the .csv file is to convert it before it gets to Cloverleaf. Any ideas?
-
Replies
-
-
I’ve got to believe there are a number of utiilities out there that convert excel files into csv (probably some is freeware). Do a Web search.
I would say put the onus on the sending system to acquire said software and pre-process the excel file into the agreed upon csv structure placing the csv file in the directory agreed upon with the file name agreed upon.
That way if the excel changes it is their responsibilty to produce the appropriate file.
Then pick up with Cloverleaf.
If Cloverleaf is running on a Windows platform you could pick up the file then execute said utility from a dirparse UPoC of another Fileset (Local) thread I think and now you have the CSV on your platform and either using another Fileset/Local to pick up and process the CSV file or some additional Tcl you can process through Cloverleaf.
If you can find a utility which runs on Unix and your Cloverleaf is on Unix then the above could work as well I guess.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
-
-
- The forum ‘Cloverleaf’ is closed to new topics and replies.
