Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,
     for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

     

    fmf AD.jpg

     

     

All Activity

This stream auto-updates     

  1. Today
  2. Not really, because I don't understand what you're describing. I answered in general, picking on the two phrases that made some sense to me. The rest is very vague (to me, anyway). I suspect your basic approach is wrong. At least I cannot think of a scenario where it would be necessary - or desirable - to tag one record among many as "master". That's not how a relational database is supposed to be organized. But again, I am speaking in general and I could well be missing the big picture here.
  3. Yesterday
  4. Charts can be a powerful way to quickly see how your data stacks up. There can be simple charts made directly within FileMaker to complex ones that are created by outside vendors. To catch future live streams, check out the schedule at: https://fmtraining.tv/#LIVE Download the demo file here : bit.ly/chart_demo support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  5. Thanks, The EAV model information was helpful, I spent all day reviewing it. I want to maintain the usability for the purpose which I created it. To do this I've displayed the data in a portal which is filtered to only display the record labelled "master" is a specific feild. I want to write a script that will switch the last input to "master" while switching the previous "master record" to an alternative label "record". I am struggling with having the script look for previous related records labelled "master"and changing the field in that record. any thoughts?
  6. Hello Wim, Thank you for your reply. Yes, I automatically received my new cert a week before the old one expires but my password log book is in my office and the University is in lock-down right now. Anybody found on campus without special permission would be in trouble and I doubt a request to get my serverKey.pem password would qualify. I therefore made a new serverKey.pem/CSR request to get a new certificate for which I had the necessary serverKey.pem password on hand. I did not try removing the existing cert with fmsadmin before importing the new one - thank you for the suggestion. I'll try it this evening after our users have logged off and I can work on the server. Will send an update one way or the other.
  7. Hi Colin, To renew an SSL cert you do NOT need to generate the certificate request again, normally your vendor will just issue a new cert and you use that plus the original serverKey.pem file to import the new cert. What you are doing is called 'rekeying' a cert which is different than renewing. End result is the same except that you're giving yourself more work. The name on your FM license does not matter at all. FM does not do any kind of checks except to verify that you have the proper passkey that was set when generating the signing request. The name ownership is validated by the SSL vendor, not by FM. FM doesn't care what name you put on the SSL cert. Since you had an cert already, did you try the fmsadmin command line to delete the previous cert, before importing the new one?
  8. Recently I got a client complaining about a crash in FileMaker Server with a script using plugin functions. A look on the trace output from our plugin via MBS("Trace"; $path) function call to write a log file showed the problem. The loops where running endless. And an endless loop eventually causes trouble when some resource is limited, e.g. available memory. Looking on the script we basically found this a couple of times: Go to Layout [ “MyTable” (MyTABLE) ; Animation: None ] Perform Find [ Restore ] Go to Record/Request/Page [ First ] Loop # process record # # next Go to Record/Request/Page [ Next ; Exit after last: On ] End Loop For privacy reasons, I removed the code to process the record and renamed the layout and file here. But otherwise the script contains a few of those loops and not all loops work well. Does the script look fine? Look and decide before you continue to read. Adding error handling First thing missing in the script is error handling. Everything could go wrong. First the call to "Go to Layout" may go wrong, so we need to add error handling there. Go to layout may fail for a lot of reasons. First someone may have deleted the target layout or the script step was pasted with Copy & Paste and nobody reassigned a layout. If you go to a layout by name, someone may have renamed it so the script step fails to find it. Security may kick in and disallow you leaving current layout or entering the target layout. Next Perform Find may go wrong. Whether it's security forbidding something, missing or invalid search criteria. So let us prepare for an error here. But most importing, you may just not find records, so you should have an IF to check whether Get(FoundCount) > 0, before you enter the loop. The next line to go to first record may fail if there are no records, if you can't leave current record or you can't enter the first record as it may be locked. Same for the Go to Next Record script step in the loop. It will exit automatically when there are no more records, but what does it do, if it can't move to the next record? Probably stay and you have the endless loop. So let us add error checks and the script gets much longer: # avoid error dialogs to user and don't let them cancel it Set Error Capture [ On ] Allow User Abort [ Off ] # # go to first step Go to Layout [ “MyTable” (MyTABLE) ; Animation: None ] Set Variable [ $error ; Value: Get(LastError) ] If [ $error ≠ 0 ] # report to user Show Custom Dialog [ "Problem in script " & Get(ScriptName); "Failed to go to layout with error " & $error ] # return error to caller Exit Script [ Text Result: "Failed to go to layout with error " & $error ] End If # Perform Find [ Restore ] Set Variable [ $error ; Value: Get(LastError) ] If [ $error ≠ 0 ] # report to user Show Custom Dialog [ "Problem in script " & Get(ScriptName); "Failed to perform find with error " & $error ] # return error to caller Exit Script [ Text Result: "Failed to perform find with error " & $error ] End If # Go to Record/Request/Page [ First ] Set Variable [ $error ; Value: Get(LastError) ] If [ $error ≠ 0 ] # report to user Show Custom Dialog [ "Problem in script " & Get(ScriptName); "Failed to go to first record with error " & $error ] # return error to caller Exit Script [ Text Result: "Failed to go to first record with error " & $error ] End If # Set Variable [ $$list ; Value: "" ] If [ Get(FoundCount) > 0 ] Loop # process record # Set Variable [ $$list ; Value: $$List & Contacts::First & ¶ ] # # next Go to Record/Request/Page [ Next ; Exit after last: On ] Set Variable [ $error ; Value: Get(LastError) ] If [ $error ≠ 0 ] # report to user Show Custom Dialog [ "Problem in script " & Get(ScriptName); "Failed to go to next record with error " & $error ] # return error to caller Exit Script [ Text Result: "Failed to go to next record with error " & $error ] End If End Loop End If # Exit Script [ Text Result: "OK" ] You see we have a lot of error handling now. Can we make this shorter and log errors better? Yes, we can use FMSQL functions with MBS FileMaker Plugin to write an error log in the database. Please create a table ErrorLog and add a few fields: TS Timestamp ErrorMessage Text ErrorCode Number ScriptName Text AccountName Text RecordID Number TableName Text You can add more fields as needed later. Now we define a new custom function named CheckError with a parameter Operation. The function is defined with one Let statement like this: Let ( [ errorCode = Get(LastError); errorMessage = get(LastExternalErrorDetail); hasError = (errorCode ≠ 0); $$error = If ( hasError ; "Failed to " & Operation & " with error " & errorCode; ""); log = If ( hasError ; MBS( "FM.InsertRecord"; Get(FileName); "ErrorLog"; "TS"; get(CurrentTimestamp); "ErrorMessage"; errorMessage; "ErrorCode"; errorCode; "ScriptName"; get(ScriptName); "AccountName"; get(AccountName); "RecordID"; get(RecordID); "TableName"; get(LayoutTableName); "Operation"; Operation )) ]; hasError ) As you see we query error status from FileMaker and check if the error code is not zero. If we have an error, we use SQL functions in MBS FileMaker Plugin to log the error to a table. Please make sure you have a table occurrence for ErrorLog in your relationship graph. The Operation parameter to the CheckError function is used to log what we tried to do in the script and is used to populate the error message. If you have multiple "Go To Layout" script steps, you may prefer to include a prefix to specify which calls. If ever FileMaker gets a Get(LineNumber) function, we could query it here to return the line number in the current script. We set $$error with the error message as we return that from the script in case of an error. This helps to avoid us typing the error message twice when using the Custom Function as we can return $$error in the Exit Script step. Also you can see it in data viewer when stepping through the script. The MBS call to FM.InsertRecord creates the log record. This is a thin wrapper around FM.ExecuteFileSQL where the plugin builds the SQL itself. Be sure to test this once to make sure you have all data types correctly. e.g. if you created RecordID as text field, you may see "[MBS] ERROR: FQL0013/(1:134): Incompatible types in assignment." as the record number from Get(RecordID) is a number. Be sure to verify the custom function works. If you like to see a message box, you can add this line to the Let statement's list of assignments: r = if (hasError; MBS("MsgBox"; $$error)); This uses our little Msgbox function to show a dialog box with the error message. Check for context Not sure if you know it, but be prepared for every script to be triggered at anytime by anyone. You probably enable fmp:// URL script triggering, AppleScript access or you may use a plugin with a start script function. Even the FileMaker iOS SDK provides a function to trigger scripts from your delegate in Swift or Objective-C. As a little check, we may just check if the current privilege name is [Full Access] to make sure it's not a regular user account: If [ Get(CurrentPrivilegeSetName) ≠ "[Full Access]" ] Exit Script [ Text Result: "Not allowed to run here." ] End If Some scripts are supposed to run on server or client, so you can check the server status via Get(ApplicationVersion) and exit the script if called on the wrong process: If [ Position(Get(ApplicationVersion);"server";1;1) = 0 ] # not on server Exit Script [ Text Result: "Must run on server." ] End If Final Script The final script looks like this: # avoid error dialogs to user and don't let them cancel it Set Error Capture [ On ] Allow User Abort [ Off ] # If [ Get(CurrentPrivilegeSetName) ≠ "[Full Access]" ] Exit Script [ Text Result: "Not allowed to run here." ] End If # # go to first step Go to Layout [ “MyTable” (MyTABLE) ; Animation: None ] If [ CheckError("Go To Layout") ] Exit Script [ Text Result: $$error ] End If # Perform Find [ Restore ] If [ CheckError("Perform Find") ] Exit Script [ Text Result: $$error ] End If # Go to Record/Request/Page [ First ] If [ CheckError("Go To First Record") ] Exit Script [ Text Result: $$error ] End If # If [ Get(FoundCount) > 0 ] Loop # process record # # next Go to Record/Request/Page [ Next ; Exit after last: On ] If [ CheckError("Go Next Record") ] Exit Script [ Text Result: $$error ] End If End Loop End If # Exit Script [ Text Result: "OK" ] Please don't hesitate to send us your comments and questions. I wonder if we missed something? Original blog post here: Looping over records in FileMaker with error checking
  9. It's time to renew our FMS 16 SSL certificate. I generated my certificate request, submitted the application to InCommon through our organization's portal and got back a certificate and intermediate certificate as normal. However, when I tried to import the certs and keyfile I got this error: Certificate could not be imported Config_DBServer_CertificateDialog_ErrorCOMODO RSA Organization Validation Secure Server CA I used a variant of our organization's name when I generated the cert request which I know is not an exact match to the name we used in our FMS license purchase. Does FMS perform an organization name match when importing an SSL certificate or is this a different error? Would much appreciate any insight. Thanks. Colin Hunter University of Maryland, Baltimore
  10. BarbW

    Barbara

    Hello, I have been running FM Server 15 on an AWS instance for about four years and yesterday we were unable to connect to our hosted databases. It turned out to be a connectivity issue with the AWS instance that was fixed by starting and stopping the instance. I'm now able to access the hosted databases remotely, but when I remote in to the AWS instance and try to open the FM Admin Console, it says "This page can't be displayed. Make sure the web address is correct". The more detailed error says "The device or resource (localhost) is not set up to accept connections on port "16001". I am also not able to access the Admin Console remotely. I've tried restarting the AWS machine and checking to make sure the firewall FM rules allowing Port 16000 and 16001 traffic are set. Does anyone have any other ideas?
  11. Last week
  12. It's hard to tell what exactly you're looking for. There are a few methods "to store previous iterations of each field" - do a search for 'audit log'. However, the main purpose of these methods is to increase data integrity, not to "show progress or change over time". Such goal would be much better served by creating a new record for every change. If the entity you're tracking has many attributes, and you want to track the progress of each attribute individually, then consider using the EAV data model.
  13. FileMaker Go is the application that runs on an iOS device and let’s you interact with your database. It also has some unique features and capabilities that we are going to demonstrate. To watch these streams live, check out the streaming schedule at: https://fmtraining.tv/#LIVE support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  14. Todd Daniel presents on Claris Connect: Integrate and automate all critical applications whether they live on the cloud, on-premise, and even on-device. Bring together your everyday apps to create automated workflows. Quickly integrate popular apps such as QuickBooks, Mailchimp, DocuSign, Box, Slack, Dropbox, and much more. Claris Connect offers the best way to connect critical cloud applications with the real, physical world of devices, servers and sensors. The post Claris Connect – Atlanta FileMaker Developers Group 4/1/2020 appeared first on Blue Feather - FileMaker Developer, Mobile, Web. View the full article
  15. Updated script triggering plug-in for FileMaker Pro 18 adds a new folder trigger. Lienden, the Netherlands, April 2, 2020–Troi today announced the immediate availability of Troi Activator Plug-in 6.0 for FileMaker Pro 18. What is Troi Activator Plug-in? Troi Activator Plug-in is a very powerful tool for triggering scripts remotely. All from within FileMaker you can: trigger a FileMaker script on a different computer (remotely) trigger a FileMaker script over internet trigger a FileMaker script when a file is placed inside a folder use the built-in security to prevent unauthorized triggering send a number (e.g. a record ID) and a long text with the trigger start and stop listening for remote trigger messages with one script step communicate with databases in different FileMaker versions or even runtimes Except from remote triggering you can also use the Activator Plug-in for: triggering a script on a specified date and time scheduling events which trigger any script you want running a script from any FileMaker calculation, for example a tooltip calculation trigger a FileMaker script when a file is placed inside a folder validating fields on exiting a record with a custom script suited to your specific needs What is new in version 6.0? Troi Activator Plug-in 6.0 is compatible with FileMaker 18 and has the following new functionality: Tested and made compatible with FileMaker Pro 18. Added new Add Folder Trigger script step and Actr_AddFolderTrigger function. These add a folder action, which triggers a script when the monitored folder is changed, for example when a file or folder is added to or removed from the folder. Added new Remove Folder Trigger script step and Actr_RemoveFolderTrigger function. These remove a previously added folder trigger. Added a new FolderTrigger.fmp12 example file which demonstrates the new functionality. (macOS) Added echo functionality to the HTTP server. The plug-in will echo back the HTTP request, including the method and headers used. This can help with debugging an HTTP problem, for example to test HTTP requests with custom headers you want to send with our Troi URL Plug-in. The response can be either plain text or HTML formatted. Updated HTTPResponse.fmp12 to demonstrate the new Echo functionality. Version 6.0 also has the following changes and improvements: Fixed a problem in the HTTP server where an empty POST request would block until timeout. Small improvement to the HTTPResponse.fmp12 example file. Fixed a typo (a URL) in the trigger.html test page. Updated the EasyInstallTroiPlugins.fmp12 file, it can now remove the old Troi Activator Plug-in 4.5 without causing a crash. You no longer need to remove it manually. Pricing & Availability A fully functional demo version of Troi Activator Plug-in 6.0 is available on the Activator Plug-in page. Licenses cost US$ 89 per user. Details on developer licenses and multi-user discounts can be found on the Activator Plug-in page. You can order licenses from our shop. Upgrade information Version 6.0 needs a new registration. The upgrade is free for users who bought a license for Troi Activator Plug-in on or after April 23, 2019. Eligible users will be sent a new registration. Contact us if you have not received yours after April 6, 2020. Upgrades from licenses bought before April 23, 2019 are available from US$ 49 per user. Upgrade prices for other licenses can be found in the shop. You can order upgrades there.
  16. I am trying to connect to a Filemaker Database via an ODBC connection. I am using a MAC and Filemaker 18 Pro. I successfully connected using my ODBC manager, but now I want to connect with NodeJS but I don't know the connection string format, please help.
  17. Within the world of FileMaker development, there are always those golden gems which become the hallmarks of "how to do something" - despite there often being more than one way to solve a problem. For managing lists of data, prior to the existence of the While function, the go-to custom function is CustomList. When it comes to variable output display using a portal you'll almost always reference Virtual List as the commonly understood approach. When it comes to saving user state, there's always been a number of ways accomplish this. But, for my part, I'm going to declare Layout Variables as the way to solve many issues when it comes to saving user state in FileMaker. While the term "Layout Variables" can apply to either locally scoped variables or global ones used within the layout, the concept is such that you're using variables to store things for the specific layout the user is on. When it comes to saving state, whether for the specific session or in order to persist, there has to be a simple and easy way to store, reference and retrieve these values and I think that solution is finally here. In this video, I showcase the Custom Functions and methods I use to implement Layout Variables. If your FileMaker solution has a need to maintain state and make it easy to both store and restore global variables used for the user interface, then you simply must watch this video. Click the title or link to this article to view the video. View the full article
  18. Within the world of FileMaker development, there are always those golden gems which become the hallmarks of "how to do something" - despite there often being more than one way to solve a problem. For managing lists of data, prior to the existence of the While function, the go-to custom function is CustomList. When it comes to variable output display using a portal you'll almost always reference Virtual List as the commonly understood approach. When it comes to saving user state, there's always been a number of ways accomplish this. But, for my part, I'm going to declare Layout Variables as the way to solve many issues when it comes to saving user state in FileMaker. While the term "Layout Variables" can apply to either locally scoped variables or global ones used within the layout, the concept is such that you're using variables to store things for the specific layout the user is on. When it comes to saving state, whether for the specific session or in order to persist, there has to be a simple and easy way to store, reference and retrieve these values and I think that solution is finally here. In this video, I showcase the Custom Functions and methods I use to implement Layout Variables. If your FileMaker solution has a need to maintain state and make it easy to both store and restore global variables used for the user interface, then you simply must watch this video. Click the title or link to this article to view the video. View the full article
  19. Hey all, I am relatively new to using FMP and really have just picked it up so I can add features that help me do my job to my organizations existing system. With time to work from home I've been playing around with a system to help stream line case management. The system includes a needs assessment which details current information (ie. employment status, linkage, transportation, etc). I built this for utility so my team can share and store the most up to date information on each case. Sent my completed system to the person who manages our FMP and he asked that I find a way to store previous iterations of each field so we can show progress or change over time. I have spoke with him several time to try to get a grip on how to accomplish this but it just makes my head spin. The assessment is extensive, so it's really not practical to generate and fill out a new record each time. I was thinking maybe duplicating the record, but even then I unsure how and where that will be recorded. Do I need a new database? I don't have a background in any of this, I've just got a lot of time on my hands, so please forgive me if my terminology isn't always correct. I have some basic familiarity with setting up relationships and writing scripts, but I feel like I'm over my head on this one. Any assistance or guidance would be welcome.
  20. Top 3 Benefits of Using 360Deploy (Instead of Making Live File Changes!) Are you making development changes to live FileMaker files? We want to give you a better solution. Making changes to a live file is never the safest option. We wrote an article to give better approaches to upgrading, modifying, or making changes to a production FileMaker file on FileMaker Server. One of the options is to simply use 360Deploy to completely automate and safely deploy your development changes on a live file. Today, we are highlighting three benefits of using a data migration automation tool like 360Deploy. Read the Full Article Read the Full Article Interested in improving your apps even more? Check out 360Works FileMaker tools! Product Name Product Description Portfolio Bundle All of our FileMaker Plug-ins for one discounted price Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive emails, plus send SMS/Text Messages from FileMaker 360Deploy Automated, simple deployment of new database versions FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases, WordPress, Salesforce, or AWS databases Plastic Payment processing plugin RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files, plus OCR functionality and PDF Merge/Splice in Scribe 4! ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync - integrate with Google Calendar, Apple Calendar, and Exchange Calendar You can get a free fully-functional demo, learn more, or buy the product that meets your needs at any of the links above. If you need AWS consulting, custom FileMaker Plug-ins, or have any questions. Please email us at infobox@360works.com Stay updated with 360Works
  21. If you or any of your friends or family are suffering from anxiety about the coronavirus, this video offers some commonsense advice that may help. I hope it does. https://youtu.be/rKwzAGKI-J4
  22. More or less the same as: https://fmforums.com/topic/105968-export-image-list-to-separate-records/?do=findComment&comment=479010 In version 18 you also have the options of writing directly to the text file: https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Ffiles-script-steps.html%23
  23. I'd like to be able to export a text file that would contain several fields from a single record, with each field on a separate line. Here's an example: John Q Public 111 West First Street New York, NY 10001 How might I do that? I know how to export csv or Excel files, but they don't satisfy my need.
  24. FileMaker Cops Ep.2: License Pirates. Whatcha gonna do when the FM Cops come for you? FMTraining.TV, here to protect the world from bad code and development practices. Happy April Fools! support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  25. FileMaker Cops Ep.1: Chasing Loops. Whatcha gonna do when the FM Cops come for you? FMTraining.TV, here to protect the world from bad code and development practices. Happy April Fools! support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com
  26. Work from Home Productively, Securely & Sanely Tools we love & tips you can use to manage your passwords & spouse so no one gets hurt Has coronavirus tossed you into a funky home-office situation? Our work-from-home pros have a few tips to help you through these trying times. Ahhh coronavirus. Wreaking havoc not just in our personal lives, but in our work lives as well. At eXcelisys, our developers work remotely from home offices sprinkled across North America. As we’ve had years to perfect the “how-to” of working from home, we thought we’d pass along a few tips for working remotely and productively from home to ensure security and sanity as you enter this brave, new world. “Hoard bandwidth and coffee; not toilet paper.” ~ Leif Hanson, eXcelisys full stack developer Sec-UR-ity – You are at the center! When you access company data and/or databases remotely, you put the data at risk. Some things to consider: Passwords: Utilize a password manager so you can use solid passwords without duplicating them or resorting to some sort of pattern that’s easy to hack. What’s a strong password? 12 characters, numbers, symbols and a combination of upper- and lower-case letters. The harder it is to remember, the stronger the password. Think: 90T&gSq&3bZ4#t5 and not 1600Broadway (your first apartment). Create a strong master password for your password manager and it’ll be the only one you have to manage. We recommend 1Password or Dashlane (some plans include a built-in VPN) VPNs (Virtual Private Networks): To create a secure connection to another network over the Internet, use a VPN. When you use a VPN, your internet activity is encrypted (coded), making it unreadable in transit. “A VPN is a must on any network that is not your own, as man-in-the-middle hacks are script kiddie 101. The commercials you see on TV about VPNs are actually very accurate; it’s not hype.” ~ Michael Suhrbier, eXcelisys web app developer Let’s break that down out of geekspeak. A man-in-the-middle hacker is someone who inserts themselves between the victim and the server, allowing them to send, receive and alter all communication between the two – like passwords and confidential stuff. A “script kiddie” is a derogatory term used to describe amateur hackers who acquire scripts (written by others) to breach computer networks. What Suhrbier is saying is that pretty much anyone who wants to become a “man-in-the-middle” hacker can purchase the programs and scripts necessary to start hacking without having any technical prowess. Think about it: there’s never been a better time to hack with so many people working from home! Suhrbier recommends PrivateVPN.com. Backups: In the office, you probably didn’t have to worry about this because IT took care of it, but working remotely from home, you’ll need a plan. Check with your management team to see what they recommend. The basic goal is to back up all of your business data on different media (hard drives, cloud, etc.) and in different locations (in case your homebound toddler kicks some juice onto your machine). “It isn’t backed up if it isn’t in more than one place. Don’t count on an online backup as your only copy.” ~ Greg Furry, eXcelisys VP for technology Updates: Stay current with security updates and use the latest browser version. Wifi: Use a strong password for your wifi and don’t publicly broadcast your network to everyone in your building or neighborhood. If you’ve not changed the default password on your provider’s modem/router – NOW IS THE TIME! One last pro tip – “Don’t visit dubious sites,” said Furry. “I also never click on an email to see the message from my bank, credit card company, etc. I go to the site directly, login, and look there.” Following this tip will protect you from malware and phishing attacks. Home Office 101: Comfort Tips & Working Alone Together Desk work. Desks are great, but consider the benefits of flexibility. “I like to be comfortable and while I do have an office with a desk I never use either,” said Suhrbier. “I find moving around the house for a change of scenery is helpful. This desk I bought is mobile, adjustable and I can use it standing, sitting or even laying in bed.” Ergonomics. You don’t need any eXtra back pain or neck pain, so try to create a comfortable office space. Find a chair or stool to sit on and use a table or desk for your devices (i.e. don’t lay in bed or slouch on your couch because you may feel it in the morning). When your new co-worker is your … spouse. eXcelisys Solution Services Consultant Mark Clark was used to working at home — alone — until last fall when his wife, Elisabeth, took a new position and started working from home, too. For a two-office home, Mark recommends each person have their own office space and respect the boundaries of that space. Likewise, eXcelisys VP Kurt Knippel suggests having a dedicated office space with doors that can close, “so you can shut yourself away from time to time.” “We don’t barge in on each other, or interrupt. I think that is a key takeaway for couples. Respect the other person’s need for concentration and space. Knock before entering, just as you might in a traditional office setting.” ~ Mark Clark, eXcelisys Solution Services Consultant Dual screen DIY from a quarantined New Yorker Working Remotely & Productively – Starve Your Distractions & Feed Your Focus Collaboration Uberconference Zoom Video Communications Google docs Basecamp Trello Intervals Motivation: Keep the work flowing with a daily phone call, email or Slack messaging. For management, work to set daily goals with employees to keep them focused and on-task. Consider the value of a 5-minute check-in meeting each day to ensure everyone stays productive as they work remotely from home. Conversation: We’re social creatures, so isolation from co-workers stinks. At eXcelisys, we have a Slack channel called #watercooler – a place for staff to communicate and stay connected. We collaborate on several Slack channels (for our “real” work), but we all use #watercooler to tell stupid jokes, post silly memes, hurl friendly zingers at each other and rant about the WTF things our kids did last night. This outlet for levity keeps us sane in our workday isolation. Recreation: Don’t forget to move every few hours. Stand up. Stretch. Pace a bit. Walk around the block. Rustle up a load of laundry and toss it in. eXcelisys Solution Services Consultant Rick Middleton suggests you make a point of seeing the sun every day to help keep your sanity. Remote Workers Have a Proclivity for Productivity “For any organization that has never allowed remote work, this will be terrifying but the truth is that remote workers are more productive and this actually might be a valuable lesson,” said Suhrbier. To make his point, he offered this recollection of his in-office days vs. his home-office days. My Past Life in a “Corporate Cube” wake up way too early & groggy 30-40 minutes getting ready 30-50 minutes driving to work 60 minutes at the office to “wake up” 90 minutes work, not all that productive 60 minutes lunch (finally!) 60 minutes getting over food coma 60 minutes actual work 60 minutes misc. meetings, etc. 30-60 minutes driving home, angry as hell because the I-4 is always backed up Did you catch how much work I did in there? Not much! Work From Home Wake up, grab a beverage, roll my desk over and I’m productive, my mind is firing like a 12-cylinder supercar … these first four hours are WWAAAYYYYYYY more productive than a desk worker’s entire day! More Tips for Working Remotely & Productively from Home Have a dedicated place for working. Ideally that place should not be in a common area of the home. Let the family know that when you are in your dedicated place, you are at work and should not be disturbed. Be aware of dogs, kids, the mail carrier, etc., when you are in meetings. Let your family know your working hours so they can be mindful of your need for solitude – but remember to be flexible – they may need you at times! Contributing Editors: Lisa Frick The post Learn to Work from Home Productively, Securely, Sanely appeared first on eXcelisys. View the full article
  27. Use the fastest drive since this will potentially generate a fair bit of disk reads and writes. As to the ideal size": we cannot answer that since there are million variables at play for this, it heavily depends on the nature and design of your solution and anything in it that requires server-side memory (schedules, PSoS, WebD, Data API, ....) Also carefully consider how high to set the FMS cache, don't set it too high or you'll crowd what the OS can use and this will cause more frequent swap-outs of its memory to disk. Use the available monitoring tools. Set the FMS cache to 1GB and check the FMS stats.log. Use Windows Perfmon (or an extended monitoring tool like Zabbix) to figure out how much memory the system is using and how it uses the swap files). Until you have a clear picture, I wouldn't try to set a fixed swap file or if you do, then definitely check it almost constantly for the first week or so to make sure you have it right.
  28. Looks like 18.0.4 update is meant to fix that: https://support.claris.com/s/answerview?anum=000034744&language=en_US
  1. Load more activity
×
×
  • Create New...

Important Information

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