com.trackstudio.app.csv
Class CSVImport

java.lang.Object
  com.trackstudio.app.csv.CSVImport

public class CSVImport
extends java.lang.Object

Field Summary

static java.lang.String	MESSAGE_BUDGET
static java.lang.String	MESSAGE_DEADLINE
static java.lang.String	MESSAGE_DESCRIPTION
static java.lang.String	MESSAGE_HANDLER_GROUP_ID
static java.lang.String	MESSAGE_HANDLER_USER_ID
static java.lang.String	MESSAGE_HOURS
static java.lang.String	MESSAGE_MESSAGE_TYPE_ID
static java.lang.String	MESSAGE_PRIORITY_ID
static java.lang.String	MESSAGE_RESOLUTION_ID
static java.lang.String	MESSAGE_SUBMIT_DATE
static java.lang.String	MESSAGE_SUBMITTER_ID
static java.lang.String	MESSAGE_TASK_ID
static java.lang.String	MESSAGE_TYPE
static java.lang.String	MESSAGE_UDF_MAP
static java.lang.String	OBJECT_EXCEPTION
static java.lang.String	OBJECT_ID
static java.lang.String	OBJECT_TYPE
static java.lang.String	TASK_BUDGET
static java.lang.String	TASK_CATEGORY_ID
static java.lang.String	TASK_CLOSE_DATE
static java.lang.String	TASK_DEADLINE
static java.lang.String	TASK_DESCRIPTION
protected static java.lang.String	TASK_EMPTY_NAME
static java.lang.String	TASK_HANDLER_GROUP_ID
static java.lang.String	TASK_HANDLER_USER_ID
static java.lang.String	TASK_NAME
static java.lang.String	TASK_PARENT_TASK
static java.lang.String	TASK_PARENT_TASK_ID
static java.lang.String	TASK_PRIORITY_ID
static java.lang.String	TASK_RESOLUTION_ID
static java.lang.String	TASK_SHORTNAME
static java.lang.String	TASK_STATUS_ID
static java.lang.String	TASK_SUBMIT_DATE
static java.lang.String	TASK_SUBMITTER_ID
static java.lang.String	TASK_TYPE
static java.lang.String	TASK_UDF_MAP
static java.lang.String	TASK_UPDATE_DATE
static java.lang.String	USER_COMPANY
static java.lang.String	USER_DEFAULT_PROJECT_ID
static java.lang.String	USER_EMAIL
static java.lang.String	USER_EMAIL_TYPE_ID
protected static java.lang.String	USER_EMPTY_LOGIN
protected static java.lang.String	USER_EMPTY_NAME
static java.lang.String	USER_EXPIRE_DATE
static java.lang.String	USER_HTML_EDITOR
static java.lang.String	USER_IS_ACTIVE
static java.lang.String	USER_LOCALE
static java.lang.String	USER_LOGIN
static java.lang.String	USER_NAME
static java.lang.String	USER_PARENT_USER
static java.lang.String	USER_PARENT_USER_ID
static java.lang.String	USER_PASSWORD
static java.lang.String	USER_PHONE
static java.lang.String	USER_PRSTATUS_ID
static java.lang.String	USER_SHOW_HELP
static java.lang.String	USER_SHOW_TREE_MODE
static java.lang.String	USER_TIMEZONE
static java.lang.String	USER_TYPE
static java.lang.String	USER_UDF_MAP

Constructor Summary

CSVImport()

Method Summary

static java.lang.String	findCategoryIdByName(java.lang.String categoryName)
static java.lang.String	findMessageTypeIdByName(java.lang.String mstatusName, java.lang.String categoryName)
static java.lang.String	findPriorityIdByName(java.lang.String priorityName, java.lang.String categoryName)
static java.lang.String	findResolutionIdByName(java.lang.String resolutionName, java.lang.String messageTypeName)
static java.lang.String	findStateIdByName(java.lang.String stateName, java.lang.String categoryName)
static java.lang.String	findTaskIdByName(java.lang.String taskName)
static java.lang.String	findTaskIdByNumber(java.lang.String taskNumber)
static java.lang.String	findTaskResolutionIdByName(java.lang.String resolutionName, java.lang.String categoryName)
static java.lang.String	findUDFIdByName(java.lang.String udfName)
static java.lang.String	findUDFListIdByValue(java.lang.String udflistValue)
static java.lang.String	findUserIdByLogin(java.lang.String userLogin)
static java.lang.String	findUserIdByName(java.lang.String userName)
static java.lang.String	findUserStatusIdByName(java.lang.String prstatusName)
static java.lang.Double	parseBudget(java.lang.String strBudget, java.lang.String locale)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

OBJECT_TYPE

public static final java.lang.String OBJECT_TYPE

See Also:

Constant Field Values

OBJECT_ID

public static final java.lang.String OBJECT_ID

See Also:

Constant Field Values

OBJECT_EXCEPTION

public static final java.lang.String OBJECT_EXCEPTION

See Also:

Constant Field Values

TASK_TYPE

public static final java.lang.String TASK_TYPE

See Also:

Constant Field Values

MESSAGE_TYPE

public static final java.lang.String MESSAGE_TYPE

See Also:

Constant Field Values

USER_TYPE

public static final java.lang.String USER_TYPE

See Also:

Constant Field Values

TASK_SHORTNAME

public static final java.lang.String TASK_SHORTNAME

See Also:

Constant Field Values

TASK_NAME

public static final java.lang.String TASK_NAME

See Also:

Constant Field Values

TASK_DESCRIPTION

public static final java.lang.String TASK_DESCRIPTION

See Also:

Constant Field Values

TASK_BUDGET

public static final java.lang.String TASK_BUDGET

See Also:

Constant Field Values

TASK_DEADLINE

public static final java.lang.String TASK_DEADLINE

See Also:

Constant Field Values

TASK_PRIORITY_ID

public static final java.lang.String TASK_PRIORITY_ID

See Also:

Constant Field Values

TASK_HANDLER_USER_ID

public static final java.lang.String TASK_HANDLER_USER_ID

See Also:

Constant Field Values

TASK_HANDLER_GROUP_ID

public static final java.lang.String TASK_HANDLER_GROUP_ID

See Also:

Constant Field Values

TASK_CATEGORY_ID

public static final java.lang.String TASK_CATEGORY_ID

See Also:

Constant Field Values

TASK_SUBMITTER_ID

public static final java.lang.String TASK_SUBMITTER_ID

See Also:

Constant Field Values

TASK_SUBMIT_DATE

public static final java.lang.String TASK_SUBMIT_DATE

See Also:

Constant Field Values

TASK_UPDATE_DATE

public static final java.lang.String TASK_UPDATE_DATE

See Also:

Constant Field Values

TASK_CLOSE_DATE

public static final java.lang.String TASK_CLOSE_DATE

See Also:

Constant Field Values

TASK_RESOLUTION_ID

public static final java.lang.String TASK_RESOLUTION_ID

See Also:

Constant Field Values

TASK_STATUS_ID

public static final java.lang.String TASK_STATUS_ID

See Also:

Constant Field Values

TASK_UDF_MAP

public static final java.lang.String TASK_UDF_MAP

See Also:

Constant Field Values

TASK_PARENT_TASK

public static final java.lang.String TASK_PARENT_TASK

See Also:

Constant Field Values

TASK_PARENT_TASK_ID

public static final java.lang.String TASK_PARENT_TASK_ID

See Also:

Constant Field Values

USER_LOGIN

public static final java.lang.String USER_LOGIN

See Also:

Constant Field Values

USER_NAME

public static final java.lang.String USER_NAME

See Also:

Constant Field Values

USER_PHONE

public static final java.lang.String USER_PHONE

See Also:

Constant Field Values

USER_EMAIL

public static final java.lang.String USER_EMAIL

See Also:

Constant Field Values

USER_PRSTATUS_ID

public static final java.lang.String USER_PRSTATUS_ID

See Also:

Constant Field Values

USER_TIMEZONE

public static final java.lang.String USER_TIMEZONE

See Also:

Constant Field Values

USER_LOCALE

public static final java.lang.String USER_LOCALE

See Also:

Constant Field Values

USER_COMPANY

public static final java.lang.String USER_COMPANY

See Also:

Constant Field Values

USER_EMAIL_TYPE_ID

public static final java.lang.String USER_EMAIL_TYPE_ID

See Also:

Constant Field Values

USER_DEFAULT_PROJECT_ID

public static final java.lang.String USER_DEFAULT_PROJECT_ID

See Also:

Constant Field Values

USER_EXPIRE_DATE

public static final java.lang.String USER_EXPIRE_DATE

See Also:

Constant Field Values

USER_IS_ACTIVE

public static final java.lang.String USER_IS_ACTIVE

See Also:

Constant Field Values

USER_SHOW_HELP

public static final java.lang.String USER_SHOW_HELP

See Also:

Constant Field Values

USER_HTML_EDITOR

public static final java.lang.String USER_HTML_EDITOR

See Also:

Constant Field Values

USER_SHOW_TREE_MODE

public static final java.lang.String USER_SHOW_TREE_MODE

See Also:

Constant Field Values

USER_UDF_MAP

public static final java.lang.String USER_UDF_MAP

See Also:

Constant Field Values

USER_PARENT_USER

public static final java.lang.String USER_PARENT_USER

See Also:

Constant Field Values

USER_PARENT_USER_ID

public static final java.lang.String USER_PARENT_USER_ID

See Also:

Constant Field Values

USER_PASSWORD

public static final java.lang.String USER_PASSWORD

See Also:

Constant Field Values

MESSAGE_TASK_ID

public static final java.lang.String MESSAGE_TASK_ID

See Also:

Constant Field Values

MESSAGE_MESSAGE_TYPE_ID

public static final java.lang.String MESSAGE_MESSAGE_TYPE_ID

See Also:

Constant Field Values

MESSAGE_DESCRIPTION

public static final java.lang.String MESSAGE_DESCRIPTION

See Also:

Constant Field Values

MESSAGE_HOURS

public static final java.lang.String MESSAGE_HOURS

See Also:

Constant Field Values

MESSAGE_HANDLER_USER_ID

public static final java.lang.String MESSAGE_HANDLER_USER_ID

See Also:

Constant Field Values

MESSAGE_HANDLER_GROUP_ID

public static final java.lang.String MESSAGE_HANDLER_GROUP_ID

See Also:

Constant Field Values

MESSAGE_RESOLUTION_ID

public static final java.lang.String MESSAGE_RESOLUTION_ID

See Also:

Constant Field Values

MESSAGE_PRIORITY_ID

public static final java.lang.String MESSAGE_PRIORITY_ID

See Also:

Constant Field Values

MESSAGE_DEADLINE

public static final java.lang.String MESSAGE_DEADLINE

See Also:

Constant Field Values

MESSAGE_SUBMIT_DATE

public static final java.lang.String MESSAGE_SUBMIT_DATE

See Also:

Constant Field Values

MESSAGE_SUBMITTER_ID

public static final java.lang.String MESSAGE_SUBMITTER_ID

See Also:

Constant Field Values

MESSAGE_BUDGET

public static final java.lang.String MESSAGE_BUDGET

See Also:

Constant Field Values

MESSAGE_UDF_MAP

public static final java.lang.String MESSAGE_UDF_MAP

See Also:

Constant Field Values

TASK_EMPTY_NAME

protected static final java.lang.String TASK_EMPTY_NAME

See Also:

Constant Field Values

USER_EMPTY_LOGIN

protected static final java.lang.String USER_EMPTY_LOGIN

See Also:

Constant Field Values

USER_EMPTY_NAME

protected static final java.lang.String USER_EMPTY_NAME

See Also:

Constant Field Values

Constructor Detail

CSVImport

public CSVImport()

Method Detail

findCategoryIdByName

public static java.lang.String findCategoryIdByName(java.lang.String categoryName)
                                             throws GranException

Throws:

GranException

findResolutionIdByName

public static java.lang.String findResolutionIdByName(java.lang.String resolutionName,
                                                      java.lang.String messageTypeName)
                                               throws GranException

Throws:

GranException

findTaskResolutionIdByName

public static java.lang.String findTaskResolutionIdByName(java.lang.String resolutionName,
                                                          java.lang.String categoryName)
                                                   throws GranException

Throws:

GranException

findPriorityIdByName

public static java.lang.String findPriorityIdByName(java.lang.String priorityName,
                                                    java.lang.String categoryName)
                                             throws GranException

Throws:

GranException

findStateIdByName

public static java.lang.String findStateIdByName(java.lang.String stateName,
                                                 java.lang.String categoryName)
                                          throws GranException

Throws:

GranException

findTaskIdByName

public static java.lang.String findTaskIdByName(java.lang.String taskName)
                                         throws GranException

Parameters:

taskName -

Returns:

Throws:

GranException

findUserIdByName

public static java.lang.String findUserIdByName(java.lang.String userName)
                                         throws GranException

Throws:

GranException

findUserIdByLogin

public static java.lang.String findUserIdByLogin(java.lang.String userLogin)
                                          throws GranException

Throws:

GranException

findTaskIdByNumber

public static java.lang.String findTaskIdByNumber(java.lang.String taskNumber)
                                           throws GranException

Throws:

GranException

findMessageTypeIdByName

public static java.lang.String findMessageTypeIdByName(java.lang.String mstatusName,
                                                       java.lang.String categoryName)
                                                throws GranException

Throws:

GranException

findUserStatusIdByName

public static java.lang.String findUserStatusIdByName(java.lang.String prstatusName)
                                               throws GranException

Throws:

GranException

findUDFIdByName

public static java.lang.String findUDFIdByName(java.lang.String udfName)
                                        throws GranException

Parameters:

udfName -

Returns:

Throws:

GranException

findUDFListIdByValue

public static java.lang.String findUDFListIdByValue(java.lang.String udflistValue)
                                             throws GranException

Throws:

GranException

parseBudget

public static java.lang.Double parseBudget(java.lang.String strBudget,
                                           java.lang.String locale)
                                    throws GranException

Throws:

GranException