recombining exported data

Discussion in 'Customization & add-ons' started by _matthew_, Jan 31, 2006.

  1. _matthew_

    _matthew_ New Member

    Joined:
    May 13, 2004
    Messages:
    9
    Hi all,

    I have 8500ish records and need to export them to csv in order to compare the data with a master list. Some data will be wrong and will be changed by the batch process run on it.

    I then need to be able to import these corrections back into the database. How to do it is beating me. Can anyone help?

    The choices I can see are:

    1. delete all current records and import the spreadsheet back in. A dangerous option.
    2. find some way for aMember to compare the membership numbers in the database with those in the spreadsheet and overwrite the data. Elegant, but I don't know where to start.
    3. do it manually. As I can't tell what will change this means comparing 8500 separate records. Not an option.

    There is no option to not do this unfortuately, the changes are vital.

    Pleased for any feedback :)

    Matthew
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Matthew,
    please contact us via helpdesk and describe your task in details. We will try to help.

Share This Page