9 Replies Latest reply on Apr 4, 2012 12:54 PM by kaostika

    UUID

    kaostika

      Hi, I understand there are several UUID standards. Which on does filemaker use? Is there a way to decode this?

       

      Oreste

        • 1. Re: UUID
          DaleLong

          FileMaker doesn't use a particular standard, but users have developed some custom functions for this purpose.  One that comes to mind is the base36 UUID by Ray Cologon.

           

          There are some other implementations available from 360works with Scriptmaster, and some listed at filemakerstandards.org.

           

          These usually come with custom functions to decode the various parts.

          • 2. Re: UUID
            rcates00

            With the release of FileMaker 12 there is now a native UUID function. No details as of yet on how it is constructed.

            • 3. Re: UUID
              kaostika

              Yes, But I wanted to see if we can decode this one.  Ray's used current timestamp that is accurate to the second.  Some other UUID use it to millesecond.  If we can decode this then we can have a get(millsecond) function.

               

              Oreste

              • 4. Re: UUID
                DaleLong

                oh wow, cool, didn't know.  Thanks!

                • 5. Re: UUID
                  DaleLong

                  Not sure on FM12, but I'm pretty sure all previous versions it was impossible to timestamp down to the millisecond.

                  • 6. Re: UUID
                    kaostika

                    Yeah, I was thinking this could be a work around.

                     

                    Oreste

                    • 7. Re: UUID
                      DavidJondreau

                      If they did it well, it won't be "uncodeable". A good UUID shouldn't be a hash of identifiable information for privacy reasons.

                      • 8. Re: UUID
                        DrewTenenholz

                        Oreste --

                         

                        Try Wikipedia for the keyword UUID.  I believe that FM12 is using Version 4 of the ISO/IEC 11578:1996 "Information technology - Open Systems Interconnection - Remote Procedure Call (RPC)" which is a random version of the UUID as follows:

                         

                        Version 4 UUIDs use a scheme relying only on random numbers. This algorithm sets the version number as well as two reserved bits. All other bits are set using a random or pseudorandom data source. Version 4 UUIDs have the form xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx where x is any hexadecimal digit and y is one of 8, 9, A, or B. e.g. f47ac10b-58cc-4372-a567-0e02b2c3d479.

                         

                        So I don't think you will be able to decode milliseconds out of these UUIDs.  On the positive side, this is an acceptable format required for healthcare databases here in the U.S. when identifying records as part of a scheme to exchange data between different electronic medical record systems.  Previous to this change, I had to use the ScriptMaster plugin to get an ID in the correct format.

                         

                        The Wikipedia article has more information on why some have argued for a UUID that does not encode any personally-identifiable information.

                         

                        -- Drew Tenenholz

                        • 9. Re: UUID
                          kaostika

                          Hi, Yes I saw the Wikipedia.  I could not figure out which one FM used.  Sux it is it v4 then.  But good for doctors!

                           

                          Oreste