Home

View the User Manual - Professional Product Catalog Software

1. Width Height Grid 1 to 10 Detail Table has Column Headers First Line in Detail Table repeats from Display Unit pea E csc ted Data Source for Notes Line Comments Line prints O Above Data Line Below Description Easton BMX Glove Comments The Detail Table Design Pad is very similar to the one on the Display Unit form There is the same stack of fields and labels to choose from Drag and drop fields onto the Detail Table and re size them by dragging the borders or entering percentage values directly Reposition the Active Cell using the mouse or the Left and Right Arrow Keys on your keyboard Only fields can be dragged onto the Detail Table The Field Labels are automatically added above the fields as Column Headers Also only the widths of fields can be changed The field heights are automatically set to the height of the row The selection for the option First Line in Detail Table repeats from Display Unit will depend on the structure of your data If you refer back to the spreadsheet and data samples throughout this manual each row contained all the text necessary to fully describe the item This means that much of the text was common to every row and this is the typical arrangement of data in a spreadsheet In designing the template the normal practice would be to place all the common text in the Display Unit and only the individual text such as part numbers sizes etc in the Detail Table In this case i
2. s Photo column so you should have already imported your spreadsheet data A summary of the database is displayed in the Data Window on this form This shows only the Category Name and the Photo filename Every category can have a different Image Folder so make sure this is set before downloading images as this the folder the files will be downloaded into The filenames used on the website may be the ones you want to use but commonly with many hosted e commerce sites the names are a string of random characters In this case you may want to rename the files using data from another field For example you may have a Part Code recorded in your data and want to use that to rename the file Select a data column or keep the original name This function will look for the filenames in the list and download them if it finds a match If a file of the same name already exists in the destination Image Folder it will be overwritten If the file to be downloaded is not found on the website the function will skip to the next name without error If the rename option is used and if the download is successful then list in the Data Window will be updated with the newly created filename Check Images The most common problem experienced in printing with this or any other catalog software is memory shortage caused by using photos which are too large Photos directly from a digital camera can be 2 000kb to 5 000kb The Check Images function displays the approxima
3. record can be seen without scrolling However because the Data View form can be customized by changing the height width and order of cells most users will find it easier to work with Add records to your database as you would on the Data View form using the Data Window There is the same Insert a New Row button as on the Data View form and also an Add a New Inventory Item button The difference is that the Add button creates a new record at the end of the current category while the Insert button creates one in the middle 1 SubCategory Text SKU Size Prce bhia SubCat Text i I donD ic Print Templates to indicat 516972 Medium 8 99 u ategory I ext Is normally usea on Dynamic rrin empiates to inaicate a break in products within a Category As shown here the text Spring Collection has been inserted between two products in a column SubCategory Text always prints above the Display Unit SubCategory Text in other template styles prints in the Page Header or Footer 516973 Large 33 99 Tagless T Shirt Short Sleeves SKU In all data in all fields Trailing Spaces and Carriage Returns are deleted This means that you cannot add spaces at the end of a data field to increase the vertical space between a field and one below it In the example here you could have more space above Spring Collection by inserting spaces or a Carriage Return before the text but not below Fortunately there is a special charact
4. Detail Tables are in an order that best fills these empty spaces You can also fine tune your Template Design to change the height of your Display Units Changing the Vertical Margins choosing different fonts and even the widths of the fields can all change how many Display Units fit on a page The Data Breaks Across Columns option will also affect how many items fit on a page but if you have made all the changes you can to a Template and still have some blank space that you want to fill Ad Text may be your solution Identify blank spaces using a Print Preview and enter an appropriate amount of text in this field Ad Text always prints below the Display Unit Left chest pocket Preshrunk for a great fit Washed for softness and a gently faded look SKU Size Price 507501 small 3 99 507502 Medium 6 99 507502 Large 6 99 Free shipping on all On line Orders Spring and Summer Tagless T Shirt Short Sleeves SKU 514221 Preshrunk cotton for the perfect fit Narrow reinforced collar resists raveling and rip out Tag free collar 100 cotton SKU Size Price 514221 small r 90 214222 Medium gt 7 90 614223 Large 7 90 12 The Category Editor Form To make changes specific to individual categories click the Category Editor button on the Main Menu and then click the Find button to select a category From the Data View or Inventory forms open the Category Editor form by dou
5. Each line in the Detail Table can have an additional Comments line This line prints above or below the Data Fields and will be the full width of the Detail Table To enable this feature simply select a Data Source from the drop down box This field is displayed on the Design Pad as a single line but will expand to accommodate multiple lines when printed 26 Formatting Text Both the Display Unit and Detail Table forms have a Formatting button Click this to go the last form to change the formatting of text and borders Description Active Cell Boxes Rows Font 09 v Roca Cell Borders cle Color 7 a Shading Description Product Size Price Easton BMX Glove 2647283 13 44 99 Notes Click any field placed on the Display Unit or Detail Table to make it the Active Cell and then click any button for the attribute that you want to adjust The best way to use this form is to experiment Change an attribute and then click the Print Preview button to see how it looks Text Numbers Currency and Barcodes The default field type is Text If you select a field and change its attribute to Number or Currency when printed CleverCat will examine the field and format it as follows If the field is empty nothing will be printed If the value is zero nothing will be printed If the value is a number then it will be formatted as a number or currency as defined by your computer s Regional Settings If the value is not a number
6. Style CleverCat does not print barcodes on its own Instead install any barcode font and select that as the Text Font on the Formatting form To be readable barcodes typically add special characters called Start and Stop bits and or error checking bits You can manually add these to the text to be printed as a barcode or they can be automatically created at print time by selecting a Barcode type on the Configuration form NOTE CleverCat has only been tested with the fonts from www elfring com and only for the barcode types listed on the Configuration form We recommend that you purchase a license for the font from Elfring Image Tools Many users will create their catalogs using data from a spreadsheet For some this spreadsheet will be created as an exported file from their online e commerce site In this situation the photo name may be recorded as a filename but also frequently as a URL In either case this may be the only place where those photos exist CleverCat requires that all the photos be on a local drive referenced by a drive letter such as C CleverCat cannot link to online photos referenced by a URL The Download Images function provides an easy method of copying online photos to your local drive Start by entering the website name and folder For example www clevercatalogs com photos This step may not be necessary if the filename to be downloaded includes the URL This function reads the filename recorded in the database
7. Z but want them to print as a single category Accessories In this case you might choose a different column from your spreadsheet for the Category Label selection Category Labels can also be changed any time after importing on the Category Editor form For the Category selection try to avoid using data containing special characters such as backslashes or quotation marks The Category name is used throughout CleverCat for purposes of sorting and selection and some special characters may cause errors Special characters can be used in the Category Label The selection SubCategory is used to separate a logical break between products within a category For most users if a subcategory is required it will be recorded on every row in the spreadsheet However as shown below this is not required and it can be recorded only where the break occurs The SubCategory field will print as a break between items in a Dynamic Printing Template or in the Page Header or Footer in other template styles If you need the subcategory to print with every product you should select this column as another data field selection mE Beefy T T Shit Short Sleeves 516971 Small 840 Category SubCategory Product Beefy T T Shirt Short Sleeves 516972 Medium 8 40 T Shirts Short Sleeves Beety T T Shirt Short Sleeves Beefy T T Shit Short Sleeves 516973 Large 840 T Sh ts Beety T Pami Short Sleeves Tagless T Shirt Short Sleeves T Shirts Beefy T T Shirt Short
8. automatically saved as you make them There is no Find Save button in CleverCat New Data File Copy Restore Backup When you first install CleverCat the default Data File is data mdb You can work with this file or create a new blank file by clicking the New Data File button If you are going to make a large number of changes to the current data file such as import new records or delete categories you should make a copy of your data first using the Copy or Backup button The Copy function will ask you to name the new file it creates and as many copies as you need can be made For regular users we recommend making multiple copies at regular intervals and naming them appropriately For example files named January February etc can be very useful if you need to return to an older version of your catalog Multiple copies are also useful if you need to make catalogs for different purposes For example you could complete your catalog for the wholesale market make a copy of it open that copy and make the changes necessary for the retail market The Backup function creates a copy of the current data file and names it Backup If the backup file already exists it will be replaced with a newer version The Restore function replaces the current file with the Backup file If for example you are working with a file named myData mdb when you click the Backup button a copy of myD
9. data from an Excel spreadsheet to an Access database it scans only the first few rows to determine the data type If the first few rows contain less than 255 characters Office assumes that every row contains less than 255 characters and longer text in subsequent rows will be truncated To avoid this problem enter additional text more than 255 characters in the first data row Every column is scanned separately so enter additional text in every column which may have more than 255 characters The Data Mapping Form Data Mapping refers to the process of selecting columns from maleyo the spreadsheet and mapping them to fields in the database Category SubCategory l w Category Group Most selections on this form are optional but you must make a selection for the Category field for the Map Click the drop down select a different column for this Category names in CleverCat must be unique but they can share a Category Label The Category Label is the text that prints in the Page Header if that option is selected Inventory Index i selection box next to the label Category to display a list of the aoran columns in your spreadsheet Print Order When you make a selection for Category the same selection is Serb Men automatically added to the Category Label box although you can Category Label For example you may have data organized as different categories Accessories A J and Accessories K
10. extreme cases this could require cascading changes through the entire catalog The biggest advantage of Page Layout software is its artistic flexibility At the upper end of this range you should be able to create on paper almost anything you can imagine This is also its biggest disadvantage as creating a large catalog can take many hours days or even months In contrast Database driven softwares are typically very rigid The printed output is very uniform in appearance and at the lower end of this range there are very few presentation options to choose from Every user s catalog looks just like every other user s catalog However using Database driven software a user might be able to create a catalog in only a few minutes CleverCat is a hybrid of Page Layout and Database driven softwares With CleverCat you create just once a printing template for your products Using this template a full catalog can be quickly created using the products recorded in the database CleverCat has the ability to create an artistic layout within a modest range of options as well as the ability to quickly produce a large catalog of hundreds or thousands of items Flat vs Relational Databases As shown in the illustrations below flat databases comprise one image for every item Similar items may be represented by the same picture and similar descriptions Flat Database CD ROM 14 00 a CD ROM 24x 16 00 gt m CD ROM 32X 18 00 e Rela
11. fill the space If the last Display Unit on the Page is cut off or missing reduce this number or select a negative value Display Unit Margins is the Horizontal and Vertical space between the Display Units themselves Formatting Any of the text elements on the page can be customized Click the text on the Example Page and it will be displayed in the Active Cell box Now click any of the attribute buttons or the color selectors to modify the selected text Display Unit customizations are also made on this tab There are four options for borders in CleverCat Off Hairline 1 Point and Rounded Hairline and 1 Point are provided for compatibility with different laser printers On some printers Hairline and 1 Point are identical On others Hairline is almost invisible Thicker borders can be created by using the Rounded Corners border option and setting the Radius to zero There are two Corner Radius Line Thickness selections The first applies to the Display Unit borders and the second applies to all cells within the Display Units The Separating Lines selection is available only for certain template styles and the function changes for each style With a Dynamic template the separating lines are vertical lines between columns With a Summary template the separating lines are horizontal lines between rows in the Summary Unit When viewing a Print Preview you may notice that borders may appear to overlap disappear or not align wit
12. moves their mouse over the product image enter it in this column Files Create the HTML and PHP files by selecting categories and then click the HTML Print button on the Printing Menu In addition to the php and htm files CleverCat will create Cascading Style Sheets css If the Copy Images options is selected the photos will be copied to the specified output folder as well This will allow you to preview the HTML files before uploading them Files for CD ROM catalogs and copies of other support files which do not change can be found in the HTML folder under the CleverCat program folder 36 Troubleshooting and Support Technical support for CleverCat is available by e mail Our office hours are 8 30am to 4 30pm Pacific Standard Time If you see an error message screen in CleverCat take a screenshot of this by pressing and holding down the Alt key and the Print Screen key Alt and Prt Sc on some keyboards at the same time This will copy an image of the current window into memory In your e mail program paste this image into the body of your message by pressing the Ctrl V keys or select Paste from the Menu Bar Sending a screenshot of the error message is not necessary but will help us identify the problem very quickly Please include a description of what you were doing when the error occurred Memory Errors Memory errors are usually caused by using photos which are too large Photos directly out a digital camera can be any
13. the files at that time Others will print every category without pausing and stack the filename dialogs in a group on the Windows taskbar and you select and combine them after they have all printed Lastly some will print to individual files and then you use a separate utility to combine them into a single file Printing photos uses a great deal of memory so you may find that you are unable to print and combine all the PDFs in one step You may need to combine groups of categories into larger PDFs and then use the PDF writer to combine these larger PDFs into a final single file Category Groups If you used the Category Groups field on the Category Editor form and assigned categories to groups there you will see a Group Selector below the Category list on the Printing Menu You do not have to assign every category to a group There will be a No Group defined group as well as an All group in addition to any groups that you create 30 Configuration Form Company Banner Logo The Banner File set here is displayed at the top of each form and is also the Company Banner which prints in the printed Page Header if that option is selected on the Page Setup form Units of Measure Select Inches or millimetres The values on the Template Editor will be automatically converted if the setting is changed later Category Name Selection Action This setting changes which form opens when you click a category name on the Main Menu Barcode
14. this Category option allows you to design a template using the text from the first record in that category in place of the labels The Color Palette E EE P7H X In many places throughout the Template Editor Double click to select forms there are color selection boxes To change the color of a selected item click the color box to open the Palette Select one of the ten colors on the quick selection palette or select from the full palette using the More button To select a color from the palette simply double click one of the ten boxes To change one of the saved colors click once on the box you want to change and then click the Add to Palette button This provides access to the full range of colors Select or create a color and click OK to place it on the quick selection palette Page Printing Templates can only be created for Letter and A4 sized paper in Portrait orientation unless the Landscape Option is enabled on the Configuration form Enabling this activates another set of calculations which reduces printing speed for all templates If you do not require Landscape templates leave this option disabled If you do enable the option on the Configuration form then you will also see a Landscape option on this form The default margins are 0 35 or 6 35mm Most printers should be able to work with these margins but increase them if you find the edges of your data are being cut off or you see an error message indicating there is not eno
15. to proceed to the Data Mapping form You do not have to correct errors in columns which you do not intend to import Also you do not need to correct formatting errors if you are Copying and Pasting data Also on the Import form is an Export button Select an existing file to export to or enter the name of a new one An existing file will be overwritten If the file does not exist it will be created CleverCat creates an internal numbering structure and importing a spreadsheet and then exporting to the same spreadsheet is a good way to view these numbers These numbers can be used later as a reference if you want to use Excel to update your data and re import just the changes into CleverCat s database Another formatting problem to avoid is trailing spaces in the Column Headers Trailing spaces are automatically deleted from all data imported into a database so this is not a problem with the data fields However the Column Headers are imported before the data If the text in the Column Headers contains trailing spaces they will be removed first When the import function later attempts to import the data it needs to compare the Column Headers in the spreadsheet and database to put the data in the right column Without a trailing space the Column Headers will no longer match and the import function will fail The last formatting consideration is the number of characters in a field CleverCat is based on Microsoft Access and when MS Office transfers
16. was reserved for it so the Display EPE ie na a Unit has a blank space when printed roomy ft 100 llasting cotton White The best approach to Dynamic Template Design is to set the size of the field to be roughly equal to the size it needs to be for the smallest amount of text in your data When designing a Grid Feature or Summary Template or when the Fields Grow and Shrink option is disabled the best approach is to set the size of the field equal to the largest amount of text If you have any difficulty with Template Design send us a sample of your data along with a picture or link to the type of template you are trying to design and we ll create one for you at no charge We can even do custom designs that go beyond what is possible using the Template Editor For example we have created custom templates where the data in a field is the result of a formula which varies depending on the contents of two or three other fields This type of custom work is well beyond what can be done with the Template Designer so we ll provide you with samples and a quote for the design costs before you commit to making a purchase 24 Data Breaks Across Columns Ultimate Cotton Pocket SEKU Sime Price Beefy T T Shirt Short Sleeves SRU 516971 Lita sott cotton feels great Shoulder to 507501 small 56 99 Free shipping on all On line Orders Ultimate Cotton Long Sleevy SKU R111 Preshrunk cotton for the pestect fit Narrow re
17. your spreadsheet Compare a field in the source data with a field in the database Source Database Of course your data may already have values which uniquely identify rows Part Numbers Product Codes etc are usually unique In this case select that column as the Source selection and the field into which you first imported it as the Database selection Compare a field in the source data with a field in the database To update the database with changes you have made to the spreadsheet select Unique Records as the Import Option and click the Update button CleverCat will compare every row in the spreadsheet with every record in the database to find matching records With a large spreadsheet and a large database this process can take several minutes The Add New Data button can also be used with the Unique Records option to add only new rows in the spreadsheet Again this can take several minutes as every record in the database must be compared against every row in the spreadsheet to identify new rows For this reason you may find it simpler to create and append a smaller spreadsheet which contains only the new records The Data View Form The Data View form provides a spreadsheet like interface for entering or editing large numbers of records in the database This form is divided into two sections the Category Window and the Data Window Click any row in the Category Window to view its records in the Data Window Cate
18. B4 7 99 Ultra soft cotton feels great SI ra 1 2 Beefy jpg Beefy T T Shirt Short Sleeves 516972 Medium Medium 5 4 15 99 Ultra soft cotton feels great St g 1 3 Beety jpg Beety T T Shirt Shot Sleeves 516973 Large Large o 4 15 99 Ultra soft cotton feels great St al 2 1 Tagless jpq Tagless T Shirt Short Sleeves 514221 Small Small ie 14 99 Preshrunk for a great fit Washe E 2 2 Tagless jpq Tagless T Shirt Short Sleeves 514222 Medium Medium 7 9 14 99 Preshrunk for a great fit Washe After creating your new category use the Data Window to enter your records The Data Window is similar to an Excel spreadsheet You can Copy and Paste data from a spreadsheet into the Data Window and use other Excel editing functions such as Ctrl F Find and Ctrl H Replace Customize the Data Window the same way you would an Excel spreadsheet Change the widths of column and the height of rows by placing your cursor at the dividing line where it will change into a double headed arrow Re order the columns by clicking the Column Header and then dragging the column to a new position To return the column order to its default position select Reset Columns from the Data Menu on the Menu Bar Copy and Paste Data Copying and Pasting data is much easier than using the Data Mapping form to import data Data Mapping is useful if you regularly update a spreadsheet and then use that to update the database The procedure for copying from Excel varies The
19. Catalog the HTML files will be created there and a subfolder named Photos would be created and your image files copied there This allows you to click on any HTML file in the output folder to preview how it will look on the website This is also the easiest way to create a catalog on CD ROM You need only copy the contents of the Output folder as well as the Image subfolder to the CD ROM to complete the Catalog Content portion of the CD ROM IMPORTANT Each time you print the PHP or HTML files all the previously created files in the Local Output folder will be deleted If your configuration requires that you print files in Separate groups remember to upload or move the previous group before creating the next iFrame CleverCat can be used as a Content Manager and does not create a complete website View the examples on www clevercatalogs com websamples html to see how the catalog content is displayed in an inline frame On the iFrame tab set the width of the frame in pixels which you will use on your site When you print the HTML files they will be configured for a frame of this width Here is the code from the sample page which creates the inline frame lt td width 800 gt lt iframe src WebSample11 htm name catContent gt lt td gt This is not the complete code For clarity the instructions setting colors borders etc have been removed What this code does is create a cell which is 800 pixels wide create an if
20. CleverCat Version 2 5 Thank you for purchasing or evaluating this software If you are only evaluating CleverCat the Free Trial you downloaded is fully functional and all the data you enter during the evaluation period will still be there should you later decide to purchase and activate the software Table of Contents Concepts 2 The Page Setup Form 18 Getting Started 3 Selecting a Working Category 18 Saving your Data 3 The Color Palette 18 Page Configuration 18 Formatting Eirors 4 Page Header and Footer 19 Display Units and Template Styles 19 Inventory Grouping 6 Page Formatting Options 20 Data Field Selections 7 Designing a Printing Template 21 Importing Options 7 Grid Feature and Summary Styles 21 Updating the database 7 Dynamic Templates 22 The Data View Form 8 Field Growing and Shrinking Rules 22 Copying and Pasting Data 8 Data Breaks Across Columns 25 Deleting Data 9 The Detail Table Form Inserting a New Row in the Database 9 The Formatting Form Sorting and Grouping Data 10 Text Number Currency and Barcodes 27 Text Alignment and Justification SubCategory Text 12 oles Backgrounds and Borders Ad Text 12 Table of Contents and Index Page Creating a New Category Page Numbering i Category Groups i Rebuilding the Page Index 29 Option Text 13 Duplex Printing 29 Page Prefix 14 Printing to PDF 30 Category Footer 14 The Configuration Form 31 Image Folder 14 LLLE TS m Kote E 31 Category Banner 14 Downloading Images from a We
21. Index The T O C numbers can be entered manually or they can be calculated when the catalog is printed For example if you have just imported your data and not printed or previewed it you would not know how many pages are required especially if you are using Dynamic Templates Therefore you would not know which page each category started on In this case select the AutoNumber and Rebuild options before printing and give each category a T O C number indicating the order you want them to print in The actual number doesn t matter it just has to be unique so you will probably just number them 1 2 3 and so on When printed the Rebuild option updates the T O C column with the actual starting page number of each category As well the Rebuild option updates the Page numbers for each record for an Index Page If you make changes within a category it is not necessary to reprint the entire catalog to update the Page Index Opening a Print Preview of that one category will update the Index if the Rebuild option is selected Be sure to set the starting Page correctly in the T O C column first You do not have to look at every page in the Preview but the Index Number is only created when each page is calculated Using the Navigation Controls at the bottom of the Preview Window skip directly to the last page and every page in between will be calculated Duplex Printing The Duplex option is provided for those users who will be printing on both side
22. Page 7 This number is not eey 3 1 7T 3 shown for every row to make the table easier to per 3 2 p read Ei 3 3 E 4 1 7 3 The Feature Unit is always at Position 1 The remaining Display Units will fill the page starting in the top left corner and print from left to right In this example the template design has Position 1 in the center of the page The positions in the top row are 2 3 and 4 The positions in the second row are 5 and 6 plus the top half of number 1 There are a total of 13 positions on this page 10 Photo Selection In the upper right corner of the Data View form is an image box which displays the product image Lookin E Photos e 0am of the currently selected row in the Data Window a Click this box to search for a new file WD sig ye Icons ass a sj List This screenshot is of the Browse Dialog in 2 ee lt 3 MG _ Windows XP Your window may be different but i there should be an option to view the files by Thumbnail This will make it easier to select the ATT959Large jpg GE9490Large jpg correct photo amp NY apr Double click the photo to select it ATT985Small jpa ATT985Large jpg T112Small jpg In the Data Window double click the Photo or x second Photo text field in any data row to open the Network Filename z same Dialog Files of type Common Image Files bmp gif jpg Open as read only The Inventory Form The Inventor
23. Prefix is added to the Page Number If your catalog uses data that is frequently updated it may not be practical to try to use a continuous page number across all categories In this case you may need to number each category starting at page 1 and a Prefix will help identify pages For example you might use a Prefix of Supplies for a page numbering of Supplies 1 Supplies 2 and so on Category Footer Each category can have its own Category Footer text and this is printed centered in the Page Footer This field can have multiple lines of text although only one is shown on the form Double click this field or any field to view the text in a larger box If you use multiple lines of text in the footer you may have to increase the height of the Page Footer in the template design to see the additional rows Image Folder Select the Image Folder for the category on this form or either data form Each category can have its own folder to make it easier to organize large numbers of photos and the folder name is combined with the photo filename to define the full path and name of the image file For example the filename C myCatalog myPhotos Photo1 jog could be recorded several ways Normally you would record C myCatalog myPhotos in the Image Folder field and Photo1 jog as the filename but you could also record C myCatalog in the Image Folder field and myPhotos Photo1 jog as the filename URLs cannot be used as the image folder but network loc
24. Sleeves T Shirts Tagless T Shirt Short Sleeves Product SKU size Price eae 7 PES Tagless T Shirt Short Sleeves 514221 Small 7 90 aa Tagless T Shirt Short Sleeves Tagless T Shirt Short Sleeves 514222 Medium 7 90 T Shirts Tagless T Shirt Short Sleeves Tagless T Shit Short Sleeves 514223 Large 7 90 a Long Sleeves ia Cotton Pocket a Long Sleeves Pani Cotton Pocket Fan innana ee ee T Shirts Witimate Cotton Pocket T Shirt T Shirts Ultimate Cotton Long Sleev Product SKU size Price era u p Ultimate Cotton Pocket T Shirt 507501 Smal 8 90 T Shirts Ultimate Cotton Long Sleev Ultimate Cotton Pocket T Shirt 507502 Medium 8 90 T Shirts Ultimate Cotton Long Sleev Ultimate Cotton Pocket T Shit 507502 Large 8 90 The next selection Category Group is currently only used for selecting groups of categories for printing In future versions it may be expanded to other functions If you need this information printed with every product you should select it as another data field selection Inventory Grouping The Inventory Group selection is optional and the Sorting and Grouping function on the Data View form can be used later to perform the same function described here If this selection is left blank the data will be imported and numbered as flat non relational If used this selection logically groups together related items and also creates the Detail Table structure for more efficiently displaying related products un
25. Small 8 40 Beefy T T Shit ShontSleeves 516972 Medium 8 40 Beefy T T Shit ShontSleeves 516973 Large 6 40 below the Photo Shoulder to shoulder tape makes it long lasting Fulk cutfor a roomy fit 100 cotton TIP Start a Dynamic design by turning on the Display Unit Tagless T Shirt Short Sleeves Borders and placing a single field Move this field up or SKU down to set the minimum height of the Display Unit 514221 Preshrunk for a great fit The Display Unit will grow to fit the fields as they grow to ings pe arden fit the text In the first Display Unit on the right there are ae palin three rows in the Detail Table As a result the Display Unit itself is taller by one row than the one below it This is why a Dynamic Template is usually the better option when the Product SKU Size Price data is variable and you want to reduce the overall number Tagless T Shirt Short Sleeves 514221 Small 7 90 of pages Tagless T Shit Short Sleeves 514222 Medium 7 90 Ultimate Cotton Pocket T Shirt There are many variables that will change how many pages a Dynamic Template requires For example increasing the Vertical Margin spacing between Display Units may decrease the number of Display Units on one page but because this change cascades through the entire category it may actually increase the number on another page The best way to understand designing Dynamic Templates is to experiment with field placement and Print Preview t
26. The Pages column may not be accurate if the catalog has not been printed yet as the number of items on a page in a Dynamic template can change depending on a range of variables For the other template styles the automatic grouping functions should produce an accurate page count when a template is selected Change this number manually if required 28 Page Numbering ee Page Numbering Option Date or Optional Footer Text Most users will want to print a catalog with AutoNumber Starting from Page 1 sequential numbering across all categories Number Categories Using TOC Number Check the AutoNumber option to do this If Rebuild T 0 C 7 Index After Printing Currency Symbol you are including other pages before your catalog data such as a Table of Contents or Duplex Printing an Introduction page you may want your Yes No page numbering to begin on a page other than 1 Enter the starting Page number as Price Markup 0 Global ind Blank Hide required CleverCat will use the global markup discount shown here The Starting Page number option is also useful if you are re printing an individual category If the category is from the middle of your catalog you would not want it to start with page 1 You can also print categories with page numbers starting at the value recorded in the T O C column The T O C number is also the Starting Page number recorded on the Category Editor form Rebuilding the
27. _jpg 411001 Small 2 2 Ultimate Cotton Pocket T Shit Ultimate Cotton Pocket T Shirt Ultimate_jpg 411002 Medium 2 3 Ultimate Cotton Pocket T Shit Ultimate Cotton Pocket T Shit Ultimate_jpg 411003 Large 3 1 Geety T Tagless Beefy T Tagless Beety jpq 606007 Small 3 2 Beefy T Tagless Beefy I Tagless Beety_jpq 606000 Medium 3 3 Beety T Tagless Beefy T Tagless Beefy jpg 606609 Large For some users importing a field into the Inventory Group column may be convenient because it allows the printed data to be changed while retaining the original grouping structure However the Inventory Grouping Field selection on the Category Editor form supersedes the Inventory Group Column data In the example above selecting Size as the Grouping Field would cause the data to be grouped by the data in the Size column even though there is valid data in the Grouping Column Similarly if the Grouping Column was empty a Grouping Field selection of Description would group the data by Description as shown above The Inventory Group selection on this form is the same as the Group By selection on the Sorting Grouping form described in the Data View Form chapter The purpose of this field is to provide flexibility for certain types of data For example if every row ina category had its own unique photo you could change the Field selection to the Photo column and print a sheet of thumbnails of every product Then you could change the Field selection to the c
28. adsheet to update the database If you make significant changes to the spreadsheet such as adding an additional column click the Refresh button to force CleverCat to re examine the spreadsheet Important This form provides a Window into the actual spreadsheet You cannot open the same file with two different programs at the same time so be sure to close Excel first Formatting Errors 21 99 In the Preview Window on this form you may notice that some of the data in your spreadsheet Num is replaced with the characters Num This can occur if a column contains a mix of text 14 96 numbers currency or dates To check the entire spreadsheet for this common formatting problem click the Check for Errors button If an error is found the data in the indicated column must be converted to text before the spreadsheet can be imported Exit the Import Form before opening the spreadsheet in Excel In Excel select the column to be converted by clicking the Column Header Select Text to Columns from the Data Menu to open the Formatting Wizard On step 1 set the Data Type to delimited and click the Next button On step 2 set the Delimeter to Tab and click Next again On step 3 select Text as the Column Data Format and click Finish Repeat these steps for all columns containing a mix of text and other data types If the Check for Errors function finds no problems you are ready
29. ally using the Sorting Grouping function Sorting data is similar to the process in Excel Check the Sort ga Data option and select one to three fields to sort your data by in _ order order Photo Descript ascending or descending alphabetical order To group your data 1 1 A101jpq Long Sleeve check the Create Detail Tables option in the Grouping section of A101 jpq Long Sleeve the form and select a Group by field E A101 jpq Long Sleeve E m If you selected an Inventory Grouping field on the Mapping form A101 jpq Long Sleeve then you would normally select Inv Group here However most relational data will have something which is common to all related __ records In this example the photo and the description are common to the groups of items and either of these would be a good selection to group the different styles together gt gt Group By is normally used together with a Sorting gt gt order order Photo selection For example if your data was being order order Photo E J220 jpg Short Sleeve J220_jpq Short Sleeve C amp F lt 8 8 lt x Po oo 1 1 1 9 2 1 Photo1jpg grouped on the Photo field and the data consisted of 1 1 Photo1 jpg E 1 2 Photoljog three rows with Photo1 jpg three rows of Photo2 gif 1 2 Photo1 jpg 1 3 Phototjpg and three more rows of Photo1 jog sorting and 1 3_ Photot jpg Enoto Jpo grouping the da
30. are testing the import function or using Excel to edit or update and then replace your data you should select and delete just the data by clicking the sheet selector in the upper left corner of the Data Window This way when you re import or re paste the updated data the category settings you made earlier will not be lost You can also delete all the data in every category in one step by clicking the All Data button at the bottom of the form This will display every record in every category in the same window Click the sheet selector and press the Delete Key Using this method the categories themselves will be retained Inserting a New Row Unlike an Excel Spreadsheet new columns cannot be inserted However they can be re ordered by dragging them to a new position and there is a button for changing the name of the currently selected column There is a button for inserting a new row above the currently selected row and this will automatically adjust the Print and Sub Order numbers l In this example the third row has Print Order number 1 and Sub ai Print Sub Order number 3 If this is the current row the Insert a Row function will order order Photo recognize that the new row will be in the middle of a group of products F 1 Froductt jpg and give it the same Print Order number and Sub Order number 3 TREFT The current Sub Order number 3 will be re numbered to 4 and this Product Jpg re numbering will ca
31. at all but text then the text will be printed CleverCat does not create Barcodes Barcodes are fonts like any other font installed on your computer To be scanned correctly barcodes require additional characters for error checking If you select the Barcode attribute CleverCat can add the error checking characters automatically Each barcode font uses different error checking characters so select the Barcode type on the Configuration form Alignment and Justification By default all text will be Left Aligned but can be changed to Centered Right Aligned or Justified The alignment of the photo can also be changed Unless your photos are exactly the same shape as the space reserved for them there will be some empty space on either side or below the photo Use the Alignment buttons to Left Center or Right align the photo For the photo the Justification button has a special function Normally your photos are fitted to the reserved Space in such a way as to show them as large as possible without distortion The Justification function fits your photos exactly to the size of the reserved space This could distort the photos so you would normally only use this if your photos are very close to the required dimensions Colors and Backgrounds The color of any text and the background shading of any field can be customized Click the field you want to change to make it the Active Cell and then click the Cell Borders or Color Shading boxes Borde
32. ata mdb is created and named Backup mdb If you later click the Restore button myData will be replaced with the older copy of Backup and any changes you made to myData will be lost Restore replaces only the current file so if you backup myData and later switch to a different file called myNewData clicking Restore will replace myNewData with the backup you made of myData Care should be taken when using the Backup and Restore buttons to avoid data loss To load an existing data file double click the Current File box or click the Find binoculars button to search for a file Find Print Preview screen without wasting paper For complete control of all printing options start your printing jobs from Most forms in CleverCat have a Print Preview button This allows you to view the printed page on the Print the Printing Menu The Importing Data Form Importing data using the Data Mapping function is optional It is much easier to simply Copy and Paste data from a spreadsheet directly into the Data Window on the Data View form However if you intend to edit your spreadsheet and use that to update the database creating a Data Map will save some time later On the Import File Selection form select the file that you want to import by clicking the Find button CleverCat keeps a record of each file that you import so that you do not have to re select the importing options each use the spre
33. ations can For example network folder is a valid entry for the Image Folder Category Banner Most users will print their company logo or banner at the top of the page but each category can have its own logo or banner This image file can be in a different folder than the categories photos Double click the box to search for a file If you enter a filename without a folder prefix CleverCat assumes the file is in the Image Folder for the category WaterMark Each category can have also have a Watermark Image This image prints the full width and height of the page behind the text and product images The watermark will be visible behind the text but not behind the product images even if their background is white CleverCat does not support transparent photos While the Image Folder Banner and Watermark can be unique to every category for many users they will be the same In this case make these selections in the current category and then use the copy buttons beside the fields to copy the same selection to the remaining categories Starting Page Number T O C Order If you need to reprint an individual category in the middle of your catalog change the page numbers so that they continue from the previous category instead of restarting at page one This value is also the T O C Table of Contents order and determines the printing order of categories It can also be changed on the Printing Menu Active Category Option You may crea
34. be created when these two T Shirts Ultimate Cotton Long Sleev columns are imported as the Print Order and Sort Order H i selections ele le li w la holm If the Print Order selection is left blank CleverCat will create its own Print and SubOrder numbers Photo Field Selections Images are not stored in the database Instead only the filename is recorded in Photo 1 and Photo 2 and this is used at print time to link to the file The complete path Drive Folder and Filename can be recorded but the best method is to record just the filename For example if your file is C myPhotos Photo1 jog your spreadsheet should just contain Photo1 jog On the Data forms specify the folder where files are stored For users who have not yet created their images here is a recommended shortcut Using Excel create a formula that will use unique data to automatically create filenames G2 fe CONCATENATE F2 jpg In this screenshot the field G2 contains the D E FE EE formula CONCATENATE F2 jpg and 14 Category Product SKU Formula the result combines the contents of F2 with 2 T Shirts Beefy T T Shirt Short Sleeves 516971 516971 ipg the text jpg Using Excel s AutoFill 3 T Shirts Beefy T T Shirt Short Sleeves 516972 516972 jpg DEUD ota ane OPY te ional coy re as g P the entire column This has the effect of 4 T Shits Beety T T Shirt Short Sleeves 516973 516973 jpg crea
35. ble clicking the Category Name in the Category Window On site Custom Software dial caaaaaae Watch the On line Tutorials Creative Database Sofutions J Double click ta browse Unique Name Baseball Gloves Image Folder PO Printed Name Baseball Gloves Category Banner PO Option Text Page Prefix Category Footer 123 AnyStreet My Town AZ 12345 800 555 1234 w Template Index Page w Active Category Start Page Numbering at Grouping Field Column 1 Couma 11 OOOO O Column 2 Columat2 O HMA Template Sounn e omae o CleverCat can print a second set of HTML files which are linked to the Column 7 eo Column 17 See first set through the primary photo For example your first template Column sd Column 18 ss could contain just a photo thumbnail and brief description When a Column 9 Column 19 si viewer clicks the photo a second HTML file containing more product Column 10 tn 200 o O detail would be displayed The first set of HTML files are given the name of the category and the second set are given the name you Copy From Baseball Gloves specify here Headers All Settings o This Category cr a g EXIT ii 4 All Categories Copy AY keil Find Print j Creating a New Category Create a new category by clicking the New button and entering a unique name The Printed Name or Category Label does not have to be unique This is useful if you need to organize large numbers of records i
36. bsite Watermark 14 Checking ne Size a Images Starting Page Number 14 Active Category Option 14 Inline Frames Price Markup Discount 14 HTML Options i Selecting a Printing Template 15 PHP Options 33 Column Header Labels 15 PayPal Cart Integration 34 Copying Categories 15 Google Checkout Cart Integration 34 Inventory Grouping Field 15 Shopping Cart Configuration 36 HTML Templates 16 HTML Tags 36 Linked Templates 16 Troubleshooting and Support 37 The Template Menu 17 Importing and Exporting Templates 17 Concepts Page Layout vs Database Driven software Page Layout software gives the user full control over every element on the page Individual graphics text borders fonts and colors can all be placed and adjusted independently Page Layout software is the better choice when the emphasis is on creating artistic pages Database driven products are the better choice when the emphasis is on ease of use or when there are a large number of products to be displayed or frequent changes are required to the product line Database software typically uses a limited range of predefined templates or fields The most obvious advantage of Database driven software is its ability to quickly insert a new product into the middle of a category by inserting a new record where needed To do the same using the Page Layout approach might require re sizing other elements on the page to accommodate the new product or even moving products from one page to the next In
37. d as 4 x 4 1 as the Display Units are arranged ina 4x4 grid 1 indicates that this template has a single larger display unit Some Feature and Summary templates do not have a larger Display Unit it is the same size as the standard Units although it can still be modified independently For convenience Summary Templates use the same Layout number selection system but the number of Display Units does not equal the number of products on a page Because the products repeat in the Summary Unit the number of products is one less than the number of Display Units Fields Grow and Shrink This option is discussed in greater detail at the end of this chapter Briefly text fields can grow to accommodate variable text This option is normally used only with Dynamic templates but can also be used on Grid templates Set this option so that No Fields All Fields or only the Detail Table and Notes Field grow There are 20 data fields available plus one Notes field All fields can record an unlimited amount of text in the database but if you have only one field which contains long text strings it is usually better to put it in the Notes field because of the extra flexibility with the Fields Grow and Shrink option Height Adjust This option is used for fine tuning the height of the Display Units If there is a gap between the bottom of the Display Units and the Page Footer you can increase the height of each Display Unit by a few pixels to
38. der both a Company Banner and a Category Banner selected on the Category Editor form can be printed If your Header option does not include a Category Banner and if the Header Spacer height is greater than zero then you have the option to use the Category Banner in place of a colored separator If you need to increase the space between your catalog data and the Header or Footer set the Header or Footer spacer value to greater than zero and change the color to white Display Units In this section choose either a Grid Dynamic Feature or Summary template style Dynamic Templates are organized into columns and the number of Product Display Units that fit on a page will vary according to the data The other template styles have pre defined number of Units Display Option 1 Static Grid Pattern If you are just experimenting with Template Design start with a Grid Template These are easier to design because Display Columns X Rows you layout the fields exactly as you would have them print Dynamic Templates are a little more difficult to design Layout Down then Across because you place fields by the minimum size you want them to print and expect them to grow to accommodate the Fields Grow and data Shrink The option you choose for your catalog depends on your data Grid and Feature Templates are better suited to artistic catalogs because you have greater control over the placement of elements on the page Dynamic Templates are bette
39. der a single photo In your spreadsheet there may be several columns with data which groups together related items Related items typically share a common photo so this is often a good choice for the grouping field In this example Column D in the spreadsheet snippet contains the product description which is common to the three available sizes Your own spreadsheet may have no data suitable for grouping related items In this case you would leave the Print Sort Category Product Inventory Group field blank and create your own Printing 1 1 T Shirts Beefy T T Shirt Short Sleeves and Sorting numbers see Sorting and Grouping on Page 4 T Shirts Beefy T T Shirt Short Sleeves 10 or Inventory Grouping Field on page 15 for more Poa Ber i a ea O Maon T shirts Tagless T shirt Shot Sleeves In this example there is a Print and a Sort column in the T Shirts Tagless T Shir Short Sleeves spreadsheet The data is organized in four groups of three T Shirts Tagless T Shirt Short Sleeves related products A Print column has been created T Shirts Ultimate Cotton Pocket T Shit UMbering each group with the same number A Sort column has also been added numbering each product sequentially within the groups T Shirts Ultimate Cotton Pocket T Shirt T Shirts Ultimate Cotton Pocket T Shirt T Shirts Ultimate Cotton Long Sleev By creating a numbering system as shown in this example T Shirts Ultimate Cotton Long Sleev the Detail Table structure will
40. designs the only difference is the heights of the Notes and Cost Fields However the bottom of the Cost Field has not changed so the minimum height reserved for the Display Unit has not changed either The Notes Field grows the same amount in either design so there is no difference in the printed output In the third example the Cost Field is in the same position but there is a space between the Cost and Notes Fields In the printed output this space is retained and the Cost is printed lower increasing the height of the Display Unit In the first group of three examples we referred only to the separation between the Cost and Notes Fields However the separation rule actually applies between every field and every other field Those designs have a minimum separation between the Product Field and the Cost Field but because the Notes Field always grew between them that minimum separation was not noticeable Beefy T T Shirt Short Shirt Short Sleeves Bey eS Ultra soft cotton els ott cotton Eels great Shoulder to shoulderto Beefy T T Shirt Short Sleeves Ultra sof cotton fels great Shoulder to shoulder tape makesit jlertape makes it longtasting Full cut for pating Full cut for a roomy fit 100 cotton fy fit 100 cotton 5159917 shoulder tape makes longtasting Fullt eo a roomy fit 100 cotton In the first example in this group we ve allowed the Cost Field to overlap the Notes Field When two fields ov
41. e field and dragging the border to the desired size Fields are allowed to overlap but this may make it difficult to select the correct cell Optionally enter the field dimensions manually This is useful if you are trying to align fields exactly When you click a field in the Display Unit or its empty placeholder in the Stack its name appears in the Active Cell box Enter its relative dimensions and position in the four boxes Left Top Width and Height When a field is Active you can also use the Left Right Up and Down keys on your keyboard to reposition the field Active Cell Positions and dimensions are recorded in percentages relative to the Display Unit not 7 petir the page The shape of the Design Pad will closely match the shape of the Display Units Depending on the template style and the shape of the Display Units the Design Pad may be quite short or narrow To make it easier to use the Design Pad you might want to select a different template style or change the number of columns while designing and then change back to the correct selection for printing In the screenshots above Photo1 is the Active Cell and its Left position is 0 the left edge of the Design Pad its top edge starts at a point 8 down the height of the Display Unit and its Width and Height are 54 and 56 of the width and height of the Design Pad Display Units have their own margins Increase the Vertical and Horizontal Margin setti
42. e used but instead of filling the entire Design Pad the fields are compressed near the top As well some of the fields are much shorter than the expected height of the text This is because we expect the fields to grow to fit the text When a field grows the fields below it are pushed down as depicted in the Print Preview screenshot below The Product field has grown and pushed down the Photo and all the other fields as well The SKU Label and the SKU Field have grown and pushed down the Notes Field On the design form the Notes field starts about 25 of the way down the Photo but on the Print Preview it is closer to about 40 On site Custom Software eer ett Another way of looking at Dynamic Template design is eee Eck that you are setting the Minimum height of the Display Unit Fields will shrink to nothing if there is no data in them but Beefy T T Shirt Short Sleeves The Display Unit will not shrink to nothing A minimum P SKU height enough to fit all the placed fields is reserved for the 516971 Display Unit In this example the bottom of the Detail Table Ultra soft cotton feels great sets the minimum reserved height If there were no data in the Detail Table and the Product field was empty the Display Unit would not grow but would also not shrink to shorter than the reserved space So when Product SKU Size Price printed there would be a thin blank white space above and Bes T T Shit Short Sleeves 516971
43. easiest method is to simply copy groups or individual columns Click the Column Header s in Excel and press Ctrl C to copy to the clipboard Then in CleverCat click the corresponding Column Header s and press Ctrl V to paste the data If you are working with a blank category this will create a number of rows in the database equal to the number of rows in the spreadsheet In the screenshot above there is an Active Column as well as Print and Sub Order Columns These columns are non movable so if you want to copy an entire spreadsheet in one step they must also exist as the first three columns in your spreadsheet because this method requires that all columns be in the same order in both the spreadsheet and database You don t have to enter data in these columns they can be left blank To copy an entire Worksheet do the following In Excel click the Sheet Selector the box to the left of column A and above row 1 and press Ctrl C to copy the entire sheet to the clipboard In CleverCat s Data Window click an empty row and Press Ctrl V to paste the entire sheet This will create a number of rows in the database equal to the number of selected rows in the spreadsheet The same method can be used to paste individual rows or groups of rows Data can only be pasted into an existing category so you would not require a category column in your spreadsheet when using this method If you are copying by rows you can paste the records directly i
44. ection boxes Each of the standard data fields can hold an unlimited number of characters so Notes does not offer any advantage over the other fields that way However there is an additional print formatting option available for the Notes field so If you have only a single field which contains long text strings enter that column as the Notes selection A column can be selected more than once For example the column selected as the category could also be selected as one of the data fields so that the category name can be printed in the Product Display Unit Importing Options When importing a spreadsheet for the first time choose All Import Option All Records Records Unique Records Only is used to update existing oeiee nie data in the database After all the field selections have been made click the Add New Data button to begin the import When you return to the Main Menu the Categories List will show any newly created categories as well as a count of the number of records in that category Updating Returning to the Inventory Index selection this is not required but may be useful if you intend to use Excel to maintain your catalog data To do this CleverCat needs to be able to match rows in the spreadsheet with records in the database and an Inventory Index is a simple way to do this This field would typically be a unique number and Excel s AutoFill function can be used to quickly add a sequentially numbered column to
45. er known as a Non Breaking Space which can be added at the end of a field SKU Size 514221 small 514222 Medium 514223 Large pring Collection Ultimate Cotton Pocket T Shirt The Non Breaking Space cannot be seen when printed so it can be used to increase vertical spacing There are other useful special characters that can he ics be added this way For example the Copyright symbol can be inserted 907501 using Alt 0169 and the Registered symbol using Alt 0174 Special characters such as this can be inserted into most Windows applications and there are different ways to do this Some Windows users will be able to insert a Non Breaking Space by pressing the key combination Ctrl Alt Space This varies between versions of Windows and other settings so if it does not work for you there is another method Press and hold down the Alt key and then enter the numbers 0160 This must be done using the Numeric Keypad not the numbers in the row at the top of your keyboard Ad Text When you print a Dynamic Template CleverCat me Pocket sku Size Price attempts to fit as many Display Units on a page as it iii n ane EKU 1697 Medium 8 can without breaking them up This means that there ohne 546973 Lage 8 40 will frequently be space at the bottom of a column too small for the following Display Unit to fill The best way to correct this is to reorganize your products so that those with larger or smaller
46. erent labels If the same labels are required for all categories change them for one category and use the Copy buttons to apply those changes across all categories Copying Categories If you are adding categories manually you may find it easier to customize one category select folders headers etc and then copy that category The Copy button will create a copy of the current category with all its settings and prompt you for a unique name Inventory Grouping Field The Inventory Grouping Field is optional but very useful for certain types of data If you made an Inventory Group selection when you imported your spreadsheet that column was imported into the Inventory Group column and can be seen in the Data Window on the Data View or Inventory form In this screenshot the Description column from the spreadsheet was selected as the Inventory Group during the import This results in a duplicate column which you would normally re order to the far right of the Data Window or hide by dragging its width to zero If the Inventory Group selection was left empty on the Data Mapping form then this column would be empty as well __ order order Description Product Code E 1 1 Long Sleeve T Shirt Long Sleeve T Shirt Long jpq 516791 Small 1 2 Long Sleeve T Shirt Long Sleeve T Shirt Long jpg 516792 Medium 1 3 Long Sleeve T Shirt Long Sleeve T Shirt Long jpq 516793 Large 2 1 Ultimate Cotton Pocket T Shirt Ultimate Catton Pocket T Shirt Ultimate
47. erlap vertically the separation rule between them is cancelled The Notes Field still grows but does not affect the Cost Field and now the separation between the Product and Cost Fields can be seen The Cost Field appears to move up slightly but is in exactly the same place it would be if there were no data in the Notes field In the second example in this group we ve allowed the Notes and Cost Fields to touch The separation rule still applies except that the separation distance is zero In the last example in this group we ve allowed fields to overlap horizontally This has no effect on separation The separation and cancellation rules apply only to vertically overlapping fields 23 The vertical separation rule applies even Beefy T T Ultra sott if fields are not aligned vertically In this Shirt Short Mtton feels example the separation between Notes Sleeves SASAE Description i and Description stays the same as makes it long Notes grows lasting Full cut for a There is a minimum separation between Product and Color in this design oo 100 ca a comy fit 100 but it is forced to be greater than that minimum by the growth of Notes Cost niteq and Color overlap vertically so there is no separation rule between them If some of your fields will contain no data then you need to consider how this will affect the separations For example using the same design if the Product Cost and Notes Fields are empty as sh
48. es memory The number of passes is multiplied by the number of Display Units in a Feature or Summary template In the worst case scenario where the template has many Display Units and Detail Tables the system could run out of memory in fewer than 100 Print Previews If you are fine tuning a template and repeatedly looking at Print Previews avoid memory problems by removing the Detail Table from the template design until needed Grid and Dynamic templates use the memory in a different way are unlikely to experience memory errors in fewer than 1 000 previews Feature and Dynamic templates which do not have Detail Tables are unlikely to encounter memory problems over many hundreds of previews Please send your questions or comments to support clevercatalogs com 37
49. es the navigation within a category but your Index Page should include the navigation instructions for the categories Also on the sample page you will see a series of similar list tags for category navigation lt li gt lt a href WebSample21 htm target catContent gt lt span gt Sample 2 lt span gt lt a gt lt li gt Your own category naviation may differ considerably but the important part of this instructions is that the link to WebSample21 htm created by the a href statement points to a target of catContent This is the name of the inline frame created by the earlier iframe statement In this way each link updates the Inline Frame to display the first page of the selected category There are three options for the HTML pages inside the iFrame and any or all of them can be used These print at the top of the page within the frame in the left center or right positions as displayed on this form Remove HTML Tags HTML tags can be included in your product descriptions when you create HTML pages Normally you would not want these to appear in your printed catalog so the default setting is to Remove Tags from printed pages Single CSS File CleverCat creates the CSS files for formatting text in the catalog content and for some users every category may require different formatting CleverCat will create a separate CSS file for each category or if all your categories use the same formatting choose this option t
50. f you are sending a template file to support clevercatalogs com you do not have to zip it or rename it mdb and mdt files are frequently blocked by mail servers because they might contain viruses As we frequently receive these files our mail server does not block them However when we return a file to you unless you indicate otherwise we will normally zip it to get through your mail server We also recommend www DropBox com for an easy method of sharing files 17 The Page Setup Form On site Custom Sofware Lal Watch the On line Tutorials Creative Database Solutions Gloves Page Header Footer Display Units Formatting Hep Custom Tyr L e Euotom Soitvere iA Category Optional Text Footer Paper Size Letter Top 0 35 Bottom 0 35 Right 0 35 Outside Working Category A Baseball Gloves vi Show data from this category The Page Setup form is where you make selections common to every page of a category These selections are grouped onto the four tabs Page Header Footer Display Units and Formatting The right side of the form displays an Example Page which shows a generalized view of the printed page Click the Print Preview button to see exactly what the printed page will look like Working Category For some users the labels used to identify the fields vary between categories so select a Working Category to provide the expected labels The Show Data from
51. ferent photo PDF file or other valid HTML There are a few rules that will be observed By default if you enter the name of a photo the link is created to point to the default image folder as specified by the Image Folder setting page 32 The default for any other filename is for the link to point to the file in the same folder as its parent HTML file If you want the link to point to a different folder you need to include that as part of the text For example consider the website myDomain com with catalog files stored in a folder named myCatalog In this case the first page of the catalog might be found at myDomain com myCatalog myProducts1 htm The image files on this server are stored in the folder myDomain com myCatalog myPhotos The following table describes where the files for different links must be located Not valid in this example but multiple can be used http must be used to point to a different website myDomain com myCatalog myPhotos photo1 jpg You can create your own links in any text field For example to create a text field containing a link in the middle of a sentence such as Click Here for today s specials your text field would contain Click lt a href mySpecials pdf gt lt B gt Here lt B gt lt a gt for today s specials On the Data View form there is another column used for HTML files Title Text If you want some descriptive text to be displayed when the user
52. gories Category Label Image Folder Pages ltem Template l c Cordless Phones Cordless Phones C Program Files CleverCat Photos ee Static Sample 1 Ww Phones Phones C Program Files CleverCat Photos 63 16 Dynamic Sample 2 w E Portable DVD Portable DVD C Program Files CleverCat Photos 2 10 Dynamic Sample 1 a oo To create a new category scroll to the bottom of the list of categories in the Category Window Simply type the name of your new category in the blank row at the bottom of the list and press the Enter key The Image Folder field is automatically filled in with the default folder Change this to match the location where you store your photos The Image Folder value is combined with the Photo Name value to define the full path and name of the image file For example if the photo is C myCatalog myPhotos Photo1 jog it can be recorded several ways Normally you would record C myCatalog myPhotos in the Image Folder field and Photo1 jog as the filename but you could also record C myCatalog in the Image Folder field and myPhotos Photo1 jpog as the filename Each category can have a separate Image Folder This is useful if you have a very large number of items and need to organize the photos into more manageable numbers Active Print 7 Sub I Change a Column Hame order order Photo Product Code Size Color_ Cost Price Notes T 1 7 are Beefy T T Shit short Sleeves 516977 Small Small
53. h other borders These imperfections can change at different zoom levels but they only appear in Print Previews When printed on paper or to a PDF the borders will print correctly Index Sorting Field The Index Sorting option only shows up when you select Index Page on the Templates Menu By default an Index Page will be sorted alphabetically by the first Data field even if this field is not included in the Template Design You can choose to sort your Index Page by another field or even by Page Number 20 Designing a Grid Feature or Summary Display Unit From the Page Setup form open the Display Unit Design form by clicking the Display Unit button or double clicking any of the Photot SKI Display Units on the Example Page Double click the Feature or Summary Unit on the Example Page to open the design form for the Feature or Summary Unit The Display Unit design form is where you select and place the fields you want to print In the lower left corner of the form is the Stack of available fields organized into two columns of labels and fields Labels as well as fields can be placed in the Display Unit Each Label Field pair is identified by the Header Name you gave them on the Category Editor or Inventory form Field Placement Detail Table Simply drag and drop fields or labels from the stack and place them on the Design Pad Change the width or height of a field by moving your mouse cursor to the edge of th
54. il Tables the labels on this form are also used as the Column Headers TIP If you are using CleverCat to design an online template it is not necessary to have any data in the local database other than the category name However as the online templates closely match the printed templates it will be easier to design a template if you enter at least one item s descriptions Navigation Links This field sets the number of Navigation links to be shown at the top of the Inline Frame The number of links you set will be bracketed by the First Previous Next and Last links For example if you select a value of 5 your in frame navigation could look like this First Previous 21 22 23 24 25 Next Last PayPal CleverCat can automatically integrate the PayPal shopping cart code into your HTML or PHP files for an instant online store You will find the values you need to set on this tab in your PayPal Merchant Profile Google Checkout At the time of this writing Google Checkout integration has not been completed IMPORTANT Never give your account passwords to anyone If you require technical support from us we do not need your passwords and will never ask for them We may ask you to send copies of the HIML or PHP files for troubleshooting but these do not contain passwords Cart Configuration To integrate either a PayPal or Google cart check the Enable Shopping Cart option The shopping cart can use either an Add to Cart bu
55. inforced collar resists raveling and rig out Tag fes collar 100 cotton shoulder tape makes it long lasting SKU 516971 516971 516971 Tagless T Shirt Short Sleeves aii ay Ea Overlapping Order With Dynamic Templates it is possible to have very long Detail Tables which span several columns or even several pages If Data Breaks is not selected CleverCat will attempt to both start and finish printing a product within a single column With some data this can result in large blank spaces at the bottom of a column Data Breaks Across Columns will allow the Detail Table of a Display Unit to be broken and continue printing on the next column if it cannot fit in the previous one In this example the last row of a Detail Table was not able to print in the first column and has been printed at the top of the second column without the photo or other descriptions The first Data Field Ultimate Cotton Pocket is repeated as well as the Detail Table Column Headers This option only works if the Detail Table is the bottom most element in the Template Design If another field is placed below the Detail Table spacing errors could result Field 19 Phota Photo Detail Table Field 1 Field 2 zi Field3 Field 7 Fredy C Field 4 Field amp Field 10 Field 5 There is a defined layering order for Fields and Photos as sh
56. iption field and the field submitted to the cart will be the same 34 The Primary Description Field selection is submitted to the cart as the Description and the Secondary Description Field is the Option In a PayPal Shopping Cart the field label column header is not shown for the Primary Field but the label of the Secondary field is included with the field data In this screenshot of a PayPal cart two data fields have been selected The Primary Description appears under the heading Description This is part of the cart and will always read Description regardless of the field label The Field Label for the Secondary Field is Part and is included with a colon before the actual data Shipping Options These selections are optional and compatible with PayPal s shipping features Use recorded shipping prices or use the values set in your Merchant Profile To use values recorded in your database make a Shipping Price Field selection This will submit the amount in that field to the cart as the shipping fee You have the option of charging reduced amounts for multiple quantities of the same item If every item purchased is subject to the same fee enter 100 in the percentage box If additional quantities of the same item are shipped for free enter 0 For a discounted fee enter the percentage of the fee for the first item For example entering 10 in the percentage box will add the full shipping amount to the first
57. item and 10 of that amount to multiple quantities of the same item 35 HTML Tags lt is possible to include HTML tags in the catalog text This would be useful if you wanted to create a page link from within the text or change an attribute of a specific word However you would probably not want these links to be printed on your paper or PDF catalogs If the Remove HTML Tags option is selected CleverCat will examine all the text at print time and not print anything found between the lt and gt characters You should be able to insert almost any valid HTML formatting tag into your text CleverCat automatically adds a few of its own If your text contains Carriage Returns where you have pressed the enter key to force the text to continue on the next line CleverCat will add a Break lt BR gt tag Without lt BR gt tags your text would wrap within the cell Printed templates can have two photos HTML templates cannot display two photos but the second Photo field can be used to create a link from the first photo As described in the HTML Templates section page 16 CleverCat can automatically create links between two sets of related HTML files If this option is not selected CleverCat automatically creates a link which will display the product photo at its native size Over ride this default behaviour by entering your own link in the second Photo field This can be a link to another website another HTML page a dif
58. m it will link to and open the corresponding Detail n htm file The number of Detail n htm files created is equal to the number of items in all the T shirts n htm files If there are three T shirts n htm files with four products on each page then there will be twelve Detail n Atm files See the chapter HTML Configuration for more information on HTML options 16 The Template Editor CleverCat can create and store an unlimited number of Printing Templates Click the Template Designer button on the Main Menu to begin There are two groups of Templates Click either Sample Templates or My Templates to view these groups Templates that you create or copy are placed in the My Templates group Additionally when you make a template selection on the data forms the selection lists contains only sample templates if the My Templates group is blank Once you have added a template to the My Templates group only this group will be displayed in the Template Selection drop down boxes The Sample Templates will still be available though Simply make a copy of the one you need and it will be placed on the My Templates list Most users will find that they will need to create only one or two templates In this case the name really doesnt matter Depending on your data you may find that you need to create a separate template for each category In this case you may find it easier to name each template for the categor
59. ngle category amp Print BBA ibe 1 9 Print Print Print all selected categories using Book 7 3 3 Press the Escape Esc key to the options set below DORS close the preview Cookware 8 2 4 HVAC 29 2 5 Compact Saws 44 9 G F Print all selected categories as a single category using the same template Towels 22 2 7 FF Baseball Gloves 19 2 8 d Table f Cont ie i ge P Print Baseball2 en i oii S a Books2 31 3 10 p l screenshots 10 2 11 d Printing Options Page Numbering Option Date or Optional Footer Text AutoNumber Starting from Page 1 SubCategory vi Number Categories Using TOC Number Rebuild T 0 C Index After Printing Currency Symbol cy gt Y Duplex Printing Yes No Al Lo Select individual or multiple categories to Print or Preview using the Category Selection list Sort the list alphabetically or by T O C Table of Contents using the Arrow Buttons above those columns When you click the Preview button only the first selected category in the list will be shown When you click the Print button all selected categories will be printed Categories are printed in the order indicated by the T O C number This number does not have to be an accurate indicator of the starting page of a category but it should be unique If you are printing multiple categories using the Compact option and they have the same T O C number the data could be mixed together The Compact option combines all catego
60. ngs to create more room between Display Units The Grid value can be set from 1 to 10 and changes how fields are placed and sized by dragging A Grid value of 1 allows values of half of one percent 9 5 10 0 10 5 11 0 etc A Grid value of 2 allows full percentage values 9 10 11 etc Larger Grid values will make it easier to line up fields but make it harder to fine tune placement of fields Using the Arrow Keys on your keyboard to reposition the cell will move it in the selected direction in steps set by the Grid value If you decide that you do not want one of the fields that you have placed click it again to make it the Active Cell and click the Return to Stack button or just press the Delete key on your keyboard Font sizes displayed on this form do not exactly represent how they will be displayed on the actual printed page Use the Print Preview button to see how your customizations will print 21 Designing a Dynamic Display Unit Detail Table Designing a Dynamic Display Unit uses all the same steps as an designing a Grid Unit However the Display Unit shown on the form does not represent the proportions of the printed Display Unit Instead the height of the Display Unit on the form represents half the printed page height and its width on the form represents the width of the printed Display Column If you compare this Display Unit with the one on the previous page you will see that the same fields ar
61. nto smaller more manageable numbers but still want to print the same category name at the top of the pages As well certain special characters in the Category Label that cannot be used in the name For example you can use the Backslash symbol in the Category Label but not in the Unique Name Category Group Currently the Category Group only allows you to organize categories for easier printing In future versions of the software its function may be expanded Select a group from the list or enter a new one If you enter a new group that selection is automatically added to the list so that you can select it for another category If you delete this group from every category it will be removed from the list Option Text The Option Text is one of three text fields which print in the Page Footer and prints on the opposite side of the page from the Page Number Commonly this field might be used to record the printing date Enter any text in this field or select one of the pre defined options If you select one of the date options the current date will be printed using the formats defined for your computer s Regional Settings on the Windows Control Panel The Option Text can also be entered on the Printing Menu If entered there it will override the text entered on the Category Editor Option Text on the Printing Menu applies to all categories so use this field only if you need different text for every category 13 Page Prefix The Page
62. nto their correct category If you are copying by columns or an entire spreadsheet you ll end up with all the records in a single category This is still usually the easiest method because the Move or Copy buttons at the bottom of the form can be used to put the data into the correct categories Optionally you can also just select rows and Cut and Paste them into the correct category using Ctrl X and Ctrl V There are two ways to select blocks of cells in the Data Window If you are using your mouse select the Starting cell and then press and hold down your Shift key While holding down the Shift key use your mouse to select the opposite corner of the block of cells To select a block of cells using the keyboard move your cursor to the starting cell and press the F2 key This will highlight all the text in the cell Now hold down the Shift key and use the Up Down Left or Right Arrow Keys to select a block of cells The F2 key can be used anywhere in CleverCat to select an entire cell or data field Deleting Data To delete rows click the Record Selector gt for one or more rows or for one or more categories and press the Delete key You will be asked to confirm this action Warning There is no recovery from an accidental deletion Make backups of your data frequenily If you delete a category in the Category Window all the records in that category as well as the category settings templates headers etc will also be deleted If you
63. o create only a single common file PHP CleverCat can also produce PHP files for Dynamic catalogs To use this feature you will store your data in a mySQL database on a webserver The first four fields in the column on the left side of the PHP tab are used to create the database connection string The setting for Database Host will normally be localhost because the PHP files will be stored on the same server as the mySQL database Database Name User and Password will be values you set when you create the mySQL database For some servers you need to prefix these settings with another string which identifies the hosted domain For example for a database named myDatabase some users will have to enter myDomain_myDatabase while others will only have to enter myDatabase The same may be true for the Database User setting You may have to contact your website host for assistance with the connection parameters Most webhosts provide a utility for creating and managing mySQL databases and this is utility is commonly phpMyAdmin The remaining fields in the left column can be found on the phpMyAdmin screens mySQL Table is the name of the table your data is stored in and mySQL Category is the name of the field in the table which holds the name of the category mySQL Photo is of course the name of the field recording the photo name and mySQL Link is an optional field which can be used to record a different link to be viewed when the pho
64. o see the results However in addition to those described above there are a few rules that fields will observe for growing and shrinking 22 Field Growing and Shrinking Rules On the Page Setup form there is an option labelled Fields Grow and Shrink Your options are All fields Grow and Shrink No fields Grow or Shrink and Only the Detail Table and the Notes Field Grow or Shrink to fit the number of rows or lines of text If you select No fields Grow or Shrink then you could design a Dynamic Display Unit much the same way you would a Grid Display Unit by placing and sizing fields exactly as you want them to print In fact the Grow and Shrink option can be used on Grid Templates as well but because the Display Unit will not grow you have to consider how much your data will cause other fields to move around or you could cut off some of the text These examples with borders around the cells and the Display Unit make it clear how fields are adjusted Photo Fhoto Notes Photo Shirt Short Sleeves Sleeves ick Ultra soit cotton feels Ultra soit cotton fele arr as great Shoulder to great Shoulder to a shoulder tape makes it shoulder tape makes it longtasting Full cut for longtiasting Full cut for a roomy fit 100 cotton a roomy fit 100 cotton Beefy T T Shirt Short Beefy T T Shirt Short der tape makes it lasting Full cut for my ft 100 cotton In the first two
65. olumn which groups rows into related products and print a different template with the photo of the first product in the group along with a Detail Table of the related rows 15 HTML Templates CleverCat Professional Edition can also produce HIML files These HTML files are designed to be displayed in an Inline Frame on your website and can closely resemble printed templates You can use any of your printing templates or create and select different templates specifically for HTML There are some features in a printed template which will not work in HTML For example fields can overlap in a printed template but not in HTML and only one photo can be used in an HTML template For these reasons you may want to make a copy of your printed template and make adjustments for HTML In a printed template you would normally place the fields close together to conserve space and use less paper In an HTML template you would normally leave a little room between cells to ensure they are aligned correctly Field positions and dimensions in a printed template are set in percentage values relative to the size of the Display Unit These values can be fractions of a percent For example the width of the photo in the template design below may be set at 40 5 of the width of the Display Unit When printed as HTML all numbers are rounded to the nearest 5 Photo1 Easton BMX Glove Closed back with adjustable quick binding strap for a snug fit and ea
66. os at the outside edge of the page if desired 29 Optional Text The Option Text is one of three text fields which print in the Page Footer and it prints on the opposite side of the page from the Page Number Commonly this field might be used to record the printing date You can enter any text in this field or select one of the pre defined options If you select one of the date options the current date will be printed using the formats defined for your computer s Regional Settings on the Control Panel The Option Text can also be entered on the Category Editor form However Option Text entered on the Printing Menu overrides the text entered on the Category Editor Also text entered here applies to every category Currency Symbol lf this field is left blank then your computer s Regional Settings will be used be used to determine the currency symbol If you need to print a catalog for a different market change this symbol as required Trailing spaces are always automatically deleted in a database so if you need to insert a space between the currency symbol and the number you will need to use a Non Breaking space Special characters such as this can be inserted into most Windows applications and there are different ways to do this Some Windows users will be able to insert a Non Breaking Space by pressing the key combination Ctrl Alt Space This varies with versions of Windows and other settings so if it does not work for you there is ano
67. own below there would be a number of blanks spaces as all the Fulkcut ra various separation rules are applied roomy fit 100 Creating a better design may take some experimenting Start by decreasing the cotton heights of the field that you know will occasionally be empty Consider this design Although it cannot be seen the Cost Field is still placed between the Product and Description Fields The height has been reduced in the design to just 0 3 Beefy T T ultra soft The Notes Field overlaps the Product Cost Beefy T T Ultra sot Shirt Short cotton feels and Description Fields cancelling the Shirt Short etton feels Sjaeyes 9 at Shoulder separation rule between them and the Notes Sleeves __ Sal Shoulder to shouldertap Field If the Cost Field has a value it grows to lF iaro akira makes it long a oe cae makes it long lasting fit If it is blank it disappears and leaves only roomy ft 100 lasting the small reserved space between Product and cotton White Description The separation rule is still in place for the Color Field and the fields above it so if the Notes field were blank it would still start a little below the Cost Field ad ie Empty fields can affect the minimum Beefy_T T Ultra of height of the Display Unit itself In this Bira Short cotton feels Color example the Size Field is blank but a a great Shoulder p Sleeves e oaidert Gire space
68. own here In General Photo 1 prints behind everything else The exceptions are Fields 19 and 20 There is nothing special about these fields except that as the last two fields they are less likely to contain data These fields can be used to create special borders behind the photos or other fields For example Field 20 could be given a background color and Field 19 could be placed on top of it with a white background The effect depending on the size of Field 19 would be of a wide colored border Any field or photo that you wanted to highlight could then be placed on top of Field 19 In this example Field 20 has a blue background and another text field has been placed on top of it with an off white background pure white actually prints as transparent Fields 19 and 20 are also excluded from the standard Shrinking rule when they are empty Normally a field that contains no data will disappear Fields 19 and 20 can therefore be used to increase the minimum size of a Dynamic Template s Display Unit and keep it from shrinking if its fields contain little or no data In this way a Dynamic Template can be turned into the equivalent of a Grid Template 25 The Detail Table Form Depending on your data you may not need to use this form If your data requires a Detail Table drag the Detail Table field onto the Design Pad From the Display Unit form double click the Detail Table field or click the Detail Table button to continue
69. r suited to catalogs where the amount of descriptive text varies between products Dynamic Templates are usually the better option when the goal is to reduce the number of printed pages because they compact the data most efficiently Feature templates are often used as Introductory Pages with advertising or diagrams in the Feature Display Unit Summary templates repeat the same data from the smaller Display Units in a table in the larger Display Unit Typically these templates may have only the photo in the small Units and the text and prices in the Table Depending on the template style you select you may select the number of columns the number of columns and the number of rows or just the number of Display Units The Example Page will continue to update with a generalized view of the page as you make changes For Dynamic and Grid templates the Layout selection sets how the Display Units are filled Down then Across columns first or Across then Down rows first If the last Display Unit on the page is missing try changing this first as the Display Unit height calculations are slightly different for each option 19 For Feature and Summary templates you select a Layout Number and the Example Page shows you the pattern of Display Units for that Layout In this example the Feature Unit the 1 Unit is in the center of the page and there are 12 standard Display Units arranged around it The Layout Pattern for this template is describe
70. rame within the cell which contains the file WebSample11 htm and name the frame catContent Also set the maximum number of rows and columns This setting does not affect the frame itself only the files displayed in the frame So if some of your categories require three columns but others only two you would print one group of categories change the setting on this form and print the remaining categories The Resize Script is optional An iFrame can be created at a specific height and you could make this height greater than the maximum amount of data that may be displayed there Optionally use this script and the complimentary function call Function resizelframe dynamicHeight document getElementByld catContent height parselnt dynamicHeight 10 on the parent page to automatically set the iFrame to be taller than the data An iFrame can also be set to scroll The example page on CleverCatalogs com has an iFrame which does not scroll Instead the entire page scrolls Your selection depends on how you want your page to look and you may want the contents of the iFrame to scroll while the parent page remains static The default Resize Script has been tested with browsers at the time the software was released but may not be compatible with future browsers Change it here when required 32 HTML Options Navigation Options You will need to create an Index or Home page for your website or CD ROM CleverCat handl
71. ries into a single category using the Template and other settings of the first category Individual categories normally start printing on a new page but because the Compact option considers all data to be part of single category there will be no page break between them This can save a number of pages if you have many categories that would normally end on a partial page However because all data is printed as a single category it only prints using the Template of the first category It is not possible to switch Templates mid page Table of Contents and Index Page The Table of Contents and Index Page are Printing Templates just like any other The difference is that they draw data from all selected categories The Table of Contents can be printed independently of the categories It does not require that you use page numbers there and it will print the number recorded in the T O C column Change the T O C numbers manually or use the Page Up and Page Down keys to do this automatically This option only works when the list is sorted by T O C number the T O C Arrow Button above the column is depressed not when sorted alphabetically Click any name in the Category list and Press Page Up or Down to move that category through the list All T O C numbers below the new position will be updated Pages and Item Count It would be more correct to call the Item Count in the Category list a record count but for some users this will be the same thing
72. rs can be added to any cell but the color of individual Borders cannot be changed All Field Cell Borders will be the same color In CleverCat the color White is actually transparent when printed If you need to create a field with a non transparent white background use the Custom Color option to create a color just slightly off white On the Detail Table Formatting form there are some additional buttons for formatting Table Rows Click the Header or Detail buttons to see what Color Attributes can be changed For example if you click the Detail Button beside Boxes Rows the Color text will be grayed out to indicate that only a Background Shade can be set If you click the Detail Button beside Dividing Lines the Shading text will be grayed out to indicate that only a Color not a Background Shading can be selected To make long Detail Tables easier to read click the Alternating Rows Button and then select a Shading color To change the background color of the entire Detail Table you will need to change the background for Alternating Rows and also click the Detail button and change the Shading color for the other rows as well 21 Printing Most forms in CleverCat have a Print Preview button A print job can be sent to your printer from any Print Preview but for greater control of printing options start print jobs from the Printing Menu Categories f Select All Category Items Pages T 0 C Print ge Preview a si
73. s of the page and want to format their catalog so that the Page Numbers and Category Label are always on the outside unbound edge of the page The Duplex option does not instruct your printer to print on both sides of the page This is a function of your printer and must be done using your printer s own controls For some printers you may have to start your print job from a Print Preview and then click the Print command on the Menu Bar to access these controls Every printer capable of duplexing will be different so these instructions are only a guideline Some printers will have an option for increasing the page margin on one side of the page to allow more room for binding If your printer does not have this option increase the Page Margin on the Page Setup form However the content will still be centered in the page If printing double sided your first page can be on either the left or right lf your printer is not capable of double side printing print just the even or odd pages flip and sort them and then print the other side of the page The easiest way to do this may be to use a PDF writer and print the catalog as a PDF first When you later print from the PDF to your printer there will be an option in the Print Setup for printing odd or even Duplex Data When printing Grid and Dynamic templates the Duplex Data option will swap the position of the photo and fields within the Display Unit This way you could always have your product phot
74. scade through the entire group Product _jpq Product jpg lf the fourth row is the current row when the button is clicked the new row could be an additional row in the first group of products or an entirely new product group In this case CleverCat will ask you for Clarification Product jpg Product2 jpq Bi Se aei JEEE EA If the new row is a new product group the Print Order number of the fifth row will be increased to 3 and this change will cascade through the entire category TIP Double click almost any field or text box in CleverCat to view the text in a larger editing window All text fields in CleverCat can contain multiple lines of text but you will not be able to see the extra lines on the Inventory form and not on the Data View form unless you increase the height of the row Sorting and Grouping Data The Print and Sub Order columns indicate the printing order as well as the grouping of related records Where each row in the Data Window is a separate product represented by a single photo the Print Order column will be a sequential number and the SubOrder number will always be 1 Where multiple products of different sizes colors etc are represented by a single photo the Print Order number will be common to a group of records and the Sub Order number will be sequential indicating the printing order of records in a Detail Table The Print and Sub Order numbers can be changed manually as required or automatic
75. sy on and off All leather construction for durability Easton BMX Glove Closed back with adjustable quick binding strap for a snug fit and easy on and off All leather construction for durability Product Stock Price Detail Table _ S S s 2647283 In Stock 44 99 Add HTML templates only print as Grid or Dynamic styles If you select a Feature or Summary style the larger Feature Display Unit will not be created Linked Templates The purpose of the Linking Filename is easiest to understand if you consider a typical shopping site Commonly there will be a page of product thumbnails If you click any of these products you will be taken to another page with more detailed information CleverCat names the HTML pages it creates with the category name and the page number For example using a category named T Shirts CleverCat will create the files T shirts1 htm T shirts2 htm and so on until all the products are printed The number of T shirts n htm files created depends on the number of rows in the database as well as the maximum rows and columns setting set on the HTML Configuration form If for example the Linking Filename is set to Detail then a second set of HTML files will be created as well using the second HTML Template selection These files will be named Detail1 htm Detail2 htm Detail3 htm and so on When a user clicks any image in T shirts n hAt
76. t is necessary to use the First Line Repeats option so that data from the first row can be displayed in both the Display Unit and its Detail Table Your own data may be structured similarly where you need each row to be printed in the Detail Table or as shown below you may have one row at the top of each group of rows that contains all the common text Pay ey z If you select the option Detail Table has Column Order Category Product SKU size Headers your Detail Table will include a Header Row 1 T Shits Beety T T Shit 516971 Small with the Column Headers Field Labels you entered on 2 T Shirts Beefy TT Shit 516972 Medium the Category Editor or Data Forms 3 T shirts Beefy T T Shirt 5163 73 Large lf your data is structured as shown to the left where the Order Category Product SKU Chest required Column Headers are different for each group of 3 T Shits Tagless T Shit 514221 32 related items you would not select either the Column r ee a ee aay E Header or the First Line Repeats options In this case 2 T shirts Tagless T shirt 514222 34 you could create Column Headers by selecting the 3 T Shits Tagless T Shirt 514223 36 Header fields and placing them on the Display Unit By making them the same width and lining them up with the fields in the Detail Table you could achieve the same results as the automatic Column Headers on the Detail but allow the text to vary between items The Comments Field
77. ta by Photo would result in the two 2 1 Photo2 gif 7 eo Terr Ta groups shown on the left If the data was not sorted a m 2 1 Photo2 aif but only grouped by Photo the result would be the a TE Phatt pa E 2 2 Photo2gif three groups shown on the right E 3 2 Photot jpg E 2 3 Photo2gif 3 3 Photot jpg When you click the Sort button the Print and Sub Order numbers will be updated immediately and the results can be seen in the Data Window without closing the Sorting Grouping form This function works on only the current category so repeat these steps for all categories Re grouping of data is also performed automatically when a new template is selected or the template type is changed except when the Group by field is blank In addition to the Print and SubOrder number columns Page and Position numbers will be displayed if the category uses a Feature template style This type of template has a single larger Product Display Unit and the Page and Position numbers indicate the position of each Display Unit on the page gt gt In this example the Print Order column indicates that there are at least four order order Page Pos products on the page The SubOrder column shows that the first product has Ey 1 7 4 only one record but the remaining products are comprised of three related 1 E 9 P 7 3 Items E 2 The Page number shows that all three of these aug 2 3 i products will print on
78. te categories of products that you do not use frequently Instead of deleting those categories uncheck the Active Category box and the category will not show up on the Selection Lists To re activate an inactive category click the Find button on this form to select and re activate it Price Markup Discount Prices in your catalog can be easily marked up or discounted without changing the recorded data On the Printing Menu there is a Global Markup Discount box that applies to all categories but each category can have its own Markup Discount This is entered as a percentage For example if you enter a value of 20 prices will be discounted by 20 This feature is useful if you print catalogs for different customers or other currencies 14 Selecting a Printing Template The Template Selection drop down box changes according to your templates If you have not created your own templates yet the selection list will show all the Samples templates included with the software To reduce this list to a manageable level when you create your own new templates the Template Selection boxes will show only your own templates Column Header Labels lf you have not changed the Field Labels Column Headers on the Inventory or Data View form you can change them here These labels will be used later on the Template Editor to identify fields and they are also the Column Headers that will be printed at the top of a Detail Table Each category can have diff
79. te file size of your photos Large files are flagged in red or yellow but this does not mean that they will not print A few large photos in a category is okay but too many will cause problems Reduce the size of the photos or create smaller categories as required We recommend www omniformat com for a simple utility which can easily resize an entire folder of images 31 HTML Configuration Output and Image Folders The Output folder is the folder on your local hard drive where the HTML files will be created The Image folder is the name of the folder on your webserver where image files are stored When creating HTML files both these folder names are used For example on a typical webserver the HTML files might be stored in the Public folder Under this folder there is typically a subfolder for image files If this folder were named Photos you would enter just Photos without the quotation marks in the Webserver Image Folder box When your HTML files are viewed on your website the HI ML code will look for your photos in the Public Photos folder The compiled HTML files can be previewed on your local drive as webpages in your internet Browser If the Copy Images option on the HTML tab was selected the folder specified as the Image Folder will be created on your local hard drive as a subfolder of the Output folder and the previewed pages will also have the correct photos For example if your local output folder is C my
80. ther method Press and hold down the Alt key and then enter the numbers 0160 Alt 0160 This must be done using the Numeric Keypad not the numbers in a row at the top of your keyboard Markup Discount On the Category Editor form each category can have an individual Markup Discount Value This adjusts the printed prices without affecting the recorded data This is useful if you are printing catalogs for different markets The Individual option uses the Markup Discount value recorded for each category on the Category Editor form The Global option adjusts prices for all categories by the amount recorded here This is entered as a percentage For example if you enter a value of 20 prices will be discounted by 20 If you need to print a catalog without pricing select the Blank option Where prices are recorded in a Detail Table the column will still be printed although it will be blank The Hide option removes the column and adjusts the width of other columns in the table proportionally Printing to PDF It is important to note that every category is printed as a separate print job unless the Compact option is used If you are printing to a physical printer this will not be noticed If you are printing to a PDF Writer the PDF software will ask you to give each print job a file name Most PDF Writers have the option to combine these separate jobs into a single file Some PDF writers will pause after every category and you name or combine
81. ting unique filenames for each product 6 T Shits Tagless T Shirt Short Sleeves 514222 514222 jpg name them to match the products T T Shits Tagless T Shirt Short Sleeves 514223 514223 ipaq The selection Inventory Index will be discussed at the end of this chapter because it will make more sense once Importing has been explained Data Field Selections There are twenty standard fields available to import your spreadsheet columns into You do not have to make a selection for each of these fields and it does not matter in what order you select them or even if you select fields which you will not print Later during the Template Design process you will decide which of your imported fields you want to print Many users import fields which are only used for reference such as a cost field when they only ever print the retail price Beside each of the twenty field selections there is a descriptive field label These will not correspond to your own spreadsheet data so just click these labels and change them to something more suitable This is not a necessary step but should make it easier to recognize your own data If you do enter labels here they will be imported as the Field Labels which you will use to identify fields during the template design process If you do not enter them before importing they can be entered later on the Data forms There is an additional special field labelled Notes at the bottom of the third column of sel
82. tional databases comprise one image plus an unlimited number of associated sub items for every item Relational Database tem Description Price Getting Started Many of our users have created their first catalog in less than one hour When you start CleverCat the first form you see is the Main Menu and there is a button there labelled Quick Start Guide Click this button to open an online PDF document with a short tutorial designed to walk you through the basics of importing or entering data and creating a simple printing template This manual will cover all of the features of CleverCat in greater detail but the Quick Start Guide is the best place to start if this is your first time using the software The Quick Start Guide is organized to follow the steps you would take in creating a catalog This manual is intended as a detailed reference and is organized by form or subject In a spreadsheet you are probably familiar with the terms Column Row and Cell In database terminology a Field is the equivalent of a Cell and a Record is the equivalent of a Row Column is common to both spreadsheets and databases but because it is sometimes necessary to indicate which field a column comes from Column and Field are often used interchangeably throughout this manual Saving your Data Current File Double click to search for a new data file C Program Files CleverCat Data data mdb i As you work with CleverCat all your changes are
83. to is clicked If the Link field is left blank when the product image is clicked the original photo will be displayed at its native size A different photo or even a different webpage can be displayed by entering that information in a field in your database and setting that field as the mySQL Link More information on linking images is provided in the HTML Tags chapter Print Order is optional This field is not a numeric field like the Print Order for printed catalogs but sorts the data alphabetically on the selected field The Common Data field is used to create Details Tables and is equivalent to the Inventory Group Group By selection for printed Detail Tables 33 PHP Fields and Labels As with a printed catalog your online template can also up to 20 data fields Use the category selection at the top of the PHP tab to set which category is used to display the labels on this form These labels will make it easier to recognize which field is being edited For example in the local CleverCat database you may have a Description column a Part Number column and a Price column However your online mySQL database may be setup completely different and the corresponding columns may be something like Columni Column2 and Column3 The labels shown here identify the columns you used in your template design and then you enter the names of the corresponding mySQL database columns in the 20 data field selections If your online template uses Deta
84. tton or a Quantity Input field View the sample HTML pages at www clevercatalogs com websamples himl to see how these are used Select either an image file to be used as a cart button or set the maximum number of digits to be used as a quantity input field The more digits you allow the wider the input field will be The cart button or input field can only be displayed in a Detail Table If your printing template does not use a Detail Table create a second template which does and use it as the HTML template A Detail Table for the purpose of a shopping cart can be designed with only one field the price field if desired The Field Selectors on this form show the actual name of the database field data1 through data20 and for PHP users these correspond to the fields on the PHP tab The field label for the current category is also shown For most users every category will be configured the same way and the price field will always be in the same data field If your categories have differing numbers of fields remember to change these options before printing the files for each category The PayPal shopping cart allows two description fields although you only need to select one These do not have to be placed in the table or even in the template at all You can use longer descriptive fields in the template and select a different field which contains a shorter technical product description for the cart For most users though the displayed descr
85. ugh room on the page Top and Bottom Margins can be adjusted independently but Left and Right Margins Inside and Outside must be equal as the content is always centered on the page 18 Page Header and Page Footer The Page Header is the area at the top of the page where a company logo and Category Label can be displayed Use the checkbox next to the Header label to enable or disable the Header Change the height of the Header to better fit your logo or banner Your logo or banner will be automatically zoomed to fit the available Space For example if you are using a banner of 8 x 2 and set the Header height 1 then the banner will be shrunken to 4 x 1 so that it will not be distorted The controls for the Page Footer are similar to those for the Header Use the drop down boxes to select the Header or Footer Option The Example Page will display a rough preview of the selected option Use the Print Preview button at the bottom of the form to get an accurate preview Experimentation or Trial and Error is the best method for using this form Explore different options to get the look you want Remember to make copies of Templates so that you can go back to previous settings Depending on the options you select certain other options may or may not be available For example the option to include the Subcategory Text in the header is available only if the Category Text is selected first Another example in the Page Hea
86. where from 2 000Kb to 5 000Kb In contrast the photos you see on many websites are commonly around 10Kb or 20Kb For printing photos need to be a higher resolution than the 72dpi used on webpages Photos in the range of 20Kb to 100Kb usually provide very good print quality without placing a drain on system resources CleverCat needs to load every photo in a category into memory when that category is printed A photo with a file size of 100kb may actually use around 1 000Kb of memory when decompressed for printing If your category contains hundreds of images you could run out of memory Reduce the size of your photos or break your data into smaller categories if you experience problems when printing There are many different utilities available online for reformatting photos and we recommend www Omniformat com for a utility which can quickly resize an entire folder of images with only a few clicks Another memory issue relates to Detail Tables and Microsoft Access upon which CleverCat is based Each time Access prints a small amount of memory is used and not returned to the system For most users this problem will never be seen as it will require printing or previewing the catalog many hundreds of times However there are factors which can increase the amount of memory consumed Detail Tables require that the same data be accessed multiple times Feature and Summary template styles also require multiple passes through the data and each pass consum
87. y form is divided into two sections The top half of the form is a scaled down version of the Data View form with a Category Window and a scrolling Data Window As on the Data View form add a new category by scrolling to the bottom of the Category Window to enter the name of the new category Category Baseball Gloves v Description Easton BMX Glove fl Product 2647283 a o Size 13 Stock In Stock Price 44 99 Product Notes Closed back with adjustable quick binding strap for a snug fit and easy Ad Text Photo 1 on and off All leather construction for durability l Print Z SubOrder SubCategory 1 1 Active Product Easton1 jpg Easton2 jpg Add a New Inventory Item Sorting Grouping EXIT The bottom half of this form the Inventory Detail Window allows you to view and edit an individual item in the database Click any row in the Data Window to view that record in the Detail Window When you create a new category the field labels will be set to the default value of Custom You should change these to match your data These field labels will be used later on the Template Editor to identify the fields and they are also the Column Headers that will be printed if your catalog uses a Detail Table The only significant difference between this form and the Data View form is that all the fields of an individual
88. y it will print from If you have already created one template you may find it easier to create additional templates by clicking the Copy button to create a new template matching an existing one This is also a good strategy if you want to make significant changes to a template Make a copy of the current template so that you can return to the original template if you are not satisfied with the changes Templates can be exported and shared with other users Click the Export button to display checkboxes on the Template List Select all the templates that you want to export and click the Export button again to create the file If you need technical support or advice regarding Printing Templates we may ask you to use the Export function to send us a copy of your template The Import function will allow you to install templates created by other users Click the Import button to search for a downloaded file containing templates For each template in the download file you will be asked to provide a new name If you require technical assistance with templates this is the method we will use to send you a custom template or updates to a template you sent to us The Index Page and Table of Contents are Printing Templates like any other with the exception that they draw data from all categories Use the Index or Table of Contents button to select either and then make the same Page and Display Unit customizations as you would for any other template NOTE I

View the User Manual - Professional Product Catalog Software

Contents

Download Pdf Manuals

Related Search

Related Contents