cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

use Record_type as Key Field in File Content Conversion in Sender Comm Channel.

then give Claim_Header.Record_type = 'C'

Job_Row.Record_type = 'J' like this..

Answers (4)

Answers (4)

Former Member
0 Kudos

HI,

If you specified a variable number of substructures for Recordset Structure, in other words, at least one substructure has the value u2018*u2019, then the substructures must be identified by the parser from their content. A key field must be set with different constants for the substructures. In this case, you must specify a key field, and the field name must occur in all substructures.

Specify the Key Field Type to be used to compare the predefined values. This entry is used if the key field name is defined.

Thanks

Swarup

Former Member
0 Kudos

Hi,

Try using a key fields for the different structures.You can ignore these key field values later using for example KeyfieldInStructue = ignore

Former Member
0 Kudos

Hi,

try giving

Footer,* instead of Footer,1

Check this:

Thanks,

Mahi

Former Member
0 Kudos