Skip navigation
Wayniac
Currently Being Moderated

Can I import data from a database into a FrameMaker document using ExtendScript?

Jan 17, 2014 8:50 AM

I want to import part information from a database into a structured (XML) FrameMaker document. The document would be an Illustrated Parts Catalog, built by merging the text in the structured document with graphic files and nomenclature stored in a database. Can ExtendScript do this, or do I need to investigate a different language for this programmatic approach to building a document?

 
Replies
  • Currently Being Moderated
    Jan 17, 2014 9:56 AM   in reply to Wayniac

    There is no direct way to connect to a database with FrameMaker ExtendScript. It is possible to write C++ code to interact with scripts, so you could write some kind of connector in C++ that would work with ExtendScript. ExtendScript can work with XML files, so another alternative would be to export your data from the database to XML and use ExtendScript to parse and import it to FrameMaker.

     

    I would take a serious look at FrameScript. FrameScript has built-in ODBC support so you can connect directly to your database and use SQL queries to get your data into FrameMaker. It also has ActiveX support, so you can use ADODB technology to get data from your database. I have done database import in a bunch of my scripts over the years. Please let me know if you have any questions or comments. --Rick

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 17, 2014 10:40 AM   in reply to Wayniac

    Absolutely. You would either have to specifically run the script whenever the data changes, or you could have the script automatically run when you open a particular document.

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 17, 2014 11:07 AM   in reply to Wayniac

    If you are interested in doing a no-cost, no-pressure consultation about this project, please let me know. We can meet via GoToMeeting and I can give you some ideas for putting it all together. Thanks. Rick

     
    |
    Mark as:
  • Currently Being Moderated
    Jan 17, 2014 9:14 PM   in reply to Wayniac

    Wayne,

     

    Another route that you might want to consider is Datazone's Miramo Personal Edition. This tool was designed just for this type of operation.

    See: http://www.miramo.com/english/overview/dp_download.html

     

    I use it to create catalogs, directories and all sorts of other database driven publications.

     

    You might want to also see this thread for additional info: http://forums.adobe.com/thread/1380660?tstart=0

     
    |
    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