Skip navigation
(pratik_bagaria)Calculating status...
Currently Being Moderated

Using XML in Illustrator CS3

Jul 31, 2008 7:58 AM

Hello there,

I was working on a Business Card design. Wherein I need to add Name, Address, Phone and Email of every person. I had all the data in Microsoft Excel. Then I exported my excel file to XML, and tried loading the XML file from Illustrator's Variables Palate. But I get an error message saying "The incoming variable library in invalid" !

Is there a way I can make my excel file into a valid XML file.

I also came across this link: http://www.spahr.org/pratt/2003/11/001241index.html

but it seems that the script is not download able...

I also have the txt file for the data ready as I was required .. but cant get it to convert to an XML file which Illustrator can understand....

Any help in this regard would be of great help.

Thanks.

P.S.: I use both Windows XP and Max OS X

Regards,
Pratik
  • JETalmage
    Currently Being Moderated
    JETalmage,
    Community Member
    Aug 2, 2008 10:17 AM
    Report
    The .zip archive mentioned on this page contains an AI Javascript named JET_VariablesFTROU (Variables For The Rest Of Us). Instead of monkeying around with XML and Illustrator's complication thereof, the script allows you to just paste your tab-delimited text from Excel into an ordinary text frame on the page. The script then creates Datasets in the Variables palette from that textframe.

    The process is described in detail in the PDF which accompanies the notes on the script.

    JET
    |
    Mark as:
  • Currently Being Moderated
    (pratik_bagaria),
    Community Member
    Aug 6, 2008 10:39 PM
    Report
    Thanks a lot James....

    It worked... :)
    |
    Mark as:
  • JETalmage
    Currently Being Moderated
    JETalmage,
    Community Member
    Aug 7, 2008 3:50 PM
    Report
    You're welcome. Glad it helped.

    JET
    |
    Mark as:
  • RogerPaine
    Currently Being Moderated
    RogerPaine,
    Community Member
    Feb 16, 2010 10:16 PM
    Report

    Hey Jet

    I've tried using your script in cs4 but it leaves out the first "column" of data. I have also tried various text editors to save an xml file but always get "incoming variable library is invalid". Any clues greatly appreciated.

    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Choose your region
Security Contact Adobe Report piracy EULAs Permissions and trademarks Careers

Copyright © 2012 Adobe Systems Incorporated. All rights reserved.

Reviewed by TRUSTe: site privacy statement

Use of this website signifies your agreement to the Terms of Use and Online Privacy Policy (updated 07-14-2009).