Go Back   PrintPlanet.com > PrePress and Workflow > Adobe

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-22-2008, 10:19 AM
Junior Member
 
Join Date: Jul 2008
Posts: 9
Exclamation Mac Indesign CS3 and Variable data.

Another day, another new way to reinvent the wheel.

We have a job that just came in that's going to be a doozy. It's a 2 sided postcard with each side having the mailee's name and address as variable data. There's a problem, I haven't the slightest clue how to to do variable data!!!! (I'm prepress/designer, what the hell would I know about direct mailing?!?)

I see that CS3 has a plugin built in for data merge, but no clues how to use it or to make it do something of this magnitude. It's going to be a list of about 500 names, I don't know HOW the names are going to be pulled in yet though.

Help me maintain my position as "program guru" and temporary hero! I KNOw there's gotta be a way to make this happen, I'm just not smart enough to figure it out!
Reply With Quote
  #2 (permalink)  
Old 08-22-2008, 10:53 AM
Member
 
Join Date: Aug 2008
Posts: 44
Default

Hello -

I feel your pain, but learned how to do this the hard way

This is actually very easy

I can help you through it - if you want email me directly at brian@arvestpress.com

Its done through the data merge Script in Indesign CS3

It has to be an excel spreadsheet though, then it gets exported to a txt file

then in indesign, you make a text box and tell it where to put each record, with the postcard design being on a master page.

Email me the file and I can help you out
Reply With Quote
  #3 (permalink)  
Old 08-22-2008, 11:25 AM
Junior Member
 
Join Date: Jul 2008
Posts: 9
Default

Bah, it's boiling down to this issue being more of a HARDWARE issue than software.

Due to this being VARIABLE it's not going be printed on a conventional printing press, but a digital press. The issue comes from the fact that it's double sided and the thickness of said stock will be too much for the digital press to handle duplexing for.

It can be done, but we need a monster printer that's just way out of budgetary reasoning for as LITTLE of this type of thing as we do.

EDIT: I can think of ways to make it happen and WORK, but I can't overcome the limitations of the press and I don't think the customer would want to pay for all the billable hours I'd need to charge for it to happen
Reply With Quote
  #4 (permalink)  
Old 08-22-2008, 11:41 AM
Member
 
Join Date: Aug 2008
Posts: 44
Default

What kind of digital press is it???

You can run it through then manually duplex it.

Do you have imposition software???? We use preps here, and we can set up a sheetwise imposition, and it will have the correct cards back up the correct front

Do you have software for that???
Reply With Quote
  #5 (permalink)  
Old 10-21-2008, 09:38 PM
Junior Member
 
Join Date: Oct 2008
Posts: 1
Default excel to indesign

Quote:
Originally Posted by bgardner View Post
Hello -

I feel your pain, but learned how to do this the hard way

This is actually very easy

I can help you through it - if you want email me directly at brian@arvestpress.com

Its done through the data merge Script in Indesign CS3

It has to be an excel spreadsheet though, then it gets exported to a txt file

then in indesign, you make a text box and tell it where to put each record, with the postcard design being on a master page.

Email me the file and I can help you out
So, start with an excel SPREADSHEET not a workbook (worksheet) ...whatever...... ?
I want to number raffle tickets sequentially with a '00' prefix. But the prefix doesn't show up. Thanks
Reply With Quote
  #6 (permalink)  
Old 10-22-2008, 10:02 AM
Member
 
Join Date: Aug 2008
Posts: 44
Default

Yes, Make a spreadsheet with your numbers in excel, and Put the numbers in the way you want it, then save the spreadsheet as a csv file

That is what will get imported into Indesign
Reply With Quote
  #7 (permalink)  
Old 10-22-2008, 12:07 PM
Cory Smith's Avatar
Administrator
 
Join Date: Aug 2007
Location: Bend, OR
Posts: 394
Send a message via AIM to Cory Smith
Default

The first time I did a merge like this, I found the indesign help to be an excellent resource as well. Once it's laid out, it's a pretty simple process.
Reply With Quote
  #8 (permalink)  
Old 10-22-2008, 12:50 PM
Vee Vee is offline
Senior Member
 
Join Date: Aug 2007
Posts: 110
Default

Quote:
Originally Posted by twitch5253 View Post
So, start with an excel SPREADSHEET not a workbook (worksheet) ...whatever...... ?
I want to number raffle tickets sequentially with a '00' prefix. But the prefix doesn't show up. Thanks
In order for the numbers to print w/ 00 in front of the others, you need to format the cells as "text". In Excel, Right click - format cells - in the number tab choose text. Done.
Reply With Quote
  #9 (permalink)  
Old 10-23-2008, 05:16 AM
Lukas Engqvist's Avatar
Senior Member
 
Join Date: Jul 2008
Location: Sweden
Posts: 285
Default

For a quick start chack out theIndesigner episode on automation.
The InDesigner » Blog Archive » Episode 43: Data Merge (VIDEO)
Reply With Quote
  #10 (permalink)  
Old 10-23-2008, 06:14 AM
Member
 
Join Date: Oct 2007
Location: Ontario, Canada
Posts: 83
Default

EskoArtwork has a plugin for Ai called Dynamic Content for Adobe® Illustrator® that may be of interest to you. Here is a link - Dynamic Content - EskoArtwork - to the webpage. Check out the 'movie' demo on the right side of the page. Notice the FREE TRIAL download available.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Sponsors



The Print CEO Blog
Links, information, analysis and commentary from various industry resources.

WhatTheyThink's Speakers Bureau
Need a speaker for your open house, conference, or special event?

WhatTheyThink's Consulting Services
Business Strategy, Workflow Integration, Sales & Marketing, Custom Research