Well, EarnestAI, that gives me the heavy idea that I have to insert thousand of photos manually in the Impress file and then try to make a macro in LOB to open it? No gain, no pain! Thank you for your time.
Oh, I’m sorry, I see now that I can insert all the files at once. That makes it easier. Thanks.
You can use with Impress:
Menu>Insert>Media>Photo album
MarioSV, thanks for your opinion. EarnestAI thinks the same way, but all I wanted is a macro to do it inside LO Base, which apparently is impossible. Thanks anyway.
But damn close.
Then go ahead and write your macro.
@Quaresma : Might be this will work for you:
Diashow.zip.ott (595.3 KB)
You have to remove .ott. At this moment *.zip isn’t allowed here…
Extraxt the file, open the database, open the form and press button “Auto”. Pictures of the choosen “Bereich” will be shown automatically changing all 3 seconds. 3 seconds is set in macro (WAIT 3000). Press the button again and it will stop showing the pictures automatically.
Thanks for your help, Robert G. It’s always a pleasure to learn from the best. Best regards.
Dear Gbp,
I was hoping that this macro would solve the problem, and it probably will but unfortunately I was unsuccessful in my attempts to indicate the name of the folder where the images are.
As I mentioned before, although I really like macros, I am not yet very familiar with them. There must be something missing that I haven’t yet figured out.
Thank you for your help.
How to program anything on your own?
Villeroy, people come to this site looking for help with their problems because they think they can count on the support of knowledgeable and experienced people, which is definitely not your case. If you can’t help me, that’s fine. I’ve tried and failed too. But it would never occur to me to replace a macro with a Report saved as a PDF as you suggested above. If you can’t help or don’t want to help, that’s fine, but you’re definitely in the wrong place and your comments should not count as attempts to help someone.
Once the “ImageForm” form included in the file is open:
The macro don’t check the types of files, so folder should contain only image files
Gbp, thank you very much for allowing me to make this old dream come true. Maybe someone else in this forum will learn how to make a macro to run a SlideShow in LibreOffice base! Big hug.
PS - Is it not possible to indicate the folder name in the macro?
You need go into macro module (Menu->Tools->Macros->Edit Macros) and change line 26 removing the single quote at the beginning ('sPath) and assign the path you want to sPath variable.
Add a single quote or REM at the beginning of the line 27.
In case of HSQL, you don’t need any macro, other than the one provided by @RobertG.
ls -1 *.png > Pics.txt creates a text file with all *.png file names. This text file can be linked to a HSQL text table. Chapter 6. Text Tables
@Villeroy: Macro in my solution is only needed for automatic slideshow. Links to the images are set by Base through imagecontrol an varchar field. A “normal” slideshow could shown without any macro by navigationbar.
Links to all elements of a folder could created like you described - and then copied into a table in a database. HSQLDB could include text files. Firebird allows external files, but it isn’t included in driver LO uses.
I did as instructed and the result was negative “Game Over”. Did I miss something? The error must be mine, for sure, but I don’t see where I went wrong.
Sorry Gbp, I don’t understand how your macro works in your LOB and it gives a BASIC error in mine. Sorry for giving you so much trouble. I’ll try RobertG’s option. Thanks.