Does anyone have experience and/or success using a 4D database as an external datasource through ODBC. I can add the system DSN and add it to FMP. Once I attempt to view the tables in the 4D database, I receive an error that the "ODBC connection is not compatible". Does anyone have a work around or suggestions? Thanks!
By Franziska B
Dear 360 Works Team
In our FileMaker Solution we want to create an Excel report including text, numbers (dates) and images via Scribe.
The FileMaker export of text and numbers works fine. But we have a problem with the export of images in the xlsx.
After the Creation of the Excel reports all text- and number elements are in the .xlsx but the image not.
When we open the generated .xlsx, Excel shows the attached error massage:
For the export of the pictures, we test following script commands:
ScribeDocValue[Name:“F5“;Value: table:: cell]
SetVariable[$PicXYZ; Value: ScribeDocWriteValue("Table1!F5", table::cell)]
Do we make a mistake, or could this be a known bug?
FileMaker Pro Advanced 184.108.40.2063
Excel 2010 and Office 365;
360 Works Scribe 3.08 and Scribe 3.09
FM Server 220.127.116.114
Microsoft Windows Server 2008 R2 Standard
Version 6.1.7601 Service Pack 1 Build 7601
Could you help me please?
By Christopher Gauntt
I installed FileMaker Pro ODBC drivers, and was able to access the data with queries from Microsoft Excel.
However, when I tried to access the same data with the same driver using Microsoft Visual Studio 2015, it could see the table occurrences, but it couldn't find any of the data columns. It came back with the following error:
" Error at Data Flow Task [ODBC Source ]: There was an error while trying to get schema information. Table has no columns."
I got the same error, no matter which table occurrence I selected.
Has anyone else run into this and solved it?
I have been google searching without much luck. Although I found one post of someone who claimed they were able to do it with Microsoft Visual Studio 2017, so maybe an upgrade is in order?
Thanks in advance,
By Christian Chojnacki
we use your plugin Scribe for editing Excel files in our Filemaker solution.
Since a few days we get an error message when calling the method "ScribeDocLoad" (see appendix) for newer Excel files.
Older Excel files from the beginning of 2018 are not affected.
So we wanted to ask if there might be a problem with the error in Scribe.
We are currently using:
Filemaker Pro Advance version 18.104.22.1682
Microsoft Excel 2016 Ver. 16.0.9029.2253 64-bit
Scribe version 3.08
In the appendix you will find an Excel file that throws an error message when opening with Scribe.
With kind regards
Click to choose files
In several tables of our solution there are records being created that have something like, "com.prosc.jdbc.JDBCUtils test d81e5f35-4f7c-4c53-92c1-bc32e3700094" in every field. Today I found 3 tables with collectively 150 records like this... this has been happening on an irregular basis since mirrorsync was implemented several months ago. Is this coincidence or something someone has seen before?