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 (freefram...@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. r...@frameexpert.com 585-659-8267 " Art Campbell art.campb...@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.co...@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 >> <m...@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.campb...@gmail.com. > > Send list messages to fram...@lists.frameusers.com. > > To unsubscribe send a blank email to > framers-unsubscr...@lists.frameusers.com > or visit > http://lists.frameusers.com/mailman/options/framers/art.campbell%40gmail.com > > Send administrative questions to listad...@frameusers.com. Visit > http://www.frameusers.com/ for more resources and info. > _______________________________________________ You are currently subscribed to Framers as arch...@mail-archive.com. Send list messages to fram...@lists.frameusers.com. To unsubscribe send a blank email to framers-unsubscr...@lists.frameusers.com or visit http://lists.frameusers.com/mailman/options/framers/archive%40mail-archive.com Send administrative questions to listad...@frameusers.com. Visit http://www.frameusers.com/ for more resources and info.
