Read specific record in a flat file

[Corab500]

Hello,

I was wondering if i can retrieve specific records in a flat file...

Explanation :

  In a flat file containing a lot of different type of record i need to extract specific one. can beanio map just the one i need and don't take in account the rest of the file ?

ex : 

RANDOMRECORDINTHEFILE

THEONEIWANT

RANDOMRECORDINTHEFILE

RANDOMRECORDINTHEFILE

ANOTHER-RECORD-THAT-I-WANT

RANDOMRECORDINTHEFILE

RANDOMRECORDINTHEFILE

THEONEIWANT

.....

I'm a new user of beanio and hope you can help me :)

Regards,

Corab

[Kevin]

Hi Corab,

Sort of.  You'll need to define records in the mapping file for identifying skipped records, but by not setting a "class" attribute, BeanIO will ignore them during unmarshalling.

Thanks,
Kevin

[Corab500]

What do you mean by define records ?

i have to define for each type of record contain in the file what identifies it ? but i don't put a class attribute ? 

[Kevin]

Yes, thats correct.  Define each record with some minimal record identifying fields and leave out the "class" attribute.

By default, any record without record identifying fields (rid="true") will always match, but I can see where that makes this request more difficult than it need be, so I'll look at allowing that to be configurable in a future release.

Thanks,

Kevin

[Corab500]

Thanks for your answer Kevin,

Just a little more question.. When i read the file beanio will only read the record with a class attribute ? so each call to read() function will retrieve in the file records that match the record's description in the mapping file that has a class attribute ? and skipped all the other

Regards

[Kevin]

Yes, that's correct.

[Corab500]

Thanks Kevin it worked perfectly.

I was wondering if i want to write an XML file can i tell beanio to write some attributes only if they are not null(empty) ?

Regards,

Corab

[Kevin]

By default, null attributes are not written out unless minOccurs="1" on the field definition.  You can see examples in section 5.7.2 of the reference guide.

Thanks,
Kevin

[Corab500]

Thanks for the answer :) I have a little other issue. when reading a file i have in one ligne the following text for example :

something | "sometext" something else | sdfsdfsdf

where | is used as separator and i have the following error :  Malformed record at line 1470619: Invalid character found outside of quoted field at line 1470619

at org.beanio.internal.parser.UnmarshallingContext.newMalformedRecordException(UnmarshallingContext.java:350)

Is there a specific property that i need to add in the parser ?

Regards

[Corab500]

And how can i also make him read an write special character like ë à ... ??

Thanks

Corab

[Kevin]

What stream format are you using?  And what parser settings have you set?

[Kevin]

BeanIO will read any unicode character from the Reader passed to it, so if you are having difficulties, it is probably in how you are creating/opening your Reader.  For example, if you are using a FileInputStream, make sure you are explicitly setting the expected character encoding.  And if you are using a FileReader, I think it will use your system's default character encoding, which may not be what you need/want.

Thanks,
Kevin