When exporting to CSV file, how can the mapping assigned to certain columns, with a default mapping the values are in a wrong column?

Version 1

    Details

     

    [SCENARIO]
    - Exporting GoldMine contact information to CSV file (can be opened by Excel)
    - Spreadsheet will be read in by a third party product, and requires that the exported information reside in certain columns
    - For purposes of this article:
      - Contact1->Contact must be in the 2nd column (column B on the spreadsheet)
      - Contact1->Company must be in the 3rd column (column C on the spreadsheet)
      - Contact1->Phone1 must be in the 5th column (column E on the spreadsheet)
    - Spreadsheet should look like the following:

    - Most try to create the spreadsheet via the following method:
    1. File>>Import and Export>>Export Contact Records
    2. Select Export to a new file
    3. Select CSV File:
    4. Click Next

    5. Uncheck Additional
    6. Click Next
    7. Highlight Contact under GoldMine Fields, and click Add Field
    8. Highlight Company under GoldMine Fields, and click Add Field
    9. Highlight Phone1 under GoldMine Fields, and click Add Field
    10.  Highlight Contact1->contact, and click Edit Expr
    11.  Change Position to 2
    12.  Click OK
    13.  Highlight Contact1->company, and click Edit Expr
    14.  Change Position to 3
    15.  Click OK
    16.  Highlight Contact1->phone1, and click Edit Expr
    17.  Change Position to 5
    18.  Click OK
    19. Click Next
    20. Click ellipses under Enter the full path and file name of the destination file:

    21. Navigate to the directory you want to store the file
    22. Enter the name of the file next to File name:
    23. Click Save

    24. Click Next

    25. Select No, and Click Next
    26. Click Finish

    - The resultant spreadsheet looks like this:

     


    Resolution

    [RESOLUTION]
    1.  File>>Import and Export>>Export Contact Records
    2.  Select Export to a new file
    3.  Select CSV File:
    4.  Click Next


    5.  Uncheck Additional
    6.  Click Next

    7. Map column 1 (column A on the spreadsheet)
        - Highlight any GoldMine Field, and click Add Field
        - Highlight the just added field, and click Edit Expr
        - Under Enter expression:, replace what's there with ''' (three single quotes)
        - Click OK
    8. Map column 2
        - Highlight Contact under GoldMine Fields, and click Add Field
    9. Map column 3
        - Highlight Company under GoldMine Fields, and click Add Field
    10. Map column 4 (column D on the spreadsheet)
          - Highlight any GoldMine Field, and click Add Field
          - Highlight the just added field, and click Edit Expr
          - Under Enter expression:, replace what's there with ''' (three single quotes)
          - Click OK
    11. Map column 5
          - Highlight Phone1 under GoldMine Fields, and click Add Field
    12.  Click Next
    13.  Click ellipses under Enter the full path and filename of the destination file:

    14.  Navigate to the directory you want to store the file
    15.  Enter the name of the file next to File name:
    16. Click Save

    17.  Click Next

    18.  Select No, and Click Next

    19.  Click Finish