Znuny Open Source Ticketsystem

My 1 row file, which fails too, is: "10249";"ZUBH98228108";;;;"My Loc 2";;"0B103T54XD32";"Production";"Operational" I'm not having any error with the Perl modification I did, and I have all data up to date. I have checked daily logs with no...

With [MyId, identifier] I mean the field [MyId] is marked as an identifier. I suppose you accounted "identifier" as a column, which is not. Anyway, it should work if I do "export" from GUI and take the same file and "import" from command line, but not always runs ok. I ...

After some investigation and learning some Perl, I have modified the following code on CSV.pm file (module Kernel::System::ImportExport::FormatBackend::CSV) while ( my $Column = $ParseObject->getline($FH) ) { push @ImportData, $Column; $LineCount++; } For this code, where eof is tested... until ( eo...

I have checked that if I don't quit the process, all data is imported to database, but in the console remains the error and looks like it is not finished, not returning control to the system... I need to end it manually, so I'm afraid the cron threads stay after the execution is finished.

Versions installed are:

otrs-3.1.10
ITSM-3.1.6


For more info:

Linux Ubuntu 10.04 TLS
PostgreSQL 9.1
Perl 5.10.1

I have created a file with just one row, and the problem is the same. "10249";"ZUBH98228108";;;;"My Loc 2";;"0B103T54XD32";"Production";"Operational" But now, I get a message with items processed Import in process... ERROR: OTRS-ImportExpor...

I just did, and watched the hidden characters, and I have seen nothing strange. That line, is the last line in file. I tried to add and extra LF, but neither works. When using the web GUI, I see on the log that the self-exported file has been correctly imported... but when I do the same operation fr...

I can't solve the problem. I have reviewed the file to import and everything is correct. I have tested to export from OTRS and import the same file, and it returns the same error: Import in process... ERROR: OTRS-ImportExport-10 Perl: 5.10.1 OS: linux Time: Sun Sep 16 19:27:47 2012 Message: ImportEr...

I resolved it... some folders didn't have the correct permission... I have executed SetPermissions again and now it's correct... maybe I missed or mistaken some parameter before. Now my problem is the input file, which is an export from another Postgre database: Message: ImportError at line 1615, Er...

For more info, the otrs account is in the www-data group.

Hi again! I have created a bash script to import data to the CMDB periodically through a cron. The job is working fine, while the CSV to import is quite small (less than 200 rows). I have configured the template to accept 1000 rows, but the process shows errors afte processing about 200 rows. The me...

Thank you! I had read that thread before but I lost the module reference in my mind.

Now it's working!!

The complete sentence I use is:

perl /opt/otrs/bin/ImportExport.pl -n <templateId> -a import -i <filenameToImport>

Ok, that's a good solution... but I don't figure out how to call the module from cron, without authentication and the input type file for telling where is the file to import. I can do something like this, but it won't work because input type file must be used on 'post' statements, not 'get' (maybe I...

I have used the module to test my templates... but I need to do it every day... so it's a work for an agent, not for a human being.

What I want to do is to invoke the "Import/Export" module from an agent... how can I do it?

I'm new in OTRS, and I have been learning for the last few days. Now I have my configuration done, including the ITSM module installed and working. My CMDB is outside OTRS, so I have created a template to import data through a CSV and it is working properly. Now, I would like to create an agent to i...