Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pricing EDI Feed Processing System Expand / Collapse
Author
Message
Posted Wednesday, May 19, 2010 7:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 9:03 AM
Points: 306, Visits: 261
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.
Post #924304
Posted Wednesday, May 19, 2010 8:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:20 AM
Points: 12,927, Visits: 32,332
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #924358
Posted Wednesday, May 19, 2010 8:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 9:03 AM
Points: 306, Visits: 261
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.
Post #924367
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse