Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About stanley

  • Rank

Profile Information

  • Title
  • Industry
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Sierra, Windows 7

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
  1. Hi Wim Thanks for that info. I'll dig deeper into the API to see what we need to do there. Stanley
  2. Hi Wim Ah, yes, the xml API. Not something I've used very much, I have to admit. The scenario is this: we have an external system (based on who-knows-what, probably SAP) whose admin wants to exchange transaction-based data with one of our FileMaker 11 systems, running on FMS. By this I mean he wants to set it up so that when an order is processed in his system, data is pushed out to our FMP system, and then when that data is modified in a specific way in FMP, we push data back out to his system. Normally when we do this with external systems, we use a file-exchange process, where we dump data for individual transactions into separate xml files on an SFTP server, where the receiving system is responsible for picking up the data and then moving the xml files to an archive. I like this because it leaves such a clear audit trail, and because the raw data is always there for debugging purposes. However, this time, the other side wants to send everything via HTTP Post, as I wrote before. Before I go any further, can you clarify something for me: is FMS and the xml API capable of encryption (as in HTTPS?) Any other advice on where to begin with this whole thing is much appreciated. Thanks Stanley
  3. Hi All: I have recently had a query from a colleague where he wants to exchange data with FileMaker Server via HTTPS Post of xml data. Has anyone been able to set something like this up, as a two-way data exchange? I imagine that it might not be possible via HTTPS, but perhaps as HTTP? Any suggestions are welcome, as I have not seen any evidence that this is possible. Thanks in advance Stanley
  4. Incrementing '00001' when it is defined as a text field will maintain the formatting. This is commonly done when creating serial numbers that need leading zeros for padding (because, for example, that format is required for export or whatever.) Cheers Stanley
  5. Hi Yianibb: You need FileMaker Pro 12, which is the client version. See here: http://www.filemaker.com/products/filemaker-pro/?homepage=fmp-product-line You can download a free 30-day trial from FMI which will let you edit your file. Cheers Stanley
  6. Hi wvms: You should be able to stop the server from the command line (using Terminal on the Mac). I barely ever use the command line so I won't give you faulty instructions here. Use of the command line is very well documented though, and it's a great way to steer around the Admin Console and its quirky behavior. Cheers Stanley
  7. I have a second server running on the same switch, which does not have the same problem. When this has occurred (it's only been twice so far) I have not had the same issue with the second server. However, I have not really compared their configurations too closely. Thanks for the SSL thing - yes, we are using SSL!
  8. Hi All I posted this on TechNet, but want to try you guys as well. We have a very busy production server running FMSA9 on Windows Server 2003 (yeah, go tell it to our IT department) and twice this week users have lost the ability to acquire the server. What we see is this: Users with no files open on the server cannot see the server. Users with any file open on the server can see all the files on the server. Users with any file open on the server can work as normal. Admin can run the console remotely (but a bit slow). Admin can RDC into the server normally. Rebooting the server solves the problem, but this is happening during the middle of the day, with most users unaffected, so that's not a great solution. Has anyone seen this before? I have a vague recollection of having a similar problem years ago, but can't recall if that was on 5.5 or 7 or what. Any hints appreciated. Thanks Stanley
  9. Hi Krea: What probably happened is that the serial number field you can see was created after some records already existed, and thus those records don't have serial numbers. I will assume that your serial number is being used as a primary key for relationships, meaning you cannot simply replace all the numbers with new numbers. However, if that is NOT the case, you can write a simple looping script to set new serial numbers. Although FileMaker does have an internal record ID, it's not available to you, so you will need to assign the missing serial numbers yourself. Depending on the number of records, you can either do that manually or via a scripted process. If you script it, you could just find a 'hole' in your numbering (or, if your numbering begins with 1 and goes up from there, create a 'hole' by changing what the next value for the field will be, increasing it by enough to give you values to assign to your existing unserialized records. So, if you have 1000 records, and 900 of them have serials going from 1 to 900, you would set the next value of your serial field to 1001, then assign (via a looping n=n+1 and SetField script) the numbers 901-1000 to the unserialized records. HTH Stanley
  10. Hi genr8er I wouldn't even explore the possibilities. FMP 5 and CDML are so old that you'll no doubt run into all sorts of compatibility issues, even if you do find a browser/OS combination that looks like it works okay. Instead, you should try to use the client's request for a web front end as leverage to get them to upgrade the whole solution. Just my five cents' worth. Stanley
  11. Oh yeah. Basic implementation's not a problem. Fitting it into our solution (which is extremely convoluted) will take a bit of labor, but not that big a deal, really. Thanks to all, and I'll post how it turns out... Stanley
  12. Get(SystemLanguage) doesn't work for us. 75% of the time it will be 'English' (and anyway, English (US) is mm/dd/yyyy and English (UK) is dd/mm/yyyy.) Thanks for the suggestion, though.
  13. Aha! That's a step in the right direction. When a record is exported to xml, the actual system settings for the date are tagged, as follows: DATEFORMAT="M/d/yyyy" or DATEFORMAT="D/m/yyyy" Well done, Comment! Although it'll be a lot of work to implement, at least it is a way to solve my problem. Certainly deserving of a beer at DevCon! Thanks Stanley
  14. Comment Said: "Another way: export anything as XML and peek at the DATEFORMAT attribute of the DATABASE element." Oh, now we might be on to something!
  15. Hi Comment: I'm not sure I follow that. If I bring in today's date (27 July 2010) as $$date and I do this: GetAsNumber($$date) I get 733980 regardless of being on mdy or dmy system settings. Okay. But is there a way to enter that value and have FMP turn that into a valid date in the current system's format? In other words, a way to get that entered in as 27/7/10 on a dmy system or 7/27/10 for mdy? Thanks Stanley
  • Create New...

Important Information

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