UPS EDI ANSI 210/4030 Billing File Importer

[robsuttonjr]

I am working on a project where I need to import data from UPS (United Parcel Service) file. It is in EDI ANSI 210/4030 format. I am hoping that someone out there has already been through this and can share the code. Anybody have any ideas?

Regards,

Rob

 

[mmerlinn]

Please do NOT post the same question in multiple forums. See faq183-874 for more information.

That said, I refuse to answer any questions posted in more than one forum for fear I am wasting my time because unbeknownst to me the question has already been answered in another forum that I don't know about.


mmerlinn

"Political correctness is the BADGE of a COWARD!"

 

[robsuttonjr]

The reason I posted in 3 different areas is to get views from 3 vastly different areas. I would agree if I posted it in 3 foxpro type groups. However I posted in 3 areas that have no relation. I work with FoxPro & SQL server. If I could post in one forum where I could catch the attention of FoxPro, SQL Server and EDI knowledgeable people I would. It really is NOT the same question if you think about it as it applies differently to each of the areas posted as they each use different means to extract data, ie, FoxPro, SQL Server and other (EDI). I prefer to get this resolved using FoxPro but if someone has done this on SQL Server then I want to be able to make the best decision possible. Sometimes you need to think outside the box or rules in this case to get the best results.

Regards,

Rob

 

[Mike Lewis]

I think Rob's got a good point. I've occasionally done the same thing myself -- for example, posting a question on WiFi security both in a security-related forum and in a forum relating to the specific hardware device. I got valuable answers from people with quite different types of expertise.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[DSummZZZ]

I would agree if I posted it in 3 foxpro type groups.

For what it's worth, I'm with Rob here too. 3 Fox groups would have been a no-no. But I've never even set foot in a SQL forum. I would never have known it was posted there.

Anyway, I haven't imported that specific type of data, but I have imported other sorts of data which required other sorts of conversions on the fly which is what necessitated the writing of these functions:
Conversion Functions: Dec,Hex,Binary,Oct Back and Forth
faq184-4461

Many times it's just a matter of grabbing values a byte (LSB or MSB) at a time and converting them to hex, concatenating them, then converting that value to ascii.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm