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
Sorry not sure what you are trying to achieve but does this feature help?0
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
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
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. Thanks0
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.0
Thank you Pete, you opened a new door for me. there are too many control tools in it. I accually did what you said but i have still some problems. First, as database, the program uses what embedded is in original data. my execute SQL is ineffective. if I want to filter my database, thats not gonna happen.Secondly I think that "while loop" is more appropriate for me. Because in the beginning I want to filter my database than send every row as a command to BarTender. Can you help me about it. also I developed my data entry form can you give me little bit more hint about it. there is no info in this topic on internet.
Sorry I am not sure what you mean,
For the Data Entry Form, what are you trying to achieve? You have included a Record Picker, but other than the first column there does not seem to be any data in it. Also what are the "buttons" meant to be for at the side of the form?0
I pasted White board on table for unnecessary info. And every button on data entry form a filtered database which frequently used. so I wanted to support it with buttons. the Question is same how can I send to main program filtered or not databases. but there is an extra situation,
when I want to add database in "execute SQL", I take that error. In normal rules there is not such a warn. so is that means, if I want to send this database somehow to print file, some places will not be printed? so should we send in command direct range numbers, and keep database in original file?
and as most important,
how should be the button action orders?
-read a filtered data base,
-take range numbers or product code(every product has a uniq product name)
- send them as print command
- in original file if we take Product code, should we compare the numbers and print appropriate candidates.0
Actually I solved the problem, Here i leave the steps for sample,
- leave the main label with dynamic filter/query prompt configured. And in printer options select all data. Database is added.
-in remote file button actions follows the steps right below
1. execute SQL (you can filter it if you want).
2. For each Database Record must carry same variable with execute SQL
3. in For each Database Record, add print document, in Query prompts tab, mark the box and add your promp info,(Prompt variable is bridge variable between two database.)
4. and print options mark the "prompt for data input"
it works me like that.
now I have only one question, can i take variables from 'Record Picker' or 'dropdown list' to the 'execute SQL'?0
I am able to successfully print individual pdf files following the instructions provided by Pete Thane. Thanks for sharing that approach!
However, I would prefer to print every record in the database, rather than have the quantity fixed (such as at "1000" in the instructions provided). It seems like Fernand Obama has found a way to do that by running the action "For Each Database Record", but I can't replicate that.
I am having trouble linking the Query Prompt back to my Excel database, and don't understand how the "%Artikelnummer" value in his example is being used.
Are there more specific instructions that can be shared for the "For Each Database Record" printing of individual pdfs?
HI Mike, firstly sorry for my explanation, I think I should work on it :)
here I resample my way;
1- you must have one main label file that has your design and one trigger label file with user form.
2- you must add your excel data base to your main label. And printer options like Pete said.
2-you should create queryprompt in your main label with one uniq variable column in your excel database.(in my old example Artikelnummer is Product number)
3-and in your trigger file you must repeat the steps i've already written.
(1. execute SQL (you can filter it if you want).(Add your excel database here too.)
2. For each Database Record must carry same variable with execute SQL(Connect execute SQL to FEDR)
3. in For each Database Record, add print document, in Query prompts tab, mark the box and add your promp info,(Prompt variable is bridge variable between two label file.))
If you describe your problem in detail, I will try to describe that part.0
If you leave the Queried records as All and do not include a database filter/query or use the Record Selector then the default should be print all anyway0
Thanks to both of you for your fast and encouraging responses! I have had mixed success, and feel like my general approach matches with what you both have instructed. I am a bit computer program challenged, though, and can't quite achieve exactly what I'm after. That's ok though, because in this case, I found a way to easily and basically automatically separate individual files after the fact.
I very much appreciate you taking the time to respond, and to share these techniques.
All the best,