Jumble Saler help

Stock system eBay mailmerge walkthrough - Step 8 of 10

Help home


STEP 8 - Creating a Jumble Saler Background Image Template rule using your background picture template files

1.  On the main menu, click on 'Background images' and then 'Background image settings maintenance' to open the template manager screen:



2.  Click the 'Add' button.

3.  In the 'List name' box enter 'Comics good'

4.  In the 'Brief description' box enter 'Comics in good condition'

5.  Change the 'Settings type' to 'STOCK SYSTEM' which updates your screen to look like this:



6.  In the panel which says 'Picture type' FIRST PICTURE, then click on the 'Browse' button and select your newly created 'MainPictureTemplate.rpic' and click on 'Open'.

7.  In the next panel below, then change the 'Picture type' form 'FIRST PICTURE' to 'ADDITIONAL PICTURES'  and then click on the 'Browse' button and select your newly created 'RearPictureTemplate.rpic' and click on 'Open'.  

Change the picture type to 'INSERT AT' and '2'.

We have front and rear pictures in your sample data for all the Scream comics, so we need this for the rear pictures.  In the 'Optional conditional SQL statement' box type in (or copy it and paste into the box):

[PictureRear] > ''

Then click the 'Check SQL' button next to it and make sure you get the 'SQL statement OK' message.  If not, then double check the spelling.


This means to only include this picture if the rear picture field in on the Stock System record has a rear picture allocated.  So what happens, is that if it merges with a Stock System record with a rear picture allocated, then it's merges the picture, and if not, then this panel is just ignored. 

NOTE - For other pictures, then click here.

8.  In the next panel below, then change the 'Picture type' form 'FIRST PICTURE' to 'ADD IF ROOM'  and then click on the 'Browse' button and select your newly created 'LastPictureAdvert.rpic' and click on 'Open'.   Your screen should now look similar to this:



Double check that your record matches this one.  The file paths will be different on your computer, but the rest should be the same.

9.  Now save you template rule using the 'OK' button to return to the Template Manager list:



10.  Close the Template Manager. 


Next step - Step 9

Previous step - Step 7

Return to Step 1


Support

Any problems with the walkthrough?  Just contact our Support Department and they will be happy to help.