6 posts in this topic
Scribe ScribeDocSubstitute Errors - A solution
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 use of Tracking under the Review menu in Word. With this switched on there are hidden occurrences of the placeholders in the XML that are referenced by ScribeDocSubstitute. We have had documents where the placeholder(s) has been typed, retyped and typed again (etc.) but could not get around the error (we have a check that runs whenever we upload a Word template to FileMaker container fields, therefore documents that generate these errors are not allowed into the database). However, we've now been able to clear all errors within a file without retyping a single placeholder as follows:
open the file generating the errors in Word, click Review, click on the arrow beside/below Accept, select Accept All Changes and Stop Tracking, save the file and test
We've been putting up with the placeholder problems since we started using Scribe and hope this helps people avoid the pain we've been through.
Andy - salefaith.com
Container Fields and Printing
In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens).
The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.
FileMaker 14 as data source to MS Access
I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3. What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12. I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error. Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)? The error I get appears on the attached screenshot.
Is anyone currently doing this?
Thank you in advance.
Export Records to Existing Excel Spreadsheets, Is it Even Possible?!
So the company I am working for just picked up a huge contract with a cruise line, where we are going to be surveying some of their hardware and other equipment, guess who has two thumbs and is the lucky son of a gun to make the database for this project? This guy!
Anyways, I can't really go into detail for legal reasons, but I can explain what I am looking for.
I'm wondering if there is a way to export the records from the database in filemaker to an existing Excel spreadsheet, and the biggest reason this is the route I'm trying to go is, I based the solution that I've build thus far on the spreadsheet deliverable that they had given us at the beginning of the bidding process. There are several fields in this deliverable that have the same name, which in Excel is no problem, but we work with Filemaker lol, so there's that. Anyway, so I have about 5-6 different types of fields that share the same name in the spreadsheet that i cannot allow in filemaker, so I cannot just set up an export to create an excel document, or else the client would most likely be very unhappy with the deliverable that they receive. So i want to know if there is any way to throw all of my records into the spreadsheet that they gave us starting at a specific cell for each of the 8 (I think it was 8) worksheets in the file. haha the more I type and am reading what i type, the more impossible I feel like this would be.
Thank you to anyone who can offer some help or insight, it is greatly appreciated!
Exporting fields' headers
By Auch info
We have a table with more than 15000 rows (museum inventory application). We used to export large amount of rows (some times like 900) to modify several fields in every rows then import it back (with version 8.5 of fmp). Now that we migrated on FMS14, it appears that it is not possible to export the fields' names in the tab file as first line. Is there a way to get the headers in the exported file ? if not please consider adding the possibility in next release.