Is there an easier way to get content from a *.csv file into a Frame table?
I can export a bug query to csv, but the only way I can see to get that into Frame is copy/paste.
Back one step.
Do you really need to?
Back when I had to deal with incorporating detailed rate.v.setting charts into FM documents, the prior writers had evidently been doing it by copy&paste, with an appalling error rate. I explored various data transfer schemes, and ended up deciding to…
Export from the spreadsheet to PDF.
Import those (and in those days, with an intermediate step through EPS, due to PDF instability).
The PDF images can even have a lot of provenance info from the source, cropped out of frame.
Yes, you won't be able to Xref into or out of such tables, and spanning pages could be extra work, but errors go to zero, and using import-by-reference, the things auto-update.
I copy the content from my Excel files and paste (Paste Special as Text) into my FrameMaker file. Then I select this content and convert to a table.
This way I am sure that everything works as I want. Only the content which I need.
However, you can also import the Excel file file directly. Also as reference so that any changes in your Excel file will be changed in your FrameMaker file.
When I import csv, then I can import only as text. This is not a table.
Does the CSV contain a large amount of data? Does the entire CSV become a single FrameMaker table? Is this a one-time import, or does it have to be done periodically? Depending on the answer to these questions, it may be worthwhile to use a script to import and format the data, especially if it is maintained in Excel (or some other program) and just output in FrameMaker.
Thank you for all the great suggestions!
frameexpert asked questions. Here are the answers:
I like Bob's suggestion to import a pdf, so I'm going to try it and see how it works.
Thank you, Winifried:
Your answer turned out to be the best fit.
I tried creating PDF tables, per Bob, but they did not import the way I hoped.