Jump to content

Ian Murphy

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ian Murphy

  • Rank
  • Birthday 07/25/1971

Profile Information

  • Gender
    Not Telling
  1. Ian Murphy

    Seeking recommendations: FMS 13 hardware

    Thank you for your input. Memory: yes, this machine tops out at 8GB RAM, which is the chief thing I have against it (b/c even if I order w. 8 GB today, I won't be able to expand in a year). Backup: I understand the value of a RAID array but because of the sort of oddball structure of the library network (having grown organically, we now have a lot of CPUs scattered around the building without a central server), in our case we have a pretty thorough patchwork solution - FMS writes copies of the db every two hours to a folder backed up by CrashPlan, and also writes a once-a-day set to a Dropbox folder synced to two other machines (including my laptop). In our case, an outage of a few days while I replaced a hard drive in the event of failure would be acceptable, in part because I could access the data.
  2. Ian Murphy

    Seeking recommendations: FMS 13 hardware

    Having made that initial post, I realized as I thought about it over supper that it was kind of silly to ask it as an open-ended question. Instead, I've gone over to Dell.com and cobbled together this description for $800 - but I'm a bit out of my depth and would welcome feedback: Power Edge R220: PowerEdge R220 Chassis Configuration: 3.5" Chassis with up to 2x3.5 Cabled Hard Drives Processor: Intel® Xeon® E3-1220 v3 3.1GHz, 8M Cache, Turbo, 4C/4T, 80W Memory DIMM Type and Speed: 1600 MHz UDIMMs Memory Configuration Type: Performance Optimized Memory Capacity: 8GB UDIMM, Low Volt, Dual Rank, x8 Data Width Operating System: No Operating System OS Media kits: Windows Server®2012R2,Standard Edition,Secondary OS,Media Kit RAID Configuration: No RAID with Embedded SATA (1-2 HDD) RAID Controller: No RAID Controller Hard Drives: 500GB 7.2k RPM SATA 6Gbps Entry 3.5in Cabled Hard Drive Embedded Systems Management: Basic Management PCIe Riser: Riser with Single x16 Gen3 PCIe Slot Network Adapter: On-Board Broadcom 5720 Dual Port 1Gb LOM Power Cords: NEMA 5-15P to C13 Wall Plug, 125 Volt, 15 AMP, 10 Feet (3m), Power Cord BIOS and Advanced System Configuration Settings: Performance BIOS Setting Rack Rails: No Rack Rails or Cable Management Arm Bezel: No Bezel Option Internal Optical Drive: DVD+/-RW, SATA, Internal System Documentation: No Systems Documentation, No OpenManage DVD Kit
  3. This is a straightforward plea for advice. The Win7 terminal where we installed FMS in 2011 is finally not up to the task - after the recent updates to IIS and ARR (and FMS), it opens and hosts my databases but refuses to serve the XML feed that powers one page of our Web site. It was always underpowered, so I don't have any complaint. When we put it in, this was an experiment, so we didn't pay much. After four years, though, the library director is convinced of the value of the product, so we're looking for a new terminal that will run FMS 13.0 v5 today. We're still a public library, which means we don't have a ton of money, and our needs are relatively modest (by the standards of Web publishing). The variables: I'd love a price range of $500-$800. This is a Windows environment. I have a rack and would like a rack-mounted solution (but could use a conventional CPU chassis instead). My 'normal use' scenario will continue to involve about ten clients locally running FMP, and FMS also publishing one XML feed. Likely future use involves five licenses for FMGo (for library staff on their personal portable devices). Possible future use includes a couple of licenses for Web Publishing (so library staff can do outreach in public places). Possible distant future use (2-3 yrs?) includes a proper custom web publishing public interface (where patrons can register online to participate in programs). What hardware do you recommend?
  4. Ian Murphy

    Allow clients to set values in one place

    how would you disallow the accidental creation of new records? I guess via a custom menu? Maybe a custom menu, plus an autofill rule that will insert the value of each field into the same field in the accidental new record, and then maybe a self-check when the database is opened that deletes all but the oldes (i.e. original) record. That seems like a lot of overhead, but I'd be concerned about the results if someone accidentally hit Ctrl-N, which after all is a common command.
  5. As I put together a solution that I intend to offer to several different clients, I'd planned to have a table called SETTINGS, populated by global fields, where they could adjust some variables. For example, I can write the calculation that opens event registration X days before the event, but they can decide how many days that needs to be. Another example: I can write in email functionality that they can use if they want to provide their own SMTP server data. I'm just learning, though, that global information can end up purged on a hosted file. And while there might be workarounds for that, it means that this isn't a rock-solid solution, so I'm in search of another one. These are variables I definitely want the client to be able to alter, so they can't be hard-coded in auto-enter calculations and stuff, and I'd like to include them in a graphic layout (so I can use tabs to simulate a wizard for some less-intuitive stuff that some folks aren't used to thinking about - like those SMTP credentials). They're not variables, because the ideal case is 'set and forget.' I'm looking to have them all grouped together so that a client can find them - maybe behind an "administrator's" account whose privilege set extends to a dedicated layout. Looking for creative, effective ways that you might have solved this in the past.
  6. thanks, guys, as ever. Solved -
  7. What I want to do is paste the contents of a portal into a text field. (A pretty good analogue of the intended use: I want to send an email to program participants who have requested it; whether they're attending one program or thirty, I want to let them know.) A couple of years ago, in a solution tracking budgets, I wrote a version of this that worked but used the system's Copy & Paste functions. Having defined the portal as BUDGET_PORTAL, I wrote: which worked fine (worked well, in fact) - but used the system's clipboard, which isn't desirable. Looking for advice for accomplishing the same thing via Insert and Get commands. I thought I had it with the GetLayoutObjectAttribute function, but it seems to want me to define content downstream of a given table, which I don't understand.
  8. Last week I did the FMS upgrade from 13.0.4 to 13.0.5, and my database has stopped providing an XML feed that worked for a a few years (and that powers one portion of my organization's Web site). I'm going to append all the information that might be pertinent. First, what I've already done: - I've Edited Deployment, asking it to enable XML. (First asked it to turn off Web Publishing, then a second pass to turn it on again.) I've then gone into Web Publishing and asked it to enable WebDirect and PHP (just wondering is that would kick-start a process). - I've run iisreset /noforce from the Windows command line. - I've rebooted. Also, I have a static IP on this machine, but in its interface, it provides what looks like an internal IP address. The next thing I guess I'll do is call support and/or reinstall, but I'm posting this to ask for related wisdom. I will mention that since we moved into a new building a few weeks ago, I've been haunted by connectivity problems - some folks get kicked off a couple of times an hour. I think that's an internal problem related to hardware/cable (since I was able to connect remotely from home and remain connected for 24 hours), but I mention it here in case it seems germane.
  9. Ian Murphy

    Limiting value list by including only related values

    Thanks. Your assumption was correct - I was on a Participants table layout - and the step I was missing was that the "limiting" relationship needed to be based on that table. Solved!
  10. I'm at my wit's end trying to manage this value list. I'm writing out the way I have it set up, not because it's working (it's not), but in hopes that a real-world explanation of what I'm trying to do will foster discussion. The goal is for a list of events to display only events that are in the future. The records being referenced must continue to encompass the past events, but in the place where we're seeing them, we only want to see events that occur today or in the future (because there's no sense letting people register for events that are over). The base value list is already set up as field contents: Use values from: rel_events::UID Also display values from: rel_events::DateAndEventName Show values only from second field Because the second field is built in the form 2015-03-26 Mon • Bicycle trip 2015-03-30 Fri • Puppet show , the alphabetical sort field is also chronological, which is fine. But now I want to screen out events that have already started. To that end, I created two fields in the Events table: - IsInFuture, a binary calculation that returns 1 if StartDate is equal to or greater than Get (CurrentDate) and otherwise returns 0; and - One, a global calc field that returns the value "1". I created a self-join relationship with new TOs based on the Events table with the conditions that IsInFuture = One AND One = IsInFuture (because I wasn't sure which value I wanted to reference, and I figure 1 = 1 = 1 = 1, right). When I ask the box to include only related values from that self-join relationship, I get results I don't understand (two or three of my 43 records show up). Open to suggestions; thanks in advance.
  11. Ian Murphy

    One-to-many creation tutorial

    The reason for the categories to be a table: this will be an informal budget tool for departments within an institution. At the end of the year, the accountant will still total up, in QuickBooks, the actual money spent. But in the meantime, this is a tool for a department head, with two or three buyers under her, to track spending week in and week out. So if we end up with one category for 'office supply' and another for 'office supplies', it's acceptable, so long as all the spending is accounted for. The thing that can't happen is: we have budgets for yellow and red, and you buy something blue, and I don't notice that the money's been spent.
  12. Ian Murphy

    One-to-many creation tutorial

    I feel self-conscious asking this rudimentary question after I've been using the product for years . . . but I guess I've never needed to do this before. I'm sure there's a tutorial out there and would appreciate a pointer to it. Googling combinations of my question hasn't turned up the answer. I've always done one-to-many relationships with fixed 'categories.' First, we create the types of things we're doing at the library (programs for kids, programs for adults), then we create the entries that fall under those types (Story time class and finger painting under programs for kids, computer class and Guest lecture under programs for adults). Same model for P.O.s we issue for purchases and for the phone directory tying local people to their businesses. But for the first time, for an internal budget tracker, I'm looking to add categories on the fly. So I intend to start with the categories yellow and red. When we buy lemons and bananas, staff will tie them to yellow, when I buy tomatoes and stop signs, I'll tie them to red. But when a staff member buys blueberries, and types category blue, I want FMP to create that category if it doesn't exist. Every way I've created the relationship (between table category and table item), it ends up one-to-many backward - so I end up with several entries called 'red' and several called 'blue.' I don't think I want to relate them through a join table, but maybe I'm missing something.
  13. Ian Murphy

    FMP on www - security overview?

    Oh! Got it. No, no one other than me uses RDC. The terminal in question is not a workstation (no keyboard, mouse or screen) - just a black CPU sitting under a switch in a room down the hall. I normally access FMS from within a browser on my own desktop down the hall, but once in a while when I want to work on the terminal in question (reboot it, get a recent file backup, whatever), I use RDC to display it on my screen.
  14. Ian Murphy

    FMP on www - security overview?

    Thanks for both of your responses. I'll briefly answer a few straightforward notes off the top: - the director says we can't afford a server until at least 2015, so I have to make do without. - FMS writes to a backup folder every 2 hours (in one location) and once a week (in another); Carbonite grabs those backups. - yes, I access the terminal via RDC. I see you telling me not to. Darn it, but okay. I have downloaded teh Security Guide and I pledge to review it carefully, implementing what I can, before I come back with any more question.
  15. My office has gotten accustomed to interacting with our custom DBs, and there is plenty of sensitive information in there (names, addresses, et c.). So I'm looking forward to telling senior staff that after a recent move & some structural LAN changes, I have a static IP set aside and a dedicated terminal and they'll be able to access their calendars and Rolodexes from home. Before I go live with that, though, I'm thinking about security. We've always maintained this data on a closed network behind a firewalled router, so I've never used any particular measures (logins, passwords) to get access. If I'm going to putting people's home addresses on a public terminal, I need to. So here's my setup: A Win 7 x64 terminal running Windows, FileMaker Server, Carbonite, and Dropbox (and nothing else) is connected to a modem. I access it via RDC and FileMaker. Windows Firewall is on, and inbound connections are blocked. Network discovery, file / printer sharing, Public folder sharing are all off. What's the local custom for allowing access? Do you set up a password and distribute it among staff? I see that FMS can restrict access to certain individuals (or accounts) - maybe that makes sense? Or can I restrict it to users who are running a copy of FMP that's authorized to my multi-volume license? I currently publish an XML feed and plan to look into WebDirect. Do I need to take any steps to ensure that www search engines don't scrape this data? Any and all input is welcome.

Important Information

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