Jump to content

flutegirl

Members
  • Content Count

    27
  • Joined

  • Last visited

  • Days Won

    1

flutegirl last won the day on January 18 2013

flutegirl had the most liked content!

Community Reputation

1 Neutral

About flutegirl

  • Rank
    newbie

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Mojave (10.14.6)
  1. To try to explain the setup as succinctly as possible: Database is running on a FM17 Server (on a Windows virtual(?) machine... Our IT department handles that part). The FM database does a number of imports every morning from our primary (4D) database, using an ODBC driver, but I have not found a way to have those imports run successfully from the server, so I have them running on an instance on a secondary user account on my desktop computer. The scripts are triggered by adding a record to a table, which is checked every five minutes using an OnTimer script. I run a separate instance of FM17 on my user account so that I can use the database even if there is an import running. This solution has been working (fairly) well for a number of years, but last week, my desktop computer was updated to Mojave (10.14.6), and since that upgrade, it seems that the imports on the secondary account will only run while that user account is active. 1) Is anyone else doing anything similar, where they have an instance of FM running on a separate user account? 2) If so, have you had any trouble with Mojave, or have suggestions on what may be going on? 3) Any suggestions on how to fix this? My initial thought is to just open the database using FMP on the Server system and try having the imports run from there, but am concerned that might also have problems. Any suggestions would be greatly appreciated.
  2. Thanks - I didn't even think of troubleshooting it from that direction. Hopefully that will help me find the problem.
  3. I know this is a fairly old thread, but I'm struggling with this right now as well, and am running into some of the issues you're referring to here. I've been trying to create a style sheet that will allow me to export from Filemaker with custom, user-friendly headers, and keep running into issues with Excel telling me the resulting document is not valid. On a whim, I attempted to open the file in LibreOffice, and was a bit irritated to find that it opens just fine, and then once I save it from LibreOffice as a .xls file, THEN Excel will open it. I'm curious if you anyone has any ideas why this is, and how I can get Excel for Mac (latest version) to open these files directly, as I can't risk sending out files that won't open in Excel.
  4. Ah, some more testing (and getting some others here involved) found the solution. The ODBC driver was set up as a System DSN. When switched to a User DSN, it is no longer requiring admin password. Unfortunately, that doesn't help on my workstation, which has two user accounts, as I can't seem to install the same driver as a User DSN under both accounts.
  5. Our main database is a 4D database, but we use Filemaker to handle a number of "helper" applications. In order to access the data in our 4D system, we've installed ODBC Manager on a few of our workstations, and installed the 4D v13 driver from 4D's website. In general, this all seems to be working well. However, as we've begun doing more with this integration, I've run into an issue that as part of the import, the OS is asking for an administrator's name and password to allow Filemaker to make changes. The main user account I use when developing is an Admin account, so I've never run into this before. Does anyone have any experience with this, or have any ideas on how to avoid the OS requesting an admin account password to perform the import? Interestingly, this only happens the first time an ODBC import is attempted during any session of Filemaker. Filemaker Pro v13 OSX 10.9.x
  6. When the user clicks the "Paid" button, will you be populating a field to notate that the account was paid for that year? If so, you should be able to add a criteria to the conditional formatting to show the text area if dates are within range AND Paid is blank or less than a value, or something. (Of course, that means you'd have to have some intelligence built in so an account marked paid for this year doesn't remain marked paid next year.)
  7. I am looking for a way to avoid the user to close a popup without clicking a button in the popover (thereby running a script) so I can use the popover for data entry. My searching capabilities seem a bit lacking today, as I couldn't find any previous discussions on this topic. I've come up with a solution, but I thought I'd check here and see if anyone had any input or a better way to do this. My solution: I created a script "Abort Click-out" The script is simply: If [ Get ( ScriptParameter ) = ""] Exit Script [Result: False] End If Then, in the popover, I do a script trigger of: OnObjectExit: Abort Click-out; Parameter: Get(ScriptName) In this way, if a script is running, then Filemaker passes the script name to the Abort Click-out script and allows the script to exit normally, closing the popover. However, if the user just tries to click out of the popover, no script parameter is sent, so the script exits with a result of false so the popover doesn't close. Are there situations I'm not thinking of that will cause problems or break something when handling it this way? Any suggestions for a better way to do this? Any advice would be appreciated. Thanks!
  8. Hello, all. Â I am attempting to make a layout in Filemaker that will be a dashboard report of sorts, comparing one time period's sales to a previous time period (user definable). Â I have been able to gather the necessary information and display it as text on the layout with no problem. Â However, what I also want to do is to create a few charts on the page which will display the relationship for a single criteria across the two time periods, but I want to have 4 or 5 of these charts on the page. Â The problem I'm having isn't creating the chart, it's the fact that I can't seem to format the chart - no matter what I do, I end up with a chart that has a ton of white space around it and the Y-axis values are displayed on both sides of the chart. Â This is leaving the actual columns that are displaying the data as a rather small graphic in the midst of a lot of white. Â Is there any way to have more control over the way the chart is displayed in Filemaker? My Google-fu is weak today, and I have not been able to find anything of assistance when I have looked. Â I've attached two snapshots - one of what I've been able to make in Filemaker, and one that is more of what I'm looking for, but created in Excel. Â Any help would be appreciated.
  9. Thanks, that fixed it. Found a couple problems as I looked closer at the script, but this fixed the main issue. I will not be able to control the users as well as I'd like in this particular spot (they can add a product in the portal, and I can't be certain that they've committed the data before they click to run the script I'm calling), so I had put a Commit Records script step at the beginning of the script. I changed that so the first thing I'm doing is moving to a field and grabbing the product ID before I commit the record, and that fixes it. (Well, after I fixed another logic error I had in a subscript.) Thanks for your assistance! This probably would have worked better, except my script is a bit scary right now doing too many things. Had I thought this through before writing it, I would have broken it down into 2-4 subscripts that would have made this much easier (and I could have handled it all via script parameters), but as I now have it working, I don't want to go back and clean it up. I'll probably regret that decision next spring when I have to dig out this database again. ...or next week if something else breaks and I end up rewriting the script anyway.
  10. Not entirely sure how to explain this, but I have a layout with a portal. Most of the fields displayed in the portal are set as non-enterable while in browse mode, as the data is coming from a table that should not be edited. I have a script in the portal that needs to take the product ID from the portal and create a new record in another table, but there are times when I've noticed it creating a record for the wrong product ID. It seems that what is happening is that when I click into an editable field FileMaker properly identifies the record I am on and properly picks up the Product ID I want. However, if I just click on the button in the portal, or click on one of the fields that is not editable, the line itself highlights, but the record is not being selected, so the script runs having grabbed the Product ID from the first row of the portal, instead of the row I clicked. I don't want to require the user to click into an editable field before running the script, but I can't figure out how else to get the portal to know which row the script is supposed to run from. Help?
  11. Yeah, I should have written my example that way - I use that when I actually write the scripts (and am staring at the list of script steps), but when I'm thinking through a problem, I tend to forget about it and think in straight-up If/End If statements. Related question - if I just end up doing this as the long string of If/Else If/Else If/End If statements (there will probably be 10-15 of them right now... Well, that's a lot for me!), will Filemaker have to evaluate every single If, or will it just evaluate until it finds the matching one, and then skip over all the remaining else's? I'm sure since it's only a couple handfuls of possible criteria, there would be no appreciable difference in performance, but I'm trying to make sure I'm building this database in ways that will teach me best practices as well, and I'm sure if this has to evaluate every single statement, that's not a good way to make a scalable solution.
  12. I am running a database on FileMaker Server 12, and have a number of daily imports and scripts that need to be run, but due to a limitation in the ODBC driver (connecting to 4D. Server can't run the imports, it has to be done on my client machine), I can't set up a scheduled script on the Server to run the imports. The thought I had on how to get around that was to have a scheduled script on Server which would populate a "Script Request" table, which would simply add a record to a table with when the script is requested, which script is requested, and the times that it can be run. Then, I'd set up an OnTimer script on my client machine that looks at that table for any records which don't have a completed stamp, would pull the name of the script from the field, and run that script. However, unlike being able to go to layout by calculation or set field by calculation, I don't see a way to run a script by calculation. The only way I see to do this is to write one big script that goes through a bunch of If [scriptToRun = "import"] Perform Script [import] end if if [scriptToRun = "import 2"] Perform Script [import 2] end if etc. So, I have two questions: 1) Is there something I'm missing that would be a better solution than all of this? 2) If not, is there a way for me to optimize this so I don't have to remember to update multiple scripts each time I need to create a new import?
  13. Oops, I think I figured out my problem. I had the table sorted on the wrong field. It does still take a little while to update when I do a new search now, but only when my search is over a large selection - when I do a tiny subset, it's lightning fast.
  14. So I'm trying out the Fast Summaries method, but I'm getting stuck on one thing: When I go to the Line items layout in order to do the find, Filemaker gets stuck trying to update the two summary fields - on nearly 6 million records. I hoped that not including the summary field on the layout would keep that from happening, but that doesn't seem to have an effect. Is there something I'm missing that would allow me to utilize this method without FileMaker trying to update the summary fields before the GetSummary function is called?
  15. I have a layout with a Tab Control on it, housing 3 tabs. In each tab, I have a portal, all pointing to the same table occurrence, but displaying different data. 90% of the time, everything works fine. However, some of the time, when I click on a tab to switch to the data I want, the view switches to show everything as <Table Missing>, and sometimes, clicking on the 2nd or 3rd tab takes me to the 1st tab showing <Table Missing>. A second click on the desired tab causes the portal to refresh and show the proper data, but I can't figure out what's going wrong in the first place to fix it. Anyone have any ideas on how this can be fixed?
×
×
  • Create New...

Important Information

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