2

An organization I volunteer for is considering this software solution. I need to see the files and fields in those files to see how they match to our current system. A brief description of the purpose of the file would be appreciated also. We have about 70,000 records. I'm a software developer, so detail would be appreciated. A large percentage of our records are imported from a voter file provided by the Secretary of State, so voter info needs to be captured. These would need to be matched to the current file and data replaced.

I'm also interested in

  1. match/merge of duplicate records;
  2. capabilities of selecting subsets of contact files based on things like member type, zip code, has email address (or not);
  3. import and export capabilities;
  4. custom fields - how easy to add and maintain?.

No doubt I'll have more questions after I learn more.

  • Welcome to StackExchange. Please note that this is a Q&A site, not a discussion forum, and our format strongly favors specific single questions that can be definitively answered. Additionally, it is an expectation throughout SE that you demonstrate your attempts at initial research. I strongly encourage you to take the site tour and review the help center for additional guidance. – choster Feb 27 '17 at 17:11
6

Sounds like you're new to CiviCRM - Welcome to the community. Here's a link to the CiviCRM data architecture page on the CiviCRM wiki.

You can create multiple custom fields in CiviCRM so you should be able create the fields you need for your existing data. During import you can choose which fields get imported and which CiviCRM field they get mapped to.

For match/merge of duplicate records - see: Deduping and Merging

For capabilities of selecting subsets of contact files based on things like member type, zip code, has email address (or not) - see: Searching and Groups & tags

I've mentioned import already - there there various way to export data, including Exporting Contacts

You should try out the demo(s) or better still, download it and create a sandbox to explore CiviCRM's functionality.

  • 2
    Sanjay posts some good links. Some additional feedback: The "data architecture" page isn't terribly helpful. You should assume you'll want to add custom fields. Custom fields are very easy to add and maintain (it happens in the web UI). Collecting subsets of contact files based on member type, zip code, etc. is all very easy; deduping is robust and you can define your own dedupe rules. Import and export are present - but if you're doing a serious project, you should consider using the API, or at least the CSV API command line tools. – Jon G - Megaphone Tech Feb 27 '17 at 21:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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