LISE import/export csv

[nikkio]

Hi

I'm trying to import data from a csv into a LISE instance but something seem not working.

The import finish without errors but nothing appears in the item list...

Digging in the DB i noticed that the table cms_module_liseinstance_fieldval contains data BUT the table cms_module_liseinstance_item was empty...

I've tried with a csv exported from an old listit2 instance, and one from the same LISE instance, same behaviour.

I'm doing something wrong?

Thank you for your help

.nicola


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

Cms Version: 2.1.3

Installed Modules:

AceEditor2: 1.05
AdminSearch: 1.0.1
CGExtensions: 1.52.2
CGSimpleSmarty: 2.0.5
CGUserDirectory: 1.5
CMSContentManager: 1.1
CMSMailer: 6.2.14
CustomGS: 2.2
DesignManager: 1.1.1
ECB2: 1.1
FileManager: 1.5.2
FormBuilder: 0.8.1.3
FrontEndUsers: 1.31.1
JMFilePicker: 1.0
LISE: 1.2.1.1
LISEgestionesoci: 1.2.1.1
MicroTiny: 2.0.3
ModuleManager: 2.0.2
Navigator: 1.0.3
News: 2.50.5
Search: 1.50.2
SelfRegistration: 1.9.6


Config Information:

php_memory_limit:
max_upload_size: 128000000
url_rewriting: none
page_extension:
query_var: pagina
auto_alias_content: true
locale:
set_names: true
timezone: Europe/Rome
permissive_smarty: false


Php Information:

phpversion: 5.6.15
md5_function: On (Vero)
json_function: On (Vero)
gd_version: 2
tempnam_function: On (Vero)
magic_quotes_runtime: Off (Falso)
E_ALL: 1
E_STRICT: 0
E_DEPRECATED: 0
test_file_timedifference: Nessuna differenza di tempo trovata
test_db_timedifference: Nessuna differenza di tempo trovata
create_dir_and_file: 1
memory_limit: 70M
max_execution_time: 240
register_globals: Off (Falso)
output_buffering: On
disable_functions: show_source, system, shell_exec, passthru, exec, popen, proc_open
open_basedir: /***/***/****/******/:/tmp:/var/lib/php/session
test_remote_url: Successo
file_uploads: On (Vero)
post_max_size: 128M
upload_max_filesize: 128M
session_save_path: Nessun controllo perchè open basedir è attivo
session_use_cookies: On (Vero)
xml_function: On (Vero)
xmlreader_class: On (Vero)
check_ini_set: On (Vero)
curl: On


Performance Information:

allow_browser_cache: Off (Falso)
browser_cache_expiry: 60
php_opcache: On (Vero)
smarty_cache: Off (Falso)
smarty_compilecheck: Off (Falso)
smarty_cache_udt: Off (Falso)
auto_clear_cache_age: On (Vero)

Server Information:

Server Software: Apache
Server Api: cgi-fcgi
Server Os: Linux 2.6.32-504.8.1.el6.x86_64 On x86_64
Server Db Type: MySQL (mysqli)
Server Db Version: 5.5.47
Server Db Grants: Ho trovato una dichiarazione "GRANT ALL" che sembra essere adatta


Permission Information:

tmp: /***/***/****/******/httpdocs/tmp (0755)
tmp_cache: /***/***/****/******/httpdocs/tmp/cache (0755)
templates_c: /***/***/****/******/httpdocs/tmp/templates_c (0755)
modules: /***/***/****/******/httpdocs/modules (0755)
uploads: /***/***/****/******/httpdocs/uploads (0755)
Maschera di creazione file (umask): /***/***/****/******/httpdocs/tmp/cache (0755)
config_file: 0444

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

[Jo Morg]

I need more details on every step you are taking to do the import.
For instance you should not set the item_id correspondence unless you are changing existing records. Are there any errors on the php error log?...

Digging in the DB i noticed that the table cms_module_liseinstance_fieldval contains data BUT the table cms_module_liseinstance_item was empty...

AFAIK that is unusual behavior... you need to dig in to the error logs and see if there is any clue about that.

[nikkio]

Hi Jo Morg,


First I've added some records in the instance, then exported a csv file, deleted the records and imported again... nothing appears in the list.

So I've noticed the behaviour described before...

I've no entry in the error_log.

any ideas?

[nikkio]

I've enabled "developer mode" in my PHP error log setting but still nothing appear in the log, the import return no entry in the item list...

[Jo Morg]

For instance you should not set the item_id correspondence unless you are changing existing records

Did you? or did you not?...

[nikkio]

Pardon... i've deselected the item_id and it works....

sorry for the misunderstanding...

.nicola