• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Does Framemaker present a way to update the contents of a table from a data source?

Participant ,
Nov 26, 2021 Nov 26, 2021

Copy link to clipboard

Copied

Is it possible to automatically (or manually) update the contents of a table from a data source or by utilizing reference links to 3. party spreadsheet sources etc?

TOPICS
Content migration , FAQ , Scripting

Views

188

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 26, 2021 Nov 26, 2021

Copy link to clipboard

Copied

Yes. Open the spreadsheet. Copy the table. In FrameMaker click Paste Special / Linked Microsoft Excel Spreadsheet (or something - my dialogue is danish)


Bjørn Smalbro - FrameMaker.dk

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 26, 2021 Nov 26, 2021

Copy link to clipboard

Copied

There are several options, one to avoid:

  1. Don't use Windows OLE (many reasons).
  2. Export the spreadsheet to PDF, import that by reference. Be sure to include some stewardship info in the export object (ID, path, date), outside the hosting frame, so future maintainers can tell where it came from.
  3. FM can be extended via script or FDK to query an enterprise database. I had that feature available in a prior position, and used it extensively.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 26, 2021 Nov 26, 2021

Copy link to clipboard

Copied

ExtendScript has a nice XML object so if the datasource is XML (or you can export it to XML), then scripting the updates could be a good option.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 26, 2021 Nov 26, 2021

Copy link to clipboard

Copied

LATEST

If using Excel, one other, albeit unsophisticated method, that works is importing by reference. You need to make sure there is only one worksheet in the Excel file and do all the formatting in Excel. You do end up with an empty paragraph return at the top of the table too. But it works.

David Creamer: Community Expert (ACI and ACE 1995-2023)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines