Help Center

uconf-manager: Urchin Configuration Manager Utility

Overview

The Urchin Configuration Manager Utility (uconf-manager) allows you to add, edit and delete records in the following tables: uaccounts, ucosts, ufilters, ugoals, ugroups, ugroups_uusers, ulogs, ulogs_ufilters, uprofiles, uprofiles_ucosts, uprofiles_ufilters, uprofiles_ugroups, uprofiles_ulogs, uprofiles_uusers, and uusers. You can use it to perform actions that can't be accomplished via the Urchin Administration Interface. Examples include:

Note: The Urchin Configuration Manager Utility version 6.402 allows you to add, edit and delete user records only.

Usage

This utility is bundled with the Urchin (6.402+) installation and can be found in the /util directory. 

uconf-manager.exe -h      :   Prints the help information.
uconf-manager.exe -v      :   Prints the version information.
uconf-manager.exe [app_params] [db_params]

where app_params are: 

table=<table_name>    Name of the table to operate on. Currently ONLY the following tables
                      are supported:
                      uaccounts, ucosts, ufilters,
                      ugoals, ugroups, ugroups_uusers, ulogs, ulogs_ufilters, uprofiles,
                      uprofiles_ucosts, uprofiles_ufilters,
                      uprofiles_ugroups, uprofiles_ulogs, uprofiles_uusers, uusers
action=<action_name>  Operation type. 'add', 'delete' or 'update'.
print=<print_level>   Print level. 'quite', 'error', 'status' or 'all'.
key1=<column_name1>   [Optional]. Column name (key1) that will be used in WHERE clause
                      of 'update' query.
key2=<column_name2>   [Optional]. Column name (key2) that will be used in WHERE clause
                      of 'update' query.

and db_params are column name/value pairs: 

<col1>=<value1> <col2>=<value2> ...

For example: 

ucus_name="user11" ucus_password="passwd" uius_level=1

Examples

1. Create an admin user with the credentials "testuser" and "testpassword": 

command: ./uconf-manager table=uusers action=add ucus_name="testuser" ucus_password="testpassword" uius_level=1 usac_id=1 print=status
output : Successful : Operation 'add' performed on table 'uusers'.

2. Update user with the login "testuser"; set the full name to "Test User" and make the account id=3: 

command: ./uconf-manager table=uusers action=update ucus_name="testuser" ucus_ful_name="Test User" usac_id=3 key1=ucus_name print=status
output : Successful : Operation 'update' performed on table 'uusers'.

3. Remove user with the login "testuser": 

command: ./uconf-manager table=uusers action=delete ucus_name="testuser" print=status
output : Successful : Operation 'delete' performed on table 'uusers'.

4. Create a CPC source with the name "cpc_name": 

command: ./uconf-manager table=ucosts action=add ucco_name="cpc_name" ucco_adwords_loginName="cpc@gmail.com" ucco_adwords_loginPassword="test_password" ucco_adwords_devToken="dev_token" ucco_adwords_appToken="app_token"
ucco_adwords_clientEmail="client_email@gmail.com" print=status
output : Successful : Operation 'add' performed on table 'ucosts'
         Insert record id : 17.

Additional information about UUSERS table fields (Urchin 6.402+)

The following fields from the UUSERS table can be updated using uconf-manager:

Fields marked with * are required to add a new user.

Additional information about UCOSTS table fields (Urchin 6.500+)

The following fields from the UCOSTS table can be updated using uconf-manager:

Fields marked with * are required to add a new user.

Additional information about UPROFILES_UCOSTS table fields (Urchin 6.500+)

The following fields from the UPROFILES_UCOSTS table can be updated using uconf-manager:

Fields marked with * are required to add a new user.

Note: Field descriptions of other tables (uaccounts, ufilters, ugoals, ugroups, ugroups_uusers, ulogs, ulogs_ufilters, uprofiles, uprofiles_ufilters, uprofiles_ugroups, uprofiles_ulogs and uprofiles_uusers) will be available in a "Urchin configuration DB schema" article which is currently in development.