Jump to content

Search the Community

Showing results for tags 'scripting'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 48 results

  1. I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether Ican make it faster with the help of FM Bench. I tried to apply it to a set of 50,000 records of randomly generated data. Then I made it much faster… Read more at honza.24uSoftware.com
  2. I've been inserting small bits of data from Filemaker Pro into other systems we've written for some time using "OpenURL". However, this approach works, but leaves you with a browser window open, and isn't able to see what the other system returns. So moving to the "Insert from URL" script step instead. This seems to work fine when the "Insert from URL" is the only step in a script, but it doesn't complete satisfactorily when "Insert from URL" is one of multiple script steps. What could be happening? My first thought was that perhaps the script step isn't given enough time to complete, but now I'm not sure that's the answer.
  3. I have a project where I need to make a value list of dates based on start date and end date. Once I have a value list I can then select a value position based on other criteria. a date range on the record may be: (start) 1/1/2014 to 4/15/2014 (end) The list created would always be for the first day of each month for the duration of the date range: 1/1/2014 2/1/2014 3/1/2014 4/1/2014 I'd like this to occur as a calc or CF, I'd rather not script this to create a variable because there may be a few hundred needed to generate. Thanks, David
  4. Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled, depending on the choice I would like a specific layout to appear for data entry. These layouts may have some fields in common with others but never all. Put another way, if I have Item_Field, and user clicks A, I would like the layout for A to appear natively or show up in a portal below. When they click new record, it reverts to the main layout again. I might also need this process to be iterative i.e. several levels down. If this involves CASE scripting, that does not scare me, I just need to know what to look for in the reference materials as to what this process is called. Any help would be appreciated. Thanks in advance.
  5. A couple of questions... I have two tables Customers, and Customer Employees. Customers is the parent table to Customer Employees. On a layout based on Customers there is a portal of Customer Employees on the right hand side, and fields which contain more details about a given Customer Employee on the left hand side of the layout. By clicking on a Customer Employee in the portal, a global field in the Customers table is set to the primary key of the Customer Employee which creates the relationship that displays the details about that Customer Employee. When creating a new Customer Employee record, a set of global fields are passed to the server through the script parameter as a list and then parsed by the server. I want to have the primary key of the new record created to be the new value in the global field in the Customers table so the user sees the details of the new record created. It appears to work simply by having the server set that value, however will this work with multiple users creating records simultaneously? Will each user get the value in his global field for the record he just created, and only that value? Secondly, I understand that a PSOS cannot be called from a script running on the server. Does that also imply that a field with a modification trigger cannot run a PSOS if that modification results from a different PSOS? Thanks.
  6. The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000. This version of the example has FM Bench Detective script steps included to measure the original and the optimized script more precisely. Watch the video recorded at Pause On Error below to learn more details about this optimization. Read more and download the sample file at honza.24uSoftware.com
  7. I need to create and run a scheduled script (or script sequence) that will give me a list of what accounts are logged in, then change a field in a record for each account holder. Any resources anyone could point me to for learning how to do this?
  8. I'm converting a very old invoicing application in DOS (written in 1990) that is still used everyday at work, to a Filemaker Pro database. The default invoice starter solution in Filemaker Pro 13 will do perfectly, but importing the 20 years of data is what's bothering me and I really could use some tips & tricks. The old database files are .dbf (dBase) files, which Filemaker pro can import, but the old database has a few different columns. The customers are already imported, but the invoices table is a real problem. The old database uses one table, and Filemaker uses two. An invoices table and an invoices data table. This is a very basic visual representation with left the old table, and right the filemaker tables: Problem 1: The TEXT column in the old database (left) contains the invoice data in plain text (on each new line a new product, with the count and unit price). Like this: What I would like to do is parse the text (regex? pattern matching?) and insert it as the invoice data in filemaker. Or is there a better way to handle this? If this is too hard in Filemaker, maybe I can convert the dbf files to a more usable format and write a script to recreate the table in a more usable way. The total & VAT will be automatically calculated by Filemaker. Edit: The TEXT often contains additional lines of info and other text, making it VERY difficult to parse. I would like to know how to insert the whole text block as one item in the invoice and set the TOTAL AMOUNT value as the item price (and use no VAT, so it becomes the final price of the invoice). This is a bit messy, but the important thing is that we can still see/search the past invoices of a client and have an idea of the invoice data. It will be a bit messy that every invoice has only one invoice item in it. Problem 2: In the old db I have a column PAYMENT_CODE which is blank or set to 'B' if it is payed. When I import the data, can I use if/else structures to set the paymentstatus to payed if the value = 'B'? How would this be done in an import script in Filemaker? Problem 3: How do I insert a default value for columns that I don't have data for while importing? For instance, the VAT checkbox has always to be checked (= value 1), the VAT amount is always 0,21, ...
  9. When I set a variable this way: Set Variable [$StudentIDs = ""] the actual value of $StudentIDs is 0, not empty or blank. So it fails the IsEmpty test. Is this by design, it is a bug or am I doing something stupid? - Brad
  10. Have you ever inherited a system built by someone else, changed a field’s name and everything stopped working? The issue, hardcoded names used in indirection, makes the system fragile. FileMaker provides developers many methods to add flexibility using indirection. However when these instances of indirection are not treated properly they will raise all sorts of problems. In this article you will learn best practices regarding indirection that will help you build a dynamic and robust FileMaker system! Includes free sample file! Building a Dynamic and Robust FileMaker System David Happersberger www.dbservices.com
  11. Hi there, first post from a n00b in filemaker, hope the question isn't too dumb... I'm a dba in mssql and oracle but as said new in filemaker. I'm wondering if it's possible to generate filemaker tables using a script à la http://msdn.microsoft.com/en-us/library/ms174979.aspx ? I would feel much more comfortable porting my solutions from development to test and later production by recreating the database/solution using a script. But, perhaps my old ways made me blind; if this is a stupid idea can someone explain to me what would be the filemaker way of doing this? Thanks in advance for your time, Regards, Bert
  12. Okay, so here’s the deal: my client wants a system that will allow him to recover all his FileMaker 11 databases within half an hour, in the event of a crash. It’s all working beautifully, all run out of a tiny database that simply imports the most recent data out of the Source File (e.g. the one that just crashed) into the Target File (e.g. last night’s backup). It’s very modular, less than 1 MB, with only about 400 script steps in the whole thing—and about 40% of those are a bunch of If/Else Ifs to import each table appropriately. Obviously, after each import, I want the primary key in that table to be updated appropriately. I can’t perform auto-enter options while importing, because the modification account names, timestamps, etc. are very important to their versioning process. (Okay, I could import each table twice—once with auto-enter options on, once with auto-enter options off—but that will significantly increase the time it takes to run.) So, I decided to use Set Next Serial Value to update each serial number after the import. Here’s the problem: while Set Next Serial Value has the same options as Set Field—specifically, “Specify target field” and “Calculated result:”—they don’t seem to be working the same way. With Set Field, you can leave the first option blank and it will operate on the active field on the current layout. Trying to do the same thing with Set Next Serial Value returns an error #102, “Field is Missing.” Can anyone confirm that this is expected behavior? If so, does anyone know of a workaround besides the obvious, i.e. placing an explicit Set Next Serial Value step after each of the already explicit imports? Thanks!
  13. Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes that I have available to me. They can only be assigned to one SKU and once assigned, needs to be removed from the available selection of barcodes in this pool. Issues I wanted to set a placeholder text for 'EAN-13' field in the product layout (this is the barcode). This field is a button! When clicked it can perform a script to open a popover or window containing all barcodes that do not have a 'ProductOptionID' assigned to it. How do I structure this script? Click the EAN field button - this sets the 'ProductOptionID' variable globally (is this correct to do) - [$$productOptionID] The script then opens the object 'Barcodes'. This is a popover button with a portal inside filtering all barcodes from the pool that do NOT have a productOptionID value in the foreign key field The script must then pause whilst I manually select a barcode and set a $BarcodeID variable? Or should I script it to pick a barcode at random from the pool of available barcodes (i've already set a script to give available a figure of 1 and unavailable a figure of 0) Then the script must put the BarcodeID variable in the product option record Is the above the right way to go about it? I also need a way to un-assign a barcode from a product and therefore remove the value from the product option id field in the barcode pool I have one more query. I have a relationship between Product Option table and the Barcode Pool. This relationship is O2M the barcodeIDpk with a lookup for the actual EAN (barcode) value on the Product Option table. When I set a barcode ID in the Product Option table - shouldn't the ProductOptionIDfk field update in the Barcode pool with the ID of the product option that the barcode is assigned to?? I am convinced I had it working earlier - but not anymore and cannot see to figure out why? See my relationship graph below and the solution attached. Thanks, Luke CRM Trial barcode.fmp12
  14. Hey Everyone, I've been doing a lot of Pause/Resume script steps in a solution and I've got somewhat of a hack for the task I'm trying to accomplish, but I'm wondering/betting there is a simpler solution. For example, the work flow works something like this. There are Three tables Invoice, InvoiceItems, and Products. The user is looking at the Invoice Layout and adds a InvoiceItem. Then, they need to pick a reference Product. From this point, I have a button on the InvoiceItem record that says "Add Product". I run a script that shows another "pop-up" window with a List View of Products with pictures. The Script is Paused. Each record has a button that says "Select". Once the user presses the button select, the window will close and the the Product ID is linked to the InvoiceItem. The trick is to get the Product ID before the pop-up closes and save it to a variable. When I have the "Select" Button with script Step Resume Script it doesn't seem to enter/access the listed record I am selecting and therefore when I try to set variable ProductID = $ProductID...$ProductID is empty or the wrong one. I have a few hacks to work around this by splitting the script into two scripts, but I'm not totally happy with the solution and I'd prefer to keep it all in the same script. Any ideas? Thanks!
  15. Hello, I continue developing the POS and so far I have almost got everything to work as desired. However, there is still a functionality I will like to add. Right now I have a portal on the left which shows all the products pictures in grid, and when I click on the picture the script trigger adds the related item to the line_item table on the invoice. So far the script looks like this: Allow User Abort [ Off ] #--------------Set Variable Product ID Set Variable [ $PRD_ID ; Value PRODUCTS::ID_Product ] #--------------Add new item to portal Go to Field [ LINE_ITEM||id_invoice|::Product ] Go to Portal Row [ Last ] Set Field [ LINE_ITEM||id_invoice|::id_product ; $PRD_ID ] Go to Field [ LINE_ITEM||id_invoice::Quantity ] END So what I would like to achieve now but I am not sure how, is to set the script so before it adds the related record to the line_item portal, it will check if the product has been already added and: a) If it is not, then it should add it with quantity set to "1" b) if it is already in, instead of adding it as a new row, it should add +1 unit to quantity. Is this possible? Thanks a lot for your help! Luis.
  16. Not sure if this is the best neighborhood for the question, but it is tied to network/db security. What method is used to best determine how a user is logged in? Is Get(MultiUserState) the best method for determination of who/how someone is accessing a locally shared (peer-shared) database? For licensing purposes, we run several authorization scripts during login, and it is helpful to know how the access is working.
  17. I have a simple Applescript that works in Script Editor tell application "Keyboard Maestro Engine" do script "Search the Web" end tell I add this same script (with escape chars) to my RESOURCES::A_SCRIPT field inside FM. The RESOURCES table is not connected to the other tables in the graph. "tell application \"Keyboard Maestro Engine\" do script \"Search the Web\" end tell" I've tried this with this field being defined as a Global Storage Field or not. Similar problems with both. I have an FM Script called EXECUTE: Perform Applescript (RESOURCES::A_SCRIPT) When I run this FM Script I get an error message: "Error: -2741" / "Expected EOL but found Command Name" I've have tried rebooting my Mac. Any ideas?
  18. I have been away from FMP for a long time, and am now jumping back in. RIght away, I ran into a problem. This is a simple script step to increment a counter, but it does nothing. Case (PETER ZIPPI FILE::SOURCE OF INTAKE="STRAY - AT LARGE"; PETER ZIPPI FILE::Q1 Strays=PETER ZIPPI FILE::Q1 Strays+1) The record has the right data in the SOURCE OF INTAKE field, so why doesn't this increment the counter? Feeling stupid in LA
  19. One of the most important and wide-reaching updates in FileMaker 16 is the ability to set cURL options in the Insert from URL script step. This allows FileMaker to natively integrate with innumerable services across the web, including Google Calendar, Google Maps, Microsoft SharePoint, and many other services. FileMaker cURL Options David Happersberger dbservices.com
  20. This is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. You can find the original article here: FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds I simply took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens in the slow and the optimized script. Now you can watch the result in this video recorded at Pause On Error. Read more and download the sample file at honza.24uSoftware.com
  21. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
  22. Is it possible to grab the current users password via script just like Get(accountname). I know this might sound like a strange request but the scenario I want to try and achieve is to re login from a mobile database to server with admin privilege run a script then relogin with the user account and password for the actual user. I would like to do this hidden and seamless. Yes i know i can run a script with full access privilege its just that my sync routine is only working with admin login not other user login and i just cant seem to find the solution as to why, however, this workaround does work as I have tried it albeit i manually typed the password back in for the user just trying to avoid that part.
  23. Dear FileMaker Pros, Perform Script on Server (PSoS) Doesn't Run I run FMP 13 (on Windows.) I import records to my Hosting FM Server from my Client. Running the script steps from the Client works well, but its a time consuming task of more than 4 hours, the records are big, almost one million. To save time, I switched the script to Perform Script on Server, (wait for completion, unchecked.) The script does not perform Import records, as it did without PSoS. My script steps on the hosting Server Db: ScriptName:"Import A" > Go to Layout ["Part_A"] > Go to Field [Select/perform; Stock_A::Field_A] > Go to Record /Request/Page[First] > Import Records [No dialog;"Receive_Gen"Add;Windows ANSI] My Perform Script on Server on Client: > Go to Layout ["Part_A"] >Perform script on Server ["Import_A"] > Go to Record/Request/Page [Last] Note: Unchecked - wait for completion Would appreciate your comments. Thanks in advance Lawrence
  24. I’m working in a database that needs to be moved to the top of the display when a certain layout is entered. Obviously I’m using a OnLayoutEnter trigger to call a script including the step Move/Resize Window [Current Window; Top: 0]. Unfortunately, this doesn’t work reliably because almost every user has a multi-display setup and places the database on the larger (not necessarily primary) display. So, when it sets the window top to 0, it uses 0 from the primary display, which is only very rarely identical to 0 on the display where the window actually resides. Anyone have any bright ideas for moving the window to 0 on the relevant display? (Note: cross-platform, FM13 solution.)
  25. I am scripting the import of data into some 400 tables already established. I have the corresponding 400 seperate data files (excel cvs). The script step "import" doesn't seem to allow the selection of the "current table specified by the layout" as a target. I goto the different layouts right before the import but the import does not change to the table that is used by that layout. When writing the script I do select the "Current Table "mytable" " as the target, thinking that this would change during execution. Nope it don't. Soo, 1) Can I have a dynamic selection during script execution of target table for data imports. 2) How does FM select the table when doing an import. It seems that the choice is very explicit. 3) Recommendations on other ways to accomplish the task. Cheers
×
×
  • Create New...

Important Information

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