Exporting to unl

[gmorales]

Hi everyone, is possible to do forms , or macros or something in a SM that is installed with SQL, and then export to an unl that i will import to another machine that have SM installed but uses another database like Oracle?................. I mean, I have done a lot of forms and orher stuffs in SM with SQL I want to export them to a SM with ORacle

[benvargas]

Yes you can... If you use the Service Manager client to unload the record, it will not matter what back-end database is supporting your Service Manager instances. You simply unload the records to a Service Manager unload file and then load it in through the client while it is connected to the instance you want to move records to.

Obviously, if you were trying to export the data from the back-end database, then you would have problems... but that wouldn't be recommended or supported anyway.

Search the SM7 Help Server for "Unload Files" and you should find plenty of information, to get you started I'll post one of the entries:

The native HP Service Manager export format is the unload file. An unload file stores the database dictionary of Service Manager tables in addition to records. The database dictionary embedded in an unload file determines where Service Manager loads records during import. The unload file also specifies whether Service Manager should update or ignore duplicate records when loading records. Service Manager can export unload files in the following file formats:

* Binary — The binary unload file format archives Service Manager tables. You can load binary unload files only from the Database Manager.
* Text — The text unload file format is human readable but only intended to be loaded from the Database Manager.
* Formatted text — The formatted text unload file format is intended to be compatible with external applications, although the actual format of the file is determined by the form you select as a template. You can create export forms to create formatted text unload files compatible with specific applications.

You can export records into an unload file from the following Service Manager utilities:

* Database Manager
* Unload Script Utility
* Directly from some record lists

After you load a .unl file to import data into Service Manager, you must stop and then re-start the Service Manager server. This ensures that the table changes are initialized.

Note: Service Manager encodes unload files in the UTF-8 format. Service Manager can import unload files from previous versions of HP OpenView ServiceCenter, but earlier versions cannot import unload files created by Service Manager.

[gmorales]

Cool ! thanks DUDEE !!! I got a lot to export thanks again, bye