Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About DPaquin

  • Rank
  • Birthday 02/01/1960

Profile Information

  • Gender
  • Location

Contact Methods

  • Skype

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Is there a reason for not being able to loop on selected records of a go to relation? Or is there a way to make those selected records being something like in the present case page 1 of 3 for record « solo 0101 », page 2 of 3 for record « solo 0305 » and page 3 of 3 for record « solo 0306 »? I am thinking of something, is it as simple as changing print setup i.e not use related records in the print. I want to avoid printing 300 pages for no reason. thanks. Daniel
  2. I've got very little experience in working with "go to related records". I've managed to get to print Customer and Merchant invoice. I'm having difficulties in printing QR-Code Coupon. When comes the time to print the coupon there are 3 records in the "Data Invoice" table. I am trying to print each of those three records as individual coupon. The expectation for this request is to produce 1 Customer invoice, 1 Merchant invoice and 3 QR-Code coupons. At the moment, I only getting 1 Customer invoice, 1 Merchant invoice and 1 QR-Code coupon. I've inserted a loop in order to print each of the 3 coupons and for some reason it does not work. Would someone have an idea why I cannot print those three coupons? Thanks in advance! TSP100_InvoicePrinting.pdf
  3. M. Decorte, could you help me about this topic? Thanks!
  4. I am about to upgrade from FileMaker Pro 12 to FileMaker Pro 16. The readings seems to suggest to have High Sierra as the OS. I currently have Maverick and need to upgrade the OS for FMP 16 to be installed. I was going to upgrade to Mojave but believe I would be better with High Sierra. There seems to be issues with FMP 16 and Mojave. I would appreciate getting your advise. With regards! Daniel
  5. Hello, I do want to upgrade from Filemaker Server 12 to version 16. At first I've wanted to uninstall v12 but cannot access to the console. I get screen saying "Cannot start the Consol, managing Admin Server not available? Does anyone have an idea of why I cannot start the FMS 12 Consol. Thanks! FMS-ERR.tiff
  6. I need to be able to execute VLC within FileMaker Pro. The clip to be displayed is to start and to end at a certain time. I have been able to do it using the following under MAC Terminal. Unfortunately, VLC starts but not at the correct place. I've created a variable $paraVLC which contains the "start, end time values to be used by VLC as video parameters. Would any one have an idea how to pass VLC parameters when using perform applescript? Thanks! printVLC.pdf
  7. DPaquin

    QR code

    I’ve got no experience in this. I use scriptmaster which I believe used JavaScript. Is it kind if the same? I’ve quickly look at QR code java script self contained on the internet and it’s says compatible with such browsers (Safari, Chrome...). My application is FileMaker Pro stand alone application how a JavaScript self-contained run in such application. As you can see I have wears questions because I’ve got very low knowledge in this. thanks again!
  8. DPaquin

    QR code

    Thanks Comment, this is very helpful. It has to be self contained since I do not have access the internet. It’s being used in a closed network, the wifi network connection is turned off and no computers are connected via Ethernet wire (rj45). Does this eliminate option 3, I am guessing this option requires internet connection when the QR code generator is being launched. I need to ensure all cameras from people intelligent phones and tactiles tablet can interpret the code at all times. Does this eliminates option 4, because requires a lot of programming and there is possibilities of missing some codings. I also have only one week to program this functionality. We are then left with option 1 and 2. One or two computers (future usage could be one or two iPads) would connected to a Filemaker server via an ethernet cable (rj45). As an exemple, then QR code would be displayed on the iPads and the user would use the camera of their intelligent phone to scan the code. Does this help, I may have to buy a plugin. What would available at a reasonable cost? I do not know about the bar code from an API (Google charts). Does it need access to the internet when being executed?
  9. DPaquin

    QR code

    I need to generate QR code within FileMaker Pro. I’ve been looking on the internet but I am not sure on what to do. QR code are to be generated in the background. Customers would make their order and part of their receipts a QR code would be printed. By pointing to their QR code with their intelligent phone some triggers would be activated. Then my need is to gather customer information generate and provide the customer invoice with a QR code for him to point when the product is ready. I would appreciate in getting your advise on getting a FMP generate QR code function. with regards! Daniel
  10. Thanks Comment! I've recoded my script using your recommendations. Everything works fine and it's for sure does simplify the process. With regards!
  11. Thanks Comment! I will look at changing options in that table. I need to ensure records are not written when duplicates. Those possible duplicate records need to be removed without any human intervention (ie in the background).
  12. Thanks Steve for your answer. This is a very short version of a long script. I've tried to remove all unnecessary steps but seem to have kept some like the loop one. The purpose of this script is to copy files recorded on SD cards which had not been previously loaded. The names of the files are always 00000.mts, 00001.mts, 00002.mts, 00003.mts.... First step is to make each video file name being unique. To perform this action I use an applesccript function which always added the date and time the file was created. Then 00000.mts becomes 00000.mts20190728030252, 00001.mtsxxxxxxxxxxxx.... All of those names are being kept in the infile table until the project is completed. The purpose of the find function is to make sure I will be keeping only one instances of each files recorded on the SD cards. In the present exemple, there is only one file which have been loaded 00001.mts. First time the script is executed the file 00000.mts20190728030252 does not exist therefore is to be loaded on the the table. Second time the script is being executed the file $foundfilemts contains 00000.mts20190728030252 and a find is being performed with the criteria infile::fileUniqueName equal to $foundfilemts. In the case the file is found (already exist) only one record belonging to that file will be kept, the other will be removed. I am not always using the same SD cards for recording videos, therefore when collapsing videos together the same name will be found. To avoid deleting video files inadvertently I add the date and time information to the each video name file. The expected behaviour is to by continue the step if the file does not already exist and to only keep one if already exist. Removing duplicate records will be the next function I will be coding. I've looked at the use Set Field instead and I am not sure how I will be able to accomplish what I need to do. THANKS!
  13. For some reason the perform find function always return the execution as the "record existing". The first execution, there is a record which is different than the one being found. The expected response was "missing record" I've left the new created record in the table for the next attempt. The expected response was "existing record". This is what I've got as a response but do not trust it because I am getting that answer eve of there are no duplicates. I've been trying multiple but it always goes to the else condition of the perform find function. Test.fmp12
  14. Thanks Comment, I've re-executed the script with having the script debugger turned on. I had an error message appearing. It's now working. Many many thanks! With regards!
  15. Bizarre. I am not getting any error messages. I've moved the perform applescript command after committing the record. Same behaviour no error messages.
  • Create New...

Important Information

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