User guidelines - Revision history

Cg_pham at 06:40, 22 April 2013

2013-04-22T06:40:39Z

← Older revision		Revision as of 06:40, 22 April 2013
Line 1:		Line 1:
	~~<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>~~
	== Introduction ==		== Introduction ==

Cg_pham at 09:24, 4 October 2011

2011-10-04T09:24:27Z

← Older revision		Revision as of 09:24, 4 October 2011
Line 1:		Line 1:
			<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>
	== Introduction ==		== Introduction ==

Phongha: /* Introduction */

2010-01-18T11:16:00Z

Introduction

← Older revision		Revision as of 11:16, 18 January 2010
Line 66:		Line 66:
	regular expression - email check.txt, is a file that contains an expression to insert into the Excel commando line to validate the email address.		regular expression - email check.txt, is a file that contains an expression to insert into the Excel commando line to validate the email address.

	To include the add-ins, you need to change the security settings for Excel. It is different from versions to version. So ~~i recommand~~ you to search for the answer if you can't get it to work with this guideline.		To include the add-ins, you need to change the security settings for Excel. It is different from versions to version. So we recommend you to search for the answer if you can't get it to work with this guideline.

	In Excel 2007, the steps are:		In Excel 2007, the steps are:
Line 87:		Line 87:

	''' Email validation '''<BR>		''' Email validation '''<BR>
	Before this will work the steps to enable ~~addins~~ (step 1-3) has to be done.		Before this will work the steps to enable add-ins (step 1-3) has to be done.

	Click on the setup.exe, and complete the installation.		Click on the setup.exe, and complete the installation.
Line 95:		Line 95:

	Edit the E2 commando to the cell that contains the email address, and then click on enter.		Edit the E2 commando to the cell that contains the email address, and then click on enter.
	The cell will return TRUE/FALSE. The email is ~~valide~~ when it is mark as true.		The cell will return TRUE/FALSE. The email is valid when it is mark as true.
	[[Image:Importtools2.gif]]		[[Image:Importtools2.gif]]
	[[Category:Production_guidelines]]		[[Category:Production_guidelines]]

Phongha: /* Tools for import */

2010-01-18T10:39:32Z

Tools for import

← Older revision		Revision as of 10:39, 18 January 2010
Line 86:		Line 86:
	Upper, will change the text to upper cases.		Upper, will change the text to upper cases.

	''' Email validation '''		''' Email validation '''<BR>
	Before this will work the steps to enable addins (step 1-3) has to be done.		Before this will work the steps to enable addins (step 1-3) has to be done.

Phongha: /* Tools for import */

2010-01-18T10:39:13Z

Tools for import

← Older revision		Revision as of 10:39, 18 January 2010
Line 86:		Line 86:
	Upper, will change the text to upper cases.		Upper, will change the text to upper cases.

	~~====~~ Email validation ~~====~~		''' Email validation '''
	Before this will work the steps to enable addins (step 1-3) has to be done.		Before this will work the steps to enable addins (step 1-3) has to be done.

Phongha: /* Disable with cgscript */

2010-01-18T10:37:43Z

Disable with cgscript

← Older revision		Revision as of 10:37, 18 January 2010
Line 45:		Line 45:
	If you can add users to be disabled in a questionniare then you can use this script to disable the user:		If you can add users to be disabled in a questionniare then you can use this script to disable the user:
	<br><source lang="javascript">		<br><source lang="javascript">
	if(getRPQTest()) return; array user=User_getQasUser();		if(getRPQTest()) return;

			array user=User_getQasUser();
			if(user[USER_DISABLED]==true) return;

	user[USER_PHONE_NUMBER]={};		user[USER_PHONE_NUMBER]={};
	if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";		if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";

	user[USER_DISABLED]=true; User_save(user);		user[USER_DISABLED]=true;
			User_save(user);
	</source>		</source>

			You can add this script on a dummy question that will be executed when the user has to be disabled or run a batch job once for all.

	=== Tools for import ===		=== Tools for import ===

Phongha: /* Introduction */

2010-01-18T10:34:36Z

Introduction

← Older revision		Revision as of 10:34, 18 January 2010
Line 1:		Line 1:
	== Introduction ==		== Introduction ==

	This page is meant as a guideline for how to do in Catglobe~~. Initially inspired by working in questionnaires~~.		This page is meant as a guideline for how to do in Catglobe.

	=== Disable many users ===		=== Disable many users ===

Phongha: moved Questionnaire to User guidelines

2010-01-18T10:33:58Z

moved Questionnaire to User guidelines

← Older revision	Revision as of 10:33, 18 January 2010
(No difference)

Phongha: /* Disable with cgscript */

2010-01-18T10:31:41Z

Disable with cgscript

← Older revision		Revision as of 10:31, 18 January 2010
Line 47:		Line 47:
	if(getRPQTest()) return; array user=User_getQasUser();		if(getRPQTest()) return; array user=User_getQasUser();

	user[USER_PHONE_NUMBER]={};~~<br>~~		user[USER_PHONE_NUMBER]={};
	if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";		if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";

Phongha: /* Disable with cgscript */

2010-01-18T10:31:25Z

Disable with cgscript

← Older revision		Revision as of 10:31, 18 January 2010
Line 47:		Line 47:
	if(getRPQTest()) return; array user=User_getQasUser();		if(getRPQTest()) return; array user=User_getQasUser();

	user[USER_PHONE_NUMBER]={}; if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";		user[USER_PHONE_NUMBER]={};<br>
			if(user[USER_COUNTRY]==empty && (user[USER_ADDRESS]!=empty \|\| user[USER_CITY]!=empty \|\| user[USER_ZIPCODE]!=empty \|\| user[USER_REGION]!=empty)) user[USER_COUNTRY]="dk";

	user[USER_DISABLED]=true; User_save(user);		user[USER_DISABLED]=true; User_save(user);