Znuny Dashboard Customer Map for Windows OTRS

[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]

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]

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

[ferrosti]

Have a look at your customer field mapping in config.pm
The fields need to have the name given in this error message.

[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

[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...

best regards
Christian

[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>