Can the Customer ID be self generated

[rohit1]

Hi All,

Can we put the Customer ID to be Auto generated in the Customer detail form, i.e we have to fill the info of Customer ID, can we make it as self generated as the same ticket number is generated.

Regards
Rohit Singh

[ferrosti]

You could setup another mapping for your customer data backend and e.g. set email as customer_id.
http://doc.otrs.org/3.0/en/html/custome ... backend-db

[rohit1]

Hi ferrosti,

I want to generate Customer ID automatically from the OTRS Software, not manually, in a particular format like ABCD/0001/11-12 and the next time it should generate to ABCD/0002/11-12, here 11-12 denotes the year, after completion of 2011 year, the format should change to ABCD/000199/12-13, please guide how can i achieve this, looking forward for your kind reply.

[ferrosti]

This is not possible by default and needs to be programmed.

[rohit1]

Hi,

Please guide me in programming, will be grateful to you.

[jojo]

you have already been told to read the developer docu.

[rohit1]

Hi,

I read the Developer docs, but there not any hint to auto generate the Customer ID, please guide anyone.

[jojo]

there is no hint as you need to develop these kind of functionality.

You'll need some deep insight on Perl development and OTRS Moduling. So read the docu and the code to learn and understand.

[rohit1]

ok, thnx

[crythias]

Hi ferrosti,

I want to generate Customer ID automatically from the OTRS Software, not manually, in a particular format like ABCD/0001/11-12 and the next time it should generate to ABCD/0002/11-12, here 11-12 denotes the year, after completion of 2011 year, the format should change to ABCD/000199/12-13, please guide how can i achieve this, looking forward for your kind reply.

Normally, I'd say use javascript, but since you have to remember and auto-increment, your needs exceed that.

[rohit1]

hi crythias,

please provide java script code, i will test if it works.

[rohit1]

Hi Crythias,

I added the below javascript code, but still not working, please suggest.


<script type="text/javascript">
function changeText(){
var A1 ='ABCi';
var lastid = '9'; // fetch this last value from database
var lastidInt = 9;
var cuntid = lastid.length;
//alert(cuntid);
if(cuntid == 1 && lastidInt < 9)
{
var noofzero = '000';
}
else if(cuntid == 1 && lastidInt == 9)
{
var noofzero = '00';
}
else if(cuntid == 2 && lastidInt < 99)
{
var noofzero = '00';
}
else if(cuntid == 2 && lastidInt == 99)
{
var noofzero = '0';
}
else if(cuntid == 3 && lastidInt < 999)
{
var noofzero = '0';
}
else if(cuntid == 3 && lastidInt == 999)
{
var noofzero = '';
}
else
{
var noofzero ='';
}
//alert(noofzero);

var id = lastidInt + 1;

var year = 2011;
document.getElementById('custid').value = A1 + '/' + noofzero + id + '/' + year ;
}

window.onload = function() {
changeText();
};
</script>

<input type='input' id='custid' value='' readonly="readonly"/>

[crythias]

Please edit your signature to include your OTRS version, Operating System, and database type.

Please indicate where your user list is obtained(otrs db? ldap?)

What you're asking is so far outside the scope of OTRS, I won't offer help on it for free.

[rohit1]

Hi,

The details are as below:

OTRS version - 3.0.7, Operating System - Windows XP , database type - MYSQL.

Please indicate where your user list is obtained - OTRS db

[ferrosti]

Fetch the last 'id' from customer_user, create a var filled with '000', append the id, remove leading zeros, check for <999, return.