Welcome To Signs101.com: Largest Forum for Signmaking Professionals

Signs101.com: Largest Forum for Signmaking Professionals is the LARGEST online community & discussion forum for professional sign-makers and graphic designers.

 


  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Repeat Serial Numbers in Illustrator?

Discussion in 'Adobe' started by dlndesign, Sep 8, 2011.

  1. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    I am doing a few thousand of consecutive numbered decals. I would like to know if this can be done in illustrator with the use of excel if possible. I need to have one set vertical and a smaller horizontal version on the same decal. Anyone know how?
     
    Tags:
  2. qmr55

    qmr55 Very Active Member

    1,767
    14
    38
    Jun 3, 2010
    Yardville NJ
    Are you looking to have it type the numbers automatically so you don't need to manually type each one?
     
  3. ucmj22

    ucmj22 Very Active Member

    1,509
    1
    0
    Dec 10, 2009
    I know that you can set up variable data fields in your document using a special roland spot color, and then create a CSV file using excel which can be loaded in to versaworks to automagically fill those fields with the data in the CSV.
     
  4. petepaz

    petepaz Major Contributor

    4,349
    84
    48
    Feb 14, 2007
    NJ/NY/PA
    would like to know how to do that one. it would come in handy.
    i have another program (sign engine) that doesn consec. numbering so i import the artwork and set the numbers then export and import into versaworks but if i could set it up right from illust. to versaworks that would be great
     
  5. ucmj22

    ucmj22 Very Active Member

    1,509
    1
    0
    Dec 10, 2009
    http://www.youtube.com/watch?v=JFZ5qqrmuIA this is in corel, but im sure the process is the same. In the design program, all you are doing, is assigning a spot color stroke to a box that versa works will recognize as a field it can add information to. you can add images or text, and can edit the font and color of text within versa.
     
  6. Fred Weiss

    Fred Weiss Merchant Member

    20,875
    523
    113
    Sep 11, 2003
    Olympia, WA
  7. rfulford

    rfulford Active Member

    566
    2
    18
    Feb 9, 2009
    Orlando
    Do you have the entire Creative Suite? InDesign is the tool for this job.
     
  8. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    yes I do, what is the tool I would be looking for. Having multiple options to do this is very helpful.
     
  9. CES020

    CES020 Very Active Member

    2,875
    4
    38
    Oct 16, 2008
    VA
    +1 on InDesign for the job. It has great data merging.
     
  10. Custom_Grafx

    Custom_Grafx Very Active Member

    1,637
    2
    0
    Nov 23, 2008
    I usually work in the hundreds, not thousands, but find that doing the data in excel, then copy/pasting into either corel or illy works for me.

    After you paste, select text only via menu command, then inverse select to select only the boxes and lines that will come across, delete, then you are left with text only.

    Tip, when dealing with more than say 50 or so, pre split your stuff into columns of 30 or so in excel, and bring them over as columns, just easier to work with.

    1. Centre align your top text to the top rectangle or whatever your label shape is.
    2. Do the same to the bottom one.
    3. Select all your label shapes, distribute evenly across selection.
    4. Select all the text in that column, and do a distribute evenly across selection.

    I love illustrator but to be honest for this particular function, Corel is way faster and easier to use for me, and being able to so easily work with multipage in Corel is a huge advantage when you run out of room. Yes, you can multipage in Illy, but my personal preference for this particular type of work is corel... it's a little more user friendly (for my laser engraver in particular... Roland, not such a big diff maybe).
     
  11. signswi

    signswi Very Active Member

    2,136
    2
    0
    Oct 29, 2009
    +10000 for InDesign

    Use all the tools in the designer toolbox. Being married just to Illustrator is a (common) mistake.
     
  12. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    ok, does anyone have a good tutorial for this in InDesign?
     
  13. Tony Teveris

    Tony Teveris Active Member

    Does your Flexi do auto number, if so then create and export to AI or EPS and import into AI
     
  14. GypsyGraphics

    GypsyGraphics Major Contributor

    4,276
    4
    36
    Mar 19, 2009
    dindesign... forget illy, go with InDesign. here's a link with nice visuals to walk you through setting up your InDesign file with variable data fields.

    InDesign VDP set-up
     
  15. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    Gypsy, Finally got my head around it. Thanks so much, you are an angel.
     
    Last edited: Sep 12, 2011
  16. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    Ok, new issue. When I export as pdf to send to VersaWorks, I get it to 100% and the whole program shuts down. Any suggestions? I have tried breaking it down to lower qty (500) and have the same issue. Is there a specific way to export?
     
  17. dlndesign

    dlndesign Active Member

    896
    4
    18
    Dec 10, 2007
    San Diego, Ca
    Ok I think I may have a workaround, exporting all as eps, then repackaging them in pdf to keep down the upload time of putting them in individually... any other way out there?
     
  18. Kevin-shopVOX

    Kevin-shopVOX Active Member

    674
    1
    16
    Mar 29, 2009
    Maine
    Just use versa works to handle it. You are ripping through there all ready and it is pretty simple to do. Scroll to Q17 for the how to.
    http://support.rolanddga.com/docs/D...ces/Manuals and Guides/VersaWorks3_FAQ_EU.pdf
     
  19. Bobby H

    Bobby H Very Active Member

    2,192
    192
    63
    Feb 4, 2005
    Lawton, OK
    VersaWorks does support variable data field printing. Unfortunately there is one "gotcha" I really don't like about it:

    Most typefaces default to column spacing for the numerals. Column spacing looks TERRIBLE unless you're setting a lot of numerals in columns. I hate looking at badly spaced numerals. Anything with one or more numeral ones in it can look especially atrocious. And we're in a year that has that (2011).

    Excel has nothing for settings on controlling numeral spacing. VersaWorks is a software-based RIP, not really a design tool.

    InDesign has numerous settings to override many of the default spacing settings built into typefaces, including the column spacing set for numerals. This can be handy to make numeral spacing in numbers look a LOT better.
     
  20. Kevin-shopVOX

    Kevin-shopVOX Active Member

    674
    1
    16
    Mar 29, 2009
    Maine
    True
     
Loading...

Share This Page

 


Loading...