Bug 57424 - Images url
Summary: Images url
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2012-11-22 19:11 UTC by Augusto
Modified: 2013-11-16 18:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Images from Urls (64.53 KB, application/x-7z-compressed)
2012-11-23 18:03 UTC, Augusto

Note You need to log in before you can comment on or make changes to this bug.
Description Augusto 2012-11-22 19:11:55 UTC
Not sure if this is not supported s
Comment 1 Augusto 2012-11-22 19:18:54 UTC
Hi.. I'm not sure if this is a missing feature or just i don't know how it works..

I have a database with images, i exported all with the mysql connector to a new mysql database..

I save on a table the url relative to the odb file

example "images/1.jpg"  and runs fine..

Now the problem.

How to view the images on a server? i tried:
"localhost/images/1.jpg" doesnt' work
"c:\1.jpg" doesn't work
"http://www.server.com/images/1.jpg" doesnt work
someone told me that may try with "file:///c:/1.jpg" doesn't work

there's any tip to know the right path to view the pictures on Libreoffice saving the info on a mysql database?
Comment 2 Robert Großkopf 2012-11-23 15:38:06 UTC
As I understand:
1) You have saved the images in the database. So there is no connection to any path. The images were saved in a field of a table. 
You can connect to the database. It could also be a mysql-database. You can see this images in a form or in a report.
2) You have only saved the path to the images. You can't see the images in any database. You can only see some text - the path. When you move this to a server there is the sane text shown. There isn't saved any image at all.
I don't understand how you have seen anything of the images, while you have created the content of the database, before you have copied it to the MySQL-server.
Comment 3 Augusto 2012-11-23 18:03:31 UTC
Created attachment 70483 [details]
Images from Urls
Comment 4 Robert Großkopf 2012-11-23 19:57:21 UTC
You haven't written anything in your bug-report, that you use macros to load an image into a form.
You read out a path, which is been saved in the table. This path is relative to the *.odb-file. But your directory isn't the same as the home-path for other users of the MySQL-database. The path you read with your *.odb-Database must be the same path for every *.odb-Database-user.
One solution could be: Save the images in the home-path of a webserver. So everybody, who uses a database, can get the connection to these files.
Other users of other PCs have nothing to read in your own home-files. 
Another solution: You have an intranet, where all other users have the same path to a file saved at one position. You could save your images at this position and everybody could see the image.

All this has nothing to do with LO-Base and isn't a LO-specific problem. Could be a better idea to contact a user-mailinglist in your own language for this, but not Bugzilla.
Comment 5 Robert Großkopf 2013-02-07 20:11:56 UTC
I have tried the following:
# Const RUTA_REMOTA As String = "http://localhost/test/" #
I have put the image in the path "test" on my local webserver. The image is shown right.
I have noticed, that the changing of the checkbox "local" in the table isn't recognized, when the form is opened.
"http://www.server.com/images/" works the same way. So what is the problem?
Comment 6 bfoman (inactive) 2013-06-12 12:48:37 UTC
Marked as RESOLVED INVALID as this seems is not a bug in LibreOffice. 

Do not hesitate to reopen in case of mistriage.