Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About DannyDK

  • Rank
  • Birthday 08/13/1973

Profile Information

  • Gender
    Not Telling
  • Location
    De Pere, WI

Contact Methods

  • Website URL
  1. Agi. Could you share how you fixed this? I'm having a similar problem with 360Works ScriptMaster.
  2. I fixed the problem. It was a permissions problem. It seems that specifying the user in the server scheduler does not work. Once I correctly set the file permissions and set up the schedule to run with the default account, it worked. To come to this conclusion, I ran the script from the Mac terminal as the fmserver user. Then, from the terminal, I was able to get the feedback I needed to fix the problem. So, if you can run the script from the command line as the fmserver user, it should then work in the FMP Server schedule. If you can't, then it won't. Here's how to run the script in
  3. I am having the same problem with a simple script that copies the contents of the backup folder to a dropbox folder. I can run the script fine from the command line, but the script will not run from FMP 12 Server. I've even had FMP run the script as root. I had used a similar script in the past in FMP 11 Server that copied the contents to an external drive. It worked fine.
  4. Inspired Time Clock http://www.inspirationssoftwaredesign.com/products/inspired-time-clock This is an unlocked FileMaker Time Clock solution, so you can customize it and/or integrate it with your existing solutions. Has some nice configuration options. Employees log into a FileMaker account to clock in and out. The user accounts are managed from within the solution. Very clean interface. It also includes basic CRM functionality. We're working on a "locked" version as well that will have a lower price if you're not interested in customizing.
  5. It looks like you will need to create two new table occurrences of the Pricing table. One with a single relationship to Booth Sales based on year and the other related to Other Sales, also based on year. You'll probably want to give them names such as "BB Pricing Options [1 and 2]" so you remember what they are for. Then create two value list (or duplicate the current Sales ID value list as they will be very similar to that one). Each using values from the new BB Pricing Options occurrences. Select the radio button "Include only related values starting from:" and choose the appropriate
  6. You could create a relationship between the two tables using the "x" relationship operator which basically makes every record in one table related to every record in the other table. It doesn't matter which field you use. Then, you should be able to see all global fields whether indexed or not.
  7. I'm not sure if I understand your data structure entirely, but it sounds like you will want a new table occurrence in the relationship chart of your main database (not the pricing database) of the table from the pricing database (or whichever table is populating the drop down menu). The relationship between that table occurrence and the table you are auto-populating with the drop down menu would be based on the year.
  8. You would setup your value list to "include only related values starting from" your new table occurrence in the relationship graph. Is that the part you weren't sure how to make work or are you having trouble setting up the relationship?
  9. DannyDK

    New Window

    This should be a very simple, 3-step script: New Window[] Go To Layout[2nd layout] Enter Preview Mode[] Order is important here. Are there any other steps in your script?
  10. That explains the problem. The hosting server is 8.5 which does not have this feature. I incorrectly assumed this was exclusively a client side feature. So, in order to utilize shadow tables in a hosted file, the hosting server must be running FileMaker Pro Server 9. Thanks for the help Jonathan!
  11. I did some additional research based on your question, Jonathan, and found that the pattern is different than I thought. Regardless of the machine in use, I an unable to create or use ODBC connections for shadow tables on a database that is hosted on an FM Server, but when I open the DB locally, everything works great. Is this by design? I sure hope not.
  12. I have gotten shadow tables to work successfully on several machines by setting up external data sources with system DSNs for MySQL databases using Actual Open Source Databases driver. For some reason, there are two machines which, when set up exactly the same way as the others, no DSNs show up in the "Select ODBC Data Source" list in FileMaker. I have dug deep into the configuration of these machines and can find no differences that would cause this. I have tried several different drivers and set things up in different orders and it is always the case that on certain machines, it just wo
  13. If you change the DSN to point to a new database, any FileMaker data sources using that DSN should automatically point to the new database server. The database names do not have to be the same, but the structure (table names, column names and order, etc.) in use by FileMaker will have to be the same for it to work. If you create a new DSN, then you will need to change the data source in FileMaker to use the DSN. This works fine too, but again, the structure will have to be the same. I have tested both methods and they worked for me. The former is probably the better practice. Y
  14. It would probably be best not to duplicate the information at all, but rather to use relationships to share the information. If you set up a relationship between the billing and the submission tables, you can use the submission data from the context of the billing table.
  15. The first non-working calc appears that it should work assuming you have your table and field names correct in "TEST_IMPORT(TEST1,TEST2,T EST3)". Though I noticed a space after the T in T EST3. What is the result of this? What is the error message you're getting, if any? What happens when you run this exact statement with hard coded values replacing each of the " & FIELDREF & " statements? i.e. INSERT INTO TEST_IMPORT(TEST1,TEST2,TEST3) VALUES ('testvalue1','testvalue2','testvalue3') There shouldn't be any need to qualify the FMP name. You are really just passing text values
  • Create New...

Important Information

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