Issue 13939 - Support binary fields (like images) in OO.o database
Summary: Support binary fields (like images) in OO.o database
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows 2000
: P4 Trivial with 17 votes (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sw
URL:
Keywords: oooqa
: 20634 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-04-29 16:15 UTC by drfox
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description drfox 2003-04-29 16:15:07 UTC
I can't get images to merge from a database into either a table or a frame. 
If I merge them into the document, they are WAY too large.
In any event, I cannot switch from M$Word to OOo Writer until I have these 
feature enabled.
Can these feature be enabled?
Comment 1 drfox 2003-05-21 21:42:12 UTC
Additionally, and just as important, text merges only erratically into 
tables. 

If anyone would like screen shots (captures), I'll be happy to send 
them.
Comment 2 diane 2003-05-22 22:08:31 UTC
Hi Dr. Fox,

Could you provide a sequence of steps to perform, for others to use to
observe the issue you have described?

It is possible to alter the size of the image, after it is placed into
the document. To do this, click on the image once, then hover over one
of the corner green points.  Grab one of these corner green points
with the mouse, and drag it to the resize the image.  If a corner
point is not used, the image will be resized in only the vertical or
horizontal direction, depending upon which point is grabbed.  If a
corner point is used, the vertical to horizontal ratio of the image
will stay intact.

The frame can be resized in the same manner.

I inserted an image into a frame, and I added text to the document to
wrap around the outside of the frame.  I did this on RH 9 Linux,
running 1.1 beta.  All worked as expected.  The text flowed nicely
around the frame, no matter how the frame size was altered.  I will
carry out more tests, if more data is added to this issue.

Is the text behaviour a different issue, than the image issue?  If so,
a new issue should be submitted for it.  The developers like to see
just one issue described per issue number.  This makes it easier to
keep the status of each issue organized.

Diane
Comment 3 h.ilter 2003-05-23 12:03:49 UTC
Reassigned to MRU
Comment 4 michael.ruess 2003-05-23 14:00:29 UTC
Currently openOffice does not support binary fields (such as images)
in databases. Would be a nice have to, but I don't know much about the
effort of implemantation in database access.
Comment 5 wesborgman 2003-10-03 11:57:16 UTC
A 3rd party program (AVImark) uses OLE automation to 'search and 
replace' text in both MS Word as well as OpenOffice 1.1 and 
StarOffice before using the word processor to print documents. Many 
of the users of the AVImark would like to change from MS Word but 
Word still does a better job when AVImark uses OLE to find and 
replace text in frames. 

The OLE method is as follows: "Find" to find text stings, 
then "Delete" to remove the text string from the document, and 
finally "InsertAfter" to insert the text or image that is to replace 
the text string. 

These methods work great, except “Find” doesn’t work to locate text 
strings in Oo1.1 that are in a tables or text box. 

This method does work with MS Word tables. In MS Word it also works 
in "text boxes" if you convert the text boxes to "frames."

Star Office has not been tested.

A fully functional demo of AVImark can be downloaded at avimark.com 
if further testing is needed.
Comment 6 wesborgman 2003-10-03 12:06:16 UTC
A 3rd party program (AVImark) uses OLE automation to 'search and 
replace' text in both MS Word as well as OpenOffice 1.1 and 
StarOffice before using the word processor to print documents. Many 
of the users of the AVImark would like to change from MS Word but 
Word still does a better job when AVImark uses OLE to find and 
replace text in frames. 

The OLE method is as follows: "Find" to find text stings, 
then "Delete" to remove the text string from the document, and 
finally "InsertAfter" to insert the text or image that is to replace 
the text string. 

These methods work great, except “Find” doesn’t work to locate text 
strings in Oo1.1 that are in a tables or text box. 

This method does work with MS Word tables. In MS Word it also works 
in "text boxes" if you convert the text boxes to "frames."

Star Office has not been tested.

A fully functional demo of AVImark can be downloaded at avimark.com 
if further testing is needed.

(note this issue is also in OO 1.1 rc5 running on XP pro)  
Comment 7 Unknown 2003-10-03 18:38:55 UTC
*** This issue has been confirmed by popular vote. ***
Comment 8 wesborgman 2003-10-08 13:16:30 UTC
*** Issue 20634 has been marked as a duplicate of this issue. ***
Comment 9 hans_werner67 2004-02-02 12:53:15 UTC
change subcomponent to 'none'
Comment 10 drfox 2004-02-02 13:46:52 UTC
This remains a defect in OOo 680_m22. Avimark is the largest selling veterinary
software with over 6000 hospitals and probably more than 100,000 users.
You can download a demo of Avimark here:
http://www.avimark.com/Demo/dlavidemo.htm

To change from word to ooo, go to Work With:Hospital Setup:System  Choose the
Documents tab, choose StarOffice/OpenOffice and change doc type to sxw.

Set up a swx document. Go to a patient record, right-mouse click over almost any
part of the screen, choose document and either print or print to screen. There
are sample pictures--try merging a picture with <animal-pic>
Set up a table and try merging variable fields like <first-name>, <last-name>,
and or <animal>--in some cells the merge works, and in some cells it doesn't. If
you put <animal-pic> in any cell, the merge fails. Contact me if you need any
further instuctions. Thank you.  Lawrence M. Fox, DVM
Comment 11 rblackeagle 2004-02-02 17:59:08 UTC
If you want others to vote for this, go to the discussion newsgroup and post the
problem and issue number -- otherwise no one will see it.
Comment 12 bettina.haberer 2005-05-20 16:55:15 UTC
Changes issue type and target milestone.
Comment 13 Mechtilde 2009-07-17 20:36:01 UTC
it is possible to save images in Base via forms

so worksforme
Comment 14 Mechtilde 2009-07-17 20:36:50 UTC
-< closed