SDU - User contributions [en]

Spel Reference Guide

2011-04-12T13:10:44Z

Bartosz: /* Reference Sections */

__NOTOC__
[[Category:Customizations]]
{{Global Header}}
{{Global Announcement}}

Note: please treat SPELL as SPEL
== Overview ==
Spell is CA proprietary code used to script Service Desk core operations. Spell code can be found in .spl and .maj files located in [[$NX_ROOT]]\bopcfg\majic and [[$NX_ROOT]]\site\mods\majic directories. Other examples can be found in the [[$NX_ROOT]]\samples directory.

Note: .spl files with a ''pcd'' preceding the .spl are encrypted files, such as chgpcd.spl or itilpcd.spl.

Spell is usually used to write methods for object or attribute triggers. Examples may be attribute validation, notification, post processing, etc.

Spell is interpreted and executed by the Method Engine (spel_srvr), it can also be executed from the command line with bop_cmd command that interprets the fragment (.frg) files and executes the code.

The language resembles C++. Unlike C or C++, Spell does not support pointers or structures.

== Reference Sections ==
{| width="100%"
|-
! colspan=3|'''Functions'''
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[format]]
*[[getenv]]
*[[gsub]]
*[[is_empty]]
*[[is_null]]
| width="33%" align="left" style="vertical-align:top;" |
*[[misc:find_mang]]
*[[now]]
*[[send_wait]]
*[[sindex]]
| width="33%" align="left" style="vertical-align:top;" |
*[[strlen]]
*[[substr]]
*[[workshift_abs2work]]
*[[workshift_work2abs]]
*[[exec]]
|-
|}

{| width="100%"
|-
! colspan=3|'''Statements'''
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[if]]
| width="33%" align="left" style="vertical-align:top;" |
*[[for]]
| width="33%" align="left" style="vertical-align:top;" |
*[[while]]
|-
|}

{| width="100%"
|-
! colspan=3|'''Other'''
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[Data Type Conversion]]
*[[Operators]]
| width="33%" align="left" style="vertical-align:top;" |
*[[Spel FAQ]]
*[[Triggering Reaction]]
| width="33%" align="left" style="vertical-align:top;" |
*[[Troubleshooting Spell Code|Troubleshooting]]
*[[Variables and Types]]
*[[Methods handling]]
|-
|}

== See Also ==
[[WSSIWYG]] by Nero Le Velu

Pdm load

2010-11-26T11:02:14Z

Bartosz: Undo revision 4152 by Agegeleruvy (Talk) - spam?

__NOTOC__
[[Category:Commands]]
{{Global Header}}
{{Global Announcement}}

== Overview ==
Use pdm_load to insert, update or remove data into the database and bypass the GUIs. 
pdm_load uses the SeviceDesk virtual DB Schema layer to access the physical database. 
Contrary to direct Database access by ODBC for example, each data change is directly propagated to all ServiceDesk processes.

== Usage ==
pdm_load -f [filename] [-a] [-c] [-e] [-h] [-i] [-m] [-v] [-r] [-u] [-x]
 
{|
|-
! Command
! Description
! Remarks
|-
| -a
| update all matching data
|
|-
| -c
| check only, no change to data
|
|-
| -e
| treat escapes literally
|
|-
| -h
| help
|
|-
| -i
| insert only
|
|-
| -m
| notify domsrvr of mass update
|
|-
| -v
| verbose
|
|-
| -r
| remove
|
|-
| -u
| update only
|
|-
| -x
| use locale sensitive numeric input formats
|
|-
|}

== Examples ==
* A standard load. This load assumes that the file contains ids or uuids for all entries.
pdm_load -f extract.txt -v

* Using the -i to load data will force the creation of new ids and uuids. The file being loaded should be void of any id and uuid data.
pdm_load -f cnt_data.csv -i -v

* Removing some info (not shared by another application) from a file. Use the -r
pdm_load -f InfoToRemove.dat -r -v 2>load.err

== Notes ==
When doing a pdm_load of a ca_xxxxxx table that contains references to another ca_xxxxxx table, the reference must be valid or the entry will not be loaded and an error generated. For example, if loading the ca_contact table, if the ca_location_uuid field contains references to the ca_location table, then the record that is being reference MUST exist in the ca_location table or that particular entry will not be loaded. A common scenario is to perform an extract of the production contact data and then load it into development. However if the contact tables has references to the ca_location table you will first need to do a load of the ca_location table to ensure that all the references from the ca_contact load are valid. And if the ca_location table has references to the ca_site table, you will need to do a load of ca_site to ensure all the references from the ca_location load are valid.

Pdm extract

2010-11-26T10:56:25Z

Bartosz: Undo revision 4156 by Agegeleruvy (Talk)

__NOTOC__
[[Category:Commands]]
{{Global Header}}
{{Global Announcement}}

== Overview ==
Use this command to dump data from the database to the screen or file (typically txt, dat, or csv).

== Usage ==
pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names]
 
{|
|-
! Command
! Description
! Remarks
|-
| -h
| Help
|
|-
| -f
| format string
|
|-
| -c
| csv output
|
|-
| -e
| csv output with double double quotes
|
|-
| -r
| informal report output
|
|-
| -v
| verbose
|
|-
| -s
| saved script
|
|-
| -u
| no headers
|
|-
| -d
| use dataent.fmt
|
|-
| -x
| locale sensitive numeric formats
|
|-
| -X
| extract all tables except table list
|
|-
|}

== Examples ==
* Extract all Service Desk tables
pdm_extract All > All.txt

* Extract a filtered list
pdm_extract -f "SELECT * FROM Call_Req WHERE type = 'I'" > Call_Req.dat

* Extract a full table
pdm_extract Priority > pri.txt

* Extract multiple tables
pdm_extract Call_Request Activity_Log > call.dat

* Extract two or more joined tables (you cannot use INNER JOIN or similar clausules, only this cross join is possible)
pdm_extract -f "SELECT ca_contact.id, c_acctyp_id FROM ca_contact, usp_contact WHERE ca_contact.id = usp_contact.id AND c_acctyp_id is null"

----
<div align='center'>To make corrections or additions to this article, select the ''edit'' tab above. 
To discuss or ask questions about this article, select the ''discussion'' tab above.</div>