Skip to Content
0
Former Member
Aug 03, 2008 at 01:36 PM

file sender content conversion 0..unbounded does not pull file

16 Views

i am trying to map a flat file using content conversion to this xml structure:

<Header>

<Field_ID/>

<Filler/>

<Record_type/>

<File_name/>

<File_date/>

<File_time/>

<Heb_code/>

<Claim_no/>

<Cont_no/>

<Remark/>

</Header>

<Claim_Header>

<Field_ID/>

<Filler/>

<Record_type/>

<Vendor_code/>

<Garage_no/>

<Data_code/>

<Year/>

<Job_no/>

<Cont_no/>

<License_no/>

<ODO_meter/>

<Claim_type/>

<VIN_code/>

<Claim_open_date/>

<Claim_fix_date/>

<N_code/>

<C_code/>

<Ejob1/>

<Ejob2/>

<Page_no/>

<Pre_conf_date/>

<Pre_conf_no/>

<Part_buy_date/>

<KM_prev_fix/>

<Bill_prev_fix/>

<Material_fault/>

<Damage_whole/>

<Damage_code/>

<Job_amount/>

<Towing_amount/>

<Parts_amount/>

<Hour_rate/>

<Cont_mark/>

</Claim_Header>

<job_row>

<Field_ID/>

<Filler/>

<Record_type/>

<Vendor_code/>

<Garage_no/>

<Data_code/>

<Year/>

<Job_no/>

<Cont_no/>

<page_no/>

<line_no/>

<shaaton_code/>

<job_finish_code/>

<amount/>

<job_time/>

<row_value/>

<color_code/>

</job_row>

<part_row>

<Field_ID/>

<Filler/>

<Record_type/>

<Vendor_code/>

<Garage_no/>

<Data_code/>

<Year/>

<Job_no/>

<Cont_no/>

<page_no/>

<line_no/>

<material_code/>

<amount/>

<unit_price/>

<row_value/>

</part_row>

<remark>

<Field_ID/>

<Filler/>

<Record_type/>

<Vendor_code/>

<Garage_no/>

<Data_code/>

<Year/>

<Job_no/>

<Cont_no/>

<page_no/>

<line_no/>

<remark/>

</remark>

<footer>

<Field_ID/>

<Filler/>

<Record_type/>

<File_name/>

<File_Record_no/>

<Claim_no/>

<Cont_no/>

<Remark/>

</footer>

job_row, part_row and remark are records that occur 0..unbounded.

when i write in recordset structure: Header,1,Claim_Header,1,Job_Row,1,Part_Row,1,Remark,1,Footer,1

and put file with one record each, the file is pulled, but when i change recordset structure to:

Header,1,Claim_Header,1,Job_Row,,Part_Row,,Remark,*,Footer,1

the file is not pulled.

can anyone tell me what i'm doing wrong?

thanx

tomer