MS Word - Blob

Brock
Brock used Ask the Experts™
on
Hello,  

I am bringing in an xml file into word to create a report. This is being done using a plugin from oracle called BI Publisher.  I believe you do not need to be familiar with this to answer my question.

The field I am trying to display is a blob - Employee Photo. In Microsoft word's properties the text form field is a 'regular text with maximum length - unlimitted.

The image is being displayed in a column of a table.  When the employee has no photo, huge blank spaces result. ie the table rows span many pages with no data.

The xml handling this field, employee photo,  in the plug is :
 <fo:instream-foreign-object content-type=”image/jpg” height=”70 px” width=”55 px”><xsl:value-of select=”B.EMPLOYEE_PHOTO”/></fo:instream-foreign-object>



So my questions are :
1. Should the Blob be interpreted as numeric or text?  When I change the photo field to numeric, the report format is fine.  However, you get the photo displaying with numbers and people without photo's are blank but do the table rows spanning many pages.

2. Can I wrap the xml statments to ignore displaying  B.EMPLOYEE_PHOTO is blank and how would I do this?

Thanks, BrockThis is the field placements.  You see the postion of the Employee photo in yellow highlightsThe xml code behind the Employee photo fieldThe actual field coming in from the xml fileWhat the report diplays like when the employee photo is numericWord showing type of field
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Theo KouwenhovenApplication Consultant

Commented:
The BLOB is a binary object, so it can be anything.
But when I look to the examples 3 ans 4, I see some data that looks like Base 64.
So in that case you can handle that as text.

To besure, try to Base64-Decode the example and look to the result (e.g. online decoding).
Could be text, photo, pdf, mp3, etc.

I would try to store the Decode result as .jpg or .png to start with.

Author

Commented:
HI Theo,

I solved the issues by putting this code in the BI Properties field for the Employ Photo:

<?choose:?>
<?when:B.EMPLOYEE_PHOTO!=""?><fo:instream-foreign-object content-type="image/jpg"height=”70 px”width=”55 px”><xsl:value-of select=".//B.EMPLOYEE_PHOTO"/></fo:instream-foreign-object><?end when?>
<?otherwise:?><?end otherwise?>
<?end choose?>


I just eliminated it from being displayed.  The oracle plugin, BI Publisher, is very finnicky.  Even extra spaces can cause havoc to the report. I was a big fan of the Seagate Crystal product for report creation. But that is not under my control.  :-)

Author

Commented:
Thanks for reaching out.  Brock
Commented:
<?choose:?>
<?when:B.EMPLOYEE_PHOTO!=""?><fo:instream-foreign-object content-type="image/jpg"height=”70 px”width=”55 px”><xsl:value-of select=".//B.EMPLOYEE_PHOTO"/></fo:instream-foreign-object><?end when?>
<?otherwise:?><?end otherwise?>
<?end choose?>

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial