Hi everyone. I can’t seem to get the import working. I created a csv file called clients.csv I added the right headers, added a line to test but just keep getting php errors. Can someone help with what is wrong?
I’m using version 1.5.3.
Here is the Partial error page:
Severity: Warning
Message: array_keys() expects parameter 1 to be array, null given
Filename: models/Mdl_import.php
Line Number: 137
Backtrace:
File: /home/aucanna/public_html/invoicing/application/modules/import/models/Mdl_import.php
Line: 137
Function: array_keys
File: /home/aucanna/public_html/invoicing/application/modules/import/controllers/Import.php
Line: 80
Function: import_data
File: /home/aucanna/public_html/invoicing/index.php
Line: 327
Function: require_once
this is repeated many times and then i get this error:
A Database Error Occurred
Error Number: 1048
Column 'client_active' cannot be null
INSERT INTO `ip_clients` (`client_name`, `client_address_1`, `client_address_2`, `client_city`, `client_state`, `client_zip`, `client_country`, `client_phone`, `client_fax`, `client_mobile`, `client_email`, `client_web`, `client_vat_id`, `client_tax_code`, `client_active`, `client_date_created`, `client_date_modified`) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2017-08-07', '2017-08-07')
Filename: modules/import/models/Mdl_import.php
Line Number: 147
even though it’s not null.
this is the content of my csv file:
client_name,client_address_1,client_address_2,client_city,client_state,client_zip,client_country,client_phone,client_fax,client_mobile,client_email,client_web,client_vat_id,client_tax_code,client_active
josh,11030 sw tempest,,lake oswego,oregon,97802,,5039555555,,,,,,1,1