Automating PBB Creation - Script provided

I am placing this here in case it helps someone. I was compiling a few PBBs tonight and it was getting a little tedious to keep doing each one by hand. You will need Excel and the AutoHotKey key utility to make it go.

The script will automatically fill in all the appropriate fields and start off the creation of the book. It will perform this for as many books as you have defined in the script.

Step 1

Make sure you have all the appropriate programs

Step 2

Download the zip with the helper files

0880.PBB Automation.zip

PBB-Automation.xlsx - Will provide the book information for each PBB

AutoHotkey.ahk - Script to automate the process

Step 3

Start logos and open the "Personal Books" in its own floating window

Step 4

Edit PBB-Automation with your information. The file has a few examples from my earlier efforts.

Step 5

Edit AutoHotKey.ahk to suit your needs (Numbers of times to run). Place file in your "Documents" folder. Select the option on the AutoHotKey tray task to "Reload this script" after every change to this file.

Step 6

Window Key+Z to kick off the process.

I suggest you start small with 2 or 3 books before kicking off a large batch. The scripts will be using the clipboard and switching windows, so I suggest you leave it alone once it starts.

Works On My Machine Disclaimer: It is a little late and the script could use some refinement. This is released with zero warranty. Feel free to use it as a base for your own work and perhaps with some collaboration we can tidy it up over time.

Happy PBB creation!

Find more posts tagged with

Comments

Rosie Perera

Thank you, Brother Odin!

Tes

I wish I could make it ,if I could understand it.

Ben

https://community.logos.com/discussion/comment/534479#Comment_534479

that's very nice, thanks.

Lee

https://community.logos.com/discussion/comment/534483#Comment_534483

nice thanks for posting

Claybon Collins Jr

Hi Brother Odin,

Thanks for the post of Automated PBB creation but I have just one question. After getting the WinZip program, do I create an AutoHotKey and if so could you be so kinds as to instruct me. Tried Win+z and nothing happens.

Thanks,

Claybon

Brother Odin

https://community.logos.com/discussion/comment/534686#Comment_534686

The zip file includes the AutoHotKey.ahk with the required script. This file must be placed in your Documents folder. You must have the utility autoHoKey (do a google search to find it) installed on your machine. When this utility runs it looks in the Document folder for this specially named file.

Open the AutoHotKey.ahk in notepad and there will be some comments there that might help.

Claybon Collins Jr

https://community.logos.com/discussion/comment/534692#Comment_534692

Thanks for your help.

Wild Eagle

https://community.logos.com/discussion/comment/534479#Comment_534479

I wish I could make it ,if I could understand it.

Same here, I wish someone would create a tutorial video.

Tes

[quote user="Brother Odin"]

The script will automatically fill in all the appropriate fields and start off the creation of the book. It will perform this for as many books as you have defined in the script.

Step 1

Make sure you have all the appropriate programs

Step 2

Download the zip with the helper files

0880.PBB Automation.zip

PBB-Automation.xlsx - Will provide the book information for each PBB

AutoHotkey.ahk - Script to automate the process

Step 3

Start logos and open the "Personal Books" in its own floating window

Step 4

Edit PBB-Automation with your information. The file has a few examples from my earlier efforts.

Step 5

Step 6

Window Key+Z to kick off the process.

I suggest you start small with 2 or 3 books before kicking off a large batch. The scripts will be using the clipboard and switching windows, so I suggest you leave it alone once it starts.

Happy PBB creation!

[/quote]

Hi Brother Odin, could you please prepare it in a kind of tutorial like videos , so that I may take part of this wonderful privilege ?

Brother Odin

https://community.logos.com/discussion/comment/541602#Comment_541602

I will see what I can do in the upcoming week. Stay tuned.

-- Odin

Tes

https://community.logos.com/discussion/comment/541870#Comment_541870

I will see what I can do in the upcoming week. Stay tuned.

-- Odin

Thank you brother Odin,

Brother Odin

https://community.logos.com/discussion/comment/541886#Comment_541886

I was going to make the recording tonight but ran into some issues with the original script. The PBB now automatically opens after building and it was causing havoc with the script. I have a new script but have run out of time to make the recording tonight.

God willing, I will record it tomorrow afternoon.

Almost there!

-- Odin

Paul-C

https://community.logos.com/discussion/comment/543198#Comment_543198

Is this a Windows only thing, or will the script work on Macs too?

Tes

https://community.logos.com/discussion/comment/543198#Comment_543198

[quote user="Brother Odin"]

God willing, I will record it tomorrow afternoon.

Almost there!

-- Odin

[/quote]

Thank you brother Odin, may God help you.

Brother Odin

https://community.logos.com/discussion/comment/543224#Comment_543224

Ok, the new script is available below. I ran into some difficulties having it work consistently on my machine. I will need to spend some time trying to get to the bottom of the problem, but it will have to be until some time next week.

In the meantime, feel free to adjust it or try it on your own machines. I have also added a tutorial video to go along with it which shows all the steps necessary to get things working.

Cheers!

-- Odin

5633.PBB Automation.zip

Link to video: https://db.tt/QPjQSNlP

Tes

https://community.logos.com/discussion/comment/543360#Comment_543360

Brother Odin thank you have done it very well,yet still it is not easy for me to understand the technical process I have to look for someone to help me understand it.Again I want to say thank you for taking time to help us.