Scribe by 360Works

Virtal Mac OS X Monterey installation. Trying to install Scribe plugin for server side scripting. However, loading fails each time with Error 474. Email and Supercontainer plugin load just fine. The processor is not an M1 or M2, so it's not the Rosetta approach. What else can I try to fix this? Thank you.

I have an excel sheet with a date 7/29/2023. When I read that cell with Scribe, and create a variable $date, it returns the number 45136. If I then say GetAsDate ($date), I get "?". If I further wrap it as GetAsDate ( GetAsNumber ($date ) ), I get 7/30/0124, which is obviously wrong.

I am putting data into the PDF perfectly, the data that is. Odd problem I have run into is Formatting. I write to some fields on the PDF that are defined as a "Number" with a leading dollar sing and 2 decimal points. However when the data gets written to the field, it truncates "0's" (ie 456.70 becomes 456.7) and also does not add the dollar sign. However if I delete out the last two digits (decimals), tab out of the field, then tab back in and put the decimals back, the formatting applies. Additionally, the "total" field that adds up the number fields always has a "0", it is as if it never updates. I can write a value to the "total" field, but I like elegan…

I have a spreadsheet i can write data from FMPro to. There is a "Header" (row 2) with a bunch of column titles, and a "Footer" (row12) with some text under where i put the individual child data. The "Header" and "Footer" are static, never change (except the sum column which is a formula). There are 10 rows between my "Header" row and the "Footer" row. If there are more than 10 kids data to put on the spreadsheet I need to insert another new row just above the "footer" row, row 12. Is there a way to insert a row on the spreadsheet at row 12, so that it moves the current row 12 down (now row 13)so I can add an 11th child's data to the sheet? I have this …

I'm trialling Scribe for many of our company's document needs and have setup an example process where I have been able to load a Word template, replace all my placeholders with FM data and output an instance of the updated document - all good. However, I was given a curve ball today whereby half of the documents I would be automating are password protected with exceptions, i.e. a bunch of editable areas that appear like this: [add name here]. I've tried opening this protected template using the DocumentLoad[ path ; password=xxx ] but it seems my placeholders are no longer recognised when they sit in Word designated editable areas [inBrackets]. I've tried extra spa…

Hi - hoping someone can help me with this. I'm trying to pass a date from FM to a PDF using the ScribeDocWrite function, but the date value is being formatted as yyyy-mm-dd in the PDF, even though the date format for the field in the PDF is dd/mm/yyyy, so for example when I open the pdf the date reads as 2022-02-22 instead of 22/02/2022. Any ideas how to get the date in the chosen format? Thanks karl.

Has anyone experienced Excel app prompting a recovery alert when opening a freshly generated Excel file from Scribe? I'm currently running FM 19, Scribe 4.0726, and Office 360. I've uploaded new excel files generated from Mac's running OS 10.12.6, 10.15.7, and 12.2. All three files saved through scribe generate this "recovery alert". Attached is a pict of the recovery message from excel ... Thanks David

Hi everyone, I'm trying to speed up my invoice entry and get as much information in there as I can. I scan my invoices using CaptureonTouch (Canon's own scanning software) which also does the OCR processing automatically. I then have a script which imports the PDF to a container and I use Scribe's fileastext command to pull everything out into a field, which is very handy if I ever need to search for any of the invoice contents in the future. What I'd really like to do to take it to the next level is extract text from select areas only and then use the data to populate the fields in the record automatically - such as invoice number, sub total an…

Tried installing Scribe 4.0726 within FileMaker 19.4.2 on my Mac Mini (M1, 2020) running OS 12.1. Unpacking process finished then froze during the initialization. Is this plug-in not compatible with the new Apple M1 chip? Thanks

Hi, A couple of years ago when scribe was at its second version only, someone posted about a problem where scribe returns the file path of an image in Word when using the ScribeDocSubstitute, instead of the image itself. Unfortunately, it seems like this person has been helped by the 360Works team, but the solution to this problem hasn't been posted. I'm currently using scribe 4.0726 on both Mac and Windows and got the exact same problem. I see that some modifications have been made to this function on the 4th version of scribe, may be this might have brought back an old problem? Thanks in advance, Alice

1. Is it possible to work with an excel file that is password protected? 2. What is the syntax to add the password to scribedocload? Thanks, Ed

Hello, I'm hoping someone from 360Works will have seen this issue before and can help. I can ask Microsoft for help as well but I figure you're the best place to start - and I don't have a ton of time to figure this out. I have a FileMaker solution with a script in which Scribe loads an excel workbook, and writes values. This excel workbook has a bunch of conditional formatting. The first three rows are static, but the rest is conditionally formatted, based on the value of the cell in a hidden column, changing depending on the row. The problem is that everything after row three is supposed to be size 11 font, and everything but column A is supposed to be ce…

Hello, I am trying to get Scribe360 to import time values (e.g 08:00) from Excel to Filemaker. In Excel the cells are formatted as hh:mm. In Filemaker I have defined the field as time but instead of getting 08:00, I get 00:00:8 which is wrong. In addition, when I try and format the field in the inspector it insists on using decimal rather than time format. Using Filemaker 19 hosted on Claris Connect. Thanks Kaps

Hi everyone, sorry to bother you with beginner questions, but I am unable to load a .docx document from a container field. As I would like to enable my database for DirectWeb-access, storing my docx-templates inside the database seems easier. For that I have created a table (Files) and container fields (global). One of the latter is the Aktennotiz-field in a dedicated "file container" layout. My script : ScribeDocLoad [ Container Or Url: "Files::Aktennotiz" ] ScribeDocSubstitute [ Search Text: "$Case$"; Replace Text: DBC::Case ] ScribeDocSubstitute [ Search Text: "$User$"; Replace Text: DBC::Operator ] ScribeDocSaveFile [ Select: On; Re…

I've been using the scribe plugin and its awesome. However, I would like to refine my process a bit by pulling the form field names from the PDF so I can build my SQL and then write the data back. I looked at the scribeDocListrFields but that pulls everything. IS there a way just to pull back for fillable forms fields names? The overall scope of this is 125 PDF forms with about 250 different field names. Worst case I suppose I could read all the fields name into a variable and do a ScribePatternMatchAll validation, but just wanted to check if there was something I was missing like: (ScribeDocListFields;"Fillable Form Field Names") …

Is is possible to insert a comment in excel? I don't see it anywhere in the documentation under the DocWriteValue function, but I just want to make sure. This is the problem I'm trying to solve: My client runs a script in FileMaker that uses Scribe to create an Excel document. Overall, the process has been working great, but she's requested something and I'm not sure the best way to accomplish it. She wants to add a large chunk of text (this is something that could take up the length of the screen and then some). If I were to do this in filemaker, I'd have to break the paragraph into however many lines are needed. I'm prepared to do that, but the easiest thing w…

Can we please, PLEASE have a forum channel for scribe?

I am attempting to create a system capable of filling the following element in a PDF form field: I've had good luck with Scribe up until now however I was unaware of this limitation: I'm curious if there is a workaround to this or how others have tackled the relatively limited capabilities of Scribes DocWriteValue function?

I hope this helps anyone that has had to put up with the ScribeDocSubstitute errors when no placeholder string could be found in a document - a problem that has had both us and our clients pulling our hair out. The 360Works Scribe help page - http://docs.360works.com/index.php/Scribe#No_occurrences_of_.5Bplaceholder_string.5D_were_found_in_the_document - offers a solution of retyping an entire placeholder due to the XML creating a split string. We've been doing this, but at times it just doesn't work and we've never seen any evidence in the XML of a split happening. However, today we hit a eureka moment and believe the main problem is not split strings, but the…

I'm looking for the ability to extract all words in a word document that are wrapped in "<< >>", such as Hello <<Name>>, Please respond by <<Date>>.... I would like this to return: <<Name>> <<Date>> I know the pattern match function in scribe should do this, but I can't figure out what to put in the Regex part. Is there a reference that explains this?

Hi everyone. I have a complex used of Scribe I need a little help on. I have a two page PDF tax form page 1 has static company information on it and page two places for 4 peoples names. What I need to do is loop through a found set up records and for the first pass through 4 records fill out both pages and then after the first 4 use the ScribeSplice function to grab just the second page of the PDF and use it to fill out X number pages with 4 records each and then use the ScribeMerge function to merge that second page with the first one. Lets say I have 40 records the end result I need is an 11 page PDF the first two pages using the full 2 page PDF and then 9 more pa…

I have an important application where I build a very large document in optional, themed sections. Currently, my process is to append a template section, make text substitutions against placeholders in each section, and then append another section, until the entire master document is built. However, in practice this means that when I add a new section, Scribedocsubstitute must scan, find, and replace against an increasingly large document - even though only the new (short) section has any replacements to be made. This means that the overall script slows exponentially with each added section. Is there an elegant way to load a section, perform substitutions in *just*…

I can't read all the text in a pdf. Do I need to flatten it first to have all the layers combined? So I tried to do flatten with ScribeDocSaveContainer ( newName {; flatten=true ; type=file } ). But I couldn't work out how to add the flatten option. After you write the file name how do you add the flatten and or type options? This doesn't work: "New FileName.pdf" ; "flatten=true"

Hello I need Help writing to Word Doc with Scribe 1) I am getting a gap between the heading and the start of the list I have tried to research on the Interweb with no joy. I have attached a screen shot with my created Word Document but as you can see I am getting a gap with a single table??? and I have put in the script for what I have done as a noobie to scribe I know that I am missing something. 2) How can I put a forward Slash in between the two words 3) How can I remove the 2nd Word if its the same as the first. I hope somebody could give me light as this is been puzzling me for the last 10days Thank you

Hi, I modified an old script from a solution that exports rows of text fields with 1 image per row to xlsx. I don't know what version of the plugin was deployed with that solution, but images don't work when done with the older $result = ScribeDocWriteValue () or the newer script step. The plugin works without any errors but when opening the file I get "We found a problem with some content...Do you want to to try to recover as much as we can?" The resulting file is only 10K, whereas the image sizes vary from 200 - 600k, so it appears that the images are not being embedded. I'm testing with Scribe 4.03 and FMPA 16.0.5. Thanks, -jb

I have been using the Scribe plugin to insert text into word-based tables as part of an annual report. I am using FM 16 on both Mac and Windows and have the very latest version of the Plugin. I am able to insert the text into multiple tables throughout the document quite well. What is not happening is that the new data is not maintaining the formatting of the table. I would be fine with just holding the correct font and size. Should the data insert into the word based tables retain the formatting and if so what determines that formatting because inserting the data into a fully preformatted table removes all the formatting and sets the data back to some kind …

Can 360 Works Scribe Read and Write data to Word and Excel Documents in the scope of Office 365 and OneDrive? I.e. can I manipulate values of documents and save them without moving them into a container or to the local hard drive? I would like to do this on both Mac and Windows platforms. Cheers!

Is Scribe fully compatible with Filemaker Cloud?

FM 18 Pro, OSX Catalina, 2019 Imac. I've been working with the Scribe plugin for weeks, having developed many complex and successful scripts. While adding to a script (unrelated to 360Works, I believe), my Filemaker database locked up and had to be restarted. Since then, I have not been able to complete the ScribeDocSaveContainer process. When it reaches that point, the following error is thrown: '"$tmp" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk'. I have restarted the OS, deleted the entire Filemaker application and reinstalled it (along with the 360works and other plugins), and…

Hello, We have tested Scribe and are ready to purchase it. But there is a problem with french accents. They do not appear in the PDF form unless with click in the field. Then they appear. I.e. we see 'Qubec' and when we click in the PDF field we see 'Québec'. Same problem on Windows and Mac running FMP 18 latest. On Windows server FMS 18 latest also. Thank you.

Hi, I use a lot of 360works plugins happily but I have found something I can't figure out with the Scribe FileAsText function. Here's the set-up: FM 12 Server Advanced -Middle Eastern version from winSoft (I need Arabic text among others for this db) FM 12 Pro Advanced -Middle Eastern version from winSoft (I need Arabic text among others for this db) IWP -hosted database on a Windows 2008 Server; SuperContainer is installed on this server. SC is working fine. text fields are set for Unicode storage. I use SuperContainer to browse and upload a file with Russian text. I use a script that contains error trapping and the two essential functions: #extract …

I'm trying to ScribeDocWriteValue a "form requester" name to a PDF. My FM field is populating correctly using Get (AccountName). After I write the value to the PDF, instead of the expected account name, the value I get is "0.0". Just wondering if someone can replicate or please confirm this doesn't work? Cheers

I am trying to get the new feature of inserting an image into word document. I am using the following format below but the result produces the filepath to the image in the container not the image itself ScribeDocSubstitute("[placeholder]" ; myTable::myContainer ) Result looks like this remote:7onwjqa8uf.jpgsize:461,64PNGf:Secure/98/C6/B9742F96/C1E5C3E5/2E9E6584/6695

So I am having trouble adding an image from a FM Container to my word document. I'm not having trouble replacing any wording on the document, only adding an image. I get a weird result as shown on the attached images. Not sure what I am doing wrong, first time I'm using this plugin. I have the demo version so to test out my needs. Thanks

First off, I love 360Works plug-ins and Scribe. We've had a very successful deployment that has saved us lots of time thanks to this great utility. All I'm missing now is the ability to downsize the size of the font that goes into some of the PDF form fields because of extremely verbose answers that wind up getting cut off when the form is printed. I've tried downsizing the type in the database and in the calculation that sets the field. I'm thinking this may be a function of the PDF form template, but I don't have Adobe Acrobat Writer. I'm on a Mac. Let me know if there's a way to do this outside of altering the original form with Adobe Acrobat Writer. Thank you.

I'm having problems reading data back from a file I have just written to with Scribe. I load a file from a container. Write to the fields with Scribe. Save it to another container. I then (have another button that ) queries this new file for some totals. It returns empty values. Though If I save the file to the desktop, open it and when I close it, it asks me to save it (though I make no changes), so I do. I then put it back in the container and I am able to get the totals with Scribe. Is it because it isn't closing/saving the file correctly? Any suggestions why this is? Thanks in advance.

When using ScribeDocAppend with a file that contains images-- all images (in saved word doc.) do not display and a red x appears with message- "Picture Can't be Displayed") The pictures are signatures in .png format Any ideas? or another solution-- trying to append the signatures dynamically at the end of the working document depending on the person creating the document. hoping to be able to merge for a document (vs. just append an image) since it also contains the text-"Signed by" and dynamic date thank you!

As suggested in the documentation, I'm using ScribeDocSubstitute to insert an image from a container field into Word. This works. I'm inserting it in a table and it can only be 3cm wide. The image ends up coming in to big & the user has to scale it in Word to fit the cell. I can send the image resized with GetThumbnail. This works but is low res. How can I push the image to Word scaled to fit but keep the picture quality? thanks

I am trying to fill PDF fields using the ScribeDocWriteValue command in my FileMaker app. It works for all but one of approx. 50 fields. The one field that I can't get it to work with is a textarea style PDF field instead of an input style PDF field. Does ScribeDocWriteValue work with textarea style PDF fields? If yes, what's the trick? If not, is there another alternative approach? I've tried setting the ScribeDocWriteValue value to a field value before issuing the ScribeDocWriteValue command. I've tried setting the ScribeDocWriteValue value to a variable value before issuing the ScribeDocWriteValue command. I've tried setting the ScribeDocWriteValue v…

We have a customer who uses Scribe. FM 15. Plugin version 3.08 They have a file that is saved in a container and it is working fine. They export the excel file from the container, open it in Excel and make changes and then save it again. They upload that file to the container and Scribe goes through the process as if it is writing the data to the file but when you open the file after it is saved to the desktop, the file is empty. But if you perform a CTRL ALT F9 in Excel the data shows up. Has anyone else seen this issue? Thanks, Mike Ahern