Welcome to Forums Sign in | Join | Help | Forums
in Search


Export - changing the field order

Last post 07-27-2009 6:16 AM by Anbu. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 07-21-2009 2:47 PM

    • Rolf Gube
    • Not Ranked
    • Posts 8
    • Organization: Habitat for Humanity Canada

    Export - changing the field order

    Hi, I am trying to change the field order in an export that I've created. For this export, I'm bringing over constituent, fund and appeal fields along with the three query fields that came over from the query that this export report derives from (gift, date, gift subtype.) These three query fields remain at the top despite my efforts to move these below the other fields. This seems like something that is doable but I can't figure it out, any help is appreciated.

    Thanks.

  • 07-23-2009 8:09 AM In reply to

    • Jeannine Viering
    • Top 500 Contributor
    • Posts 27
    • Organization: Hospice of Palm Beach County, Inc.
    • Products:  Blackbaud Direct Marketing, The Financial Edge, The Raiser's Edge

    Re: Export - changing the field order

    I am assuming you are running a "Gift" export which automatically exports the gift information first.  I would recommend changing the order of the columns in excel once the export is completed.

    Hope this helps,

    Jeannine

  • 07-23-2009 10:11 AM In reply to

    • Rolf Gube
    • Not Ranked
    • Posts 8
    • Organization: Habitat for Humanity Canada

    Re: Export - changing the field order

    Thanks for the reply Jeannine. Yes, this is a 'Gift' export. Changing the order once into Excel is what we have been doing up to now. I was hoping to save that extra step by defining the order from within RE. However, this does not look possible.

  • 07-27-2009 6:16 AM In reply to

    • Anbu
    • Top 50 Contributor
    • User Since: 2006
    • Posts 129
    • Organization: Ataxia UK
    • Products:  The Raiser's Edge

    Re: Export - changing the field order

    It is possible by excel macro. i dont know how it works but it basically maps the exported excel file to the format of the macro file and gives you a clean file. You can google it..

    Regards
    Anbu
Page 1 of 1 (4 items)