csv files in FM 8

[Art Campbell]

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.
>