Znuny Dashboard Customer Map for Windows OTRS

Moderator: crythias

Post Reply
austinknight
OTRS newbie
Posts: 11
Joined: 09 Apr 2013, 18:24
OTRS Version?: 3.2.3
Real Name: Jason Austin
Company: Falcon Development

Znuny Dashboard Customer Map for Windows OTRS

Post by austinknight »

I have installed Znuny Google Customer Map into OTRS 3.X windows version. I see it as a dashboard widget but im unable to:

3) Build geo location data of your customer records
Just execute the following cmd program to build your geo location database. You also can do this by using var/cron/customermap cron job to build it automatically.

shell> bin/otrs.GMapsCustomerBuild.pl
NOTICE: Done (wrote 209 records).
shell>


in windows version can you tell me how to do this?

austinknight
OTRS newbie
Posts: 11
Joined: 09 Apr 2013, 18:24
OTRS Version?: 3.2.3
Real Name: Jason Austin
Company: Falcon Development

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by austinknight »

Here is as far as I've got.

C:\Program Files\OTRS\OTRS>cd bin

C:\Program Files\OTRS\OTRS\bin>perl otrs.Gmapscustomerbuild.pl
ERROR: OTRS-GMapsCustomerBuild-10 Perl: 5.12.3 OS: MSWin32 Time: Wed Apr 10 08:2
5:37 2013

Message: No Customer Data found with 'UserCity' attribute (UserStreet, UserCity
and UserCountry is used in generel)!

Traceback (2700):
Module: Kernel::System::GMapsCustomer::DataBuild (v1.1) Line: 178
Module: otrs.Gmapscustomerbuild.pl (v1.36) Line: 87

ERROR: Failed!

C:\Program Files\OTRS\OTRS\bin>

austinknight
OTRS newbie
Posts: 11
Joined: 09 Apr 2013, 18:24
OTRS Version?: 3.2.3
Real Name: Jason Austin
Company: Falcon Development

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by austinknight »

Not all customers but many have all address fields, filled in correctly.

ferrosti
OTRS superhero
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by ferrosti »

Have a look at your customer field mapping in config.pm
The fields need to have the name given in this error message.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems

Bl00dfish
OTRS newbie
Posts: 2
Joined: 05 Apr 2012, 12:21
OTRS Version?: 3.1.3
Real Name: Marcel
Company: Beschaffungsamt des BMI

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by Bl00dfish »

Hi there,

there was a change in the google api which we included in a new version.

You´ll find the new opm-file here:

http://znuny.com/d/Znuny4OTRS-CustomerMap-1.3.0.opm

After installing the opm-file via the Package Manager in the Admin Interface just restart bin/otrs.GMapsCustomerBuild.pl...

Hope that helps... ;-)

Greetz
Znuny GmbH - Enterprise Services for OTRS
Znuny4OTRS Extensions auf Github: https://github.com/znuny/
http://znuny.com

choenig
OTRS newbie
Posts: 36
Joined: 28 Sep 2012, 11:26
OTRS Version?: 3.1.10
Location: 49° 54′ N, 10° 54′ O

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by choenig »

Hey,

has anyone a working customer mapping with LDAP (2008R2) for Customer Maps and can post it?
I'm too silly to get that working... :shock:

best regards
Christian
OTRS 3.2.8 - KIX4OTRS - ConfigureCallHome - ZnunyCustomerMap - running on CentOS 6.4 and MySQL
anyone who finds clerical errors can keep it...

crythias
Moderator
Posts: 10121
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Znuny Dashboard Customer Map for Windows OTRS

Post by crythias »

This is my Config.pm entry (a different type of "map") (this opens in a new window when clicked):
[ 'CustomerCompanyStreet', 'Street', 'street', 1, 0, 'var', 'http://maps.google.com/?q=$Data{"Custom ... CompanyZIP"}', 0, "_blank" ],

Note that the http-link encloses the field:

Code: Select all

<a href=" + http-link + " + " + target + " > + CustomerCompanyStreet + </a> 
if you want to make an iFrame with the link, you can play around with this:

Code: Select all

<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.com/maps?q=$Data{"CustomerCompanyStreet"},$Data{"CustomerCompanyCity"},$Data{"CustomerCompanyZIP&output=embed"></iframe>
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask

Post Reply