Migrating to Exchange

Calendar SingleTasks

Microsoft Outlook Calendar relates tasks to projects by using the ProjectID number. Without a ProjectID number, tasks are imported without being connected to a specific project.

Example...
SingleTasks:
{
		Priority:	 16672
		Text:   "Update summer catalog."
		AmountActualEffort:	 0
		AmountEstimatedEffort:  1
		IsTaskAutoDone:		 T
		StartDate:	3-6-1996
		AmountStartWork:		4
		TypeUnitStartWork:	2
		EndDate:		3-10-1996
		TypeUnitEstimatedEffort:		2
		TypeUnitActualEffort:   2
}

The following table describes the properties of SingleTasks.

Property Values Description
AmountActualEffort Number Amount of time of actual effort, in units set by TypeUnitActualEffort.
TypeUnitActualEffort 0 = Minute
1 = Hour
2 = Day
3 = Week
4 = Month
Type of unit for measuring actual effort for task.
AmountEstimatedEffort Number Amount of estimated time effort, in units set by TypeUnitEstimatedEffort.
TypeUnitEstimatedEffort 0 = Minute
1 = Hour
2 = Day
3 = Week
4 = Month
Type of unit for measuring estimated effort for task.
AmountStartWork Number Amount of time before end date to start work on item, in units set by TypeUnitStartWork.
TypeUnitStartWork 0 = Minute
1 = Hour
2 = Day
3 = Week
4 = Month
Type of unit for amount of time before end date to start work.
Billing String Billing information.
CompletedDate mm-dd-yyyy Date task was completed.
StartDate mm-dd-yyyy Date task starts.
EndDate mm-dd-yyyy Date task ends.
IsTaskAutoDone T or F If task should appear as automatically completed on end date.
Mileage String Mileage associated with task.
PercentCompleted Number Percentage of task completed.
Priority See the following explanation. Priority of task.

Priority Property

Schedule+ prioritizes tasks by using numbers (1 through 9), letters (A through Z), or a combination of both. For example, "A1," "3," and "B" are valid priority properties. The migration file format converts the priority to a decimal format.

The following table illustrates how priorities are converted to decimal versions. The ASCII value of the letter or number is converted to a hexadecimal, the number 20 is prefixed or appended as a space and place holder, and then the number is converted to a decimal format.

Priority Convert to hexadecimal Prefix or append 20 Convert to decimal
1 31 2031 8241
2 32 2032 8242
3 33 2033 8243
4 34 2034 8244
5 35 2035 8245
6 36 2036 8246
7 37 2037 8247
8 38 2038 8248
9 39 2039 8249
A 41 4120 16672
B 42 4220 16928
C 43 4320 17184
D 44 4420 17440
E 45 4520 17696
F 46 4620 17952
G 47 4720 18208
H 48 4820 18464
I 49 4920 18720
J 4A 4A20 18976
K 4B 4B20 19232
L 4C 4C20 19488
M 4D 4D20 19744
N 4E 4E20 20000
O 4F 4F20 20256
P 50 5020 20512
Q 51 5120 20768
R 52 5220 21024
S 53 5320 21280
T 54 5420 21536
U 55 5420 21536
V 56 5620 22048
W 57 5720 22304
X 58 5820 22560
Y 59 5920 22816
Z 5A 5A20 23072

For a number priority of 3, for example, use the hexadecimal 33 and prefix 20. The value 2033 converts to a decimal of 8243. For a letter priority of C, for example, take the hexadecimal 43 and append 20. The value 4320 converts to 17184.

If your system prioritizes by requiring a combination of letters and numbers (for example: A1, B3, or Z9), use this procedure. Convert both to hexadecimal, concatenate (link together) the values of the letter and number, and then convert that value to a decimal format. For a priority of A3, for example, use the hexadecimal of A (41) and concatenate it with the hexadecimal of 3 (33). The value 4133 converts to 16691.

Related Topics

Schedule Data Secondary Files Formatting the Migration Files