Bartek

Scribe Excel Insert Image Syntax

4 posts in this topic

Posted (edited)

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 menno
      When updating any 360works-plug-in it is deactivated after any update. Sometimes it does not even is replaced.
      I have created batch-scripts to shut off FileMaker and then remove any 360works-plug-in.
      After that my user(s) have to restart the application again and the new version of (any) 360works plug-in is installed correctly and activated automatically.
      I also use other plug-ins by Troi, Dacons en Goya simultaniously and these work perfectly fine and also will be updated and activated when a newer version is being installed. Only the 360works-plug-ins fail to update everytime.
      I use the script-step "Install plug-in file" so nothing exotic is done there.
      The problems occur on windows 7, 8, 8.1, 10, 2008 and 2012. On the 32 and 64 bits versions (2012 - 64-bit only)
      Any suggestions or anyone else has the same trouble?
    • By cchaski
      I am using Scribe to extract text from a pdf. The pdf has a filesize of 705542 so it is fairly large. The Scribe result is fairly good but it has a serious problem: a space is inserted into words; see example of words like NE W YORK AND NEW JERSEY, airp orts, Inte rnational, Internat ional
      Why does Scribe do this? Is there a way to fix it? (It is close to a dealbreaker if you can extract text but then not use the text that's extracted)
      Many thanks in advance for your replies, as I certainly hope I can use Scribe since I've used 360Works products for years and Textractor before Scribe.
      Carole
        
        
        
       
    • By slbr549
      I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. 
      I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"
      What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on.  I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value])
      Thanks.
       
    • By TaiChi56
      I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
      Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
      Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.
    • By fm8443
      I have 4 Tables of Sales Records (1 per Store) for the same 1000 products (each sold in the 4 Stores).   Table1 (T1) has 30,000 records T2 has 50,000 records T3 has 10,000 records T4 has 10,000 records   The fields in the 4 Tables have different names and contain similar “core” content.   Tables are added to each month with additional records (imported into FM 14 Pro Advanced from Excel).   Unfortunately the same Products are named slightly differently in each of the 4 tables.  Each store / table has a (text) Product-ID but (for the same product) it is different per store. I do want to rectify this “naming problem” (perhaps in a Table #5?)  so I can produce a report showing sales for each of the 1000 products across all 4 stores (grouped by date etc.) I’m not sure how to structure/carry-out this in Filemaker most effectively.  Any ideas?   Ultimately, when the data is clean, I want to upload ALL the records (e.g. 100,000 records) in one export into one Excel spreadsheet so I can run a Pivot Table (Cross-Tab) report.   Do I need to combine the 4 Tables into 1 Master Table before doing an Export on the Master Table? If so, how would I do this?   Thanks for any ideas about this?