I would use Richard's solution for simple importing, but one of the leading FrameScript gurus, Rick Quatro, just released a more sophisticated solution for importing from a database. Although Rick's example uses a tab-delimited file, a csv is the same type.
>From his post, on a different (freeframers at omsys.com) list: "Hello Framers, I have been working on a project where it is necessary to import text from a tab-delimited file into a series of FrameMaker tables. Even though the source text file is large (over 300,000 lines), and the required data is scattered throughout the file, we are able to import the precise data into each table using SQL queries. Each query is embedded in a custom marker in the table's title. When we receive a revised text file, we simply rerun the script to refresh the data in FrameMaker. There is a brief Flash demo at http://www.frameexpert.com/demos/TextToTable_demo.htm Please let me know if you have any questions or comments. Rick Quatro Carmen Publishing Inc. rick at frameexpert.com 585-659-8267 " Art Campbell art.campbell at gmail.com "... In my opinion, there's nothing in this world beats a '52 Vincent and a redheaded girl." -- Richard Thompson No disclaimers apply. DoD 358 On Thu, Apr 30, 2009 at 3:29 PM, Combs, Richard <richard.combs at polycom.com> wrote: > Joel wrote: > >> I don't see an option for CSV or Notepad in the list of options. I did > mean >> comma separated values. >> >> Joel >> >> On Thu, Apr 30, 2009 at 3:14 PM, Matt Sullivan >> <matt at grafixtraining.com>wrote: >> >> > If by csv you mean Comma Separated Values, you should be prompted to >> > convert >> > to a table when using the File > Import > File command. >> > >> > Set the # of columns and other ?options and you are done. > > A CSV file is a plain text file. When you import one, the Unknown File > Type dialog's Convert From setting should already be Text. If it isn't, > select that. Then click Convert. In the Import Text File dialog, select > Convert to Table and click Import. In the Convert to Table dialog, > select the Table Format you want to use. The Treat Each Paragraph As > settings should already default to A Row with Cells Separated By Tabs. > Set Heading Rows appropriately (probably 1), and if the CSV file doesn't > start with a record of field names, check Leave Heading Rows Empty. Then > click Convert. > > HTH! > Richard > > > Richard G. Combs > Senior Technical Writer > Polycom, Inc. > richardDOTcombs AT polycomDOTcom > 303-223-5111 > ------ > rgcombs AT gmailDOTcom > 303-777-0436 > ------ > > > > > > > _______________________________________________ > > > You are currently subscribed to Framers as art.campbell at gmail.com. > > Send list messages to framers at lists.frameusers.com. > > To unsubscribe send a blank email to > framers-unsubscribe at lists.frameusers.com > or visit > http://lists.frameusers.com/mailman/options/framers/art.campbell%40gmail.com > > Send administrative questions to listadmin at frameusers.com. Visit > http://www.frameusers.com/ for more resources and info. >