2 replies to this topic

[Raphael]

Hello here is a little command to extract all objects for $U on unix if you want to move them to another node.

for s_esp in app int sim exp; do for s_obj in upr ses; do echo "" >>./extract.log; echo "***********$s_esp $s_obj************" >>./extract.log; echo "*****listing $s_esp $s_obj*******" >>./extract.log; echo "$UXEXE/uxlst $s_obj $s_esp NODE=$S_NOEUD" >> ./extract.log; $UXEXE/uxlst $s_obj $s_esp NODE=$S_NOEUD >> ./extract.log; echo "*****processing $s_esp $s_obj*******" >>./extract.log; echo "$UXEXE/uxext $s_obj $s_esp $s_obj=* v$s_obj=* NODE=$S_NOEUD output=ext_$s_esp_$s_obj_$S_NOEUD.ext" >> ./extract.log;  $UXEXE/uxext $s_obj $s_esp $s_obj=* v$s_obj=* NODE=$S_NOEUD output=ext_$s_esp_$s_obj_$S_NOEUD.ext >> ./extract.log; done; echo "***********$s_esp TSK************" >>./extract.log; echo "*****listing $s_esp TSK*******" >>./extract.log; echo "$UXEXE/uxlst TSK $s_esp NODE=$S_NOEUD" >> ./extract.log; $UXEXE/uxlst TSK $s_esp NODE=$S_NOEUD >> ./extract.log; echo "*****processing $s_esp TSK*******" >>./extract.log; echo "$UXEXE/uxext TSK $s_esp SES=* VSES=* UPR=* VUPR=* MODEL NODE=$S_NOEUD output=./ext_TSK_$s_esp_$S_NOEUD.ext" >> ./extract.log; $UXEXE/uxext TSK $s_esp SES=* VSES=* UPR=* VUPR=* MODEL NODE=$S_NOEUD output=./ext_TSK_$s_esp_$S_NOEUD.ext >> ./extract.log; done;

Note that this is a single command line

it will

• Work on all area (app int sim and exp)
  
• create a log file in the current folder
  
• List the objects before extraction
  
• extract all uprocs, sessions and tasks in the local folder

It can also work on calendars

Note that the ./extract.log will be appended by this command

Edited by Raphael, 20 November 2008 - 04:10 PM.

[Raphael]

In addition to this command you can run

for s_iobj in RES RUL; do echo "" >>./extract.log; echo "***********$s_iobj***************" >>./extract.log; echo "*****listing $s_iobj*******" >>./extract.log; echo "$UXEXE/uxlst $s_iobj NODE=$S_NOEUD"  >> ./extract.log; $UXEXE/uxlst $s_iobj NODE=$S_NOEUD >> ./extract.log; echo "*****listing $s_iobj*******" >>./extract.log; echo "*****processing $s_iobj*******" >>./extract.log; echo "$UXEXE/uxext $s_iobj $s_iobj=* NODE=$S_NOEUD output=ext_RES_$S_NOEUD"  >> ./extract.log; $UXEXE/uxext $s_iobj $s_iobj=* NODE=$S_NOEUD output=ext_RES_$S_NOEUD  >> ./extract.log; done;

To extract all rules and resources

and also

for s_adm in TNODE TSOC DOM APPL USER MU; do echo "" >>./extract.log; echo "***********$s_adm***************" >>./extract.log; echo "*****listing $s_adm table*******" >>./extract.log; echo  "$UXEXE/uxlst $s_adm NODE=$S_NOEUD" >> ./extract.log; $UXEXE/uxlst $s_adm NODE=$S_NOEUD >> ./extract.log; echo "*****processing $s_adm table*******" >>./extract.log; echo  "$UXEXE/uxext ADM $s_adm=* NODE=$S_NOEUD output=./ext_ADM_$S_NOEUD.ext" >> ./extract.log; $UXEXE/uxext ADM $s_adm=* NODE=$S_NOEUD output=./ext_ADM_$S_NOEUD.ext >> ./extract.log; done;

To extract some usefull administration tables (note that this command has some little glitches du the differences between uxlst and uxext commands)

[Raphael]

And here are the insertion commands: (not tested yet)

for s_esp in app int sim exp; do for s_obj in upr ses; do echo "" >>./import.log; echo "***********$s_esp $s_obj************" >>./import.log; echo "*****listing $s_esp $s_obj*******" >>./import.log; echo "$UXEXE/uxlst $s_obj $s_esp NODE=$S_NOEUD" >> ./import.log; $UXEXE/uxlst $s_obj $s_esp NODE=$S_NOEUD >> ./import.log; echo "*****processing $s_esp $s_obj*******" >>./import.log; echo "$UXEXE/uxins $s_obj $s_esp $s_obj=* v$s_obj=* NODE=$S_NOEUD output=ext_$s_esp_$s_obj_$S_NOEUD.ext" >> ./import.log;  $UXEXE/uxins $s_obj $s_esp $s_obj=* v$s_obj=* NODE=$S_NOEUD output=ext_$s_esp_$s_obj_$S_NOEUD.ext >> ./import.log; done; echo "***********$s_esp TSK************" >>./import.log; echo "*****listing $s_esp TSK*******" >>./import.log; echo "$UXEXE/uxlst TSK $s_esp NODE=$S_NOEUD" >> ./import.log; $UXEXE/uxlst TSK $s_esp NODE=$S_NOEUD >> ./import.log; echo "*****processing $s_esp TSK*******" >>./import.log; echo "$UXEXE/uxins TSK $s_esp SES=* VSES=* UPR=* VUPR=* MODEL NODE=$S_NOEUD input=./ext_TSK_$s_esp_$S_NOEUD.ext" >> ./import.log; $UXEXE/uxins TSK $s_esp SES=* VSES=* UPR=* VUPR=* MODEL NODE=$S_NOEUD input=./ext_TSK_$s_esp_$S_NOEUD.ext >> ./import.log; done;

for s_iobj in RES RUL; do echo "" >>./import.log; echo "***********$s_iobj***************" >>./import.log; echo "*****listing $s_iobj*******" >>./import.log; echo "$UXEXE/uxlst $s_iobj NODE=$S_NOEUD"  >> ./import.log; $UXEXE/uxlst $s_iobj NODE=$S_NOEUD >> ./import.log; echo "*****listing $s_iobj*******" >>./import.log; echo "*****processing $s_iobj*******" >>./import.log; echo "$UXEXE/uxins $s_iobj $s_iobj=* NODE=$S_NOEUD output=ext_RES_$S_NOEUD"  >> ./import.log; $UXEXE/uxins $s_iobj $s_iobj=* NODE=$S_NOEUD output=ext_RES_$S_NOEUD  >> ./import.log; done;

for s_adm in TNODE TSOC DOM APPL USER MU; do echo "" >>./import.log; echo "***********$s_adm***************" >>./import.log; echo "*****listing $s_adm table*******" >>./import.log; echo  "$UXEXE/uxlst $s_adm NODE=$S_NOEUD" >> ./import.log; $UXEXE/uxlst $s_adm NODE=$S_NOEUD >> ./import.log; echo "*****processing $s_adm table*******" >>./import.log; echo  "$UXEXE/uxins ADM $s_adm=* NODE=$S_NOEUD input=./ext_ADM_$S_NOEUD.ext" >> ./import.log;$UXEXE/uxins ADM $s_adm=* NODE=$S_NOEUD input=./ext_ADM_$S_NOEUD.ext >> ./import.log; done;

Edited by Raphael, 20 November 2008 - 04:27 PM.