The ACTION values U,N and D in the TLOG files are usually known, but what means the Action field value 'M' in GMTLOG table?

Version 1

    Details

    The ACTION values U,N and D in the TLOG files are usually known, but what means the ACTION field value 'M' in GMTLOG table?

    - In older and current documentation about the GoldMine table structure the values "N", "U", "D" in the column ACTION for the GMTLOG and CONTTLOG table are usually included and described as 

    Field Name ACTION:
    >> action performed for the record with the certain RECID = FRECID in the table from the TableId (see related Knowledge Articles # 16449 - What are the tableid values in the GMTlog and #16451 - What are the tableid values in the Contlog Table)
    >> possible ACTION values are N = New, U = Update and D = Delete
     
    - In newer versions from GMPE 9.x onward there is a further ACTION value appearing in the GMTLOG table, what does the ACTION field value "M" mean?


    Resolution

    [INFORMATION]
    - The value "M" in the ACTION column of the GMTLOG table is for Modifying CALDEF activities after being synced,
    - The ACTION "M" indicates that a user was changed / removed from either a single activity of the series or globally

    - The ACTION value "M" may appear for changes on single instances of multi-user activities in the CAL table (TABLEID “) or for global changes of multi-user activities in the CALDEF (Y)


    [SCENARIO]

    Although there might be also other scenarios but via the following steps the one can see what is happening in GMTLOG and when the "M" ACTION value is used.

     

    - in a GoldMine demo database where at least 2 Users are available (here MASTER and LENAH)


    1. Browse to Art Bardtoll
    2. Schedule >> Appointment
    3. Enter any reference + date and time
    4. Tab Users >> Add another user (now MASTER is the primary user and LENAH is additional user)
    5. Tab Recurring >> End after: 5 occurrences
    6. Button Schedule
    7. Verify the Pending Tab of Art Bardtoll  and the GMTLOG table within the SQL Server Management Studio
    >> RESULT:          
    a.  10 activities are created and visible in the Pending Tab of
    Art Bardtoll - 5 appointments for MASTER and 5 appointments for LENAH



    b. The
    GMTLOG shows a row for the TABLEID "Y" (CALDEF) with an ACTION "N" (New) and FIELDNAME "zzNew" which is new and not yet synchronized (at this point a synchronization will be performed on record level and not on field level)

     


    8. Create a manual transfer set with all data (which includes the CALDEF record) with ignore cutoff date (on the demo database!)
    Note Beside: For changing a single activity the synchronization would not be necessary to get the "M" action value for the CAL TABLEID (") 

    9. Verify the GMTLOG again within the SQL Server Management Studio
    >> RESULT:
    The GMTLOG shows now the row from 7.b. for the TABLEID "Y" (CALDEF) with an ACTION "N" (New) and FIELDNAME "zsNew" which is new and now already synchronized (from this point onwards a synchronization will be performed on field level)



    10. Right Click on one of the activities scheduled for LENAH >> Edit >> Edit the activity on date only for user LENAH >> OK



    11. Change the user for this activity to MASTER >> OK (ignore the conflict)



    12. Verify the GMTLOG again within the SQL Server Management Studio
    >> RESULT:
    The GMTLOG shows now an additional row for the TABLEID """ (CAL) with an ACTION "M" (Modified) and FIELDNAME "zzzDelUser:LENAH" which indicates that a single instance was Modified and the user LENAH removed from this single activity
     


    13.    Right Click on any of the scheduled activities >> Edit >> Edit the recurring series >> Tab Users >> Remove LENAH from the selected users >> OK



    14.    Verify the GMTLOG again within the SQL Server Management Studio
    >> RESULT:
    The GMTLOG shows now an additional row for the TABLEID "Y" (CALDEF) with an ACTION "M" (Modified) and FIELDNAME "zzzDelUser:LENAH" which indicates that the user was removed from all instances of the series