Start your own betting game and invite your friends, colleagues, customers and/or family members and challenge them to an exciting competition. Create your own betting game (betting meeting point) - completely free of charge and predict the matches of the Bundesliga, Premier League, World Cup and many more!!
- This guide is from our member Curswine, (Source) thx a lot!
So what I'm aiming to do is setup a .PSD file in Photoshop that will use a .CSV file to produce thumbnails of all fixtures in a league or cup competition.
What You'll Need:
Adobe Photoshop 7 or newer.
Google Sheets (Although any spreadsheet software should work.)
An advanced text editor (I use Notepad++ (Optional))
Method:
Open Photoshop:
Start off by creating a new .PSD file in Photoshop and make it 1280x720.
Design your fixture layout however you want to, mine looks like this to start off with. My base looked like this.
Once you're happy with how it looks, click on the 'Rectangle tool' and drag out a shape where you wish your home team logo to be, also note that this will define how large your logo will appear on your finished design.
Name these layers something obvious as if you don't things may get confusing later. I have named mine 'Home Team Logo' and 'Away Team Logo' respectively.
Make a text layer named 'Filename', this doesn't have to show on the image, it can be a hidden layer.
Save the .PSD in a folder with the logos that you're going to be using to display as fixtures.
Google Sheets:
Open a new sheet and name it however you like.
You're now going to have to create your fixtures, this could be done in a number of ways depending on your familiarity with spreadsheet software.
Using Find and Replace (Ctrl+H) I then substituted the numbers for the logo filename; for example 1 as replaced with Banga.png, 2 with Kauno.png etc.
I also made sure to add a column called 'Filename' which is what Photoshop will use to name files. I used the two team names separated by an underscore as my filenames: Banga_Kauno. Here's how mine looked.
Now it's time to save your file as a .CSV, make sure to save it to the same folder as your .PSD where your logos are located. Your folder should look a bit like this.
Back in Photoshop:
Now to link the ,CSV to the .PSD. With your file open navigate to 'Image > Variables > Define...'
In the 'Layer' drop down box find your layer that you named 'Home Team Logo' earlier.
Tick the 'Pixel Replacement' checkbox and in the 'Name' field type in 'Home_Logo' or whatever you named the column in your .CSV file.
Now once that is done navigate again to the 'Layer' drop down box and find the layer named 'Away Team Logo'.
Again tick the 'Pixel Replacement' checkbox and in the 'Name' field type 'Away_Logo'.
Finally find your 'Filename' layer, click the 'Text Replacement' box, and type in 'Filename'.
If you've done this correctly each layer should now have an asterisk (*) next to their name in the drop down box. It should look something like this.
Next click on the drop drown box which says 'Define' and click on 'Data Sets'. Alternatively click on 'Prev' or 'Next', they all lead to the same place.
In the 'Data Sets' screen click on the button which says 'Import...' and then navigate to where your .CSV file is saved. Also make sure the two check boxes in this window are ticked. Click 'OK'.
If everything has gone to plan you should now be able to view all your fixtures with the logos instead of the squares, click through them all to make sure that they work, if not it is best to check that filenames are correct. You may also receive error messages at this stage.
Saving in Photoshop:
Once you're happy with everything it's time for saving. Go to 'File > Export > Data Sets as Files...'.
This will bring up a menu for you to select where you wish to save your files to and how you wish to name them, if you included a 'Filename' column they should automatically be named this. If not, play around with the options till you get a filename format you're comfortable with.
Unfortunately there is no way to export the files directly as .JPG files, so they must first be saved as individual .PSD files , so it's best to make your original .PSD file as light as possible before exporting.
Once you've picked a location for your files to be saved and clicked 'OK' to export your files, navigate to 'File > Scripts > Image Processor...'.
In the first section of the 'Image Processor' window navigate to your folder full of newly created .PSD files.
In the second section I choose 'Save in Same Location', Photoshop will automatically create a 'JPEG' folder.
In the third section choose a file quality, 12 is best, here you can also resize the images if you so wish.
Click 'Run' and Photoshop will begin to process all the images into .JPG files. The end result https://i.imgur.com/a6NQYMD.jpg
Notes:
This is probably the simplest method there is, of course it can be made more complicated by whatever different design features you wish to include like team names, event times, round names, country flags etc. These would involve adding more columns into the .CSV file and pointing the .PSD to the right location for the information.
If you're using diacritics in text ÁáÉéÍíÓóÚú etc. Make sure to open the CSV in the text editor first and convert it to ANSI coding, if you don't do this it is likely that the letters will not display correctly in Photoshop.
