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 126.96.36.1993
Excel 2010 and Office 365;
360 Works Scribe 3.08 and Scribe 3.09
FM Server 188.8.131.524
Microsoft Windows Server 2008 R2 Standard
Version 6.1.7601 Service Pack 1 Build 7601
Could you help me please?
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 184.108.40.2062
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
By Little Mighty
I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards.
I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other.
I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script.
Does the above make sense, and could it be done via a script?
Thanks for the help - really appreciate it!
Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue)
My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
I am making cutom import and export from/to excel documents.
Is there any way to merge excel cells in scribe?
I can easly find out which fields are merged when importing.
two nested loops and if second col or row is empty while reading i consider it merged.
Problem is while exporting.
I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical).
Thanks in advance for any help.
Have a nice day.