CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import without Names or Emails
Pages: [1]

Author Topic: Import without Names or Emails  (Read 1018 times)

jacobhunter

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Drupal 6.22
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.14
Import without Names or Emails
March 09, 2012, 03:30:08 pm
I am working with several campaigns and am finding the requirement for First/Last name or Email address to be cumbersome with imports. For instance, when we get data on who has voted, we only get ID fields (same goes for DO NOT CALLS being only phone numbers).

I am wondering if there is a way to turn off the requirement for Names/Emails for an import to work? (Currently using Civicrm 4.08 and 4.11). I understand the logic of this requirement as a default, but it would be ideal if it was able to be turned off.

Thanks!

-Jacob

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Import without Names or Emails
March 09, 2012, 08:50:30 pm

Currently no :(

Can you take a look and see what changes need to be made to enable the below. I suspect if the entire import is an update, then the first/last or email can be bypassed

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Import without Names or Emails
March 28, 2012, 01:35:39 am
If you are importing only ID numbers, it is possible to bypass CiviCRM's import feature complete and import CSV files directly into the MySQL database using PHPMyAdmin or the MySQL command line.

You would want to practice, and make backups, but I have done this and it is possible.

It is a good idea to let CiviCRM auto_increment the id field, and import only the data fields you need into the civicrm_contact table
Try CiviTeacher: the online video tutorial CiviCRM learning library.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import without Names or Emails

This forum was archived on 2017-11-26.