Jump to content
Bartek

Scribe Excel Insert Image Syntax

Recommended Posts

Hi There,

First of all many thanks to creators for amaizng plugin.

What is the syntax for inserting images to excel?

ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) 

Do not work for xlsx with error about invalid cell name (first parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample

I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image.

Any suggestions?

Thanks in advance.

Bart

Edited by Bartek
Error in title

Share this post


Link to post
Share on other sites

Hi-

When you tried the standard syntax, ie ScribeDocWriteValue( cell ; image), did you get any errors? That is how you would add an image with Excel. The 'addImage()' format is just for PDFs. What version of Scribe are you using?

Share this post


Link to post
Share on other sites

Hi, 

I did not get any error when using standard syntax.

The image was just not added to the excel file like rest of the data.

I use it for product card generation.

Name, desc, image and i am dinamicly generating table with related extra product fields with definitions defined in category(similar to online store).

Everything works great exept of image insertion.

I am using latest plugin version availible from downloads.

To be sure i also used excel file provided in examples, because i had same issues with files saved from excel as xlsx from ms office (Maybe language settings, no time to get dipper)

Thanks, Bart

Edited by Bartek

Share this post


Link to post
Share on other sites

Could you reproduce the issue and send your logs to support@360works.com? Locations for log files can be found here. You'll need to make sure Filemaker has not been restarted since the problem occurred. 

Share this post


Link to post
Share on other sites

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

  • Similar Content

    • By Aaron Lamperti
      Anyone had any luck getting Scribe to substitute text within a Text Box in a word document?
    • By 360Works
      We get excited about adding innovation to the FileMaker platform! Today we are showing you how to use machine learning in FileMaker to detect objects, scenes, and images.

      This can be useful for FileMaker databases that need to be able to identify objects and characteristics within an image file and report on the findings within the solution.
      Joe Martin, Senior Developer and Product Lead at 360Works, is demonstrating the process in the video below. He will be building off of AWS scripts from Jesse Barnum, President of 360Works, from his presentation at the 2018 FileMaker Developer Conference. See Jesse's past presentation and scripts in "Session Materials".
      FileMaker Image Detection Video and Free Demo File
        Download the Free Demo File

      Download the Demo TXT File
      Want more AWS technology in FileMaker, but no time to implement it into your solution? Let us do the work for you. Email us at infobox@360works.com for consulting or questions.
        Stay updated with 360Works
       
    • By Jonathan Ackerman
      is it possible to append text or images to the end of a loaded doc. (not just another document)-
       
      i.e. something like--
       
      $result=ScribeDocAppend ("new stuff")
       
      it seems the function only looks to append other files, not text
      what i need is to be able to add custom text to the end of some documents-
       
      not sure how to do this.
       
      thanks!
    • By Christian Chojnacki
      Hello, there,
      I'm trying to get the Scribe plugin running on my Filemaker Server 17.
      But I always get the error message:
      Error 474 Plugin could not be loaded: 360Works_Scribe.fmx64
      and
      Error 701 The FileMaker Script Engine process was terminated abnormally.
      I tried Scribe 3.08 and Beta Scribe-3.08009 but both don't work.
      The server runs on a Windows Server 2008 R2 Standard
      JRE 1.8.0_171 (32 & 64 bit) & JRE 1.8.0_171 (32 bit) is installed.
      The permissions are enabled to full access for "Everyone".
       
      Server restart, reassign permissions and restart services did not help.
      Does anyone have any idea why? I can send other log files if needed.
      Thank you and greetings
      Christian
      360Plugins_ServerScripting64.log
    • By brownt
      I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker.  Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked!  And would like to do everything for his business in FileMaker.  His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients...  Well, now I've been asked to see if it can be redeveloped in FileMaker, because my friend doesn't want multitudes of Excel sheets for every project, that he has to paw through when he wants to pull data for his other tracking tools that are in FileMaker.   He'd like to be keeping all the data in one place.
      His partner's Excel sheet basically tracks the date of an activity, a note about the activity (what business or consultant or company performed the activity), what kind of activity it is (each spreadsheet for each project may have anywhere from 8 to 16 different kinds of activity) and how much money was associated with that activity (credit or expense).  Tracking that is not a tough deal in FileMaker, that piece I've already sketched out.  Reporting on it is where I'm having problems, because he'd like FileMaker to produce a report that looks as close to what the Excel sheet looks like, including columns for each kind of activity they're tracking, with activity totals, balances, budget remaining, etc...  Where I'm really really running aground is the fact that there may be any number of different kinds of activity going from project to project.  Some may have 7 different kinds of activity, some may have 15 or 20. 
      I've included a sanitized, example version of one of his Excel files.  I can't wrap my head around how best to do up a report that doesn't have a set number of fields (what would correspond to the columns in his Excel).  I could do it as a great big flat file database and put in fields for every possible kind of project activity, I guess, but.... argh!  
      I would welcome any thoughts on how a report like the one I've included as an Excel file here could be created in FileMaker...  Or if the combined expertise here figures this is something that is best left to Excel (I must admit, my thoughts have drifted that direction as I wrestle with this).
       
      Thanks in advance!
      report.xlsx
  • Who Viewed the Topic

×

Important Information

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