1

Some time ago we transferred data from CiviCRM to a different CRM (YourMembership). However, it has become apparent that we have not collected all of the data.

We have the web version CiviCRM 4.6.21. I am trying to export ALL of the data, but I keep getting warnings and errors that there is not enough memory in one of the lines of code.

In addition to that, even when I segment the data and export it in chunks, some of the data in each individual records appears to exist only within the record, and not in some master spreadsheet (e.g. ticket sales).

Any help would be greatly appreciated.

Thank you.

Improve this question
3
  • 1
    Are you using the search results export function or exporting data directly from the database?
    – Allen Hutchison
    Commented Dec 18, 2017 at 17:59
  • You will have to be more clear about what you mean with "all of the data" before I can give you a sensible answer? I am sure there are parts in the database which you do not want to export.
    – ErikH - CiviCooP
    Commented Dec 19, 2017 at 8:46
  • I am trying to export the full database: all member records, all event records, all contacts/constituents, etc.
    – Jen
    Commented Dec 19, 2017 at 18:19

1 Answer 1

Reset to default
2

Exporting 'all' data is not a simple process. You will need to eg

  • Find all Contacts: export including all Custom Fields using for Contacts
  • Find all Contribution: export including all Custom Fields using for Cont
  • Find all Events: export including all Custom Fields using for Cont
Improve this answer
3
  • Thanks! I tried this method. Unfortunately, I keep getting this error. Any thoughts on what to do? 500 SERVER ERROR Previously the error implied there was a memory problem.
    – Jen
    Commented Dec 19, 2017 at 18:32
  • maybe a constraint due to your hosting. you may need to grab smaller chunks, or try to find someone who is happy to work from a copy of the db (assuming you can get one via your host) to do the data migration
    – petednz - fuzion ♦
    Commented Dec 19, 2017 at 20:41
  • will do thank you!
    – Jen
    Commented Dec 21, 2017 at 21:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.