{* +--------------------------------------------------------------------+ | CiviCRM version 3.1 | +--------------------------------------------------------------------+ | Copyright CiviCRM LLC (c) 2004-2010 | +--------------------------------------------------------------------+ | This file is a part of CiviCRM. | | | | CiviCRM is free software; you can copy, modify, and distribute it | | under the terms of the GNU Affero General Public License | | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | | | | CiviCRM is distributed in the hope that it will be useful, but | | WITHOUT ANY WARRANTY; without even the implied warranty of | | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | | See the GNU Affero General Public License for more details. | | | | You should have received a copy of the GNU Affero General Public | | License and the CiviCRM Licensing Exception along | | with this program; if not, contact CiviCRM LLC | | at info[AT]civicrm[DOT]org. If you have questions about the | | GNU Affero General Public License or the licensing of CiviCRM, | | see the CiviCRM license FAQ at http://civicrm.org/licensing | +--------------------------------------------------------------------+ *} {htxt id='choose-data-source-intro'}

{ts}The Import Wizard allows you to easily upload contact records from other applications into CiviCRM. For example, if your organization has contacts in MS Access© or Excel©, and you want to start using CiviCRM to store these contacts, you can 'import' them here.{/ts}

{ts}You can import records from a comma-separated-values format (CSV) file, or using a SQL query. See "Choose Data Source" help below for more information.{/ts}

{ts}After importing contacts, you may also want to import contributions, membership info and/or event participation data for these contacts. If so, first make sure that the corresponding CiviCRM component is enabled from Administer CiviCRM » Global Settings » Enable Components. Enable CiviContribute, CiviMember, and/or CiviEvent. Then navigate to the Import option found in each component's menu (e.g. CiviContribute » Import Contributions).{/ts}

{/htxt} {htxt id='contact-type'}

{ts}Select Individual for Contact Type if each record in your file represents and individual person - even if the file also contains related Organization data (e.g. Employer Name, Employer Address, etc.).{/ts}

{ts}Select Organization or Household if each record in your file represents a contact of that type. (NOTE: Some built-in contact types may not be enabled for your site.){/ts}

{ts}Importing Contact Subtypes - If your file contains a mix of "subtypes" belonging to a built-in type, select the built-in ("parent") type here. You will then be able to map a Contact Subtype field from your file which sets the subtype for each row. EXAMPLE: If you are importing a mixture of Individuals who are "Students" and "Parents" and "Staff" subtypes, select "Individual" here AND include a column in your import file which contains the subtype for each row.{/ts}

{ts}If all records in the file belong to the same subtype, then select that subtype from the "Subtype" field. All records will be automatically assigned to that subtype. In this case you do NOT need to include a Subtype column in the file.{/ts}

{/htxt} {htxt id='contact-sub-type'}

{ts}Select a specific Contact Subtype here ONLY if all you want all records in this import to be assigned to that subtype. EXAMPLE: If all records are of the Student, select that subtype here and it will be assigned to all import records.{/ts}

{ts}Do NOT select a Contact Subtype if your import file contains a mixture of subtypes. In that case, select the built-in ("parent") type, and make sure you'll file includes include a column which sets the subtype for each row.{/ts}

{/htxt} {htxt id='dupes'}

{ts}If a contact in the import file appears to be a duplicate of an existing CiviCRM contact...{/ts}

{ts}Skip: Reports and then Skips duplicate import file rows - leaving the matching record in the database as-is (default).{/ts}

{ts}Update: Updates database fields with available import data. Fields in the database which are NOT included in the import row are left as-is.{/ts}

{ts}Fill: Fills in additional contact data only. Database fields which currently have values are left as-is.{/ts}

{ts}No Duplicate Checking: Inserts all valid records without comparing them to existing contact records for possible duplicates.{/ts}

{/htxt} {htxt id='data-source-selection'}

{ts}Select the source of the imported data. By default the following choices are possible:{/ts}

{ts}Comma-Separated Values (CSV){/ts}
{ts}A spreadsheet-like file with the contact data in each row. Data fields are separated by commas. You can export to a "CSV" file from most spreadsheet applications, many database managers, and as well as other contact management and address book applications. Consult the documentation for your application if you're not sure how to do this. Save this file to your local hard drive (or an accessible drive on your network) - and then choose that file as your Import Upload File.{/ts}
{ts}SQL Query{/ts}
{ts}A direct SQL query in the form of a SELECT query. For example:{/ts}
SELECT first_name, last_name, email FROM somedatabase.sometable
{ts}This query can be against a different database, but that database has to be on the same database server and the CiviCRM database user has to have the SELECT privilege (and any other privileges required to execute the query).{/ts}

{/htxt}