Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

bdarch's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Hello We have a set of databases we've been running without incident for years, though many FMP upgrades - all served up by FMP Server. With 14 - suddenly I have instances of numeric fields whose display I cannot control - the Inspector seems to have no effect on the number of decimal places, nor can I control percent or currency notation. Context We are a consultancy and the file is our timecard, with daily hour totals and reporting ratio of billable and unbillable time. Calcs A summary field to total the hours, and the ratio calculated by dividing that total summary field by another summary field totaling the unbillable hours. The summary field is in the footer. Problem As I said - I can't control or change the display - number of decimals showing does not respond to the Inspector data/data formatting commands. Never had this problem before - I feel like I'm missing something right in front of me... Checked the dB file... no corruption. Nobody else on the internet is complaining about this that I can find. So... obviously... it's ME. :-) Any clues? Many thanks...
  2. Wim - I love being wrong! After saving a fmpsl to the desktop, my line of (incorrect) deduction began with seeing both the original file - with server name appended in parentheses at the top of its window - and the opened fmpsl link - which does not show the server name at the top of its window. But with testing I see a record added to one is added to the other. GREAT! But why the name difference?
  3. Stephen - thanks for cluing me in about FMPSL's. I've been reading up on the feature, but I'm confused about the SL's function. With apologies for the topic drift... Initially I thought a SL was a "saved found set" - that would, when opened, return you to the original file with the found set restored. As one poster mentioned - a handy way to return to a previous worksession. But now I'm realizing that SL is a *copy* of a found set - which opens up a facsimile of the original database - with all layouts and scripts, just not all the data (only the saved set). Am I right here? This concept seems crazy to me... and subject to much confusion in a shared work environment. I can easily see people entering new data in the "wrong" file! I'm confused about the efficacy of the FMPSL when working with data - but I do see its potential usefulness as a dashboard file without records - so thanks for that idea.
  4. Steven, Thanks, I didn't know 'bout Snapshot Links - nice feature. However our deployment is based on a small "dashboard" file everyone keeps up and running, with buttons to open the file needed. It's a system that has been trouble-free for years.... until last week. :-) I think Priyabrata might be on to something - can you shed any light on what he's describing? Or someway to re-set the parameters of the troublesome file? Thanks so much.
  5. P, Thanks for your help. I'm still puzzled by this. To answer your question, the served files are opened locally with either a simple "open file" script command, or in some instances a "perform script" command, pointing to the served file, which opens it and starts the specified script. I can't remember why we set it up both ways... both script commands work except for the file in question. One clue: in defining an "open file" script, I noticed that I can generally reference scripts belonging to served files, even if those files are not open locally yet. This is *not* true of the file that won't open... I can't reference any of the scripts in that file until it is open on the local machine. What might this indicate? I need help understanding what you mean by your first line "refer to the server file using the hosted server IP path". I see no such reference pointing directly to the server in any of the External Data Sources in my files that can be opened by my "file open" script... what should I be looking for exactly? With apologies for being so dense...
  6. Hey Wim - By file reference, you mean External Data Sources?
  7. Hi all - (not sure if this is a "server" question or a "scripting" question - apologies if I'm in the wrong forum) We have FMP Server 12 hosing 50 files or so on an OSX ethernet. We typically open remote files from a small "control" panel on users machines firing an "openfile" script to bring up the right db. All is well except just recently ONE file won't respond to the OpenFile script command - all the others work fine. I can open the file manually via the "Open Remote" menu command - it's right there in the list of hosted files. Can someone throw me a bone? What might I be missing? Cheers, Jeff in VA
  8. LR re: server quality machine Ha! Busted. We're hosting temporarily on the imac until the new mac mini is released. We only have fifteen users so the loads are minimal. We have a good backup scheme. So far so good. But yeah, an iMac is probably not "best practice". re: TechNet Registered ages ago - thanks for the reminder. I'll take another look at that resource! Thanks for the help. Happy New Year to all.
  9. BruceR - I'll do a search for both those topics. Just getting back into it so thanks for your patience.
  10. BruceR and LaRetta, thanks to you both. BruceR - Ha. I'm sure a lot of my thinking is out-dated! From your answer I presume your "best practice" is just to go ahead and edit the live file. In truth, I make lots of changes to live hosted files. But some changes don't stick - for example I've noticed that global variable container fields won't keep a value I set, unless I take the file off-line, make the change, then re-host. Is there a list of what changes to a live file are accepted vs. those that aren't? LaRetta - yes... assessing levels of "risk" is exactly right - it would seem that FM would disallow "risky" edits to live files. Or if it allows edits that could potentially break something - is there documentation or a matrix of risky/not risky interventions? Ha. Call me a worry wart. Or just someone who wants to know...
  11. Hi Steven and thanks Basically I want to use the Admin Console to take the served file off-line, then open it for editing with FMP Advanced on another machine. The server databases are on the server machine, of course. I want to edit at my workstation. Question is, after closing the file or files on the server, what's the best method for opening for editing - or does it matter? - go to the server machine, open and edit with non-server FMP? - open the file across the network? - copy the file to my local workstation, then edit, and copy back? - should I take ALL the hosted files off-line or it it OK to just close and edit just the one (there are warnings about not finding related files... ) Back in the day as I recall, FM was very clear not to run FMPS and regular FMP on the same machine. I think there were warning about AFP and FMPS running on the same computer, but I can't find current v 12 documentation about that. Does this make my question more clear? This would seem to be a common occurance (hosted files ALWAYS need tweaking, right?). I assumed there would be a clear recommended best practice out there.
  12. Hi there, I'm getting back into details of FMP Server and wanted to ask for some advice about recommended methods for tweaking hosted files. We've had our FMP system that has run like a clock since version 5-something. We tweaked it a bit with the big change at version 7, as I recall. But then again we haven't had to touch it. Sweet. But now the time has come - our company and practices have evolved and so must our FMP databases. Not in a big way - need to tweak layouts and scripts a bit. Maybe change some container fields. We host FMPS 12 on a dedicated iMac. I'm looking for the easiest and quickest way to access my database files from a remote computer. I can't work from the server machine directly - but I do have ARD access. I can't find any recommendations in the server documentation or the admin guide. If I've missed something obvious please point me in the right direction. Thanks so much, Jeff in VA
  13. fenton - thanks for posting this excellent workflow for converting repeating fields into separate records. question: when you say "Choose your own file/table as the source to Import" do you mean import the file into itself? when I try this I get a message saying the maximum number of users has been exceeded and the application shuts down. the file is being served up by fmpserver.
  14. Please throw a fried brain a bone! Background: I have a summary field reporting total hours in a given week. I'd like the report to show the week number for the summarized records, plus the date of the monday the week started on "week beginning" would be the head of this date column. Fields: dDate: date field for each record cDateWeekNumber = WeekOfYearFiscal(dDate;2) cMondayofDateWeek = dDate-(DayOfWeek(dDate)-1)+1 Report: subsummary on cDateWeekNumber(trailing) The Problem: sometimes, not always, the report will repeat a date in the "week beginning" column across two different week numbers - perplexing! week beginning week 8.03 32 8.10 33 8.24 34 8.24 35 8.31 36 In this particular case, there *are* records from the week of 8.17, but as you can see - they don't come up in the subsummary. Any thoughts about this perplexing case? Thanks!
  15. Same question here - my searches of the fm fora were not productive. There is a Plug-in for version 8 that I found. Any feedback on that packaged script or other techniques would be appreciated. It's hard to keep an office's contact list organized and in one place. For us we want FMP to be the mother lode, allowing updates from FMP to Address Book but not typically the other way around.
  • Create New...

Important Information

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