Issue 127348 - Database In Draw (Data Source)
Summary: Database In Draw (Data Source)
Status: UNCONFIRMED
Alias: None
Product: Draw
Classification: Application
Component: editing (show other issues)
Version: 3.4.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-07 13:51 UTC by Brett Byrd
Modified: 2017-03-10 09:23 UTC (History)
2 users (show)

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


Attachments
What I am needing (429.38 KB, image/png)
2017-03-09 19:02 UTC, Brett Byrd
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Brett Byrd 2017-03-07 13:51:42 UTC
I am wanting to suggest a new feature. 

It is very helpful being able to use a database in the Text Document. I am, however, wanting to be able to add Database fields to a Draw Document. You can add date, page#, and author but that is all. Is there a way we could have that in a future update. It would be very helpful in what I am trying to accomplish.
Comment 1 Regina Henschel 2017-03-07 15:56:39 UTC
You can already add database fields to Draw- and Impress-documents. Open the "Form Controls" and "Form Design" toolbars to insert fields and to define the connection.

I guess, that you do not mean a "database" but that you mean meta information. That request does already exists. It is bug 2882.
Comment 2 oooforum (fr) 2017-03-08 09:03:20 UTC
What do you do with database fields in ODG document?
Could you give us a real example and attach a screenshot of expected result?
Comment 3 mroe 2017-03-08 09:52:59 UTC
(In reply to Regina Henschel from comment #1)
> You can already add database fields to Draw- and Impress-documents. Open the
> "Form Controls" and "Form Design" toolbars to insert fields and to define
> the connection.
> 
> I guess, that you do not mean a "database" but that you mean meta
> information. That request does already exists. It is bug 2882.

I think he doesn't mean controls rather database fields:
Insert → Fields → Other…: (Tab) Database
(mail merge/reports/lists/labels)

Draw has more possibilities for design so I can imagine that for labels, reservations … the use of database fields that can be formatted like “normal” text could be a good enhancement.

Maybe the OP has other suggestions fur use.
Comment 4 mroe 2017-03-08 09:53:54 UTC
(In reply to mroe from comment #3)
> Maybe the OP has other suggestions fur use.

Typo: Maybe the OP has other suggestions for use.
Comment 5 oooforum (fr) 2017-03-08 10:04:35 UTC
For me, Draw app must be stay a drawing app.
Writer is dedicated with database interface.
If you want objects from Draw, you could use OLE function or simply a copy/paste.

Do not use a hammer to screw :-)
Comment 6 Brett Byrd 2017-03-09 19:02:24 UTC
Created attachment 85981 [details]
What I am needing

Attached I have two screens. On the left I have a Writer Document with a DataSource I am using for envelopes. 

I am wanting to be able to do the same thing with our company ID cards in Open Office Draw on the right. 
FName
LName
Employee#
Department 
Date of hire 

So instead of saying database maybe DataSource would be better. Either way the picture on the left is what I want on the picture on the right.

I hope this clears it up a little.

Any help is appreciated
Comment 7 Brett Byrd 2017-03-09 19:39:54 UTC
(In reply to oooforum (fr) from comment #2)
> What do you do with database fields in ODG document?
> Could you give us a real example and attach a screenshot of expected result?



I added a comment below
Comment 8 oooforum (fr) 2017-03-10 09:23:50 UTC
Well, design your label into Draw app.
Export as picture
Insert into Writer app on your document in background.

Anyway, you can't use none picture as field
https://bz.apache.org/ooo/show_bug.cgi?id=18651

So, I think that your problem will be unsolvable.