How to import csv file
-
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.
- This topic was modified 9 months, 1 week ago by smattiko83.
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
- 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