Clovertech

Excel files

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Excel files

  • Creator
    Topic
  • November 30, 2015 at 9:43 pm #54896
    Christy Stepp
    Participant

      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?

    • Creator
      Topic
    Viewing 2 reply threads
    • Author
      Replies
      • December 1, 2015 at 3:34 am #83340
        Jim Kosloskey
        Participant

          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.

        • December 1, 2015 at 9:33 am #83341
          Charlie Bursell
          Participant

            If on Windows use the tcom package

            I agree with Jim.  I see no reason the vendor cannot save the file as a CSV file before sending to you

          • December 1, 2015 at 1:43 pm #83342
            Peter Heggie
            Participant

              quick question – is the xlsx file there, and the Cloverleaf FTP protocol cannot find it / pick it up? Or do you need Cloverleaf to deliver it in a modified format/name?

              Peter Heggie
              PeterHeggie@crouse.org

          • Author
            Replies
          Viewing 2 reply threads
          • The forum ‘Cloverleaf’ is closed to new topics and replies.