Page 1 of 1

import csv file

Posted: Tue Aug 13, 2019 4:21 pm
by HPR
Hi,
I get the following error before importing csv file:

ERROR: Resource key "warning.import.keyColumn.index" not found in default bundle

does anybody know what it is?
kind regards

Re: import csv file

Posted: Tue Aug 13, 2019 6:41 pm
by maschoff
The key for this message is missing in table messages_tbl. The SQL code for It is included in file emm-mysql-messages.sql. Looks like either you use an older beta version of OpenEMM 2019 or the SQL was not executed properly by OpenEMMINstaller at install time.

You can add the message by starting mysql and executing the code:

Code: Select all

mysql -u root -p
use openemm
INSERT INTO messages_tbl (message_key, value_default, value_de, value_es, value_fr, value_it, value_nl, value_pt, deleted, creation_date, change_date) VALUES (
	'warning.import.keyColumn.index',
	'The key column for import has no index in database, so the import process will take a long time.',
	'Die Schlüsselspalte besitzt keinen Index in der Datenbank, daher kann der Import sehr lang dauern.',
	'La columna clave no contiene ningún índice en la base de datos, por tanto la importación puede tardar mucho.',
	'La colonne clé n''a pas d''index dans la base de données, le processus d''importation peut donc durer très longtemps.',
	'La colonna chiave non contiene un indice del database, per cui l''importazione può durare molto a lungo.',
	'De sleutelkolom van de database bevat geen index; de import kan om deze reden erg lang duren.',
	null,
	0,
	STR_TO_DATE('08.05.2018 17:31:37', '%d.%m.%Y %H:%i:%s'),
	NULL);

Re: import csv file

Posted: Wed Aug 14, 2019 4:56 pm
by maschoff
Please update OpenEMM via OpenEMMInstaller to latest frontend version (19.04.000.459 or later). This should fix your problem.