|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: <MISC> Mapping Documentation Software
Try www.inobiz.com
For each map You have four types of documentation. Example below
shows one of the documentations for SQL to X12 mapping.
Inobiz Development System - 2004-03-31 17:20:24
===============================================
SQL - X12 file
Map file 'C:\develop\edic5\x12\fs.eds'
Implementation Guide - Mapping details
========================================================================
ISA - Interchange Control Header
========================================================================
Name Description Num Len C/M Mapping notes
---- ----------- --- --- --- -------------
ISA01 Authorization Information Qual 101 2 m INSERT INTO
abc (col1) VALUES (@)
ISA02 Authorization Information 102 10 m Not mapped
ISA03 Security Information Qualifier 103 2 m INSERT INTO
abc (col2) VALUES
<target> =
<source>;
integer i =
778;
ISA04 Security Information 104 10 m Not mapped
ISA05 Interchange ID Qualifier 105 2 m Not mapped
ISA06 Interchange Sender ID 106 15 m Not mapped
ISA07 Interchange ID Qualifier 105 2 m Not mapped
Next example is one of the XML to flat file mapping documentation styles
--------------------------------------------------------------------------
Inobiz Development System - Implementation Guide
--------------------------------------------------------------------------
Project file:
C:\develop\edic5\eds5\Support\enator\case1\MerittInspectedInvoices.eds
Date and time for documentation: 2004-03-31 17:40:56
SOURCE file TARGET file
File type: xml File type: flatfile
Root name: INVOICE_CENTER Root name: TargetFile
Field length (variable/fixed): Field length (variable/fixed):
fixed
Field delimiter: "" Field delimiter: ""
Record delimiter: "" Record delimiter: "\r\n"
SOURCE field TARGET field
CONTENT_FRAME.ChoiceGroup7.INVOICES.INVOICE.CONTROL.ARCHIVE_CONTROL.IDENTIFI
ER_ID.pcdata MerittInspectedInvoices.Company
Description: attribute Description: Company
Type: alphanumeric Type: alphanumeric
Conditional/Mandatory: conditional Conditional/Mandatory:
conditional
Length: 1000 Length: 3
Mapped to source: yes
Map type: statement
Program code: string sOrganisationsId = ""; xmlptr p =
INVOICE_CENTER.CONTENT_FRAME; ; for ( ; xmldata (p); ++p) { if
(p.ChoiceGroup7.POSTINGS.POSTING.IDENTIFIER.IDENTIFIER_ID.pcdata ==
<source>) { sOrganisationsId =
p.ChoiceGroup7.POSTINGS.POSTING.IDENTIFIER.ORGANIZATION_CODE.pcdata;
break; } } <target> = sOrganisationsId;
TRANSPORT_FRAME.TF_CODE.pcdata
MerittInspectedInvoices.SubLedger
Description: attribute Description: SubLedger
Type: alphanumeric Type: alphanumeric
Conditional/Mandatory: conditional Conditional/Mandatory:
conditional
Length: 1000 Length: 1
Mapped to source: yes
Map type: direct
Program code:
Regards
Kurt Svensson
Inobiz
www.inobiz.com
/>
> I know of the many mapping products/editors within the XML space that
offer drag and drop
> utilities for the mapping creation but I have not as yet come across any
solutions that allow both
> the creation of the mapping and generate some GOOD mapping documentation
(commonly accepted
> formats).
>
> Thanks for your feedback and any pointers.
> Steve
>
>
>
>
>
> ___________________________________________________________
> WIN FREE WORLDWIDE FLIGHTS - nominate a cafe in the Yahoo! Mail Internet
Cafe Awards www.yahoo.co.uk/internetcafes
>
>
> .
> Please use the following Message Identifiers as your subject prefix:
<SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
>
> Yahoo! Groups Links
>
>
>
>
>
>
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
