Recent content by voyageur

Why would you not use a map? Infact, now that you've done the translation outside of Gentran, it should be a snap to map it: 810 to 810.

Also find out what the standards are for your industry. Some trading partners support more than one standard so you will want to choose a standard that is most common for your industry if you can. I've supported two different standards (UCS and X.12) as well as multiple versions. If you have...

You may be able to rid yourself of the first messages by adding the host of the DAP in the trusted sites list or zone of IE6 and then turning off some of the warnings for that zone (See IE6 Tools|Internet Options|Security|Trusted Sites)

Thanks for the code Andrew. It works great in normal VB.NET. I'll give it a try where I really need it...in a SQL Report Server RDL report.

Is there an easy way to programmatically determine if a website URL actually points to a live page so that I can filter out non-existent pages so end users don't have to find out for themselves when they click on the hyperlink?

I've also heard talk of "compiled XML". The concern over the size of XML documents has prompted the industry to look at compressing XML to a smaller, machine readable only format. So keep a lookout for this too.

Great suggestion, thanks

I'm looking for something similar but because I'm running the query from MS SQL 2000 Report Server I can't use the INTO clause. I need the equivalent of the Oracle rownum virtual field. Any suggestions?

It depends on your translation software. Under Gentran a turnaround translation is meant to go back to the original sender. I've used it to by manipulating the outbound document to send documents to a third party. A better solution (with Gentran) would be to map the inbound 820 to a 820...

You should find out what version of the 997 your trading partner is expecting or negotiate the version you want to use with them

It really depends on what your flat file looks like. I'm not using the same version as you are but I have had great success in setting up temporary segments on the inbound size ($$$ segments) and using rules to map the elements reqired and then using the standard mapping to the output side...

I'm not sure but it sounds like you may have left out a maditory element / segment or a conditional element may be missing one of its related elements

Sorry for the late reply Move the input field into an array of 1024 one character element. Process the array one element at a time to a similarly defined output array. Stop everytime you run into the quote, move the output array to the output field, output the record and clear the array...

I've been away from the 400 for a few years so can you remind me what a DDMF type is?

If it's a one time occurence you can always open the EDI source file with a text editor and change the T to a P in the ISA envelope and then re-process the interchange. If it is supposed to be a Production transmission, call your partner and have them change it in their system and retransmit so...