CiviCRM Community Forums (archive)

I am trying to import a small CSV with a few hundred household.

The URL for the screen with the error: http://www.mygroup.org/civicrm/import/contact


I get the SQL error:
Database Error Code: Identifier name 'acbpsarah_gladstone_________________________________________________________________________________' is too long, 1059
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => CREATE TABLE civicrm_import_job_e8314c14324787c1297c3139b47b0f28 (`acbpsarah_gladstone______________________________________________________________________________________________bazx` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'acbpsarah_gladstone_________________________________________________________________________________' is too long]
    [type] => DB_Error
    [user_info] => CREATE TABLE civicrm_import_job_e8314c14324787c1297c3139b47b0f28 (`acbpsarah_gladstone______________________________________________________________________________________________bazx` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'acbpsarah_gladstone_________________________________________________________________________________' is too long]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TABLE civicrm_import_job_e8314c14324787c1297c3139b47b0f28 (`acbpsarah_gladstone______________________________________________________________________________________________bazx` text) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci [nativecode=1059 ** Identifier name 'acbpsarah_gladstone_________________________________________________________________________________' is too long]"]



)

--------------------------------------


How is the Identifier name being generated? 


And I'm an idiot, turns out OpenOffice switch my comma delimiters to semi-colons (I have no idea how though) which made the importing think all field headings on the first row were one giant field name