Daniel Paquin

Many thanks dansmith65, Problem solved! In my situation I was to close to the threes and could not see the forest. Very simple solution and I never saw the checkbox. However, I sure did a lot of research on the web and never got an answer. Regards! Daniel

Does anyone have an idea why the png images (company logo, control buttons...) are not showing ? My computing environment is the following: - One MacMini Server --ARWEN-- hosting the FileMaker pro dbms (the png images are not showing) - Two Macbook pro remotely login to the FileMaker Pro located on ARWEN (the png images are showing); - One MacMini --GANDALF-- remotely login to FileMaker Pro DBMS on ARWEN (the png images are not showing). The FileMaker Pro DBMS has been located in a folder called VII in the Application folder. At the moment when starting the dbms I always manually start FileMaker and then open in ARWEN and file open remote on all others. I would really appreciate to known if someone had the same problem. I do not need someone to solve this problem but to guide me on where to look for. Do we have to register the image? With regards! Daniel

I am new in writing a WEB application. I am currently writing a VERY simple web application which require to read and write information to a filemaker Pro database. The database is located on a MacMini Server, I do have five to six client remotely connected to the database. I could have between 5 to 15 external users trying to access the database simultaneously through the web application. People will be registering to the DBMS and make order ? My web pages are written in XHTML and I am intending to use PHP to : validate user entry information; query/ gather information from the Filemaker Pro database and; write information onto the FileMaker Pro database. I do have a few questions. Is PHP the right choice ? Can I use a FileMaker Pro database or I need a FileMaker Pro Server ? Is there a book you would recommend for me to get which would guide me in how to achieve what I want to accomplish? Best regards! Daniel

I've got an AppleScript program which starts automatically when an SDHC card is inserted in the computer. The content of the card is transferred onto a specific directory for FileMaker Pro to import. Up to last week everything was done on the internal disk of my computers. I now have a SAN (Storage Area Network) and all computers have have access to the files. However, I still need to keep the option to run locally. Therefore. I've created the field "MasterDisk" in the "Preference" table of my FileMaker Pro database. MasterDisk can only have the value "SAN" or "LOCAL". I want the AppleScript program when starting to go and grab the value of the cell "MasterDisk" If the value is equal to "SAN" the files contained in the SDHC card is to be copied onto the SAN disk. If the value is equal to "LOCAL" the files contained in the SDHC is to be copied on the local disk of the computer executing the script. The table Preferences contain only one record. How can I get the value contained in the MasterDisk cell. I've tried this script and I got an timeout error. I want abcd to get the value "SAN" or "LOCAL" from the Preference filemaker pro table. tell application "FileMaker Pro Advanced" set abcd to cell "GMasterDisk" of table "Preferences" of database e "Inventory" display dialog abcd end tell I just thought of that, what about a plist. Can FMP interact with PLIST i.e save and retrieve the content of a specific field. Regards! Daniel

Thanks Comment, it is working. Best regards! Daniel

The data files used by the FMP DBMS I am currently creating is always located in the UserLogon name directory. At that location, there also a list of folders which are used by other MAC system component. Then if a user logon onto the system under MrX, all required files will then be located under ../Users/MrX/... I am trying to see if there is a quick way to point to that folder without parsing. At this moment, I am using this parsing function which I need to clean up since FMP is giving me an error. Best regards! Daniel Let ( [ StartPos = Position ( Get(DesktopPath) ; "/Users/" ; 1 ; 1 )+7; Len = Position ( Get(DesktopPath) ; "/Desktop" ; 1 ; 1 ) - StartPos; UserHost = Middle (get(DesktopPath); StartPos;Len) ] );

" DesktopPath: " & Get(DesktopPath) & " UserName: " & Get(UserName) & " UserAcount: " & Get(AccountName) & " HostName: " & Get(HostName) When I use the DesktopPath function I get something like : Macintosh HD/Users/DanielPaquin/Desktop What I am interested in getting is the information contained between /Users and /Desktop i.e: DanielPaquin I've tried UserName and AccountName and found out those were in relation to FMP. I then used HostName which gave me the name of the MacMini server, in this case being ARWEN. Is there a get function which would give me only DanielPaquin In the meantime I will continue searching. Best regards! Daniel

I have an Applescript program which read the content of a directory. Each files contained in the directory becomes a record in a FMP table. It is used to fill the Product table. All of this process is done behind the scene in batch. I do have a problem and do not know if there is a solution. In order for all of the information to get loaded in the Product table I must ensure nobody is accessing the file either from via the layout for the Standard form, a Table view and a List View. If someone is accessing the Product table at the same time the batch program is starting the load nothing gets loaded in the Product Tbale. Is there something I can do to make this working? Thanks in advance! Daniel Applescript program . . try tell application "FileMaker Pro Advanced" do script "LoadProductTable" end tell end try End Applescript progran LoadProductTable: Perform Applescript [ repeat with i from 1 to count of sortedMPGFiles set theRecord to create new record at table "Products" tell theRecord set cell "PictNo" to (text 5 thru 8 of item i of sortedMPGFiles) set _PictNo to (text 5 thru 8 of item i of sortedMPGFiles) set _SubFolder to (text 5 thru 6 of item i of sortedMPGFiles) set cell "OriginalName" to (text 5 thru 8 of item i of sortedMPGFiles) set cell "PathVideoFile" to "/Users/UserName/" & _SubFolder & "/AVI10" & _PictNo & ".AVI" set cell "Category" to "Video" set cell "Status" to "Loaded" end tell end repeat ]

What is your recommendation? Is there a FMP function I can use to open a video file with VLC or it would be better for me to write a quick Applescript program ? Thanks! Daniel

I forgot to ask. If not possible to have VLC as a native FMP function, does any one know if there is a plug-ins which would allow to use VLC inside FMP? Anyone to recommend ? Thanks again! Daniel

Is it possible to have FMP preferences or parameters being set to use VLC instead of QuickTime ? Best regards! Daniel

Thanks Comment. Indeed it really helped, this is exactly what I was looking for.

I am attaching a picture of what I am trying to do. I would like to know if this possible to do this or not in FMP. I would like to browse through pictures in two different ways. The first way, one picture at a time using control buttons. This functionality I can implement without any problems. The second ways is by using a table view inside a tab. I have been able to Display records from a related tables in a layout. Unfortunately when I click on a row the appropriate picture does not show. As you can see in the attached document. I've put aside a box for where the picture is to be displayed. Is it possible to have a Table view inside a Tab showing records from which when clicking on a row the appropriate picture is being displayed. Thanks! Manage Pictures.tiff

Thank you very much Fenton. I am trying to do most of my function using FileMaker Calculation. The reason I've needed this functionality is because the working folder I've created for my solution are under MacIntosh HD/User/Username/SubFolder1/SubFolder2. I needed a way to quickly retrieve the MacIntosh HD/User/Username path. I have a field which, using the calculation you've provided me with to populate the image reference. Using this function I can now add the proper path. It is now working, thanks again! Daniel

Well I found that I can use something like Get (DesktopPath). I will see what else I can do with my calculation function. I had the idea to remove the word "Desktop". However, this will not work on a French OS.

How can I get from the Calculation function the value found in DestinationFolder ? tell application "Finder" set DestinationFolder to (path to home folder as text) end tell Thanks!

I am interested in using VLC because I am using MP2 files and when opened with the default FMP function the audio does not come out. When using VLC both the audio and the video are coming out. My question is this, in using any of the proposed solution in this topic would it open a separate windows (outside FMP) or it is possible to have the window to be part of a FMP layout using another video player than QuickTime? I would really like to have a VLC video solution playing inside a FMP layout. Thanks! Daniel

The script is to relate two table together LineItem with Products by the field "PictNo" Once related the replace field is to replace the Status field in the LineItem table from "Commander-Ordered" to "Filmed" and replace the Status field from nothing to "Selectionner-Selected" I have a script which looks at the content of a directory and for all of the files found, the information about that file is imported in the Product table. One of the information is the PictNo. In the LineItem table all the pictures that have been ordered are listed there. Those orders in the LineItem table have the following status "Commander-Ordered, Filmed, Graver-Burned, Livrer-Delivered". At this moment, I am only interested in matching the LineItem and the Product table for the records in the LineItem having their status equal to "Commander-Ordered". The common matching field is PictNo. All matching records will then get their Status changed. In the LineItem table it goes from "Commander-Ordered" to "Filmed". In the Product table it goes from nothing to "Selectionner-Selected". Thanks! Daniel

Hello Bruce, here it is ! ERD model.tiff French to english: CommandeClient : CustomerOder SousCommande: SubOrder CommandeOrdrePa: LineItem Produits : Product If you want me to change the table name in the diagram, let me know. Relationships A CustomerOrder could have one to many SubOrder A SubOrder may have one to many LineItem A Product could be in more than one LineItem A SubOrder my have more than one Product A Product could be in more than one SubOrder This is why I've created the relationship LineItem (in order to remove the many to many relationship). Regards! Daniel

OK what I've done since the last time. I've registered myself to Lynda.Com and I am going through all the videos. This is providing me with useful information and I am starting to get some of the FileMaker Pro fundamentals. I've went through some of the sample models provided with FileMaker Pro I've redone a ERD model and I've made changes accordingly in FileMaker Pro (see the link) My new ERD model Please note I am including this link because I am unable to add a picture. Relationships 1. A CommandeClient could have one to many SousCommande 2. A SousCommandeClient could have one to many CommandeOrdrePa 3. A CommandeOrdrePa could have one to many Produits 4. A Produits could be in one to many CommandeOrdrePa Table CommandeOrdrePa Status could be equal to {Commander | Filmer | Graver, | Livrer } Table Produits Status could be equal to blank or “Selectionner” What is it that I want to do: Select from CommandeOrdrePa all records with Status is equal to “Commander” Select from CommandeOrdrePa and Produits all records with CommandeOrderPa:PictNo equal to Produits:PictNo Replace related records in CommandeOrderPa field CommandeOrdrePa:Status to “Filmer” Replace related records in Produits field Produits:Status to “Selectionner” I've done the following script : Could someone tell me what is wrong with my script? One of the thing I could mention that I do not seem to have a way to relate records based on field values i.e CommandeOrderPa:PictNo equal to Produits:PictNo I am continuing my investigation. Best regards! Daniel

I've looked at supplied at standard FileMaker script was when all of this started provided by BruceR I've looked at the template files and their scripts I've searched onto the web on that specific topic and I've tried many time and cannot figure it out. I have the a CustomerOrder table and want to get counts by grouping information together, For example, I have the following table: CustomerOrder InvoiceNo, IndexNo, OrderNo, Status 123456 1 0101 Photographed 123456 1 0102 Photographed 123456 1 2012 Ordered 123456 2 0301 Photographed 123456 2 0405 Ordered 123456 2 0512 Ordered 123456 2 0701 Ordered 123455 1 0104 Photographed 123455 1 0201 Photographed 123455 1 2501 Ordered The result I am looking is as follow InvoiceNo, IndexNo, Status, Count(*) 123456 1 Photographed 2 123456 1 Ordered 1 123456 2 Photographed 1 123456 2 Ordered 3 123455 1 Photographed 2 123455 1 ordered 1 I am looking a the GetSummary ( summaryField ; breakField ) function and I am totally lost. In my mind I have two summaryField (InvoiceNo and IndexNo) and the breakField is Status GetSummary ( CustomerOrder::InvoiceNo & CustomerOrder::IndexNo ; CustomerOrder::Status ) When clicking OK in the calculation dialog box I get the following error message "Only summary fields are allowed as the first argument in a GetSummary function". What I want to get is summarized counts of status grouped by InvoiceNo and IndexNo. Where could I find a good practical example on how to do this? Best regards! Daniel

Is there a way to print all of the template files as one pdf document ? There must be 20 some templates provided with FMP each of them containing X numbers of scripts. When I click OK button on I get this error message "Expected expression but found unknown token.". I am going to try something else, in reading one of my previous topic, Fenton gave me an idea that I will be exploring during the day. What I am doing now is different then at that time. However, I there is a way to accomplish what I want to do. Go to Layout [ “CommandeClient” (CommandeClient) ] Set Variable [ $NoFacture; Value:CommandeClient::N°Facture ] Go to Layout [ “CommandeOrdrePassage” (CommandeOrdrePassage) ] Perform Find [ Specified Find Requests: Find Records; Criteria: CommandeOrdrePassage::N°Facture: “=$NoFacture” AND CommandeOrdrePassage::SN°Commande: “=1” ] [ Restore ] If [ Get (LastError) ≠ 0 ] Go to Layout [ “CommandeClient” (CommandeClient) ] Beep Show Custom Dialog [ Title: "Enregistrement non trouvé"; Message: "L'enregistrement recherché n'existe pas dans la base de donnée!"; Buttons: “OK” ] Else Go to Record/Request/Page [ First ] Loop Show Custom Dialog [ Title: "Enregistrement"; Message: CommandeOrdrePassage::N°OrdrePassage; Buttons: “OK” ] Set Variable [ $$the_list; Value:$$the_list & CommandeOrdrePassage::N°OrdrePassage ] Go to Record/Request/Page [ Next; Exit after last ] End Loop Replace Field Contents [ CommandeOrdrePassage::Status; Replace with calculation: "B" ] [ No dialog ] Show All Records End If Show Custom Dialog [ Title: "la liste"; Message: "la liste....:" & $the_list & ":...."; Buttons: “OK”, “Cancel” ] Perform AppleScript [ Native AppleScript: --set FMPrec to $$the_list repeat with i from 1 to stringLength by 4 if stringLength - i < 4 then set nextpar to (text i thru -1 of FMPrec) else set nextpar to (text i thru (i + 3) of FMPrec) end if display dialog "Nextpar" & nextpar end repeat ]

I've looked at the pdf document and it does not have any example on the "Go to Record/Request/Page <first/last/next>" Nevertheless, I've managed to rewrite the first part of my applescript program as a filemaker script (see attached) my first read FMP script function Now, the next step for me is to pass the value of the variable $the_list to the function Perform AppleScript which is to execute Toast Titanium. For the time being in my AppleScript I am only executing the following vary basic operation. I've tried to set the variable FMPrec to the variable $the_list and that does not work. How can I pass the value of $the_list to the function Perform AppleScript? set FMPrec to $the_list set stringLength to length of FMPrec repeat with i from 1 to stringLength by 4 if stringLength - i < 4 then set nextpar to (text i thru -1 of FMPrec) else set nextpar to (text i thru (i + 3) of FMPrec) end if display dialog "Nextpar" & nextpar end repeat Thanks!

I agree with you thisis five minutes of work for someone who knows about scripting in FileMaker. Like I've said I know NOTHING about filemaker pro. I am learning, I like the tool, I am happy about my choice of going with FileMaker Pro. Why, am I asking questions on this site, it is because I need help. Why not answering the question I've asked What is the command in FMP which allow to read one record at a time? I think I have to loop through the result of a Find using the Go to Record/Request/Page <first/last/next>. Am I right? Maybee that would be a good way to help me to think FileMaker before applescript. Just an idea !!!

The reason being that I must have something ready for January 20, 2011. At this time, part of the solution is working with Applescript programs. I have to look at long and short term solutions. When comes the time to optimize some of the processes I will be recoding as much as I can in FileMaker pro. First, I have to meet the January 2011 milestone. Then I will start to optimize the code and make the workflow more robust. My next milestone is for March 24, 2010.