Pdf printing Follow

0
Avatar
fernand obama

I use versin 2019 but have a question. Fİrst of all I must give diese information. My project consists of 4 pages, annd .I use excel tabelle to fill templates. In excel I have 1000 row data.

when I use inclusive bartender PDF printer so I can name my file from databese excel tabelle but obtain one big pdf file as 4000 seite. I want 1000 datafile consisting of 4 pages

I can not choose. the program has to switch to a separate file on 4 pages.
 
What I have to do?

5 comments

0
Avatar
Pete Thane
Comment actions Permalink

Sorry not sure what you are trying to achieve but does this feature help?

0
Avatar
fernand obama
Comment actions Permalink

sorry but not like that. ı create brochures which are 4 page. And in bartender I made 4 page design.

if I create a one pdf file I obtain 4 pages a wonderfull pdf brochure thats really good.

but if I use 2 different consecutive or my all data, I wanna obtain 1000 piece of PDF file. but program gives me 1 file which is 4000 page.

than I have to splitt 1000 page and rename it again etc.

0
Avatar
Pete Thane
Comment actions Permalink

I dont think you can do that as it stands but you can configure an Action Button to run the process for you. 

In your existing label on the Print Screen make sure you configure BarTender to make unique labels by adjusting the File Name settings such as

Make sure the Queried Records on the Print screen is set to Selected at Print Time and delete the 1... from the Selected Records to leave this blank.

Close the screen when done save the label and close that file,

  • Start a brand new label the size etc wont matter as it wont actually print it. 
  • When the blank label opens up click on the Form1 tab at the bottom of the screen to go to the Data Entry From screen.
  • From the Data Entry Control drop down list select Button and click on the form to add it to the screen.
  • Right click on the button and go in to the Properties of it, change the Text from Button to something that makes more sesne to your application, like create files etc.
  • Click on the Actions button to open a new screen. 
  • Press the blue plus button next to the Control Clicked and choose the Database option and Execute SQL.
  • When that screen open configure the Database connection to your Excel file (it will need to be closed to do this and when you are printing)
  • As above click on the same blue plus button and this time choose the For Loop option from the Execute menu. Note the Name of Iteration variable (the default seems to be %index%) and adjust the End Value to 1000, although for testing you may want to use a smaller number.
  • There should now be a blue plus sign next to the For Loop, click on this and again from the Execute menu choose the Print Document option.
  • Browse to choose your main label from the above and then click on the Print Options tab and tick the Record Range and then with the cursor in the Record Range box choose the Insert Variable option (as this will now be enabled) and choose the Iteration variable mentioned above (eg %index%)
  • Click OK and Close and then Save your label and when you press Print Preview (if you press Print you can only Preview anyway) the Button screen should appear and when you press this your PDFs should be created.

I hope this helps

Pete

0
Avatar
Allyn Van Hout
Comment actions Permalink

Trying to run this same process but BarTender crashes everytime after trying to attach the Excel DB to the form template.  We are running BarTender 2019 R6.  Thanks

0
Avatar
Pete Thane
Comment actions Permalink

Sorry not sure what to suggest, I am using the same version of BarTender and do not have an issue and so could be a problem with your Excel file, unless you had the Excel sheet open elsewhere in which case you would get a problem.

Please sign in to leave a comment.