The format of the file must be:

 

File type

CSV, text separated by semi-columns

Field delimiter

Semi-column

Record delimiter

CRLF (CHR(10) + CHR(13))

Code page

1252 ANSI (Event. 850 or 437 ASCII)

File extension

*.whx

 

Field Nb Description Field type Comments Priority
1 Activity date Date Compulsory  
2 Staff member code C(15) Compulsory  
3 Activity status N(1)

Compulsory

The accepted values are:

1 Incomplete

2 Editable

3 Not approved

4 Billable

5 Billed

6 Do not bill
 
4 Activity batch number N(10)

Optional

The same batch number should be assigned to all the activities that will need to be grouped.

 
5 Task code C(15)

Optional

 
6 Task description C(250) Optional  
7 Start date and time Date or Date Time

Optional

The accepted formats are

DD.MM.YYYY or

DD.MM.YYYY HH:MM:SS
5 (see remark)
8 End date and time Date or Date Time

Optional

The accepted formats are

DD.MM.YYYY or

DD.MM.YYYY HH:MM:SS

5 (see remark)
9 Total length in minutes N(10)

Optional

1 (see remark)
10 Total length in seconds N(10)

Optional

2 (see remark)
11 Total length in hours and hundredths N(15, 4) Optional 3 (see remark)
12 Integer part of number of hours N(10) Optional 4 (see remark)
13 Integer part of the number of minutes N(2) Optional 4 (see remark)
14 Task hourly rate N(15, 2) Optional  
15 Task total amount C(20) Optional  
16 Place C(20) Optional  
17 Project code C(20) Optional  
18 Customer code C(20) Optional  
19 Notes C(250) Optional  

  

Remark: 

The file to be imported must contain all the columns mentioned above. The order of the columns is compulsory.

The name of the fields does NOT determine the content.

The optional fields must be in the file, but can be left empty.

Some programs can generate NULL values in their exports. This value is not always supported during the import. The only way to know if it is possible to exploit the files created by your program is to test them yourself.

The length of the activity can be specified in different ways:

- Filling in only field 1, and thus determining a full day length (fill in the key: full_day_length);

- Filling in both fields 7 and 8, and thus determining a series of full day lengths;

- Filling in both fields 9 and 10, and thus determining an activity that has a length corresponding to the difference between the two;

- Filling in only field 11, thus determining an activity which length corresponds to the number entered (ex: 4.5 equals 4 hours and a half);

- Filling in both fields 12 and 13, thus determining the length of the activity in hours and minutes.

If the information concerning the length are specified in more than one field, WinBIZ will use only the first piece of information available according to the column priority.

 

If you wish to import a file with very few information, you can check the keys available in ProjectActivitiesImport in order to discover which elements can be defaulted.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.