JSON Classes are BAD ASS

    Robert Baehr  July 2 2022 04:03:36 AM
    Greetings:

    A company (Client) uses HCL Notes and Domino to capture and create reports on various elements.  By rule, this data must be shared with a global organization (Vendor) within a fixed time-frame for tracking purposes and quality control.   If data is submitted late, then the Client could lose its business partnership with Vendor (not good).

    The Vendor designed a new system which requires Client to submit all data in JSON format.    Since the original applications were not designed to export data in JSON, and data comes from multiple NSF files, I devised the following solution using Notes and the JSON classes in Lotusscript.  The scripts include conversion of data (dates, for example) and packaging of the data as per the JSON data model and structure supplied by the Vendor.

    Image:JSON Classes are BAD ASS

    This was frustrating to build, for the Vendor system was new and changes made on the Vendor system - causing me to revisit my new app and make adjustments therein.

    In the end, I look back and think.... THIS WAS A BLAST TO BUILD!!!!!!

    Thought I'd share a brief, real world application of Notes, Domino, and the Lotusscript JSON classes.

    Cheers!
    Robert Baehr
    The Unofficial Poster Child for Notes and Domino




      Mapping A Drive Letter To OneDrive

      Robert Baehr  January 19 2022 02:19:50 AM
      Greetings:

      Given that everyone is on the cloud migration bandwagon, I thought I'd share a little simple "trick" that  I use to map a network drive to my OneDrive (note:  This works for Google Drive with some slight modification).


      While there are some other methods that I have found on-line, many appear cumbersome and, quite frankly, I could not get any of them to work. Keeping in mind that all environments are different, I took the following approach that should work for any Windows client environment.


      Instead of using the "Map Network Drive" option of Windows Explorer, I reverted back to my old DOS days and utilized the SUBST Command.   For those brought up in a post-DOS world, SUBST works like NET USE - it assigns a drive letter to a local folder on your PC.  The base syntax is:


      SUBST L: "Path"
      , where
      • L: is the drive letter you want to use
      • "Path" is the local folder that you want to map the L: drive to

      When you specify "Path", don't forget the double quotes.


      For my example, from a DOS prompt (there's that DOS word again), I mapped the Z: Drive to my OneDrive folder by issuing the following command:


      SUBST Z: "%USERPROFILE%\OneDrive"


      That's it!  If I look in explorer, I see a Z: drive.  If I am logged into OneDrive, any files added, deleted, or modified therein will sync to the cloud.  


      For ease of management, this command can be placed in a login (or other) script so that users have a familiar drive letter in which to reference their OneDrive files.


      Hope someone finds this useful - I know I do!




      Cheers!


      Robert Baehr

      The Unofficial Poster Child For Notes and Domino






        You Are One Quarter Cup Of Coffee Away From SSL/TLS With Domino 12

        Robert Baehr  September 27 2021 04:56:59 AM
        Greetings:

        My SSL/TLS Certificates were due to expire, so I thought - what the heck - let's try the new CertMgr feature of Domino 12.  I mean, what could possibly go wrong?

        Answer:  Nothing!  

        In case you haven't read about it yet, Domino 12 includes full integration with (and a lot of automation to) the Let's Encrypt free SSL/TLS certificate authority.  

        I decided to start off with a cup of coffee - a little cream - a dash of splenda - and the Domino Administrator help database.

        After a quick NOTES.INI modification, and server restart, I entered the CertMgr.nsf database on my server.   After completing two simple forms, and submitting my request, I was amazed that the SSL/TLS certificates that I requested were fully operational.   I mean, I barely got to sip my coffee before the process was completed.

        No KYR - no STH files to deal with.  No KYRTOOL and OpenSSL tools needed.    No copy - no paste - no "retrieve certificate" needed.

        Thank you, HCL, for taking a cumbersome process and making it easy.   It's the little things.....

        Now, where's the rest of that hot coffee?


        Cheers!
        Bob Baehr
        The Unofficial Poster Child for Notes and Domino.


          What Domino R12 and ONE Cup Of Coffee Have In Common

          Robert Baehr  September 6 2021 07:28:17 AM
          Greetings:

          "What does Domino R12 and ONE Cup Of Coffee Have In Common"?

          First, if you know me, then you know I love my coffee.  Simple - a little cream, a little sweetener - and I am a happy man.

          Second, if you know me, then you know I love Domino (I didn't get "The Unofficial Poster Child for Notes and Domino" title for nothing).

          So, what's the point?

          This morning, I woke up and decided to upgrade two Domino servers from R11 to R12.   Now, I didn't enable any of the new R12 features (yet), but just to get the servers upgraded.    So, I made a cup of coffee, went into my office, and started the process.   From download to INI "tweaks" to completing the upgrade of two servers took less time than it took for me to finish one cup of coffee.  

          Yes - the process was that quick - that painless - and everything works as it did before (mail, apps, web).  In a word, flawless.   And my coffee was still quite hot when done.

          Try THAT with a 'competitive' product!

          As a customer, I really appreciate the efficiency of the upgrade process.  Hats off to HCL - well done!  Next up, since I have the CCB license, I am going to consolidate the servers.    

          I have the consolidation plan done, and I think this may actually take TWO cups of coffee.

          How can I get any happier than that?

          Happy Computing!

          Bob Baehr
          The Unofficial Poster Child for Notes and Domino






            Domino and PDF Data Transfer

            Robert Baehr  July 11 2021 02:45:38 AM
            Greetings:

            I am seeking information on bi-directional data transfer between Adobe PDF forms and Domino.   Mail aside, are there any Domino apps that have the ability to:

            - take data from a PDF form and create a document in a Domino application?
            - take data from a Domino application and automatically populate an Acrobat form?

            Of course, there would be "customization" involved (mapping PDF fields to Domino fields, PDF forms to Domino documents, etc.)

            Thoughts appreciated.




            Happy Computing!


            Robert Baehr
            The Unofficial Poster Child for Notes and Domino

              Seeking Feedback on Domino 12 Upgrade

              Robert Baehr  July 1 2021 03:03:38 AM
              Greetings:

              Has anyone encountered any issues with upgrading to Domino 12?  Environment is Windows.

              I am ready to make the jump, yet, want to be ready for any challenges that lie ahead.

              If you have any feedback, I'd love to hear it here.

              Happy Computing!
              Bob Baehr
              The Unofficial Poster Child for Notes and Domino

                Spell Check Freezing Notes - Interesting Find In The Last Place You Might Expect

                Robert Baehr  April 20 2021 03:45:06 AM
                Greetings:

                Recently, I had a user running Notes 10.0 (Basic) encounter a situation whereas the spell checker would freeze the Notes client.   I mean, complete lockup - task manager style!


                After checking all the usual NOTES.INI settings, preferences, deleting the NDK and local BOOKMARK.NSF file, etc. -- the problem continued to be a pain in the, you know... the thing!


                I took a deeper dive into the configuration, and noticed that the user was a roaming user.    I visited the folder containing the user's roaming files and discovered that BOOKMARK.NSF was a staggering 500GB in size.   Yes, you read that correctly - 500GB!


                I ran the usual maintenance utilities (COMPACT, with file size reduction - FIXUP - UPDALL) on the roaming BOOKMARK.NSF, and got it down to 150GB.   Still large, but a lot smaller than it was before.


                Once done, spell check worked perfectly, and continues to do so to this day.


                Just a simple reminder to check up on those roaming Notes files now and then - they are part of the environment, and, need some love, too.....


                Happy Computing!


                Robert Baehr

                The Unofficial Poster Child for Notes and Domino


                  BaehrWare - Still In the Domino Universe

                  Robert Baehr  March 1 2021 04:27:56 AM
                  It's been a long time comin' ....

                  https://www.baehrware.com

                  Happy Computing!
                  Bob Baehr
                  The Unofficial Poster Child for Notes and Domino

                    The Domino 11 Upgrade - Coming Soon

                    Robert Baehr  February 18 2020 03:42:52 AM
                    Greetings:

                    We found the root cause of my previous post of not seeing my Domino Utility Express in the HCL License Portal.

                    Somehow, I managed to haveTWO separate accounts with HCL!   These accounts are being merged, and, the Domino 11 upgrade will be happening soon!

                    Special shout of thanks to HCL for calling me and resolving the problem.   I don't use their support much, but, in this case, their support team rocked it!

                    Cheers!
                    Bob Baehr
                    The Unofficial Poster Child for Notes and Domino

                      The Domino 11 Upgrade (or lack thereof)

                      Robert Baehr  February 17 2020 08:04:26 AM
                      Greetings:

                      I went to upgrade to HCL Domino R11 today.  It is not appearing in my list of entitlements.   Is anyone else experiencing this?


                      Oh, and yes - I have the invoice to prove ownership.


                      Feedback appreciated.



                      Bob Baehr

                      The Unofficial Poster Child for Notes and Domino