Pdf printing フォローする

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?

9 コメント

0
Avatar
Pete Thane
コメントアクション Permalink

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

0
Avatar
fernand obama
コメントアクション 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
コメントアクション 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
コメントアクション 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
コメントアクション 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.

0
Avatar
fernand obama
コメントアクション Permalink

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.

best regards

0
Avatar
Pete Thane
コメントアクション Permalink

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
Avatar
fernand obama
コメントアクション Permalink

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
Avatar
fernand obama
コメントアクション Permalink

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'?

サインインしてコメントを残してください。