Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Pricing EDI Feed Processing System


Pricing EDI Feed Processing System

Author
Message
Danny Sheridan
Danny Sheridan
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 266
Hey All - I've just been assigned the task of reading in an EDI 811 feed from one of our clients, and this is something we/I have never done before. Basically, the process that will handle these feeds from start to finish (reading them in to creating the invoices and reporting), is being created from scratch. I have a few options I've come up with so far on the route I believe I'll be taking to accomplish this task, but I was just curious if anyone else has been assigned something similar and/or if anyone has heard of any pricing estimates for a system like this?

A little background on the EDI 811 format:
1) File contains three main parts - Heading Area, Detail Area, Summary Area
2) Each of these segments can contain various information from multiple tables
3) Simply put, it is a bunch of relational database tables extracted into a flat file

I'm mainly going to be utilizing SSIS, T-SQL, UDF's and SProcs, and a little VB and PowerShell scripting to complete the lifecycle of this EDI reading process. Does anyone know what a fair price would be for implementing a Bill Reader system such as this from the ground up (i.e. reading in file, normalizing to standard format, consolidating invoices for auditing, reporting on invoices)?

Thanks in advance!

Danny Sheridan
Comtekh, Inc.
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14957 Visits: 38958
I currently maintain a system that does EDI 864 records;(?? didn't really notice they are numbered)

if you have the schema and sample EDI file, I could look to see if you could use a .NET version sample of my code to do it yourself.
do you only need to import, or do you need to output files in that format as well?

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Danny Sheridan
Danny Sheridan
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 266
Thanks Lowell. The 811 after EDI refers to the format of the feed (e.g. EDI 810 and EDI 811 are invoicing EDI feeds in X12). There are others such as 850 which refers to ORDERS feeds, among many others.

Unfortunately, due to data privacy, I cannot offer a sample feed or the schema of the feed. I was looking more to see if anyone else has implemented this type of system and the costs and efforts associated with it.

I also just need to import the file to our system (SQL Server 2008) and parse out and normalize the data, where I will then run logic to match the invoices up to our asset inventory to produce the bills. There will also be a reporting system embedded for auditing purposes for finance folks.

I'm still curious as to the method you approached with your .NET code - as I plan on parsing the data out with string functions (CHARINDEX to find the occurences of segment delimitters), then send each unique segment to its appropriate table. I understand if you don't want to, or are unable to provide some of that information.

I've searched around and it's not easy finding information on methodologies used to import/process EDI feeds, so I'm open to suggestions if you think my first course of action I'm going to attempt has holes. Thanks again!!

(Typo - Edited EDI 8100 to EDI 811 in first line and changed some wording)

Danny Sheridan
Comtekh, Inc.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search