SDU - User contributions [en]

Send WaitCall attrGet groups by persid

2010-10-13T13:58:55Z

NeronLeVelu: /* Examples */

__NOTOC__
[[Category:Customizations]]
[[Category:r11]]
[[Category:r12]]
[[Category:Spell Code]]
{{Global Header}}
{{Global Announcement}}
== Overview ==
This method gets a list of groups for specified user.

This action can be called in [[Spel_Reference_Guide|spell code]] in method [[send_wait]] (or [[send]]) using [[Send_WaitCall_Attr|call_attr]] action.

== Usage ==
<source lang="javascript">
void send_wait (int timeout, object top_object, "call_attr", "cnt", "get_groups_by_persid", contact_persid)
</source>

* timeout - how long (in seconds) should the method wait for finishing the method (0 means infinite [no timeout] and is generally the value used)
* top_object - root object for the method (on which the method is called)
* contact_persid - persistent ID of an user for which you are looking for attached groups

== Results ==
success or failure is tested with msg_error() (boolean function)

On success the resulted list is filled into a global array '''msg''' as follows:
* msg[0] - the number of assigned groups
* msg[1] - a list of group's UUIDs

On failure (don't forget to test failure in your code, your are in production with dummy users)
* msg[0] - failure reason

== Examples ==
<source lang="javascript">
int i;
send_wait(0, top_object(), "call_attr", "cnt", "get_groups_by_persid", "cnt:776B094702EABB4B87F04A139E72D44B");
if( msg_error()) {
logf (ERROR, "failure in send_wait ..... .Reason: %s",msg[0]);
}
else{
for (i=0;i<msg_length();i++) {
logf (SIGNIFICANT, "Msg index #%s: %s", i,msg[i]);
}}
</source>

== Comment ==
'''This code does not work since SD R12.5. See this post: http://www.servicedeskusers.com/forum/index.php?showtopic=6047'''

Send WaitCall attrGet groups by persid

2010-10-13T13:56:27Z

NeronLeVelu: /* Results */

__NOTOC__
[[Category:Customizations]]
[[Category:r11]]
[[Category:r12]]
[[Category:Spell Code]]
{{Global Header}}
{{Global Announcement}}
== Overview ==
This method gets a list of groups for specified user.

This action can be called in [[Spel_Reference_Guide|spell code]] in method [[send_wait]] (or [[send]]) using [[Send_WaitCall_Attr|call_attr]] action.

== Usage ==
<source lang="javascript">
void send_wait (int timeout, object top_object, "call_attr", "cnt", "get_groups_by_persid", contact_persid)
</source>

* timeout - how long (in seconds) should the method wait for finishing the method (0 means infinite [no timeout] and is generally the value used)
* top_object - root object for the method (on which the method is called)
* contact_persid - persistent ID of an user for which you are looking for attached groups

== Results ==
success or failure is tested with msg_error() (boolean function)

On success the resulted list is filled into a global array '''msg''' as follows:
* msg[0] - the number of assigned groups
* msg[1] - a list of group's UUIDs

On failure (don't forget to test failure in your code, your are in production with dummy users)
* msg[0] - failure reason

== Examples ==
<source lang="javascript">
int i;
send_wait(0, top_object(), "call_attr", "cnt", "get_groups_by_persid", "cnt:776B094702EABB4B87F04A139E72D44B");
for (i=0;i<msg_length();i++) {
logf (SIGNIFICANT, "Msg index #%s: %s", i,msg[i]);
}
</source>

== Comment ==
'''This code does not work since SD R12.5. See this post: http://www.servicedeskusers.com/forum/index.php?showtopic=6047'''

Send WaitCall attrGet groups by persid

2010-10-13T13:53:30Z

NeronLeVelu: /* Usage */

__NOTOC__
[[Category:Customizations]]
[[Category:r11]]
[[Category:r12]]
[[Category:Spell Code]]
{{Global Header}}
{{Global Announcement}}
== Overview ==
This method gets a list of groups for specified user.

This action can be called in [[Spel_Reference_Guide|spell code]] in method [[send_wait]] (or [[send]]) using [[Send_WaitCall_Attr|call_attr]] action.

== Usage ==
<source lang="javascript">
void send_wait (int timeout, object top_object, "call_attr", "cnt", "get_groups_by_persid", contact_persid)
</source>

* timeout - how long (in seconds) should the method wait for finishing the method (0 means infinite [no timeout] and is generally the value used)
* top_object - root object for the method (on which the method is called)
* contact_persid - persistent ID of an user for which you are looking for attached groups

== Results ==
On success the resulted list is filled into a global array '''msg''' as follows:
* msg[0] - the number of assigned groups
* msg[1] - a list of group's UUIDs

== Examples ==
<source lang="javascript">
int i;
send_wait(0, top_object(), "call_attr", "cnt", "get_groups_by_persid", "cnt:776B094702EABB4B87F04A139E72D44B");
for (i=0;i<msg_length();i++) {
logf (SIGNIFICANT, "Msg index #%s: %s", i,msg[i]);
}
</source>

== Comment ==
'''This code does not work since SD R12.5. See this post: http://www.servicedeskusers.com/forum/index.php?showtopic=6047'''

Send wait

2009-08-20T14:39:10Z

NeronLeVelu: /* Usage */

__NOTOC__
[[Category:Customizations]]
[[Category:r6]]
[[Category:r11]]
[[Category:Spell Code]]
{{Global Header}}
{{Global Announcement}}
== Overview ==
This is the most tricky function and it is the main reason of difficulty of reading [[Spel_Reference_Guide|SPELL code]]. It is used for calling methods on objects. On every SD object (ie. cr, chg, alg...) are defined methods and using ''send_wait'' function you can call them. Definitions of some of them are in *.maj files in [[$NX_ROOT]]/bopcfg/majic folder.

== Usage ==
void send_wait (int timeout, object top_object, string method, [ var parameters… ])

* timeout - how long (in seconds) should the method wait for finishing the method (0 means infinite). A timeout mean time after which the function is considering as failure, returning to caller with error and no result. Nearly every time the 0 is used.
* top_object - root object for the method (on which the method is called)
* method - name of the called method
* parameters - variable number of parameters based on the called method

== Results ==
Function doesn't return value, but methods usually fill global '''msg''' array with return values. What values are on what positions depends on the called method.

== Available methods ==
{| width="100%"
|-
! colspan=3|'''Base object common'''
|-
|colspan=3|These methods are defined on all objects (maybe)
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[Send_WaitCall_Attr|call_attr]]
| width="33%" align="left" style="vertical-align:top;" |
*[[get_attr_vals]]
| width="33%" align="left" style="vertical-align:top;" |
*[[Send_WaitGet_Co_group|get_co_group]]
|-
|}

{| width="100%"
|-
! colspan=3|'''Base object CR'''
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[Send_WaitAuto_assign|auto_assign]]
*[[Send_WaitChange_status|change_status]]
*[[Send_WaitClose_call_request|close_call_request]]
*[[Send_WaitCopy_cr|copy_cr]]
*[[Send_WaitCopy_cr_site|copy_cr_site]]
*[[Send_WaitCob_mark_delete|dob_mark_delete]]
*[[Send_WaitCo_expand|do_expand]]
| width="33%" align="left" style="vertical-align:top;" |
*[[Send_WaitEscalate|escalate]]
*[[Send_WaitIinit_activity|init_activity]]
*[[Send_WaitInit_call_request|init_call_request]]
*[[Send_WaitLog_callback|log_callback]]
*[[Send_WaitLog_comment|log_comment]]
*[[Send_WaitLog_comment_no_checkout|log_comment_no_checkout]]
*[[Send_WaitLog_event|log_event]]
| width="33%" align="left" style="vertical-align:top;" |
*[[Send_WaitLog_research|log_research]]
*[[Send_WaitMake_from_template|make_from_template]]
*[[Send_WaitMake_from_template_site|make_from_template_site]]
*[[Send_WaitManual_notify|manual_notify]]
*[[Send_WaitReopen_call_request|reopen_call_request]]
*[[Send_WaitSend_api_msg|send_api_msg]]
*[[Send_WaitTransfer|transfer]]
|-
|}

{| width="100%"
|-
! colspan=3|'''Base object CHG'''
|-
| width="34%" align="left" style="vertical-align:top;" |
*[[Send_WaitAccumulate|accumulate]]
*[[Send_WaitAccumulate_change|accumulate_change]]
*[[Send_WaitAccumulate_workflows|accumulate_workflows]]
*[[Send_WaitAdd_assets|add_assets]]
*[[Send_WaitAdd_auditlog|add_auditlog]]
*[[Send_WaitAuto_assign|auto_assign]]
*[[Send_WaitChange_status|change_status]]
*[[Send_WaitClose_change_descedents|close_change_descendents]]
*[[Send_WaitClose_change_request|close_change_request]]

| width="33%" align="left" style="vertical-align:top;" |
*[[Send_WaitCopy_chg|copy_chg]]
*[[Send_WaitCopy_chg_site|copy_chg_site]]
*[[Send_WaitDo_expand|do_expand]]
*[[Send_WaitDob_mark_delete|dob_mark_delete]]
*[[Send_WaitEscalate|escalate]]
*[[Send_WaitFast_track|fast_track]]
*[[Send_WaitImpact_analysis|impact_analysis]]

| width="33%" align="left" style="vertical-align:top;" |
*[[Send_WaitInit_activity|init_activity]]
*[[Send_WaitInit_change_request|init_change_request]]
*[[Send_WaitLog_event|log_event]]
*[[Send_WaitMake_from_template|make_from_template ]]
*[[Send_WaitMake_from_template_site|make_from_template_site ]]
*[[Send_WaitManual_notify|manual_notify]]
*[[Send_WaitOk_close_descedents|ok_close_descendents]]
*[[Send_WaitRemove_all_assets|remove_all_assets]]
*[[Send_WaitTransfer|transfer]]
|-
|}

== Examples ==

Web Screen Painter

2009-06-12T15:50:58Z

NeronLeVelu: /* On Save */

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

== Overview ==
This articles provides an under-the-hood explanation of the Web Screen Painter (WSP) and the Schema Designer introduced in r11.x.

== Web Screen Painter ==
WSP Facts:
*Located on the Primary Server.
*Uses Tomcat exclusively.
*All published changes are automatically exported to all Secondary Servers.

=== On Save ===
When initiating a save (File > Save) the following occurs:
* The [[$NX_ROOT]]\site\mods\wsp\project directory is created if it does not already exist.

* A new or modified file is stored within the [[$NX_ROOT]]\site\mods\wsp\project\... directory which has a structure that mimics the location of the default version of the file. ''For example: If editing the bin_form_np.htmpl used by the Analyst Interface which originally resides in [[$NX_ROOT]]\bopcfg\www\htmpl\web\analyst, a saved copy will be placed in [[$NX_ROOT]]\site\mods\wsp\project\www\htmpl\web\analyst.''

* Do not forget that also 2 tables are updated by web screen painter to "remind" the modification. It is possible that some change (made manually for example) are not know by the WSP with all the side effect that can result in case of modification.

=== On Publish ===
When initiating a publish (File > Publish) the following occurs:
* Any saved versions of the files being published that reside within [[$NX_ROOT]]\site\mods\wsp\project\... are removed.

* A new or modified file will be stored on the Primary and all Secondary Servers within the [[$NX_ROOT]]\site\mods\... directory which has a structure that mimics the location of the default version of the file. ''For example: If editing the bin_form_np.htmpl used by the Analyst Interface which originally resides in [[$NX_ROOT]]\bopcfg\www\htmpl\web\analyst, a saved copy will be placed in [[$NX_ROOT]]\site\mods\www\htmpl\web\analyst. CA ensures that the default files are never altered by your customizations by saving custom files in a dedicated location.''

* A deleted file will be removed from the Primary and all Secondary Servers.

* The [[pdm_webcache]] command is automatically initiate which clears the cache on the Primary and all Secondary Servers.

=== Backing out ===
Both published and unpublished forms can be deleted via the WSP. However, you can also navigate through the directory structure and delete the file.
*For saved but unpublished, navigate through the [[$NX_ROOT]]\site\mods\wsp\project\... directory and remove the target file.

*For published files, navigate through the [[$NX_ROOT]]\site\mods\... directory on the Primary and all Secondary Servers, delete your file from all servers, and run the [[pdm_webcache]] from the Primary Server.

== See Also ==
[[Schema Designer]]

Pdm extract

2008-01-25T14:49:36Z

NeronLeVelu: /* Examples */

[[Category:Commands|Commands man]]
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 the whole big stuff (USD only not full mdb)
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 several table at once
pdm_extract Call_Request Activity_Log > call.dat

Pdm load

2008-01-25T14:45:10Z

NeronLeVelu: /* Examples */

[[Category:Commands]]
Use pdm_load to load information directly into the database and bypass the GUIs.

== 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 ==
pdm_load -f extract.txt -v

pdm_load -f cnt_data.csv -i -v

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