How to extend the length of user defined character fields?

Version 1

    Details

    Sometimes it will be desired or necessary to extend the length of certain user defined character fields within GoldMine. How can we extend the length of user defined character fields?


    Resolution

    The following ways are ONLY intended for increase the length of a user defined character field and may require a good knowledge of Microsoft SQL Server. These workflows are only partly supported by GoldMine Technical Support and therefore only provided as-is without any warranty of any kind. We strongly recommend to discuss prior with your GoldMine certified partner


    MAKE SURE TO HAVE A FULL RUNNING BACKUP OF YOUR GOLDMINE DATABASE

    A. Increase length of field in GoldMine and Rebuild the database

    1. Make sure that all users are logged out of GoldMine and all services related to GoldMine are shut down (e.g. GoldSync)
    2. Make sure that all users are logged off or have closed all applications with an integration into GoldMine (e.g. GMME, Outlook, Word etc)

    3. Make sure to have a full running backup of your GoldMine database
    4. With Master rights
    5. Tools >> Configure >> Custom Fields

    6. Browse to the old original short user defined field >> Highlight it
    7. Properties Button



    8. Extend the value in Len(gth) - Please make sure to extend the value as otherwise the existing values will be truncated! >> OK (this will change the definition of the field within the CONTUDEF table)





    9. Rebuild Button >> Confirm the rebuild action (this will adjust the field length of the user defined field within the database / CONTACT2 table)



    10. Log into GoldMine >> Verify the data and length of the changed field


    B. Increase length of user defined field in back end database and change the user defined field's definition within GoldMine

     

     

    The following possibility to increase the length of a character user defined field requires additional Microsoft SQL knowledge and is only provided as-is without any warranty of any kind. For example depending on the used Microsoft SQL version it might be necessary to allow changes in the design of tables via the SQL Server Management Studio >> please refer to http://support.microsoft.com/kb/956176. GoldMine Technical Support cannot assist in any such related inquiries for Microsoft SQL products or versions.  

    1. Make sure that all users are logged out of GoldMine and all services related to GoldMine are shut down (e.g. GoldSync)
    2. Make sure that all users are logged off or have closed all applications with an integration into GoldMine (e.g. GMME, Outlook, Word etc)

    3. Make sure to have a full running backup of your GoldMine database

    4. Open the SQL Server Management Studio on the database server

    5. Browse to the GoldMine Database

    6. Browse the CONTACT2 table

    7. Open the table in Design view via Right Click >> Design and browse to the desired field’s row or alternatively if applicable Expand the Column tree from the CONTACT2 table >> Right Click on the desired field >> Modify

    8. Extend the varchar length to the desired length e.g. from varchar(40) to varchar(50)


    >>   

    9. Save the changed layout via File >> Save CONTACT2, the save icon (disk) or CTRL+S
    10. Leave SQL Server Management Studio
    11. Log into GoldMine with Master rights
    12. Tools >> Configure >> Custom Fields
    13. Browse to the appropriate user defined field >> Highlight it

    14. Properties Button >> Extend the value in Len(gth) exactly as changed in the SQL Server Management Studio in step 8. >> OK (this will change the definition of the field within the CONTUDEF table)

    15. Close >> a message will appear Changes have been made. Would you like to rebuild the database? >> Press NO >> OK (a Rebuild is not necessary anymore as the database was already changed in the back end)


       >>   

    16. Close GoldMine and log into GoldMine again >> Verify the data and length of the changed field