2 posts in this topic
By Peter Barfield
Not sure if this is the relevant area however, I couldn't seem to find a scripting section
What I would like to do and I have had no success so far is the following scenario.
I have database which stores references to files in container field located on a folder on a shared computer.
What I want to do is have a script which when run populates the database with the names of those files located in the folders on the computer and create a new record for those not already present and if they are already present ignore the import.
I have tried a test script which gets the documents path and loops through each record however I get file unknown when debugging and that is as far as it goes.
The script in no one handles the above scenario of omitting and inserting only new docs it was just a test to see if it was possible to import via this method. From what I can see the script is asking for a particular filename and if it can't be found it throws the error. That though is no good as essentially the filename is in a sense unknown at the time of import and that is what the purpose of the script would be i.e. too find those files and create a new record with reference only in a container.
Documentation on this is either non existent or sparse and confusing to say the least (or at least that's how I find it)
Any enlightenment would be appreciated.
Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year
the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better
searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!
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.
Thanks in advance.
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])
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.