Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About HHMacGuffin

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Hi, I am going to migrate my FileMaker server from one server machine to another and I am in the process of testing the transfer. However following the test transfer I have discovered that accessing database files in the new server via WebDirect is not functioning properly. I wonder if the community can offer some advice? Normally upon entering the hyperlink (i.e. <host>/fmi/webd/), I would be presented the default WebDirect screen asking for my credentials before presenting me with the list of database files available. However when the files are hosted on the new server, I only get the default WebDirect screen but no requests for my credentials and no database files are displayed. I also tested access using the server machine's own web browser via localhost/fmi/webd/ but got the same result. On the other hand, I have tested access via FMP and FMG and they are all working fine. I'm at a lost as to where the settings went wrong or where to start with, and I would really appreciate if the community can offer some advice and suggestions. Many thanks for your time and help. The MacGuffin
  2. SSL Certificate and Open URL Script

    Oh whoops! Sorry, can't believe I made this silly mistake. I completely forgot to update my client software. Thanks for pointing it out Steven!
  3. Hi, I just installed the custom SSL certificate as part of the update of my FMS13 to 13.0v9, and I noticed the open url script step on my FileMaker Pro client stopped working since the certificate was installed. I have since proceeded with the update and completed it successfully, but the open url issue remained. I'm at a loss as to why this is the case and would appreciate any suggestions to resolve the issue. I know the open url script stopped working after the certificate was installed but before the update was carried out because I happen to have need of using it at that point. The issue appears specific to my FMP client as the same script runs smoothly on FMG as well as on Web Direct. There is no other script steps involved: It's just open the url given in a record (it's a table of websites). Many thanks for your time and help. Cheers, The MacGuffin
  4. Count Unique Values

    Hi all, Just want to say in the end I applied Comment's suggestion as it is easy enough for my level of skill to implement and it worked very well. A great many thanks to Comment and everyone in the community for the support and help. Cheers, The MacGuffin
  5. Count Unique Values

    Hi Comment, Essentially, I need to be able to say, "my team has compiled X correspondence sent to contacts representing Y countries this year". Country is an attribute of a contact indeed. The join table only retrieves country through a calculation field base on the contact. This is made because each correspondence is essentially a template letter, and each letter is sent to multiple people from different countries - Like a mass email I guess. We are less interested in the total amount of correspondence sent and the number of people received. Instead we're more interested at how many letters my team compiled, and the geographical coverage of the recipients. I can do this by exporting the joint table as Excel, and then do a remove duplicate of the country field and count number of countries there. I just wonder if FileMaker can calculate this number by itself so it can be automated to report this particular number. If my set up is completely wrong, or there are better ways to obtain the numbers, your recommendations are highly appreciated - In the end, all I need is to be able to report how many letters were written and sent to how many countries. Hope this makes a little more sense. Many thanks for your time and support. Cheers, The MacGuffin
  6. Hi, I have a simple correspondence database with three tables: Contacts (called PEO), Correspodence (called peo_peocoo_COO), and a joint table called peo_PEOCOO. In Contacts, one of the fields is Country. I need to give a single number of how many countries has received correspondence from my team, so I wanted to count number of countries (not the number of times each country has ocurred) in the joint table. I am however having difficulty at using the methods commonly posted in the forums and would really appreciate some assistance. As an example, I have China China Japan China US Japan UK UK The number I would expect from the above is 4 - Four countries have received our correspondence in the past. I've tried using the ExecuteSQL method by creating a calculation field ("SELECT COUNT (DISTINCT Country) FROM peo_PEOCOO" ; "" ; ""). I however ended up with a question mark in every record. I've tried the "sum the reciprocal" method, creating, in peo_PEOCOO, a summary field CountryCount (which resulted in total number of records), a caculation field FractionOfCountryCount (which shows number of times each country has ocurred), and another summary field FinalCountryCount (which resulted in the sum of number of times each country has ocurred). Still couldn't get the number of countries in the peo_PEOCOO table. Finally, I tried "self join" method, creating a second peo_PEOCOO_SelfJoin, creating a calculation field in peo_PEOCOO called Counter, which is Count(peo_PEOCOO_SelfJoin::Country), and a summary field called CounterTotal which is a Total of Counter. It ended up again with the sume of number of times each country has ocurred. I would grateful if the community can help point out what went wrong in all my methods. A great many thanks for your time and help. Cheers, The MacGuffin
  7. User-customizable Questionnaires

    Hi, Â I am designing a FM12 database to allow people report their progress of work. I've seen a database design that allows customizsation by the users (not just admins) to create their own question templates, which will then appear in a separate reporting page for users to fill in. Building on this design, I wonder if it is possible to give users the ability to choose which questions they would like to answer. I am however at a loss as to how to create the relationships and designs to achieve such functionality, and would really appreciate your expertise in the matter. Â From the database design I've seen, the users can essentially access a layout to create a template of their own quesitons by typing in the question, and assigning the answer type: text box, radio button, check box. For the latter two, the user will also need to provide the available options. For example in the screenshot below, Q3a is set to answer with text box, while Q3b is set to answer with radio button: Â 3a: Â 3b: Â The selections: Â In a separate layout designed for users to report their progress, all the questions, in their designated format (text box, radio buttons with options, etc.) are presented to the users to be filled in. Following with the previous example: Â 3a: Â 3b: Â This flexibility would be hugely useful to the database design. However I'd like to take it a step further, if feasible, by allowing users to choose which questions they would like to answer. For example, the user may want to answer only 3a but not 3b due to lack of information. The design will allow users to create a record, choose one question from a full list they would like to answer, which then automatically presents the chosen question with its answer box in the correct format (e.g. text box, radio button) to be filled in. Â I would really, really appreciate you and the community's help and guidance on creating the relationships and designs of such a system, even if it is only the first part. Many thanks for your time and help. Â With best regards, The MacGuffin
  8. Portal data not displaying

    Hi, I have a Country table (CTY) linked to a News Article table (GPN) via a joint table. I am having difficulty getting a portal to display related records from the joint table, and have tried but couldn't figure out why. All I want is for the portal to display the title of the article. The portal in question is in a layout of the CTY, and is showing related records from the joint table, which has a calculation field that gets the article title from GPN. Somehow the portal is unable to display the calculated article title of the joint table. The calculation field in the portal is persistently empty - I enabled field entry in Browse Mode and found it has no content (and also received the not editable alert because it is a calculation field). I tried changing it to other fields in the joint table and it is still empty, including auto-filled ones such as modified date. I checked the (one-and-only) record in the joint table, and all the fields are correctly filled, including the CTY foreign key and the calculated name of the related country, as well as the GPN foreign key and the calculated title of the article - I would have thought that means they are correctly linked? The portal has no filter set up, so I am at a loss of what I could have missed. I would really appreciate any help on resolving this portal issue, and I wonder if there is a checklist of checks I could follow on portal-related issues? Many thanks for your help. Kind regards, The MacGuffin
  9. Password Window Not Popping Up

    Hi Wim & Steven, We've figured out the problem: Port 5003 was not open on the client computer. All is working fine now, and a million thanks for all your help and suggestions. The MacGuffin
  10. Password Window Not Popping Up

    Thanks Wim. No there was no sign of her connecting at all in the event and access logs. Could this be an issue with slow connections on the client side?
  11. Password Window Not Popping Up

    Thanks Steven, Both the client and the server are operating on Windows Vista. And yes the client does have access to the database, with a valid account and password: We've tested her access via IWP and she is able to log into the database successfully. Cheers, The MacGuffin
  12. Hi, One of my colleagues overseas cannot get the password window to pop up when trying to connect to the FileMaker Server in our office. This is the first time we encounter this problem and I would appreciate any help to remedy it. My colleague, base in Malaysia, has just installed FileMaker Pro 12 in her computer. She tried to open remote file and add a favourite host with the correct host internet address. Normally, upon saving the new favourite host, a new window would be opened and the user would be prompted to enter the account name and password. This window did not pop up at all. She has sent me a screenshot and her host interenet address is correctly entered. She also confirmed that she has Bonjour installed as prompted during the installation process. The database in question is hosted with FileMaker Server 12 Advanced in our office, and we use FileMaker Pro 12 for accessing the database. We have in the past successfully installed FMP12 and access the database remotely in other oversea offices (Africa). Your help is greatly appreciated. Many thanks. The MacGuffin
  13. Cannot (always) connect to server

    Thanks for confirming Wim Decorte, Will using 3G to connect be a potential solution? (next time, my colleague is back in office now) The MacGuffin
  14. Hi, My team had been successfully accessing our database via FileMaker Pro and Go for a while from our office and from our home. Today a colleague of mine tried accessing the database from another wifi network outside of our office and homes but failed. Is there some way I can rectify this? The database in question is deployed with FileMaker Server 12 Advanced on a server computer in our organisation. We've been accessing it with FileMaker Pro and Go (both with iPads and iPhones) for a couple of months now without problem. We've only ever accessed it when we're in the office, or at home. My teammates are having a meeting elsewhere today and got the message "the host is not available or that the file is not on that host anymore" when trying to access it with FileMaker Go on iPad. At the same time, I'm connected to the database with both FileMaker Pro and Go in the office without problems. She tried FileMaker Go on iPhone but also failed to access it. Is there something I can do to correct the situation? Or is that something to do with the wifi network they are connected to (and therefore beyond my control)? Any help and suggestions on the matter would be greatly appreciated. Thanks! The MacGuffin
  15. Copy and Pasting

    Hi all, I re-logined as admin and tried copy and pasting - and it worked. I then re-logined to the original (non-admin) account and everything suddenly worked again. Tested it the next day and all is well once more. Really strange. In any case, many thanks to all of you for your time and help to resolve the matter. Cheers, The MacGuffin

Important Information

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