Re: SQL Inserts to SPANISH

"Aquiles Cohen" <[email protected]>
Newsgroups gmane.comp.otrs.internationalization
Message-ID <[email protected]>
ok. but in the templates the inserted parameters i cant see this working by
example when i chose a phone ticket Type List show me

- Incident
- Incident::Disaster
- Incident::ServiceRequest
..
..
-- etc


The AgentTicketPhone.dtl contains this code on lines 163 - 167

<!-- dtl:block:TicketType -->
          <tr>
            <td class="contentkey">$Text{"Type"}:</td>
            <td class="contentvalue"> $Data{"TypeStrg"}</td>
        </tr>

How can insert this parameters on .pm languaje files??


Aquiles Cohen.-

Homepage : http://aqcohen.blogspot.com


On Sat, Aug 9, 2008 at 8:59 AM, Manuel Hecht - OTRS AG <
[email protected]> wrote:

> Hi Aquiles Cohen
>
> It's not necessary to translate the content in the OPM files. The
> translation files do this work!
>
>  Best regards,
>  Manuel Hecht
>
> ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing
>  Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18
>   http://www.otrs.com/ :: Communication with success!
>
>
>
> Von: [email protected] [mailto:[email protected]] Im Auftrag von
> Aquiles Cohen
> Gesendet: Samstag, 9. August 2008 05:51
> An: [email protected]
> Betreff: [otrs-i18n] SQL Inserts to SPANISH
>
> 1. Is There any way to make spanish packages from .opm  packages?
>
> 2. IF 1 = True
> then Is this help?
>
>    <DatabaseInstall Type="post">
>        <TableCreate Type="post" Name="configitem">
>            <Column AutoIncrement="true" Name="id" PrimaryKey="true"
> Required="true" Type="BIGINT"></Column>
>            <Column Name="configitem_number" Required="true" Size="100"
> Type="VARCHAR"></Column>
>            <Column Name="class_id" Required="true" Type="INTEGER"></Column>
>            <Column Name="last_version_id" Required="false"
> Type="BIGINT"></Column>
>            <Column Name="cur_depl_state_id" Required="false"
> Type="INTEGER"></Column>
>            <Column Name="cur_inci_state_id" Required="false"
> Type="INTEGER"></Column>
>            <Column Name="create_time" Required="true" Type="DATE"></Column>
>            <Column Name="create_by" Required="true"
> Type="INTEGER"></Column>
>            <Column Name="change_time" Required="true" Type="DATE"></Column>
>            <Column Name="change_by" Required="true"
> Type="INTEGER"></Column>
>            <Unique>
>                                <UniqueColumn
> Name="configitem_number"></UniqueColumn>
> </Unique>
>            <Index Name="configitem_class_id">
>                <IndexColumn Name="class_id">
>                </IndexColumn>
>            </Index>
>            <Index Name="configitem_last_version_id">
>                <IndexColumn Name="last_version_id">
>                </IndexColumn>
>            </Index>
>            <Index Name="configitem_cur_depl_state_id">
>                <IndexColumn Name="cur_depl_state_id">
>                </IndexColumn>
>            </Index>
>            <Index Name="configitem_cur_inci_state_id">
>                <IndexColumn Name="cur_inci_state_id">
>                </IndexColumn>
>            </Index>
>            <ForeignKey ForeignTable="general_catalog">
>                <Reference Foreign="id" Local="class_id">
>                </Reference>
>                <Reference Foreign="id" Local="cur_depl_state_id">
>                </Reference>
>                <Reference Foreign="id" Local="cur_inci_state_id">
>                </Reference>
>            </ForeignKey>
>            <ForeignKey ForeignTable="users">
>                <Reference Foreign="id" Local="create_by">
>                </Reference>
>                <Reference Foreign="id" Local="change_by">
>                </Reference>
>            </ForeignKey>
>        </TableCreate>
>        <TableCreate Type="post" Name="configitem_definition">
>            <Column AutoIncrement="true" Name="id" PrimaryKey="true"
> Required="true" Type="INTEGER"></Column>
>            <Column Name="class_id" Required="true" Type="INTEGER"></Column>
>            <Column Name="configitem_definition" Required="true"
> Type="LONGBLOB"></Column>
>            <Column Name="version" Required="true" Type="INTEGER"></Column>
>            <Column Name="create_time" Required="true" Type="DATE"></Column>
>            <Column Name="create_by" Required="true"
> Type="INTEGER"></Column>
>            <ForeignKey ForeignTable="general_catalog">
>                <Reference Foreign="id" Local="class_id">
>                </Reference>
>            </ForeignKey>
>            <ForeignKey ForeignTable="users">
>                <Reference Foreign="id" Local="create_by">
>                </Reference>
>            </ForeignKey>
>        </TableCreate>
>        <TableCreate Type="post" Name="configitem_version">
>            <Column AutoIncrement="true" Name="id" PrimaryKey="true"
> Required="true" Type="BIGINT"></Column>
>            <Column Name="configitem_id" Required="true"
> Type="BIGINT"></Column>
>            <Column Name="name" Required="true" Size="250"
> Type="VARCHAR"></Column>
>            <Column Name="definition_id" Required="true"
> Type="INTEGER"></Column>
>            <Column Name="depl_state_id" Required="true"
> Type="INTEGER"></Column>
>            <Column Name="inci_state_id" Required="false"
> Type="INTEGER"></Column>
>            <Column Name="create_time" Required="true" Type="DATE"></Column>
>            <Column Name="create_by" Required="true"
> Type="INTEGER"></Column>
>            <Index Name="configitem_version_configitem_id">
>                <IndexColumn Name="configitem_id">
>                </IndexColumn>
>            </Index>
>            <Index Name="configitem_version_depl_state_id">
>                <IndexColumn Name="depl_state_id">
>                </IndexColumn>
>            </Index>
>            <Index Name="configitem_version_inci_state_id">
>                <IndexColumn Name="inci_state_id">
>                </IndexColumn>
>            </Index>
>            <ForeignKey ForeignTable="configitem">
>                <Reference Foreign="id" Local="configitem_id">
>                </Reference>
>            </ForeignKey>
>            <ForeignKey ForeignTable="configitem_definition">
>                <Reference Foreign="id" Local="definition_id">
>                </Reference>
>            </ForeignKey>
>            <ForeignKey ForeignTable="general_catalog">
>                <Reference Foreign="id" Local="depl_state_id">
>                </Reference>
>                <Reference Foreign="id" Local="inci_state_id">
>                </Reference>
>            </ForeignKey>
>            <ForeignKey ForeignTable="users">
>                <Reference Foreign="id" Local="create_by">
>                </Reference>
>            </ForeignKey>
>        </TableCreate>
>        <TableCreate Type="post" Name="configitem_counter">
>            <Column Name="class_id" PrimaryKey="true" Required="true"
> Type="INTEGER"></Column>
>            <Column Name="counter_type" Required="true" Size="50"
> Type="VARCHAR"></Column>
>            <Column Name="counter" Required="true" Size="50"
> Type="VARCHAR"></Column>
>            <ForeignKey ForeignTable="general_catalog">
>                <Reference Foreign="id" Local="class_id">
>                </Reference>
>            </ForeignKey>
>        </TableCreate>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Computador</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Hardware</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Ubicación</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Red</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Software</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Vencido</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Inactivo</Data>
>            <Data Key="functionality" Type="Quote">postproductive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Mantenimiento</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Piloto</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Planificado</Data>
>            <Data Key="functionality" Type="Quote">preproductive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Producción</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Reparación</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Retirado</Data>
>            <Data Key="functionality" Type="Quote">postproductive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Revisado</Data>
>            <Data Key="functionality" Type="Quote">productive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::DeploymentState</Data>
>            <Data Key="name" Type="Quote">Pruebas</Data>
>            <Data Key="functionality" Type="Quote">preproductive</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::YesNo</Data>
>            <Data Key="name" Type="Quote">Si</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::YesNo</Data>
>            <Data Key="name" Type="Quote">No</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Portatil</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Desktop</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Teléfono</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Agenda Personal</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Servidor</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Computer::Type</Data>
>            <Data Key="name" Type="Quote">Otro</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Monitor</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Impresora</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Switch</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Enrutador</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">WLAN Access Point</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Dispositivo de Seguridad</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Dispositivo de Copias</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Mouse</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Teclado</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Cámara</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Video Beam</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Modem</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Tarjeta PCMCIA</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Dispositivo USB</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Docking Station</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Escaner</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Hardware::Type</Data>
>            <Data Key="name" Type="Quote">Otro</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Edificio</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Oficina</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Piso</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Salón</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Rack</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Lugar de Trabajo</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Exterior</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Cuarto de Cableado</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Location::Type</Data>
>            <Data Key="name" Type="Quote">Otro</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Network::Type</Data>
>            <Data Key="name" Type="Quote">LAN</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Network::Type</Data>
>            <Data Key="name" Type="Quote">WLAN</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Network::Type</Data>
>            <Data Key="name" Type="Quote">Telco</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Network::Type</Data>
>            <Data Key="name" Type="Quote">GSM</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Network::Type</Data>
>            <Data Key="name" Type="Quote">Otro</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Aplicación Cliente</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Middleware</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Aplicación Servidor</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">SO Cliente</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">SO Servidor</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Herramienta de
> Administrador</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Herramienta de Usuario</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Embebido</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::Type</Data>
>            <Data Key="name" Type="Quote">Otro</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Single Licence</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Por Usuario</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Usuarios Concurrentes</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Por Procesador</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Por Servidor</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Por Nodo</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Licencia por Volumen</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Licencia Corporativa</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Licencia de Desarrollador</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>            <Data Key="name" Type="Quote">Demostración</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>             <Data Key="name" Type="Quote">de Tiempo Restringida</Data>
>             <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>             <Data Key="name" Type="Quote">Freeware</Data>
>             <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>             <Data Key="name" Type="Quote">Open Source</Data>
>             <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>        <Insert Type="post" Table="general_catalog">
>            <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Software::LicenceType</Data>
>             <Data Key="name" Type="Quote">Ilimitada</Data>
>             <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>     </DatabaseInstall>
>    <DatabaseUpgrade>
>        <Insert Type="post" Table="general_catalog" Version="1.1.90">
>             <Data Key="general_catalog_class"
> Type="Quote">ITSM::ConfigItem::Class</Data>
>            <Data Key="name" Type="Quote">Ubicación</Data>
>            <Data Key="valid_id">1</Data>
>            <Data Key="create_time">current_timestamp</Data>
>            <Data Key="create_by">1</Data>
>            <Data Key="change_time">current_timestamp</Data>
>            <Data Key="change_by">1</Data>
>        </Insert>
>     </DatabaseUpgrade>
>    <DatabaseUninstall Type="pre">
>        <TableDrop Type="pre" Name="configitem_counter">
>        </TableDrop>
>        <TableDrop Type="pre" Name="configitem_version">
>        </TableDrop>
>        <TableDrop Type="pre" Name="configitem_definition">
>        </TableDrop>
>        <TableDrop Type="pre" Name="configitem">
>        </TableDrop>
>    </DatabaseUninstall>
>
>
>
>
> Aquiles Cohen.-
>
> Homepage : http://aqcohen.blogspot.com
>
>
> _______________________________________________
> OTRS mailing list: i18n
> Archiv: http://lists.otrs.org/cgi-bin/listinfo/i18n
>

_______________________________________________
OTRS mailing list: i18n
Archiv: http://lists.otrs.org/cgi-bin/listinfo/i18n
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.