Jump to content

FMP can't import Scribe-modified .xlsx file


This topic is 2597 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I’m running into a problem with FMP not recognizing an Excel file I saved using the ScribeDocSave() function

I’m using Scribe to read an xlsx spreadsheet, search for a value in the first row, and change the value in a cell. Reason being- I plan to import this file using the Import File script step and I need the field name to match exactly (it’s not always in the same column in the first row).
That part works perfectly and was easy to implement. Then I save the modified file to a temporary directory.

The trouble is, if I try to import the modified file into FMP I get the following error:

The selected Excel workbook has an unsupported file format.
Please convert the workbook to the Excel 2007, or Excel 2008 file format and try again.

Is this a known issue, and is there a workaround?
 

I’m on a Mac (OS X 10.9.3)

Link to comment
Share on other sites

A cursory check of Scribe documentation seems to indicate that it uses the newer .xlsx format only and not the older .xls format.

 

The error seems to indicate it wants a .xlsx formatted file.

 

Maybe it is the name of the file suffix, or you are modifying a .xls file with .xlsx file attributes which is causing the error?

Link to comment
Share on other sites

  • Newbies

Thanks Brian,

I'm using .xlsx files from start to finish in the script. What's weird is that I can import the modified file after open/save as/overwrite/close in Excel. It seems like the Scribe plugin corrupts the xlsx file in some way to make it unrecognizable. I'm trying to figure out if this is a known issue with a workaround, or if I need to write an Applescript to do the open/save as/overwrite/close.

Link to comment
Share on other sites

Hey Stewart,

As far as I know, this is not a known issue, but I'd definitely like to check out the .xlsx files before and after the open/save as/overwrite/close operation. If there's some issue with the way Scribe is handling .xlsx files, that's something we should address here, as opposed to you writing an apple script to work around it.

 

Send me a PM so we can open up some dialog on this specific case.

Link to comment
Share on other sites

This topic is 2597 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By 360Works
      Scribe 4 - FileMaker OCR: Extract Text from Select Areas of Documents and Files Automatically
      We are back with a new demo for 360Works Scribe 4 featuring OCR in FileMaker!

      This time our focus is on extracting text from select areas of your PDF document or image file. If you have a stack of files (i.e., forms, receipts, photographs) with text in the same select area and you need to pull this text into FileMaker, you can easily automate this process with Scribe.
      Watch the Video
      In this demo video, we will show how you can use the new drag-and-drop and coordinates functionality in Scribe to extract text from documents and images in select areas, to then store the data in FileMaker automatically.
        Watch the Video   Stay updated with 360Works
       
    • By 360Works
      Scribe 4 - FileMaker OCR Scanning Demo Video
      Today, we wanted to share a practical way to use the new FileMaker OCR and PDF integration features in Scribe 4. If you have a stack of paper with information you need to access from FileMaker, you can easily automate this process with Scribe.
      In this demo video, we will show how you can scan in a stack of paper and extract the text (using OCR) into FileMaker, and have it on individual (spliced) PDF pages.
        Watch the Video   Stay updated with 360Works

      Questions? Email: [email protected]
       
    • By 360Works
      New Major Version Release:
      Scribe 4!
      We are excited to announce a new major version of a popular 360Works plug-in, introducing Scribe 4! 360Works Scribe is the ultimate document automation plug-in for FileMaker; it allows integration with Word, Excel, and PDF documents. In this release, we are taking it to the next level by adding in the ability to read your scanned documents, such as receipts, forms, or contract PDF files, with OCR (Optical Character Recognition) functionality. Additionally, we added features to allow you to merge PDFs and get meta-data from them, plus multiple fixes for existing functionality in Scribe.
      New OCR Functionality
      Scribe 4 ships with brand new OCR functionality to read your scanned documents and extract text to be added into FileMaker. For example, a law firm can scan in loads of paper legal contracts and have the text extracted and imported into the appropriate FileMaker records! Scribe leverages the technology of Amazon Textract which goes beyond simple OCR by not only extracting text but also identifying key information like the contents of fields in forms.

      Click here for a cool demo file showing how to use this new OCR functionality in Scribe!
      New PDF Merge Feature
      We added two new functions to merge and manipulate PDFs with Scribe. For example, if you have a couple of PDFs stored in container fields, the new function ScribePDFMerge allows the two PDFs to be merged together. The new ScribePDFSplice function allows a multi-page PDF to be split up into smaller PDFs. This is beneficial if you have containers with multi-page PDFs, and only need to utilize a specific part of the entire PDF file.
      Get PDF Meta-Data
      You can now get meta-data about a PDF, such as the name of the author and page count. The new ScribeGetPDFAttributes function will return various meta-data about a PDF. This can be helpful if you want to have FileMaker manage PDF files according to the author or number of pages specified in the meta-data.
      Multiple Improvements to Existing Functionality
      We also made several upgrades to the existing Scribe functionality. When using Excel with Scribe, the Excel cell reading and writing images to Excel cells has been greatly improved. We also made fixes for the ScribeDocSubstitute function for replacing a value.
       
      Try or Buy Scribe 4
       
      Availability
      Scribe 4 is available now at the Scribe product page. Active maintenance subscribers for Scribe or the 360Works Portfolio Bundle can download new major version 4 at no additional cost. All purchases within the last 12 months are still under an active maintenance subscription. If the maintenance on Scribe has not been renewed within the last 12 months, you will need to purchase a new license to use Scribe 4.

      For new license purchases, we have several license types available based on number of users, client-side or server-side usage, and a solution bundle license for developers with a vertical market solution.

      A free, fully functional demo is available to test Scribe. While in demo mode, Scribe will run for 2 hours every time you launch FileMaker (or FileMaker Server, for server deployment).

      Full pricing, license type information, and the demo version can be accessed at the Scribe product page.
        Try or Buy Scribe 4     Stay updated with 360Works


      360Works

      Questions? Please Email [email protected]
       
    • By Stickybeak
      Has catalina broken scribe?
       

    • By dmcs
      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. 
  • Who Viewed the Topic

    2 members have viewed this topic:
    Sparknet  normanicus 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.