PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/10/2017 7:34 AM by  jamesraceson
Creating excel xlsx file instead of csv
 12 Replies
Sort:
You are not authorized to post a reply.
Page 1 of 3123 > >>
Author Messages
HDAustin13
IT programmer
Austin ISD
Basic Member
(17 points)
Basic Member
Posts:9


Send Message:

--
10/09/2017 10:46 AM
    Hello All,

    I have a flow that using SQL to produce an output to CSV file but the vendor keeps having an issue of opening it. In order to successfully open it, he has to rename the file extension from .csv to .xlsx each time. Does any know if IPA can produce an output excel file to .xlsx instead of .csv file? Can you please advise?

    Thanks, Han

    David Williams
    Private
    Private
    Veteran Member
    (3001 points)
    Veteran Member
    Posts:1011


    Send Message:

    --
    10/09/2017 11:03 AM
    If all the vendor is doing is to rename the file (and not having to open and save as), then just name the file with the different extension. I have a feeling they are opening and saving as Excel so it reformats correctly.
    David Williams
    Woozy
    Private
    Private
    Veteran Member
    (3466 points)
    Veteran Member
    Posts:700


    Send Message:

    --
    10/09/2017 11:07 AM
    Hi Han,


    The short answer is "no" . Writing a file to xlsx is far more complicated than just changing the extension and it is not really possible in IPA/PFI without extensive custom code.

    It's confusing to me that they are having an issue opening the file, because a csv file is just a text file with a comma (or some other) delimiter. If it is really a csv file, then you should be able to open it with any text editor. Can you open one of the files with notepad? If not, then there is something wrong with your file.

    When you say you're "using sql to produce an output to csv", do you mean that you are doing a SQL query in your flow, and then writing the data to a file using the FileAccess node in the flow?
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Woozy
    Private
    Private
    Veteran Member
    (3466 points)
    Veteran Member
    Posts:700


    Send Message:

    --
    10/09/2017 11:20 AM
    Hi David,

    If the file is being written as a "true" csv file, even if it is named with an .xlsx extension they won't be able to open it in Excel, will they? Excel will be expecting a file with an xlsx extension to be in the xlsx format, which as csv isn't.

    Maybe I'm missing your point?
    Kelly
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Woozy
    Private
    Private
    Veteran Member
    (3466 points)
    Veteran Member
    Posts:700


    Send Message:

    --
    10/09/2017 11:26 AM
    Ahhh - I think I misunderstood. The vendor really wants an Excel file rather than a csv file? I'm tracking now.

    Unfortunately, this is not an option with PFI/IPA. Technically it could be possible using a custom node written by developer who really understands the xlsx format. However, this is really not anything most companies would do.

    The csv format is pretty standard for transferring files. Any vendor worth their salt should be able to take a csv file and do whatever they need to do with it. Unfortunately, there are some vendors that will only accept Excel, and if that's the case here then you are (unfortunately) out of luck using PFI/IPA.

    Kelly
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    You are not authorized to post a reply.
    Page 1 of 3123 > >>