Convert a SQL script to SOPM DatabaseInstall

Hi, I’m developing an OTRS Module which creates a database table and modifies some others (a custom statistics module, just adding some control information and data so I don’t have to redo every calculation). I’ve developed it in my DEVELOPMENT environment and now I want to make a package to test install it in my PREPRODUCTION environment. And now I face the challenge of converting my SQL script to XML and insert into my SOPM file. Anyone has a custom tool or script that makes this conversion? If not, is there any Backus-Naur style notation for the grammar needed in the SOPM file? Juan Clavero Almirón Gestiò d’Identitats, Firma i Custòdia Oficina de Tecnologies, Informació i Comunicacions (OTIC) Servei de Salut de les Illes Balears C/ de les Escoles, s/n - 07181 Bendinat - Mallorca Telf. +34 971.42.65.30

Hi Juan, you can find some information about the XML code to be used at http://doc.otrs.org/developer/3.0/en/html/hacking.html#id676924. Best regards, mg Am 18.01.12 10:26, schrieb Juan Manuel Clavero Almirón:
Hi,
I'm developing an OTRS Module which creates a database table and modifies some others (a custom statistics module, just adding some control information and data so I don't have to redo every calculation).
I've developed it in my DEVELOPMENT environment and now I want to make a package to test install it in my PREPRODUCTION environment.
And now I face the challenge of converting my SQL script to XML and insert into my SOPM file.
Anyone has a custom tool or script that makes this conversion? If not, is there any Backus-Naur style notation for the grammar needed in the SOPM file?
*Juan Clavero Almirón*
*Gestiò d'Identitats, Firma i Custòdia*
*Oficina de Tecnologies, Informació i Comunicacions (OTIC)*
*Servei de Salut de les Illes Balears*
* *
*C/ de les Escoles, s/n - **07181 Bendinat - Mallorca***
*Telf. +34 971.42.65.30*
_______________________________________________ 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
-- Martin Gruner Senior Developer R&D OTRS AG Europaring 4 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn Schalten Sie hoch! Der Turbo für Ihr OTRS - Exklusive Feature Add-Ons: http://www.otrs.com/de/solutions/subscriptions/feature-add-ons/
participants (2)
-
Juan Manuel Clavero Almirón
-
Martin Gruner