Interesting. So if I would switch to postgresql I would Get double The amount of characters without having to do anything else. 512 characters is still not enough though.

Would I have to change any code in OTRS if I would change to blob? where would I find this code?

As far as I understand the field CustomerIDs is created by The xml definition so I would probably have to find it in a table related to xml definitions somewhere. Any idea how to find this field?

I will try to make a blob out of it and see what happens.

Thank you very much,

Regards,
Roald

Op 26 feb. 2015 00:42 schreef <prmarino1@gmail.com> het volgende:
Sorry it's been a long time since I dug into the schema. Also be aware if I remember correctly the limitation comes from MySQL. VARCHAR fields in MySQL max out at 256 characters and PostgreSQL maxes out at 512. This could in theory be resolved by transforming the column into a "TEXT" field which is essentially a BLOB containing text, but I don't know how well MySQL with searches of that field type. I know extensive work was done in PostgreSQL to make it work well for data warehouses, but I doubt much work was done on it for MySQL since I last looked.

Sent from my BlackBerry 10 smartphone.
From: Roald
Sent: Wednesday, February 25, 2015 13:28
To: Development community of OTRS
Reply To: Development community of OTRS
Subject: Re: [dev] how to change maxlength of a textarea defined in an xml file?

I had a suspicion that I would need to do something like that.

Would you happen to know how to go about this?

Thank you very much,
With kind regards,
Roald

Op 25 feb. 2015 18:05 schreef "Paul Robert Marino" <prmarino1@gmail.com> het volgende:
for that you would have to alter the database schema.

On Wed, Feb 25, 2015 at 6:12 AM, Roald <depjayds@gmail.com> wrote:
> Dear all,
>
> I want to make a small adaption to this CustomerSLA module:
> http://opar.perl-services.de/package/D/DI/DIETMARB/CustomerSLA
>
> I would like to increase the amount of accepted characters of the
> CustomerIDs field.
>
> Step one is to increase the Cols and Rows in
> /opt/otrs/Kernel/Config/Files/CustomerSLA.xml
>
>     <ConfigItem Name="SLAPreferences###02_CustomerIDs" Required="0"
> Valid="1">
>         <Description Translatable="1">List of customer company IDs for which
> this SLA applies.</Description>
>         <Group>CustomerSLA</Group>
>         <SubGroup>Frontend::SLA::Preferences</SubGroup>
>         <Setting>
>             <Hash>
>                 <Item
> Key="Module">Kernel::Output::HTML::SLAPreferencesGeneric</Item>
>                 <Item Key="Label">CustomerIDs</Item>
>                 <Item Key="Desc">List of customer company IDs for which this
> SLA applies.</Item>
>                 <Item Key="Block">TextArea</Item>
>                 <Item Key="Cols">50</Item>
>                 <Item Key="Rows">3</Item>
>                 <Item Key="PrefKey">CustomerIDs</Item>
>             </Hash>
>         </Setting>
>     </ConfigItem>
>
> But If I change Cols and Rows the amount of characters when I hit Submit in
> the AdminCustomerSLA window still gets limited to 250 characters. How do I
> increase the max lenght of characters of CustomerIDs ?
>
> Thank you very much,
> With kind regards.
> Roald
>
> _______________________________________________
> OTRS mailing list: dev - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/dev
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev


_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev