Question 1

How to Use LCB Book Creator (Powerpoint product)

Accepted Answer

This tutorial describes how to Use LCB Book Creator (Powerpoint product). It applies to:

For the Reseller / White Label product, the screenshots may look slightly different because of product customisation. for the Source Code product, this tutorial shows how the scripts and macros work after delivery.

First Things First - Handling Security Issues

If you get security warning from Powerpoint when you start the product, you have to tell both Windows and Powerpoint that you accept the file and the macros. We have a separate tutorial that shows you in detail how to do this: Enable Powerpoint Macros

Using LCB Book Creator

You can find LCB Book Creator on the Add-ins ribbon:

LCB Book Creator Finding the Add-In

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/2t13ML5EZa/LCB%20Book%20Creator%20Finding%20the%20Add-In.png (LCB Book Creator Finding the Add-In)

LCB Book Creator Finding the Add-In

Click the "LCB Book Creator" text or icon to start the LCB Book Creator:

LCB Book Creator Main Window

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/Bnja5XbYzz/LCB%20Book%20Creator%20Window.png (LCB Book Creator Main Window)

LCB Book Creator Main Window

There are 5 different (small) steps:

Select the CSV File, the data file for your Low Content Book or Images,
Select the Powerpoint Template file
Verify Placeholders - Check that all placeholders in the Powerpoint file do have data in the CSV file
Set the Powerpoint Output file
Generate Slides.

Optionally you can create example files, this will save a sample CSV file and a sample Powerpoint file to your computer. (You can select the sample files for step 1 and 2, to do a first test-run with LCB Book Creator).

CSV Files

CSV means "Comma Separated Variable length". In other words: the different values, texts, on each line are separated by commas. Besides that, it's just a plain text file, that you can type in Notepad, or save in Excel (use csv as the output format).

For LCB Book Creator, the first line needs to have the 'Placeholder' names, that will be present in the Powerpoint file.

After the first line with the placeholders, you can add lines with data. The lines will be processed one at a time.

Powerpoint Templates

Powerpoint Templates for LCB Book Creator are regular Powerpoint files. You can use placeholders (like "%TITLE%") that will be replaced with text from the CSV file.

The image below is from the sample Powerpoint Template file.

PPT Sample File

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/XE7n05BEIF/PPT%20Sample%20File.png (PPT Sample File)

PPT Sample File

The sample file is plain, and it is not recommended to use it 'as is'. It is intended to show you how the placeholders work. You can design the Powerpoint file any way you like, and you can even use multiple slides for each row of data in the CSV file.

Whever the text for a placeholder is an existing file on your computer (e.g. "C:/Images/Books.jpg"), LCB Book Creator will replace the placeholder with the image. Otherwise, it will only replace the placeholder text with the next text.

Output Settings

To generate a Powerpoint file, you'll always need to specify where the new file must be saved (step 4).

Additionally, you can automatically generate image files in PNG, JPG and PDF format. These will be saved in a subfolder. The value in the first column of your CSV file will be used as the filename.

Generate Powerpoint Slides

When you click Generate, a Powerpoint file will be created and saved to your computer, with the name and location that you selected in step 4. This may take a couple of seconds, depending on the complexity of your template, the number of placeholders and the size of the CSV file.

Question 2

How to Enable Macros and Install Add-In's in Powerpoint

Accepted Answer

This tutorial describes how to Enable Macros and Install Add-In's in Powerpoint. It applies to:

LCB Book Creator - Commercial
LCB Book Creator - Reseller / White Label

Whenever you use a Powerpoint file that contains macros, you'll receive a warning in Powerpoint. There are two steps to take (just once) to allow the macros to work:

Tell Windows that the file can be trusted
Tell Powerpoint that the macros can be trusted
Add the Add-In

Security Step 1 - Windows

To let Windows know that you trust the downloaded file, right-click the Powerpoint file and select Properties.

Unblock File in Windows

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/5Tk3PaDOK8/Windows%20Unblock.png (Unblock File in Windows)

Make sure "Unblock" is checked, then click OK.

Security Step 2 - Powerpoint

After you double-click the Powerpoint file, Powerpoint may show a warning that Macros are disabled. In that case, you have to enabled macros to use the LCB Book Creator on your computer:

In Powerpoint, click the File menu-option, then click "Options", at the bottom. In the Options window, find the Trust Center options (at the bottom), and click "Trust Center Settings".

How to find the Powerpoint Trust Center

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/0NMByXbpKG/Powerpoint%20Trust%20Center%201.png (Powerpoint Trust Center)

Powerpoint Trust Center

In the Trust Center, find the Macro Settings, then click either "Disable all macros except digitally signed macros", or "Enable all macros".

Powerpoint Trust Center - Enable Macros

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/8uWjC3gkuF/Powerpoint%20Trust%20Center%202.png (Powerpoint Trust Center - Enable Macros)

Powerpoint Trust Center - Enable Macros

Step 3 - Install Add-In

Please be aware, if the security settings (Step 2) are set to "Disable all macros", you won't be able to install the add-ind.

Open the Powerpoint Add-Ins Manager

Open the Powerpoint Options window by clicking the File menu, then click Options (at the bottom left).

LCB Book Creator Manage Add-In's

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/sqyv4o12bN/LCB%20Book%20Creator%20Manage%20Add-In%27s.png (LCB Book Creator Manage Add-In's)

LCB Book Creator Manage Add-In's

In the Options window, click the Add-Ins option, and select "PowerPoint Add-ins" in the dropdown menu at the bottom.

Add the new Add-In

The Add-Ins window may look different if you already have other add-in's installed.

LCB Book Creator Add New Add-In

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/YOsxR0LJHq/LCB%20Book%20Creator%20Add%20New%20Add-In.png (LCB Book Creator Add New Add-In)

LCB Book Creator Add New Add-In

Click "Add New" and navigate to the folder where you saved the LCB Book Creator addin. Please be aware that the plugin should stay in this location, otherwise Powerpoint will not be able to use it in the future.

Depending on your security settings, you may get a security notice (see below).

Handle the Security Notice

Powerpoint will let you know that you're installing something new, and let you decide whether to accept this.

LCB Book Creator Security Notice

https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/wuGqS3zSeN/resources/XPHiX2fbr2/LCB%20Book%20Creator%20Security%20Notice.png (LCB Book Creator Security Notice)

LCB Book Creator Security Notice

The add-in file is signed with a digital certificate owned by "Core Insights" (click Show Signature Details to verify this). You can either "Trust all from publisher" or "Enable Macros". If you decide to "Trust all from publisher", Powerpoint will never show you the security notice again for future add-ins or updates.

Once this is done, you're ready to use the add-in in Powerpoint.

How to Use LCB Book Creator (Powerpoint product)

How to Enable Macros and Install Add-In's in Powerpoint

Not many results?