Import images into libreoffice base database without using a form to manually import individual images

[somnath]

I have a LibreOffice Calc spreadsheet that contains the following fields to generate student admit card.

1. Roll number
2. Name
3. Semester
4. Passport sized photograph

and other fields…

The 4th field contains the absolute path of the images. How can I print admit cards of each individual student using Forms in LibreOffice Base?

[Ratslinger]

There are different ways to use data from a spreadsheet in Base. A very simple method is to start the creation of a new database. Row 1 will be used for field names. On the opening dialog select Connect to an existing database. Then use the dropdown selector just below that and choose Spreadsheet. Click Next button. Use the Browse button and select your spreadsheet. Then Finish. Give the DB a name & save location and save it. It is a read only table you can use for Queries and Report generation.

If you want actual DB tables, you can copy the sheet data and paste into table section of main Base screen. Dialogs will prompt you to complete the actual table. Typically you would want row 1 data to become table field names.

There are other possible methods like using Writer and doing a mail merge.

LO documentation can be found on the Document Foundation site - click here.

Edit:

Just want to clarify, the actual images are not necessary. The path is fine. In Report Builder use an Image control and tie it to the field containing the path. The image will be brought in to the report from its’ location. Embedded pictures (Blobs) are a bit of a problem especially with space and don’t even work with mail merge.