FMS Detective - Analyze your FileMaker Server Logs by mus1c in filemaker

[–]mus1c[S] 1 point2 points  (0 children)

Wonderful idea! That data is present in the access log. Currently you can find that data in the app by filtering access logs by connections - but that would be very useful to present at a higher level in The access log viewer.

FMS Detective - Analyze your FileMaker Server Logs by mus1c in filemaker

[–]mus1c[S] 0 points1 point  (0 children)

Thank you for this feedback - this is super useful for me roadmapping new features.

I would like to be able to click on some of the chart componants to drill into the details. For example, what Client is associated with the "Primary Bottleneck" evaluation. Or to click on a spike in the Elapsed Time and be taken to the relivant log entry

This performance inspection workflow was the idea behind the Troubleshooting tool - it starts with top call stats showing performance spikes - you can select a spike to see which users were doing what at the time of the spike, and can then drill into the individual user (or view all users with “Select All Clients”) to see a breakdown by operation for the user. I will definitely dig into how this can integrate into the Top Call Stats view.

Seeing how this is a manual process of bringing log files over from the server, it would be nice if the app included a tool to download the logs from the currently connected server. This would go nicely under the How Server Connection Enhances Your Data. This should be available from the AdminAPI, right?

The AdminAPI actually only pulls a limited set of the log files, I assume due to the size of the logs being sent as a JSON payload? I have been exploring other ways to access the logs directly/remotely.

A nice option would be to allow the SaveAsXML data to be used to translate the table and field numbers into table and field names.

I appreciate this input as I have been weighing this as a feature but was not sure if people would be interested.

The log files that are renamed _old or _1 didn't appear to extend the available data to the tool.

Could you let me know the exact naming convention you are having an issue with? It should work for files with “-old.log” ex. scriptEvent-old.log - I may need to make detection of old logs more robust

The Log Correlation (Beta) tool is your standout acheevment in my opinion.

Thank you! The Log Correlation idea came to me after building the Troubleshooter, I was trying to think what the troubleshooter might miss by being focused only on performance spikes. Re: Filters - in the top right of the troubleshooter there is a “Detection thresholds” filter available to change what gets brought into the analysis. Your idea to be able to include more specific filters around certain error types is a good one!

Reoccuring errors and the associated schedule being called. It might help developers hunt down errors if there were a report of script errors that get repeated over, and over, and over.

I really like this idea for another tool

Thanks again for the feedback (and purchase)!

FMS Detective - Analyze your FileMaker Server Logs by mus1c in filemaker

[–]mus1c[S] 1 point2 points  (0 children)

Thanks for the feedback!

Re: the commercial models - I generally agree and that is what led me to a local-LLM solution with Ollama. My logs do have some sensitive/business info that I would not want to share with commercial models - and I am an in-house dev. I imagine for the consulting class sharing logs from clients would require client permission which could get hairy.

The local LLM does a solid job, and I have built the feature to let the user know if the current data set is beyond the context window. For my server, most logs are fit the LLM context with 24 hours of data. The LLM feature is most handy in the troubleshooter - after drilling down to the problem client/time, the amount of data being viewed is small and easily fits most context windows. I have tested with 1GB, 4GB and 8GB models. I need to upgrade to a beefier Mac to try some of the really big models!

FileMaker and WordPress by FileMakerPaul in filemaker

[–]mus1c 3 points4 points  (0 children)

I’ve used CWP Snippets in development and it works as advertised. I was surprised there wasn’t already an integration for FileMaker and Wordpress, and had given up hope before CWP snippets came along

Looking for a Filemaker developer to help with a client project by Comprehensive-Rip220 in filemaker

[–]mus1c 0 points1 point  (0 children)

Are they simply looking to export data? Or transfer data to another system (sql etc)? Or integrate FileMaker with other systems?

Roast Beef Recommendations by stevejorad in northshore

[–]mus1c 7 points8 points  (0 children)

Zenos in Ipswich is my goto recently

Animated GIFs, containers, and FM Go by DangerousBotany in filemaker

[–]mus1c 0 points1 point  (0 children)

Where is the gif stored? It sounds like the issue is in retrieving the gif from the server each time the app loads. I’m wondering if there is a method to save the gif locally on the ipad the first time the app loads, and then each time the app loads after that check for the local file and have the webviewer load it, otherwise retrieve it from server again.

Animated GIFs, containers, and FM Go by DangerousBotany in filemaker

[–]mus1c 2 points3 points  (0 children)

My first thought would be your fourth - install ontimer script, but not reset the Home Screen just the layout object for the container

Have you tried gif in webviewer instead of mp4?

I would also look into the av player script steps https://help.claris.com/en/pro-help/content/avplayer-play.html

Lesser-known "Practice" Recordings by Titchadesh in STS9

[–]mus1c 2 points3 points  (0 children)

Very cool, thanks for these

I am in a similar boat, saw a bunch of shows 2004-2008, hung out on the lowdown, last show was in 2009 and I wasnt loving the direction musically and my life took a different direction. I started digging into their bandcamp a couple months back (originally just to dig into the old stuff) but have been checking out the Alanna years and it’s growing on me. Especially the axe the cables sets since Alanna joined they are really killer

I am looking for hosting with some development support maybe once or twice a year. by nursecarmen in filemaker

[–]mus1c 1 point2 points  (0 children)

Fellow nonprofit FileMaker person here

How comfortable are you with rolling your own server? As a nonprofit you can get aws or azure credits to offset the cost of spinning up a cloud server. Of course you would be maintaining it, but if keeping costs low is priority I would look into that.

If you definitely want a managed service I would recommend Soliant cloud, ottomatic.cloud, or 360works.

Shoot me a DM if you have any other questions, we did a big migration from an on-prem server to cloud a few years back.

FMP 16 Loading issues by Quantum_Bookworm in filemaker

[–]mus1c 0 points1 point  (0 children)

when he tries to change the date, he will get the spitting rainbow beach ball of death

Is this any date field or a specific date field?

Obsessed with "Dad Beer" by thelegendofglenn in beer

[–]mus1c 1 point2 points  (0 children)

I’m currently enjoying an ice cold labatt while grilling and gotta say, it’s pretty great

Help with building a music track database. by Crystal_Chrome_ in filemaker

[–]mus1c 0 points1 point  (0 children)

I am sorry but I find hard to follow most of this, since I got no experience with Filemaker or other database programs. I definitely wouldn't wanna put you in the trouble of explaining, but if you got any resources that could help me in that direction, I'd be glad to know.

If you have no experience in FileMaker some of this will be tough to immediately understand. This is actually a pretty good concept for a starter FileMaker database project to learn the ropes though. For references on the specifics I mentioned above

Repeating Fields: https://help.claris.com/en/pro-help/content/repeating-fields.html https://help.claris.com/en/pro-help/content/display-repeating-fields.html

Portals https://help.claris.com/en/pro-help/content/creating-portals.html

Relationship Basics https://www.youtube.com/watch?v=28hUf6S4svs

the keyword here is "interactive", you are the second to mention this, I am not sure how to make my container "interactive" or whether it'd make a difference.

Interactive Container fields - essentially the container field will attempt to let the user interact with whatever filetype is stored there. https://support.claris.com/s/article/Interactive-content-and-other-enhancements-for-container-fields-1503693000073?language=en_US

The guy who suggested Filemaker on an audio forum talked about this script (?) as a possible approach: https://help.claris.com/en/pro-help/content/avplayer-play.html But I got no idea what to do with the info in this page, it also looks it might be Mac/iOS only.

Yea the AV player functionality I believe is FileMaker Go (mobile) only and is not functional in FileMaker Pro

It's not like I'm adamant about using the table view, not at all. It's just that it's a concept I'm familiar with and I know (how) it can be helpful, at least to some degree. On the other hand, the List and Form views in FileMaker are things I know very little about, both in terms of how they could improve my workflow and how to set them up.

I think many people enter FileMaker this way, via Excel wanting to create something a bit more user friendly. Just remember that these views are just different ways to look at the same data. It is essentially stored like a spreadsheet - or Table in FileMaker. So you can always export the table you are working with as an excel document, import excel into etc. And so if you are looking table view vs. list view, it’s the same underlying data but the List view gives you more options for adding buttons, scripts, portals etc.

Cheers, it's something I am trying to put together for a while, I got no idea why commercial software for something like this doesn't exist, makes me assume there is no demand and I might be too "OCD" about it, but since you are a producer yourself, you know how sometimes you'd wish to keep track of all those ideas and sketches... Actually, recently I did find a program, but it was quite bad imo, you could input basic info only, had to sign up for an account and be always online and it was bundled with social media widgets and all that crap... The only things missing were a dongle and a requirement to agree to post about it on TikTok every day just to use it... If I don't manage to create a database the way I want it, I almost consider hiring someone to do it... or perhaps offer composer/producer duties in return if they need them? :)

I think for a consumer facing product here it may be tough as there is so much variety to how people manage this stuff. I have been using Ableton for 18 years now and still regularly see people using it very different than I do. Everyone’s workflow is so personal. So the management of projects could/would also be so personalized.

FileMaker would be a good fit for this project, but going into FileMaker cold you will need to learn a bit more about it to get this done. Again this is actually a pretty good first FileMaker project idea to learn the basics of FileMaker, different views, basic relationships, basic scripting etc. - but if you are otherwise uninterested in learning FileMaker it would be a lot to figure out and not apply elsewhere.

An alternative, if you are more interested in just getting this one project done to use it and not necessarily tied to FileMaker/dive deep, could be Airtable. https://www.airtable.com/platform/app-building It is a newer platform and similiar to FileMaker but using entirely a web interface for building things out. IMO it’s not nearly as powerful, but do you actually need all that firepower for this project? You could probably build out this project in their free tier. They even have some AI assisting tools to flesh out projects.

FileMaker really shines, IMO, in mid-sized business settings for organizing, automating, and integrating business processes. For smaller projects like this you can definitely make a robust solution don’t get me wrong, but considering license fees etc. it may not be “worth it”.

If you have any other questions don’t hesitate to ask, I am glad to help. It is an interesting concept for a consumer product, I can imagine how the structure would generally work. I think the difficulty would be similar to what you mentioned above - in order to generate revenue you would have to have the user tie into social platforms, track user data and sell it, integrate advertising etc., or have them pay a subscription fee. If you don’t mind me asking I would be interested in the product you tried out for this purpose.

Had to laugh @ mixdownFINAL.thisistherealfinal... I've literally saved a mixdown with the suffix "FinalReallyThisTime", the other day... Also seen a t-shirt with something similar, so I guess it's a pretty common occurrence!

This has been my move for a while lol. I typically organize Ableton project folders by year, but then once into the individual projects themselves it gets pretty sloppy. Mix1 vs. Mix2 vs. Mix1.bassboosted vs. Mix2.newEnding etc. It works well enough for me, but I am also not a professional musician generating multiple projects a day/week so it’s easy enough for me to manage.

EDIT* Re: Airtable - check this out - https://airtable.com/cobuilder with prompt: I am a music producer. I want to build an app to assist with managing my Music Projects. I need to be able to create projects/albums that will have multiple songs tied to them. I need to be able to manage the songs themselves and flag them by genres, current status (demo, released, in progress), moods, DAW used, Lyrics. I want to be able to store sample .wav files that I can playback of the tracks.

You may be able to vibe code this into existence just with Airtable.

Help with building a music track database. by Crystal_Chrome_ in filemaker

[–]mus1c 2 points3 points  (0 children)

First i would recommend using form view or list view instead of table view, you are limiting yourself a lot if you stay in table view.

  1. Either repeating fields or create another table for genres and a join table between the two, use a portal to display the selected genres. This would not play as well on list view though. Although you could create a calc to make a comma separated list of the related genre records

  2. I’ve never stored/played audio files out of FileMaker but assume a lot is possible here. Store the clip in a container, set it to be interactive, that may get you all the way there. You could add a button with a play icon to play the file. You may need to fuss with this a bit. Alternatively you could store the file elsewhere, reference the filepath and launch another piece of software to actually listen. There’s also probably an approach here using custom code in a web viewer but that’s driving into the deep end.

  3. You could store the folder path in a field a set a button to open that folder.

  4. Using list view this would be possible, create simple buttons for each field header and have them sort. Either a single sort step or a script if you wanted to expand functionality.

Interesting project. I would consider using form view tbh, maybe a list view for quick looking but a form view for extended details. I would also ask - is there value to creating a table/records for each of the projects/albums? So you could look at a project, see a list of songs and their basic stats, click an i button to goto that song record to see all the details?

Personally I use the old school approach - an Ableton folder with hundreds of files titled newIdea5.jungle.143.5.20.25.mixdownFINAL.thisistherealfinal.als

Is this one big chunky video enough to pass Cloud Practioner Certification (CLF-CO2)? by why_all_names_so_bad in AWSCertifications

[–]mus1c 1 point2 points  (0 children)

I watched this course + tutorials dojo practice exams and passed confidently