Jump to content

Greg Hains

  • Content count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About Greg Hains

  • Rank
  • Birthday 12/26/1967

Profile Information

  • Gender
  • Location
    Brisbane, Australia

Contact Methods

  • Skype

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. Hi Docasar, I am trying to do a similar thing... I'd like to drop a CSV file into a (global) container field (for convenience rather than setting a path in concrete), then be able to read the contents of that file into one of the tables. I wasn't sure if I was able to read the contents directly (should be possible right?), but thought I could then export it back (was CSV) out to a known path (get(temporary path) in this case) then Import it back in. Whilst it's not the most elegant solution (double handling the file for sure), I was not sure how to Export it back to this temporary folder because I'm not saving an FM file - its a file within a container. Whatever the method, there must be a tricky way to import entries from a CSV that is already stored in a container field. I'm going to work on this over the next few days - if I find a solution I'll let you know. If one of you gurus out there already know a method I'm keen to learn. Thanks, Greg
  2. CURL question - API usage

    Hi Dan, Thankyou for this file. It looks great. I have sent you a private PM through FmForums as well. I have been also working with the provider in regards to the exact syntax they require. I probably wont hear back over the weekend but will get back to you once they do. Thanks for your help and look forward to working further on this question. Greg
  3. CURL question - API usage

    Thanks Dan. I have made further enquiries with the hosted service regarding the API syntax etc. I hope to hear back from them soon. I've sent you a private message with more details. Thanks, Greg
  4. CURL question - API usage

    Hi Dan, Thank you for responding. The API documentation I have been working through (not to mentioned the countless examples and Googled pages on CURL in general over the last 48 hours) is at https://apidocs.unleashedsoftware.com/. There is an API Key and an API ID (which, with all due respect, I cannot post publicly as it is for my client) issued by Unleashed - both of them longish alphanumeric strings. I was hoping to get more info about the raw text string sent to Unleashed's API sandbox (even if I used Wireshark. lol), but I was hoping there was a "standard" that may be used that would incorporate the likes of API keys. I realise to that this is a proprietary thing and probably not a general forum question, but thought there maybe a glimmer of hope in finding a solution. I will check out those websites you mentioned - thank you Cheers, Greg
  5. Good morning. I am trying to use FM16 to extract data through an API. It requires an API key and string to be sent, but don't see where in the "Insert from URL" syntax how it can be applied - I think I have the rest of the syntax working ok though. The PHP syntax (according to the host support team) say it is: $curl = getCurl($id, $key, $signature, $endpoint, $requestUrl, $format); I have all the details (I'm pretty sure) except the signature. I'm trying to use the native FM16 functions if possible - just to minimise third party products (although BaseElements may be OK) Could somebody please give me a clue as to the correct syntax I should be using? I'm happy to engage (and pay for) the services of somebody for a hour or two to sort this out for me. (I hope Im not breaking any forum rules here by doing this - I'll remove this if I am) Thank you in advance. Greg
  6. Do Find and Omit "clash"?

    Good evening. Once again I find myself stumbling over something that I think will turn out to be very simple. I seek the help of our Filemaker mentors for assistance. I have a table with about 3000 records in it. One of the fields is called "Type" and can contain any one of 7 different values" Another field is "Gender" (containing one of there values: Male, Female, Unstated") Another field ("Duration") is a numeric value that can be anything from 0 to 300 I want to Find records whose Gender is male (easy), the numeric value in a range (also easy), but exclude all records whose Type does NOT equal "Assessment". I found that I can Omit the "Assessment" records OK, but then unable to then constrain the set to show just Gender=Male and a Duration value of choice. After the Omit works, running a Find on the remaining records seems to undo the Omit. So, I tried the Omit stage after the Find of Gender and Duration - still no luck. It seems that a Find cancels out a previous Omit. One cannot do a Find on something that "does not equal" - it has to be an omit process. I am not going to do a Find on the other possible 6 values either - thats not a clean solution. I have been unable to find a solution through Googling on the correct procedure and usage of the Find/Omit tools to achieve what needs to be done. I'm sure it can be done, and I'm just missing something simple. Any help would be appreciated. Thank you, Greg
  7. Reading the (n)th record from a related table

    I agree Comment. I will put that to them. It was their decision to not do it in the first place (apparently), but it's only going to cause (me) headaches - it's already a discrepancy in the logic. Thank you.
  8. Reading the (n)th record from a related table

    You're right Comment. It is assumed (awesome attitude in a logical world, lol) that the widget was returned that day. It's not failed in that respect, but now they want to report on it, the wheels fall off. My post now turns from requiring a tricky method to going back to basics. Thank you. :-) Appreciated as always. Greg
  9. Reading the (n)th record from a related table

    Hi Comment Thank you again for your help. What I failed to mention too - my apologies - was that there is a HIRE_TYPE and that was a value of DAILY or PERIOD, so if DAILY was used then the HIRE_RETURN was not used. I'm thinking of changing that so both HIRE_OUT and HIRE_RETURN are both populated with the same date with a daily hire so that an empty field definitely means a widget is still out for hire. Much cleaner I suppose. I originally had that method you suggested, but with the way it was recorded (see above) counting the populated fields did not work. Thank you. Greg
  10. Good evening, I am looking for some help please - is anybody able to give me a clue as to how I can achieve what I need quicker than what I'm already doing? Description is: Two tables and their fields. CLIENT CLIENT_ID HIRE_STATUS HIRE CLIENT_ID HIRE_OUT HIRE_RETURN They are linked together via a CLIENT_ID field. It's a one-to-many relationship. Any given client can hire a widget. The date they hire it out is HIRE_OUT, and the date it is returned is HIRE_RETURN They may hire it for one day, or they might hire it for several days. They may have hired it a few days ago and as it's not yet returned so whilst the HIRE_OUT data is populated, the HIRE_RETURN date is still empty. What I'm trying to do is to establish from the CLIENT table if a client currently has a widget out. I achieved this in a cumbersome way by: 1. Flicking back to the HIRE table to the related records, 2. Locating the most recent hire entry after having been sorted, 3. Determining if the hire was closed (populated HIRE_RETURN field) 4. Returning to the CLIENT table (layout) and updating the HIRE_STATUS field. Very manual and clumsy - I know. I am looking for the likes of a calculation (or any method really) that will read the most recent HIRE record without having to go to another layout. Is there a function that will allow me to read specific fields, from the last (most recent) record from a related (sorted) table so as to estbalish the current hire status? Any help is appreciated. Thanks, Greg
  11. Network sharing issue

    Hi Wim, Thanks for being subtle there. lol I should clarify - reading back my wording does say what you read. FMS is install on it's own Windows Server, and FMP installed on the TS box. The icon on the desktop of each user (on the TS) does not point to the actual file through Explorer but through Open Remote. I'm pretty sure it's a launcher file, but will check with the provider/host nonetheless. If Network Sharing is enabled in the file, and I have seen it on, and switched it off, why has it returned? What triggers it back on? Do I have to open the file locally to disable then then publish it again? (If that makes sense), as my disabling it doesn't seem to hold. Thanks for the reply. Cheers, Greg
  12. Network sharing issue

    Good morning. My client has FMS14 running on a terminal server with about 8 clients using it at any one time from that terminal server. From the reports I am getting back, when they open the solution, they are getting a message that appears to show that the Network Sharing has been enabled. As I understand it, when the solution is hosted on FMS, then the Network Sharing (for peer to peer?) should be disabled, however, even after turning off Network Sharing, it appears to come back again. Why is this? How do I stop it please? The only problem it seems to be causing is the initial error message when the solution is opened. I access the file remotely (not through the TS) and I don't get that message - I'm also the only Mac client if that makes any difference. Any ideas would be appreciated. :-) Greg
  13. Tide tables

    Hi, I think Ive bitten off more than I can chew with this project. Thank you for your response. Cheers, Greg
  14. Tide tables

    Hi jbante, Thank you for your reply. I sort of knew that I was opening a can of worms with that question as it is a complex issue. All the various formulae I have seen still refer to other variables which are PROVIDED and not calculated which makes it difficult to make a stand-alone solution. I suppose even being able to look at the high tides and low tides of any day (past or present) would be pretty good - if it were possible to do it that way. Cheers, Greg
  15. Tide tables

    Hi there, I realise that this section of the forum may not be the best for this post, but after going up and down the list, I thought I'd start here. Moderators, please feel free to move it if you see fit. I have for some time looking to be able calculate tide tables for any given location for a long time now. There is very little I can find in terms of actually calculating them with the necessary parameters - most of them are pre-calculated and ready for download. Quite by accident, I came across the page below and wondered if anybody by chance was interested in these types of calculations and might have something - at least for FM. Cheers, Greg

Important Information

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