Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Processing CSV File using Gentran Server Windows NT

Status
Not open for further replies.

mnavare

Programmer
Dec 17, 2003
6
IN
Hi,

Currently we are trying to process and outbound 855 transaction. The application side is a CSV file through Getran Server Ver 3.2.02 on windows NT .

Have set the input side propoerties with segment and tag delimiter as ",". Now when we import a file, the source file format is:

HDR,123,123,4567,2
DET,1,test line item1,068,20051205

On processing Gentran gives 2 compliance errors saying:

1. Record HDR field 4 data 2 has error in data format 0110 (The datatype for the field is set to string with max length 4)

2. Record HDR field 4 20051205 has error in data format 0110 (The data type for the field is set to string with max length 8).

This error is given for all the last field of each segment.

My understanding is it is not able to differentiate segment delimiter which is CRLF.

Anyone has any idea.

Please help.
 

Segment delimiter "," is missing right ?

HDR,123,123,4567,2
DET,1,test line item1,068,20051205

USE
HDR,123,123,4567,2,
DET,1,test line item1,068,20051205,
and try.

Since segment delimiter is missing it might be interpreting CRLF as data.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top