[eGroups Migratio...]

I am new to Datamapper and have been unsuccessful in solving my current error. I have asked Axway professional services for support but they have not provided a solution.

I have a fixed format input file that needs to be parsed into the X12 830 document. Input looks something like:

830PSH SAFEWAY ADDRESS CITY STATE ZIP VENDOR ADDRESS CITY STATE ZIP

The output needs to be written into the X12 830 document as:

N1,FR,SAFEWAY
N3,ADDRESS
N4,CITY,STATE,ZIP
N1,TO,VENDOR
N3,ADDRESS
N4,CITY,STATE,ZIP

The first issue is that the X12 830 output writes N1,N1,N3,N3,N4,N4. I have had no luck in solving this issue.

The second issue is that if I loop I am unable to determine if the Origin and Destination names are filled appropriately. If I code a @variable<>"" in the condition and a "FR" in the expression, I will get a "FR" in the N1,e01 everytime. The only option I see at this point would be to code @variable="SAFEWAY" then N1,e01 should be "FR". This works but I have not been able to solve a simple IF/THEN/ELSE solution to put the "TO" in N1,e01 if the @variable is not SAFEWAY.

This seems like it should be easy but is proving complex. Any ideas?

thanks

Russ

[eGroups Migratio...]

Hi Russ,

Have you tried using literals to map to your output? Click on the literals tab, create a literal and link it to output.

Herb

[eGroups Migratio...]

Hi Herb,

I have literals mapped to the output but I imagine I would have the same issue if I mapped two literals to the same loop in the output.

The fixed format input is mapped as follows:

LOOP 1/1
Static values 1/1
LOOPING Input 2/2
Extras 1/1

The output is mapped to the X12 830 document:

N1_LOOP
N1/e02
N3/e01
N4/e01-e04

Since I don't have control over the X12 830 Document output map variables, I figure the solution needs to be in the application map or in a structural or data link.

The IF/THEN/ELSE still has me baffled.

Thanks

Russ

[eGroups Migratio...]

I am new to Datamapper and have been unsuccessful in solving my current error. I have asked Axway professional services for support but they have not provided a solution.

I have a fixed format input file that needs to be parsed into the X12 830 document. Input looks something like:

830PSH SAFEWAY ADDRESS CITY STATE ZIP VENDOR ADDRESS CITY STATE ZIP

The output needs to be written into the X12 830 document as:

N1,FR,SAFEWAY
N3,ADDRESS
N4,CITY,STATE,ZIP
N1,TO,VENDOR
N3,ADDRESS
N4,CITY,STATE,ZIP

The first issue is that the X12 830 output writes N1,N1,N3,N3,N4,N4. I have had no luck in solving this issue.

The second issue is that if I loop I am unable to determine if the Origin and Destination names are filled appropriately. If I code a @variable<>"" in the condition and a "FR" in the expression, I will get a "FR" in the N1,e01 everytime. The only option I see at this point would be to code @variable="SAFEWAY" then N1,e01 should be "FR". This works but I have not been able to solve a simple IF/THEN/ELSE solution to put the "TO" in N1,e01 if the @variable is not SAFEWAY.

This seems like it should be easy but is proving complex. Any ideas?

thanks

Russ

Russ

My usual response to such problems is to go back to first principles. Which version of Datamapper do you have ? I would highly recommend you use the "Structural Links" option which I believe is available from 3.0.7.. It was introduced to prevent extreme hair loss in situations like this.

Assuming you have that, then you must first decide how many occurrences of your output you need. If there is a container on the input side you can use that corresponds, then all well and good, you can use the "each" option on the link. If there isn't ( for example where you have an SQL query as the source data ) then you have to be more devious, and maybe even use the "Specify" option in the "Loop Expression" and "Source Reference" of the container link.

In this case it doesn't look too bad. If I understand you, I think you need to have 2 N1 loops for each input record. Make a copy of the N1 loop in the output view (with a different name) and map the input record to each N1. That gives you 2 N1 loops for each input. Then you can use the relative addressing of the input ( @ThisOccurrence etc - look in the manual for details ) if you need to.

Sound like you need some training in any case...

Hope that points you in the right direction (ish)

Regards

Mark S

[eGroups Migratio...]

Russ

My usual response to such problems is to go back to first principles. Which version of Datamapper do you have ? I would highly recommend you use the "Structural Links" option which I believe is available from 3.0.7.. It was introduced to prevent extreme hair loss in situations like this.

Assuming you have that, then you must first decide how many occurrences of your output you need. If there is a container on the input side you can use that corresponds, then all well and good, you can use the "each" option on the link. If there isn't ( for example where you have an SQL query as the source data ) then you have to be more devious, and maybe even use the "Specify" option in the "Loop Expression" and "Source Reference" of the container link.

In this case it doesn't look too bad. If I understand you, I think you need to have 2 N1 loops for each input record. Make a copy of the N1 loop in the output view (with a different name) and map the input record to each N1. That gives you 2 N1 loops for each input. Then you can use the relative addressing of the input ( @ThisOccurrence etc - look in the manual for details ) if you need to.

Sound like you need some training in any case...

Hope that points you in the right direction (ish)

Regards

Mark S

Hi Mark,

We are running V3.1.1 of DataMapper. Yes, we need education and we are waiting on Axway to provide such. I am also surprised that the professional resources individual assigned to our company was not able to answer these questions. Structural links are defined for the input to output mapping and have an each defined for loop expression and source reference.

The fixed format file is 514 bytes of data. The input file only has one of these records. The first 31 bytes of data is constant and only appears once in the record. The next 382 bytes of data needs to loop twice, 191 bytes each. The last 101 bytes of data is fillers. According to Axway the application input is set up correctly.

The mapping is providing the X12 830 document with the correct data in the correct variables. DM is writing the records in order as to how the output variables are defined. I have no control over the output map except through the input map and structure and data links.

Russ

[eGroups Migratio...]

Hi Mark,

We are running V3.1.1 of DataMapper. Yes, we need education and we are waiting on Axway to provide such. I am also surprised that the professional resources individual assigned to our company was not able to answer these questions. Structural links are defined for the input to output mapping and have an each defined for loop expression and source reference.

The fixed format file is 514 bytes of data. The input file only has one of these records. The first 31 bytes of data is constant and only appears once in the record. The next 382 bytes of data needs to loop twice, 191 bytes each. The last 101 bytes of data is fillers. According to Axway the application input is set up correctly.

The mapping is providing the X12 830 document with the correct data in the correct variables. DM is writing the records in order as to how the output variables are defined. I have no control over the output map except through the input map and structure and data links.

Russ

Hi Russ,

I quickly tried out to map from your 1 record to the 830 X12 EDI format, and this is the result I got:

ST*000*0000\n
N1*FR*SAFEWAY\n
N3*ADDRESS\n
N4*CITY*STATE*ZIP\n
N1*TO*VENDOR\n
N3*ADDRESS\n
N4*CITY*STATE*ZIP\n
SE*8*0000\n

Is this what you expected?

Please note that I only mapped the N1_LOOP, the ST and SE segments are mapped by default.
I didn't use Structure Links, but straight forward mapping :-)

Attached the fold created by Datamapper (but WINZIPPED due to size limitations of the Yahoo Groups). Hope this helps.
Please don't hesitate to contact me in you need any further assistance/support,

Cheers,
Wim Jans

[eGroups Migratio...]

Hi Russ,

I quickly tried out to map from your 1 record to the 830 X12 EDI format, and this is the result I got:

ST*000*0000\n
N1*FR*SAFEWAY\n
N3*ADDRESS\n
N4*CITY*STATE*ZIP\n
N1*TO*VENDOR\n
N3*ADDRESS\n
N4*CITY*STATE*ZIP\n
SE*8*0000\n

Is this what you expected?

Please note that I only mapped the N1_LOOP, the ST and SE segments are mapped by default.
I didn't use Structure Links, but straight forward mapping :-)

Attached the fold created by Datamapper (but WINZIPPED due to size limitations of the Yahoo Groups). Hope this helps.
Please don't hesitate to contact me in you need any further assistance/support,

Cheers,
Wim Jans

Hi Wim,

Yes. This is what I expected. Unfortunately, I have had no luck.
When I try direct mapping, no structural links, I get the following error message.

Link[1]
First link must be a structural link

Perhaps this is something related to the new version of Datamapper.

The FLD file you sent I have not been able to open. The version of Axway DataMapper I am using has .adf, .map, .arc, .s4m, files. Not sure how to access this file. Most of the posts I have read on the Internet so far are uncertain what a .fld file is.

Russ

[eGroups Migratio...]

Hi Wim,

Yes. This is what I expected. Unfortunately, I have had no luck.
When I try direct mapping, no structural links, I get the following error message.

Link[1]
First link must be a structural link

Perhaps this is something related to the new version of Datamapper.

The FLD file you sent I have not been able to open. The version of Axway DataMapper I am using has .adf, .map, .arc, .s4m, files. Not sure how to access this file. Most of the posts I have read on the Internet so far are uncertain what a .fld file is.

Russ

.fld is the fold format - like an archive .arc but produced from datamapper itself rather than datamapper builder. This was discontinued on the latest versions of datamapper. It's worth getting the latest java version as it includes useful stuff for building statements etc.

To produce the .arc file just open the project in datamapper builder, and select new archive of the archive menu.

Zac

[eGroups Migratio...]

.fld is the fold format - like an archive .arc but produced from datamapper itself rather than datamapper builder. This was discontinued on the latest versions of datamapper. It's worth getting the latest java version as it includes useful stuff for building statements etc.

To produce the .arc file just open the project in datamapper builder, and select new archive of the archive menu.

Zac

Unable to open the .fld document with DM Builder. There are several incompatibilies with Synchrony4 and previous versions. This must be one of them.

Would a simulation trace be of help? You will notice in the output the firing of N1 N1 N3 N3 N4 N4. Almost like the N1 is looping, then N3 is looping, then N4 is looping, instead of Looping on N1_LOOP.

Russ


=== INPUT begin ===
MTF_000M:1
PSH_LOOP:1
PSH_LOOP:2
PSH:1
PSI:1
PSF:1
PSD:1
LOOP:1
PSF:1
PSD:1
LOOP:2
PSF:1
PSD:1
LOOP:3
PSF:1
PSD:1
LOOP:4
PSF:1
PSD:1
LOOP:5
PSF:1
PSD:1
LOOP:6
PSF:1
PSD:1
LOOP:7
PSF:1
PSD:1
LOOP:8
PSF:1
PSD:1
LOOP:9
PSF:1
PSD:1
LOOP:10
PSF:1
PSD:1
LOOP:11
PSF:1
PSD:1
LOOP:12
LOOP:13

=== INPUT end ===

=== MAP begin ===
[1] <NULL SRC> ===> EDI_HEADERS
[2] <NULL SRC> ===> ISA
[3] Literal(Authorization_Qualifier) -*--> e01='00'
[4] Literal(Authorization) -*--> e02=' '
[5] Literal(Security_Code_Qualifier) -*--> e03='00'
[6] Literal(Security_Code) -*--> e04=' '
[7] Literal(Sender_ID_Qualifier) -*--> e05='08'
[8] Literal(Sender_ID) -*--> e06='9251750000'
[9] Literal(Receiver_ID_Qualifier) -*--> e07='ZZ'
[10] Literal(Receiver_ID) -*--> e08='NMCOUGHCOLD'
[11] Literal(DATE_CUR) -*--> e09='080722'
[12] Literal(TIME_CUR) -*--> e10='0957'
[13] Literal(Repeat_Sep_Stds_ID) -*--> e11='U'
[14] Literal(EDI_Version) -*--> e12='00401'
[15] Literal(Control_Number_ISA) -*--> e13='000000339'
[16] Literal(Ack_Request) -*--> e14='0'
[17] Literal(Test_Production) -*--> e15='P'
[18] Literal(Subelement_Separator) -*--> e16='>'
[2] fired
[19] <NULL SRC> ===> GS
[20] Literal(Functional_Group_ID) -*--> e01='PS'
[21] Literal(Authorization) -*--> e02='8019721193'
[22] Literal(Receiver_ID) -*--> e03='NMCOUGHCOLD'
[23] Literal(DATE_CUR) -*--> e04='20080722'
[24] Literal(TIME_CUR) -*--> e05='0957'
[25] Literal(Control_Number_GS) -*--> e06='146'
[26] Literal(Responsible_Agency_Code) -*--> e07='T'
[27] Literal(Version_GS) -*--> e08='004010UCS'
[19] fired
[1] fired
[28] <NULL SRC> ===> ST
[29] MTF_000M ===> ST
[30] MTF_TRAN_ID ----> e01='830'
[31] Literal(Control_Number_ST) -*--> e02='00146001'
[29] fired
[28] fired
[32] PSH ===> BFR
[33] PSH_ENFCST_DATE ----> e07='20080920'
[34] PSH_STFCST_DATE ----> e06='20080629'
[35] PSH_TXN_PURP_CD ----> e01='00'
[36] PSH_SCHD_TQUAL ----> e04='PS'
[37] PSH_SCHD_QQUAL ----> e05='A'
[38] Literal(DATE_CUR) -*--> e08='20080722'
[32] fired
[39] PSH ===> N1_LOOP
[40] PSH_LOOP ===> N4
[41] COUNTRY ----> e04='USA'
[42] ZIP ----> e03='94588'
[43] STATE ----> e02='CA'
[44] CITY ----> e01='PLEASANTON'
[40] fired
[40] PSH_LOOP ===> N4
[41] COUNTRY ----> e04='USA'
[42] ZIP ----> e03='01930'
[43] STATE ----> e02='CA'
[44] CITY ----> e01='GLOUCESTER'
[40] fired
[45] PSH_LOOP ===> N3
[46] ADDRESS ----> e01='5918 STONERIDGE MALL RD'
[45] fired
[45] PSH_LOOP ===> N3
[46] ADDRESS ----> e01='51 BLACKBURN DR'
[45] fired
[47] PSH_LOOP ===> N1
[48] DUNS ----> e04='0091372090000'
[49] NAME ----> e02='SAFEWAY INC'
[47] fired
[47] PSH_LOOP ===> N1
[48] DUNS ----> e04='6186135900000'
[49] NAME ----> e02='NUTRAMAX PRODUCTS'
[47] fired
[39] fired
[50] PSI ===> LIN_LOOP
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080705'
[77] PSF_FCST_STDATE ----> e04='20080629'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080712'
[77] PSF_FCST_STDATE ----> e04='20080706'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080719'
[77] PSF_FCST_STDATE ----> e04='20080713'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080726'
[77] PSF_FCST_STDATE ----> e04='20080720'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080802'
[77] PSF_FCST_STDATE ----> e04='20080727'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080809'
[77] PSF_FCST_STDATE ----> e04='20080803'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080816'
[77] PSF_FCST_STDATE ----> e04='20080810'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080823'
[77] PSF_FCST_STDATE ----> e04='20080817'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080830'
[77] PSF_FCST_STDATE ----> e04='20080824'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080906'
[77] PSF_FCST_STDATE ----> e04='20080831'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080913'
[77] PSF_FCST_STDATE ----> e04='20080907'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[51] LOOP ===> FST_LOOP
[52] PSD ===> SDQ
[53] PSD_DUNS1(0091372093544) -*C-> e02='9'
[54] PSD_ITEM_UOM ----> e01='CA'
[55] PSD_DUNS1 ----> e03='0091372093544'
[56] PSD_QTY1 --C-> e04='1.000'
[57] PSD_DUNS2 ----> e05='0091372093701'
[58] PSD_QTY2 --C-> e06='1.000'
[60] PSD_QTY3 --C-> e08 not mapped
[62] PSD_QTY4 --C-> e10 not mapped
[64] PSD_QTY5 --C-> e12 not mapped
[66] PSD_QTY6 --C-> e14 not mapped
[68] PSD_QTY7 --C-> e16 not mapped
[70] PSD_QTY8 --C-> e18 not mapped
[72] PSD_QTY9 --C-> e20 not mapped
[74] PSD_QTY10 --C-> e22 not mapped
[52] fired
[75] PSF ===> FST
[76] PSF_FCST_ENDATE ----> e05='20080920'
[77] PSF_FCST_STDATE ----> e04='20080914'
[78] PSF_FCST_TQUAL ----> e03='X'
[79] PSF_FCST_QUAL ----> e02='D'
[80] PSF_FCST_QTY ----> e01='2.000'
[75] fired
[51] fired
[81] PSI ===> PO4
[82] PSI_WGHT_UOM --C-> e07='LB'
[83] PSI_WGHT_PERPCK ----> e06='5.50'
[84] PSI_WGHT_QUAL --C-> e05='G'
[85] PSI_ITM_SZE_UOM ----> e03='EA'
[86] PSI_ITM_SIZE ----> e02='1.000'
[87] PSI_ITM_PACK(000001) -*--> e01='1'
[81] fired
[88] PSI ===> LIN
[89] PSI_VENDR_ITMCD(77650) -*C-> e06='VN'
[90] PSI_PURCH_ITMCD(58500169) -*C-> e04='PI'
[91] PSI_PROD_ID ----> e03='032113077650'
[92] PSI_UPC_CD_QUAL ----> e02='UA'
[93] PSI_VENDR_ITMCD ----> e07='77650'
[94] PSI_PURCH_ITMCD ----> e05='58500169'
[88] fired
[50] fired

=== OUTPUT begin ===
ISA
GS
OUTPUT: ST
OUTPUT: BFR
OUTPUT: N1_LOOP 1
N1
N1
N3
N3
N4
N4
OUTPUT: LIN_LOOP 1
LIN
PO4
FST_LOOP 1
FST
SDQ
FST_LOOP 2
FST
SDQ
FST_LOOP 3
FST
SDQ
FST_LOOP 4
FST
SDQ
FST_LOOP 5
FST
SDQ
FST_LOOP 6
FST
SDQ
FST_LOOP 7
FST
SDQ
FST_LOOP 8
FST
SDQ
FST_LOOP 9
FST
SDQ
FST_LOOP 10
FST
SDQ
FST_LOOP 11
FST
SDQ
FST_LOOP 12
FST
SDQ
OUTPUT: SE
GE
IEA

=== OUTPUT end ===

[eGroups Migratio...]

I should probably include that all the other looping requirements are being met as those are multiple records. The only issue is with the single record being written in the correct order of the N1_LOOP.

Russ

[eGroups Migratio...]

I am new to Datamapper and have been unsuccessful in solving my current error. I have asked Axway professional services for support but they have not provided a solution.

I have a fixed format input file that needs to be parsed into the X12 830 document. Input looks something like:

830PSH SAFEWAY ADDRESS CITY STATE ZIP VENDOR ADDRESS CITY STATE ZIP

The output needs to be written into the X12 830 document as:

N1,FR,SAFEWAY
N3,ADDRESS
N4,CITY,STATE,ZIP
N1,TO,VENDOR
N3,ADDRESS
N4,CITY,STATE,ZIP

The first issue is that the X12 830 output writes N1,N1,N3,N3,N4,N4. I have had no luck in solving this issue.

The second issue is that if I loop I am unable to determine if the Origin and Destination names are filled appropriately. If I code a @variable<>"" in the condition and a "FR" in the expression, I will get a "FR" in the N1,e01 everytime. The only option I see at this point would be to code @variable="SAFEWAY" then N1,e01 should be "FR". This works but I have not been able to solve a simple IF/THEN/ELSE solution to put the "TO" in N1,e01 if the @variable is not SAFEWAY.

This seems like it should be easy but is proving complex. Any ideas?

thanks

Russ

Russ,

I tried to send the DM Builder archive through the Yahoo Group, but this is too big. I have now sent this to your email address directly.

Rgds,
Wim

[eGroups Migratio...]

Russ,

I tried to send the DM Builder archive through the Yahoo Group, but this is too big. I have now sent this to your email address directly.

Rgds,
Wim

Hi Wim,

Thanks for your help. I found out what a FLD file was and was able to unfold the map. This map contained the clue I was missing. I was unaware I could change the output map without impacting the original X12 830.

With help from another resource at Axway I was able to solve a Trim and Truncate issue as well as the IF/THEN/ELSE issue. A wonderful day for me in solving these issues. Thank you all for your help and support.

Russ