Output to >> Clipboard >>  All Entries from Contact Search Center (CSC) loses values from last column and re-arranges column headers

Version 1

    Details

     

    Output to >> Clipboard >>  All Entries from Contact Search Center (CSC) loses values from last column and re-arranges column headers

    [STEPS TO REPLICATE]
    For example on the US Demo database with a fresh test user
    1. Log in as any user to GoldMine
    2. Click the Search button on the toolbar (there should appear by default the CSC columns - Company, Contact, Phone1, Contact, State, Postal Code - please make a note of the last visible column)
    3. Search for any contacts by entering "%" (this brings up all 16 demo records)
    4. Right Click >> Output to >> Clipboard >> All entries....


    5. Start Microsoft Excel
    6. Paste the contents of the clipboard
    >> RESULT: The content of the Postal Code is not available and the State column contents appears twice, also the column headers seem not to match


    7. Back in GoldMine >> Click the Columns button in the Search Center toolbar
    8. Click the Column Selection tab >> Add for example the Record Type (Key1) column to the search center results
    9. Click OK
    10. Verify that the Record Type column was added and that values are displayed
    11. Right click in the results pane
    12. Click Output To >> Clipboard >> All Entries



    13. Start Microsoft Excel
    14. Paste the contents of the clipboard
    >> RESULT: The content of the Postal Code is now available, but the Record Type field contents are missing and the Postal Code column contents appears twice, also the column headers seem not to match

     


    Resolution

    [CAUSE]
    This is RM # 223891


    [WORKAROUND A] - Tag all >> Output to >> Clipboard >> Current Selection
    1. Log in as any user to GoldMine

    2.  Click the Search button on the toolbar (there should appear by default  the CSC columns - Company, Contact, Phone1, Contact, State, Postal Code -  please make a note of the last visible column)
    3. Search for any contacts by entering "%" (this brings up all 16 demo records)
    4. Right Click >> Tag All
    5. Output to >> Clipboard >> Current Selection


    5. Start Microsoft Excel
    6. Paste the contents of the clipboard
    >> RESULT: All columns and contents are there as expected (the first column can be removed as it is the column with the check boxes in GoldMine



    [WORKAROUND B] - Use instead Output to >> Excel
    1. Log in as any user to GoldMine
    2.  Click the Search button on the toolbar (there should appear by default  the CSC columns - Company, Contact, Phone1, Contact, State, Postal Code -  please make a note of the last visible column)
    3. Search for any contacts by entering "%" (this brings up all 16 demo records)
    4. Right Click >> Output to >> Excel

    >> RESULT: Microsoft Excel will be started and the content from the CSC added with correct headers and content (*due to the dBASE IV format the file may appear in protected mode and requires to be enabled for further changes)



    [WORKAROUND C] - Add a further not used column (e.g. EXT1) >> Output to >> Clipboard >> All entries and modify/correct the Output in Excel
    1. Log in as any user to GoldMine
    2.  Click the Search button on the toolbar (there should appear by default  the CSC columns - Company, Contact, Phone1, Contact, State, Postal Code -  please make a note of the last visible column)
    3. Search for any contacts by entering "%" (this brings up all 16 demo records)
    4. Click the Columns button in the Search Center toolbar
    5. Click the Column Selection tab >> Add for example the Ext1 column to the search center results although this is not needed for the output
    6. Click OK
    7. Verify that the Ext1 column was added 
    8. Click Output To >> Clipboard >> All Entries
    9. Start Microsoft Excel
    10. Paste the contents of the clipboard
    >> RESULT: The content of the Postal Code is now available, but the Ext1  field contents are missing and the Postal Code column contents appears  twice, also the column headers seem not to match by one column to the right

    11. Move the headers in row 1 by one column to the right >> This makes the column headers matching with the values again


    12. Delete the column A as this column is not useful and contains duplicate information. and delete the last column Ext1 as this is not necessary at all and contains anyway no data at all