Bulk Customer Data upload in to OTRS Postgres DB

Hi ALL,
I would like to upload more than 500 customer data in to postgres db of
OTRS. I was tried with copy and pg_upload that have not been successful.
Any help?
SMPM
On Mon, Jun 11, 2012 at 5:30 PM,
Send otrs mailing list submissions to otrs@otrs.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.otrs.org/cgi-bin/listinfo/otrs or, via email, send a message with subject or body 'help' to otrs-request@otrs.org
You can reach the person managing the list at otrs-owner@otrs.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of otrs digest..."
Today's Topics:
1. Error fetchting mails with IMAPTLS (Johannes Homuth) 2. change ticketing numbering (Neil Simpson) 3. Re: change ticketing numbering (Steven Carr)
----------------------------------------------------------------------
Message: 1 Date: Mon, 11 Jun 2012 10:47:26 +0200 From: Johannes Homuth
Subject: [otrs] Error fetchting mails with IMAPTLS To: otrs@otrs.org Message-ID: <4FD5B09E.4080603@sourcepark.de> Content-Type: text/plain; charset="iso-8859-15"; Format="flowed" Hi List,
I setup my OTRS System last week (Version 3.1.6) and everything works fine. But I get stuck on an "Error" which is displayed in the SystemProtocol. It always says that he can't process mail the Array would be empty. I mean, there is no mail every time the cron job will check, but that isn't an error I guess?!? Does anyone have the same problem and/or know how to fix that?
Aktuelle Eintr?ge im Systemprotokoll
Zeit Priorit?t Einrichtung Nachricht Mon Jun 11 10:22:02 2012 notice OTRS-otrs.PostMasterMailbox.pl-10 IMAPTLS: Fetched 1 email(s) from xxxx/xx.xx.xx.xx Mon Jun 11 10:22:02 2012 error OTRS-otrs.PostMasterMailbox.pl-10 IMAPTLS: Can't process mail, email no ARRAY(0x3322e88) is empty!
-- ------------------------------------------------------- SOURCEPARK GmbH B.Sc. Johannes Homuth Hohenzollerndamm 150 14199 Berlin
Tel. : +49 (0) 30 / 39 80 68 30 Fax : +49 (0) 30 / 39 80 68 39 e-mail : johannes.homuth@sourcepark.de www : www.sourcepark.de ------------------------------------------------------ SOURCEPARK GmbH Sitz der Gesellschaft: Berlin / Amtsgericht Charlottenburg HRB 80254 Gesch?ftsf?hrung: Matthias Barmeier, Harald D?rr ------------------------------------------------------
Wichtiger Hinweis: Die vorgenannten Angaben werden jeder E-Mail automatisch hinzugef?gt und lassen keine R?ckschl?sse auf den Rechtscharakter der E-Mail zu.
Diese Email kann vertrauliche und/oder rechtlich gesch?tzte Informationen enthalten. Wenn sie nicht der richtige Adressat sind oder diese E-Mail irr- t?mlich erhalten haben, informieren Sie bitte sofort diesen Absender und ver- nichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

Hi,
This package works for mysql DB, I never use on pgSQL you can try
*
http://opar.perl-services.de/bin/index.cgi/package/C/CA/CAPEIT/CustomerUserI...
*
Regards.
Carlos Gallego
2012/6/11 sm pm
Hi ALL,
I would like to upload more than 500 customer data in to postgres db of OTRS. I was tried with copy and pg_upload that have not been successful.
Any help?
SMPM
On Mon, Jun 11, 2012 at 5:30 PM,
wrote: Send otrs mailing list submissions to otrs@otrs.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.otrs.org/cgi-bin/listinfo/otrs or, via email, send a message with subject or body 'help' to otrs-request@otrs.org
You can reach the person managing the list at otrs-owner@otrs.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of otrs digest..."
Today's Topics:
1. Error fetchting mails with IMAPTLS (Johannes Homuth) 2. change ticketing numbering (Neil Simpson) 3. Re: change ticketing numbering (Steven Carr)
----------------------------------------------------------------------
Message: 1 Date: Mon, 11 Jun 2012 10:47:26 +0200 From: Johannes Homuth
Subject: [otrs] Error fetchting mails with IMAPTLS To: otrs@otrs.org Message-ID: <4FD5B09E.4080603@sourcepark.de> Content-Type: text/plain; charset="iso-8859-15"; Format="flowed" Hi List,
I setup my OTRS System last week (Version 3.1.6) and everything works fine. But I get stuck on an "Error" which is displayed in the SystemProtocol. It always says that he can't process mail the Array would be empty. I mean, there is no mail every time the cron job will check, but that isn't an error I guess?!? Does anyone have the same problem and/or know how to fix that?
Aktuelle Eintr?ge im Systemprotokoll
Zeit Priorit?t Einrichtung Nachricht Mon Jun 11 10:22:02 2012 notice OTRS-otrs.PostMasterMailbox.pl-10 IMAPTLS: Fetched 1 email(s) from xxxx/xx.xx.xx.xx Mon Jun 11 10:22:02 2012 error OTRS-otrs.PostMasterMailbox.pl-10 IMAPTLS: Can't process mail, email no ARRAY(0x3322e88) is empty!
-- ------------------------------------------------------- SOURCEPARK GmbH B.Sc. Johannes Homuth Hohenzollerndamm 150 14199 Berlin
Tel. : +49 (0) 30 / 39 80 68 30 Fax : +49 (0) 30 / 39 80 68 39 e-mail : johannes.homuth@sourcepark.de www : www.sourcepark.de ------------------------------------------------------ SOURCEPARK GmbH Sitz der Gesellschaft: Berlin / Amtsgericht Charlottenburg HRB 80254 Gesch?ftsf?hrung: Matthias Barmeier, Harald D?rr ------------------------------------------------------
Wichtiger Hinweis: Die vorgenannten Angaben werden jeder E-Mail automatisch hinzugef?gt und lassen keine R?ckschl?sse auf den Rechtscharakter der E-Mail zu.
Diese Email kann vertrauliche und/oder rechtlich gesch?tzte Informationen enthalten. Wenn sie nicht der richtige Adressat sind oder diese E-Mail irr- t?mlich erhalten haben, informieren Sie bitte sofort diesen Absender und ver- nichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
participants (2)
-
Carlos Andrés Gallego Arboleda
-
sm pm