Focal Point
[SOLVED] Webfocus and G-Suite

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2717092096

June 01, 2018, 04:29 AM
JACQUETL
[SOLVED] Webfocus and G-Suite
My company will give up MSoffice

Does anyone try to link webfocus to Google Suite (Slide, sheet)

succeed for example to generate a G-sheet directly ?

Do you have feedback ?

This message has been edited. Last edited by: FP Mod Chuck,


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
June 01, 2018, 07:12 AM
Frans
Yes you can generate G sheets directly, but not as a output format, but writing it to a API: https://developers.google.com/sheets/api/


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
June 01, 2018, 07:21 AM
JACQUETL
oh well thank you for link


Webfocus 8.201M.
Windows
InfoAssist +
Chrome, IE, Excel, HTML; PDF, AHTML,GRAPH
June 01, 2018, 11:33 AM
CoolGuy
Nice tidbit Frans. Very interesting. Appreciate the share.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
June 03, 2018, 05:05 PM
Waz
I have done a prototype, and it requires Google Drive to be installed, and you create an XLSX (in my case) and "upload" it to Google Drive, which makes it available to be opened in Sheets. Then just open it in Google Sheets

I am told that Google Sheets is a proprietary non-published format. So you will either have to create an XLSX and upload it or try the API.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!