Exporting to Excel

Options
Jo Lynn Brummer
Jo Lynn Brummer ✭
Ancient Membership
in Blackbaud Raiser's Edge NXT®: General Discussion

I have created an export with numerous fields, name, address, ConsID, giving history, etc. I usually export a 3 line address, city, state, zip, county and country. However, when I open the Excel spreadsheet, the fields are arranged differently, particularly the address. The zip appears first, then the city, state, 3 lines of address, then the country. Has anyone else had problems with exporting a lot of fields. I am now working on an export that has over 60 fields and need the fields to remain in the same order on the Excel spreadsheet as it appears in the export.

Tagged:

Comments

  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    Jo lynn Brummer:

    I have created an export with numerous fields, name, address, ConsID, giving history, etc. I usually export a 3 line address, city, state, zip, county and country. However, when I open the Excel spreadsheet, the fields are arranged differently, particularly the address. The zip appears first, then the city, state, 3 lines of address, then the country. Has anyone else had problems with exporting a lot of fields. I am now working on an export that has over 60 fields and need the fields to remain in the same order on the Excel spreadsheet as it appears in the export.

    I'm sure you're going to love hearing this:  According to Blackbaud solution BB616964 your export is corrupt and you'll need to recreate the export.  Sure you need all 60 fields?  [^o)]

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Jo lynn Brummer:

    I have created an export with numerous fields, name, address, ConsID, giving history, etc. I usually export a 3 line address, city, state, zip, county and country. However, when I open the Excel spreadsheet, the fields are arranged differently, particularly the address. The zip appears first, then the city, state, 3 lines of address, then the country. Has anyone else had problems with exporting a lot of fields. I am now working on an export that has over 60 fields and need the fields to remain in the same order on the Excel spreadsheet as it appears in the export.

     Josh beat me to the reply - kb 16964. 

    This is a problem and as there have been other posts regarding it, I'm assuming BB is aware of the issue.  With 60 fields, I'd opt for re-arranging the address lines in Excel instead of recreating export.

     

    Solution ID:  BB616964Product:  The Raiser's Edge 7Published:  05/22/2009Updated:  05/29/2009
     

    Description

    Columns change order when Exporting


    Environment

    The Export file is corrupt





    Answer

    1. Recreate the Export


  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    JoAnn Strommen:

     Josh beat me to the reply - kb 16964. 

    This is a problem and as there have been other posts regarding it, I'm assuming BB is aware of the issue.  With 60 fields, I'd opt for re-arranging the address lines in Excel instead of recreating export.

     

    Solution ID:  BB616964Product:  The Raiser's Edge 7Published:  05/22/2009Updated:  05/29/2009
     

    Description

    Columns change order when Exporting


    Environment

    The Export file is corrupt





    Answer

    1. Recreate the Export


    Set up and use a macro in Excel to move your columns around, assuming the RE Export rearranges the fields the same way every time.

Categories