Jump to content

Dave Ramsey

Geist Interactive
  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Dave Ramsey

  • Rank
    FMPerception Developer
  • Birthday 02/04/1974

Profile Information

  • Gender
  • Location
    Delaware, Ohio, USA

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Sierra, Win 10

Recent Profile Visitors

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

  1. Jeff, While reviewing the Geist helpdesk system, I saw that you had previously raised this issue with support. Todd replied with a query regarding your machine ID, but it does not appear as if you responded. Did you receive an email from Todd on February 4th? If not, check your spam filter to see if it got lost there...
  2. Jeff, My apologies for the difficulty. When you have a chance, can you send the same message to support@geistinteractive.com. Todd can help you get your trial activated. Thank you.
  3. Jonathan, There is not currently a single-step way to do that. The fastest way to do that with the current version of FMPerception would be to do a CSV export of the occurrences of the relevant script steps, and a CSV export of the scripts flat list, and then relate them in FileMaker. It's not optimal, but it shouldn't take more than about 5 minutes to get there... That said, I like the idea, and am likely to do something with it in a future version of FMPerception.
  4. Hey, Gilles, Excel has its own particular rules when it comes to CSV, particularly related to Unicode and line feeds. I did optimize that export for feeding back into FileMaker. It's been on my agenda to do some further checking to see if I can determine why Excel is being funky... But that agenda is a long list.
  5. Aside from the freeform text search, there really isn't a query maker (yet). That said, You can get there with two CSV exports bumped into FileMaker. 1 - Export Fields (flat), which will have which fields have repetitions, and what table they're in 2 - Export Layout objects (flat) (third query from the bottom), which has all the layout objects on every layout. 3 - Import both to FileMaker, and relate the two tables on field name and table name. This assumes that table names are unique... which may not be true in a multi-file system. In that case, add a predicate based upon the File Name field in both lists. Then, make whatever report makes the most sense to you. I don't know if you want to put the count of repetitions on the layout object list, or if you would prefer to make a portal of layout appearances on the field list... That'll depend upon your process, and what you're planning to do. Will that meet your needs?
  6. Gilles, You are correct, we have not talked about those much. Those 2 columns are patterned after the 4 columns immediately to the left, which flag if a named function is referenced inside the current item/row. I pre-defined 4 of them, but left 2 that you can define yourself. To use this feature, go to the preferences, and then the "Flagged Functions" tab. The right column has the complete name of the function you'd like to search for. The left column has the name of the FMPerception column that should show a dot when that function is referenced. A couple of notes: 1 - You can see that currently, User Defined 1 shows a dot when the position function is used. This is just an example. Feel free to override it. 2 - You can see that the ExecuteSQL() column gets a dot if the ExecuteSQL function is used, or if the @.sqlExecute function is used (from the SQL Sugar collection of custom functions). This is just an example showing that a single column can flag on multiple functions simultaneously. You can use this feature yourself, by adding the names of custom functions that you use that wrap standard FileMaker functions (like SQL Sugar wraps the ExecuteSQL function). This also means that you can override any of the function columns, not just the User Defined ones. If you want to make the Evaluate() column show a dot when the LeftValues function is used (for whatever reason), you have that option. 3 - There are no rows currently for User Defined 2. That's fine. You don't have to put a value for every column. You just have to use a value for every column that you want to see dots in. 4 - This feature searches only on functions (not variables, field names, etc), and only on the complete function names. If you're searching for a function called FormatZip, your function FormatZipPlus4 will not flag (unless you also add a line for FormatZipPlus4). The criteria are not case sensitive. 5 - Don't include the parenthesis in your function names on the right hand side. 6 - The intended use case for the User Defined columns was for a migration of some kind. Let's say that your system makes use of the trim() function, but that's causing problems because it's not handling trailing returns. So, you make a new custom function for SuperTrim(). Then, I'd make User Defined 1 look for 'Trim', and make User Defined 2 look for 'SuperTrim'. Load the DDR, and make all the dots in User Defined 1 move to User Defined 2. 7 - When you change the flagged columns, FMPerception will not update the results for currently loaded DDRs (due to FMPerceptions performance caching). You'll have to do a File -> Refresh or otherwise reopen the DDR. 8 - If you really mess things up in the Flagged Columns, there's a button to Restore Function Defaults, so you can get back to where you started. After typing all this up, I realized that we do have some documentation on this. Take a look at this page, which also has a video from Todd... https://docs.geistinteractive.com/article/60-flagged-functions-columns Does that clarify things? Do you have further questions?
  7. Gilles, Absolutely correct. It works with anything that FileMaker can copy and paste, so it works for tables, fields, scripts, script steps, layout objects, value lists, custom functions, and custom menus/menus sets/menu items. I don't think there's a way to mark something correct in this forum system. I'm just happy I could answer your question.
  8. Gilles, Since you copied table fields, you would have to paste them where table fields would go. So, go to your FileMaker database, Manage > Database, and then go to the Fields tab for the table you'd like to add those fields to. Click in the big field list area, and then Command-V to paste. All those fields should then appear in that table, just as if you had copied them all from within a FileMaker table using the FileMaker interface itself. Note that the definitions of some of the calculations may not carry over due to context issues (again, as if you had used FileMaker to copy/paste), so double check them before you make use of them. Does that answer your question?
  9. Sorry for the delay in getting back to you. Post DevCon, I've been sleeping for most of the last 10 hours. 🙂 Green - means that QuickFind is on, and the field is local to the TO for the layout, and stored. Yellow - means that the value is stored, but is at least one relational step away form the context TO for this layout. So, doing a QuickFind on this field will do a relational search. If you have quickfind turned on for this layout, you should minimize these. Red - means that the field in question is an unstored value (remote or otherwise), meaning that FileMaker must first calculate the value of this field for all recored (local or otherwise) before it can even begin doing a search. As a general rule of thumb, you should never leave QuickFind activated on a field like this. Note that these indicators pay no attention to if QuickFind is activated on the layout itself. If QuickFind is turned off for the layout, you don't have to worry about these, unless you would like to turn QuickFind back on. Does that make sense? Thank you very much for the kind words, Dave Ramsey
  10. Hey, David. Andreas is correct. The current Diff Processor figures out which databases to compare based upon the names of the databases. It's helpful when you have a big multi-file system, but less so when you have 2 single-file versions that just happen to have different names. You can do it with a text editor, but my preferred way way would be to rename the local version and then export a new DDR. It's sub-optimal, I know. One of the core features of the next version of the Diff Processor is support for differing file names, but that's not yet ready for release.
  11. Most of the "back-end" code for FMPerception is 95% the same between Mac and Windows. Of the remaining 5%, most of that is just punctuation. I've gotten pretty good at mapping Swift to C# and vice-versa. When I'm doing that work, the two code bases are up side by side, and everything is named pretty much the same. The big difference occurs when I'm interacting with the OS or the UI. The APIs for communicating with each are completely different, and I've taken to not looking at the code side-by side as I don't want the Mac way of doing things to hurt my Windows code. That can lead to this kind of difference, though it's not generally visible to the user. For that matter, this was never supposed to be visible to the user. It was just debugging code for my own personal use that lived too long. Normally I'd have just hidden it, but the users found it useful... and then I wanted to replace it with the menu option... so until the menu option comes in I didn't want to start renaming files that people might be making use of... And now it's all better.
  12. By the way, the latest version of FMPerception (16.0.7) has an option under the File menu to export the Report Card or Call Chain Diagram HTML to a place of your choosing. While this is not directly provide print capability, it does make it easier to archive, transmit, or print (using your browser of choice). See the release notes for the latest version for additional details. Thanks!
  13. So, there's a relatively simple way to do this. I haven't directly implemented printing support yet for either OS (definitely non-trivial). But, when generating either a call chain diagram or a Report Card, the HTML is saved out to disk each time you make one. Windows: The file is called htmlDump.html. It's on the desktop. Mac: The file tempDump.html and it is in the Documents directory. So, bring up the relevant call chain diagram, and then find the exported html file on your machine. It's not elegant, but it's there. Good enough?
  • Create New...

Important Information

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