Map Flatfile to EDI and get error (Inovis software)

[fredong]

I created a flat file and when I mapped the Flat file to EDI using TLW Inovis software. I get an error on the first record. Below is my flat file Header and first record

flat file
---------

//STX12//850ABCDEFTest 000000000000000000000401121644 0401121644
0100NE000000000000000003976408182003 ->first record req 36

Error
-----
Date: 01-12-2004 Time: 16:45
Errors encountered while translating flatfile to EDI

Flatfile Name: DX-FX-VF.080

Document #: 1 Form Name: D01_850_D_v4010_ABCDEF^_021016
*** 1BEG01 - Mandatory Element Missing
*** 1BEG02 - Mandatory Element Missing
*** 1BEG03 - Mandatory Element Missing
*** 1BEG05 - Mandatory Element Missing


*** End of Report ***

I calculated many times and there were 36 characters and nothing missing and I don't understand why I am still getting error. Can Somebody helps. Thanks.
By the way, anyone has a flatfile editor that I can download for free? Currently, I am using wordpad to manually count the spaces.

 

[keller999]

From what you have posted of your dx-fx-vf.### file - it looks reasonable. But w/o the data entry &/or print form you are flatfiling with - it is impossible to say for sure.

To truely determine the problem - one would need to see your sample dx-fx-vf.### file as well as the data entry &/or print form you are using to flatfile with. (If both assigned, I believe data entry forms flatfile layout takes precedence for flatfiling.)

If you care to email me your flatfile and dataentry / print form, I'll take a look at it. Sounds like it should be an EZ diagnosis. Otherwise, one would need to see the entire contents of your dx-fx-vf.### file - as well as the complete flatfile layout...and even then, the cause could easily be missed w/o having the actual files you're using in front of you.

As for flatfile editor - I just use the dos editor - it at least has the row and column counters in the lower right hand corner.

Good luck...
Ken Keller
keller999_1999@yahoo.com

 

[fredong]

I am using osql in a batch to pipe out the flat file. The osql call on a store procedures that contains select statement and create the flat file every time I execute the batch file.

I have discovered what my problems on my flat file but I do not know how to fix it. Basically,my flat file on the line 07 and multiple line 18 and 19 have trailing spaces that causes the conversion from flat the EDI to fail. If I maually removed the trailing spaces the conversion will succeed. Do you think you can fix my SQL statement to remove the trailing spaces. Below is my SQL statement and my flat file results.I will email you my flat file too. Thanks for your help.


select
'//STX12//850ABCDEFTest 850'+char(13)+
'0100NE'+a.PO_No+a.PODate+char(13)+
'05ST ZZ'+char(13)+
'06'+a.ShipTowhsecode+char(13)+
'07'+'GHIJKL'
from tableA a, tableB b
where a.id_num = b.Countrow
Union Select
'17'+AssgnID+'+'+OrderQty+'EA'+' '+' '+'MG'+char(13)+
'18'+ItemID+char(13)+
'19'+'F'
from tableC


Results in Flat file
--------------------

//STX12//850ABCDEFTest 850
0100NE000000000000000004074020031105
05ST ZZ
0655109998
07GHIJKL
171 +000000000000002 EA MG
18DUPH70247
19F
172 +000000000000004 EA MG
18DUPH69575
19F
173 +0000000000000013EA MG
18DUPH80064
19F
174 +0000000000000037EA MG
18DUPH7997A
19F
175 +0000000000000028EA MG
18DUPH8017A
19F
176 +0000000000000029EA MG
18TECSPINPAPER236
19F
177 +0000000000000048EA MG
18TECSPINPAPER242
19F
178 +000000000000004 EA MG
18DUPD11507939
19F