Post reply

How to import csv file

  • February 13, 2024 at 8:26 pm

    #4378146

    I'm trying to import this csv file but i am unsure how. The demo row has a bsu id and the rows below it are related to that id until another bsu id is shown. Any ideas on what I should do? I've been told it is similar to an 837 file.

     

    I've attached the file that contains the data and headers and also the same file without header also.

     

     

    sample

    • This topic was modified 10 months, 1 week ago by  smattiko83.

    Attachments:
    You must be logged in to view attached files.

  • February 14, 2024 at 9:10 pm

    #4378794

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • February 15, 2024 at 1:44 am

    #4378875

    smattiko83 wrote:

    Any ideas on what I should do? I've been told it is similar to an 837 file.

    With some good bit of work, the header version could be parsed but I wouldn't do that.

    Have the people sent the data as and actual EDI 837 formatted file and buy an EDI 837 parser.

    What would be even better is if they sent you multiple files (1 for each perceived table) and information on how to join the tables once they're in the database.

    I'll never understand why people use EDI, XML, JSON, or a wealth of "methods" to transfer relational data.  IMHO, it's not convenient or efficient, period.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply