• ramadesai108 (9/28/2012)


    We do not have the layout file, how do I create one or where do I get one?

    Thanks.

    ouch, there is seriously no "easy" way on this then.

    to the best of my knowledge, you cannot jsut magically create one;

    each field, their meaning, data type and min/max values are all business dependent;

    it might be if you have some code that either creates or reads the edi file iteself, you need to go through the code.

    here's an example layout of one file the US gove happens to use; it goes to teh trouble to breakd own every value;

    you need something similar to make heads or tails of the incoming data.

    http://www.hud.gov/offices/cpd/systems/idis/edi/idis_edi_records_layout.pdf

    Even an experienced code monkey like me would need something like that as a starting reference.

    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!