50 likes | 129 Views
The reality of ETL. For my customers: How to get from Excel to CiviCRM the easiest, fastest, cheapest way possible. Scripted imports. The idea: Describe the Transform with a language ‘smarty for imports’ Make it easy: Use ‘conventions’ Use language constructs
E N D
The reality of ETL For my customers: How to get from Excel to CiviCRM the easiest, fastest, cheapest way possible
Scripted imports • The idea: • Describe the Transform with a language ‘smarty for imports’ • Make it easy: • Use ‘conventions’ • Use language constructs • Use Excel – it’s not that bad, really! filter, search/replace, split columns, lookup tables, etc. • Write a PHP function (extends the language)
Typical – membership file • Prefix, First Name, Last Name, Custom fields • Organization Name, Job Title • Membership Type, Start Date, End Date • Main Phone, Work Phone, Main Fax • Main Email, Home Email • Address • Website