the first line in a file is supressed

[Former Member]

hi all,

i have a really weird problem.

i have a file with a lot of data and i am using a file adapter with file content conversion to parse it.

the file adapter is a sender one.

the problem come when i do read the file and then it ignore the first line of the file.

all the lines from the second one forward is shown in SXMB_MONI but the first line of the file isn't.

i can't seem to figure out what the problem is, i tryed looking for some kind of attribute in the file adpater but had no luck.

could you please help me?

btw,

the file structure is: header,1,body1,<wildcard>,body2,<wildcard>

Edited by: Roi Grossfeld on Oct 29, 2008 4:24 PM

[Former Member]

still stuck on this probelm can you help me please?

[santhosh_kumarv]

Hi,

Just check these things..

1. If there is any additional space added to the keyfield value of the field H1.

2. If Document offset is set to 1 earlier and the changes made has not been refreshed in the cache, you check if this is the case by looking in the older CC verison from the verison history.

Thanks

SaNv...

[Former Member]

did u set anything in FCC for Document Offset option.

if its set to 1 then it will ignore the first line n start with the next line.

chirag

[Former Member]

if you look at the prev post you see that i told that i didn't set anything in that field

[Former Member]

i have posed the same before u posted ur reply....

can u let us know ur FCC configuration.

chirag

[Former Member]

Recordset Structure: H1,1,B1,<wildcard>,B2,<wildcard>

Key Field Name: RecordType

H1.fieldFixedLengths 6,2,8,1,1,3,30,5

H1.fieldNames FileNo,RecordType,TransmissionDate,Car_Truck,BU,MD,FileName,Count

H1.keyFieldValue H1

B1.fieldFixedLengths 6,2,10,27,8,8,4,5,3,11,9,9,11,11,9,9,7,9,11

B1.fieldNames FileNo,RecordType,InvoiceNumber,VesselName,MMSEShipmentDate,PlanArrivalDate,DeliveryPlace,Units,Currency,ModelPriceAmount,OptionPriceAmount,ColourPriceAmount,REPriceAmount,TotalPriceAmount,FreightChargeAmount,InsuranceFeeAmount,MiscellaneousAmount,VATAmount,GrandTotalAmount

B1.keyFieldValue B1

B2.fieldFixedLengths 6,2,10,12,12,12,5,6,12,3,3,3,4,17,7,7,12,8,5,3,9,7,7,9,9,7,9,4,20

B2.fieldNames FileNo,RecordType,InvoiceNumber,MDOrderNumber,MMSEOrderNumber,MMSECaseNumber,ModelYear,BodyType,Model,ExteriorColourCode,InteriorTrimColourCode,OptionCode,RearEquipment,VehicleIdentificationNumber,ChassisModel,CSequenceNumber,EngineModel,ESequenceNumber,KeyNumber,Currency,UnitModelPrice,UnitOptionPrice,UnitColourPrice,UnitRearEquipmentPrice,UnitTotalPrice,UnitVATAmount,UnitTotalVAT,VATRate,VATNumber

B2.keyFieldValue B2

ignoreRecordsetName true

Edited by: Roi Grossfeld on Oct 29, 2008 4:39 PM

[justin_santhanam]

Roi,

If possible could you please paste the sample flat file here, and let us which value is missing exactly?

raj.

[Former Member]

i think ur FCC is correct, paste the sample file and which record is missing?

chirag

[Former Member]

here is a sample of the file:

VMD107H102102008CBIL9MANIFEST DATA 00244

VMD107B10010044021ANNA 3009200824102008ETH 00121JPY001755694000000000000000000000000000000000175569400000000000000000000000000000000000000175569400

B2 is not nessecery so that is why he isn't shown

Edited by: Roi Grossfeld on Oct 29, 2008 5:21 PM

[justin_santhanam]

Roi,

Did you gave value for Document Offset parameter?

raj.

[Former Member]

nope i didn't give any... when i tryed to fix it i gave it 0 but it didn't make no difference