import csv file

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

HPR
Posts: 1
Joined: Tue Aug 13, 2019 4:12 pm

import csv file

Post by HPR » Tue Aug 13, 2019 4:21 pm

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

maschoff
Site Admin
Posts: 2177
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: import csv file

Post by maschoff » Tue Aug 13, 2019 6:41 pm

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);
OpenEMM Maintainer

maschoff
Site Admin
Posts: 2177
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: import csv file

Post by maschoff » Wed Aug 14, 2019 4:56 pm

Please update OpenEMM via OpenEMMInstaller to latest frontend version (19.04.000.459 or later). This should fix your problem.
OpenEMM Maintainer

Post Reply