Skip navigation
727Designs
Currently Being Moderated

I need to number 20,000 tickets in InDesign and have them in order when I cut them

Oct 26, 2010 5:25 PM

I need to number 20,000 tickets in InDesign and have them in order when I cut them, I know there is a way to use data merge or something. I just can't get it to work. Any help would be greatly appreciated.

 

I saw a post similar, answered by Peter Spier which explained this, but I still can't get it to work.

 
Replies
  • Currently Being Moderated
    Oct 26, 2010 6:26 PM   in reply to 727Designs

    Ask your printshop about “Crash Numbering”.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 26, 2010 6:41 PM   in reply to 727Designs

    What previous poster says applies to offset print, but if you are looking to digital print:

     

    You could set up a series of numbers in excel and save as 'csv' (comma separated) data which you could then add to a doc using data merge.

     

    Say you had 20 on a page, you could sort the numbers into 20 columns in excel with the first row being 1,1001,2001,3001 etc and so on to 19001 with 1000 rows.

     

    Then you name each column at the top as 'a' 'b' 'c' etc

     

    then your Indesign page would be set up with 20 tickets on a page with <<a>> going in position one and <<b>> in position two, then your first page after merging would contain each of the ticket numbers in the first row, the second page would contain the second row numbers and when printed and cut down, the stacks would be in order.

     

    Hope that makes sense...  that's how I would do it without scripting.  Very achieveable for the average user!  ( I don't know what your level is )

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 26, 2010 6:46 PM   in reply to p taz

    This can be done digitally as well. Not all digital print shops can do it, but any decent one can (so not Kinko’s). I assume they will handle the cutting as well, so they can determine the best way to arrange the numbers.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 12:21 AM   in reply to Scott Falkner

    What about Auto Page Numbering to number the tickets for you.

    How many tickets per page have you got.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 4:24 AM   in reply to mckayk_777-PN6kWE

    mc, Auto Page Numbering works only in one way: one number per page. So in this case you'd need one ticket per page, and 20,000 pages.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 5:10 AM   in reply to 727Designs

    I'll run throough my method one more time to see if it helps.

     

    The first thing you need to know is how many tickets you plan to put on a page. That determines the number of columns, or fields, you need in the data file. Next you need to divide the total number of tickets (20,000 in this case), by the number of tickets per page. Round up to the next whole number. This is the number of rows, or records, in the data file. Each record represents a single page in the merged file.

     

    To make the data file you fill the first column starting with the first number in the first row and put the second number in the first columen second row, and soforth, filling the column downward in in consecutive order until the correct number of rows is reached, then you start with the next number in the first row of the second column and work down again. This should make it clear that every row represents a stack of ticket. A spreadsheet like Excel can auto-fill the grid for you once you have enough numbers in place to establish the pattern, generally three in either direction.

     

    After the grid of numbers is done, you need to insert a new row at the top to hold the field labels (Stack 1, stack 2, stack 3... or whatever) and then save as .csv or tab delimited text to use as the Data Source file for the merge.

     

    Set up your tickets as a full grid on the page in ID and drag one field name into each ticket, then do the merge as a Single Record per Page.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 6:41 AM   in reply to 727Designs

    There is a good chance that the digital printer that you will use, has a cut and stack imposition method. This is a method that replicates Peter's description, except it is done at the RIP and automatically. If this is the case, all you would need to do is supply a file from your data merge (20,000 single pages), and the imposition is taken for you.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 8:47 AM   in reply to 727Designs

    If you figure how many you have on a sheet that will be printing and the location it is pretty easy. I just do a quick round of numbering with Excel so the stacks come out in order. I haven't found a way to get InDesign to do this, but I regularly have to do this for a couple of tickets and gift certificates.

     

    Information you need: Number of tickets one a sheet. Number format (need leading zeros?)

     

    It's pretty easy in Excel. Take your number of tickets you'll get on a sheet, divide 20000 by that number. That will be your number of rows. Type a 1 in the A1 cell location, type =(A1+1) in the A2 cell location. Paste that in as many rows as you determined. Copy the last cell in your first column. Paste that in cell B1. Copy B1 and paste in as many rows as you had in Column A. Copy column B and paste in column C. Copy C and paste in Column D. Repeat as many times as you have tickets on a sheet until you have enough columns as you do tickets on a sheet. Save as Tab deliminated text and bring into data merge on an imposed sheet. Data merge should be able to build you a document easily with as many sheets as you need and on a 1 knife trimmer you should have neatly stacked tickets in order.

    Ticket Numbering.jpg

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 27, 2010 5:03 PM   in reply to 727Designs

    You only need to answer once . All responses are posted on the web and go to all who are subscribed.

     

    Did you remember to add a row and the field labels to your file? They need to be in the first record...

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 28, 2010 6:11 AM   in reply to 727Designs

    727Designs wrote:

    I am printing them on one of our Xerox 700 Digital Presses

    What is the DFE or RIP to this device? I bet it is either an EFI or Creo and probaly has cut and stack imposition.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 28, 2010 7:52 AM   in reply to 727Designs

    you need to put in a heading row. just do A B C D…etc and make another row directly below it that is A1 A2 A3 etc for dummy numbers. That 2nd row can be your first sheet and let what I affectionately refer to as "cutterboy" do his/her setup.

     

    Then just assign each of the letters to where you want in the layout. You will see <<A>> <<B>> in each of the spots where the letters are. when you do you merge make sure that you have the page as the sheet size that you are using and do not use multiple records per sheet.

     

    All the remaining pages should pop off just how you want it. If you continue to have issues and want me to look at it you can pm me a link to the file and i'll steer you in the right direction. You are 95% of the way there.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 28, 2010 11:04 PM   in reply to 727Designs

    Quite Imposing Plus does Cut Stacks and Double cut stacks.

    Check out our tech sheets on the subject at www.quite.com/imposing/techsheet

    Just go to Shuffle pages for imposing...

    Put in a group of 12

    And a RULE of 1 2 3 4 5 6 7 8 9 10 11 12

    then do n-up pages.


    Here is a temporary number to test drive us live:
    Quite Imposing Plus
      Expires end 11/2010  Serial 4626-8727-8912-4682  Code 6456
    




    cheers,

    Charles



    Charles James

    Technical/Marketing Director

    Quite

    USA

    858.581.9143

     

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 29, 2010 12:12 AM   in reply to 727Designs

    The same problem gets into the news also in Japanese Blogs now.

    I wrote a Script :

    http://d.hatena.ne.jp/seuzo/20101029/1288287509

     

    1. Select target Text Frames on Master Page.

    2. Run the Script.

    3. Input start and end number.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points