Football card - dynamic layout and PDF print
Budget: $30 – $250 USD
I would like to produce a PDF file for printing football cards.
I need a script that automatically adjust the layout of football cards based on a specified list in excel, so that I don’t manually need to hide/unhide layers that I want to display for each individual card. The code should also save the layouts to PDF and in the end combine them all to one total PDF file containing all cards.
As input for the layout there is an excel list with all parameters specified. In total there are 75 layouts (3 for each player) The variables are:
- Player (example Albin, John, Isabell)
- Background (example Red, Gold)
- Position (example Defender, Midfielder)
- Description (example Captain, Future Star)
- Points (example 76, 84)
- Symbol (example Star, Ball)
One layout is equal to one row in excel. The first layout has the following settings:
Player: Albin
Background: Gold
Position: Forward
Description: Future Star
Points: 98
Symbol: Star
If there is no parameter specified (for a specific variable) all layers for that variable should be hidden.
There is no need for adjusting the graphical content of the layers as such. Its all about hide and disply the correct layers. The graphical layout and layers is today done in Inkscape, but I’m open for other software solutions like Adobe Illustrator or Indesign. I would prefer an opensource solution.
Some layers should always be visible, for example the "´Frame" and the "Club Information". Some layers should always be hidden, for example the "Help layout".
After that the correct layers are visible, the script should print the layout to PDF-format (specified size width: 68mm and height: 93mm) and resolution. The name of the PDF-file should be taken from the excel-list’s first column called "FileName". Number of cards (PDF pages) with the same layout is specified in the second column in the excel-list. If Cards is equal to 3, then the PDF file should contain 3 pages with exactly the same layout.
After that that all the layouts are completed and saved (end of script), all the PDFs should be combined to one common file, containing all the layouts in order with the correct number of cards (pages). Based in the provided excel list there should be 75 specific layouts and 275 cards (PDF pages), in the PDF document.
I need a script that automatically adjust the layout of football cards based on a specified list in excel, so that I don’t manually need to hide/unhide layers that I want to display for each individual card. The code should also save the layouts to PDF and in the end combine them all to one total PDF file containing all cards.
As input for the layout there is an excel list with all parameters specified. In total there are 75 layouts (3 for each player) The variables are:
- Player (example Albin, John, Isabell)
- Background (example Red, Gold)
- Position (example Defender, Midfielder)
- Description (example Captain, Future Star)
- Points (example 76, 84)
- Symbol (example Star, Ball)
One layout is equal to one row in excel. The first layout has the following settings:
Player: Albin
Background: Gold
Position: Forward
Description: Future Star
Points: 98
Symbol: Star
If there is no parameter specified (for a specific variable) all layers for that variable should be hidden.
There is no need for adjusting the graphical content of the layers as such. Its all about hide and disply the correct layers. The graphical layout and layers is today done in Inkscape, but I’m open for other software solutions like Adobe Illustrator or Indesign. I would prefer an opensource solution.
Some layers should always be visible, for example the "´Frame" and the "Club Information". Some layers should always be hidden, for example the "Help layout".
After that the correct layers are visible, the script should print the layout to PDF-format (specified size width: 68mm and height: 93mm) and resolution. The name of the PDF-file should be taken from the excel-list’s first column called "FileName". Number of cards (PDF pages) with the same layout is specified in the second column in the excel-list. If Cards is equal to 3, then the PDF file should contain 3 pages with exactly the same layout.
After that that all the layouts are completed and saved (end of script), all the PDFs should be combined to one common file, containing all the layouts in order with the correct number of cards (pages). Based in the provided excel list there should be 75 specific layouts and 275 cards (PDF pages), in the PDF document.