4 // This page contains a form with a file-upload button
5 // so a user can choose a file to upload a .csv file and store it in task mgr
9 pm_header(array('title'=>_('Upload data into the tasks.'),'group_project_id'=>$group_project_id));
13 <?php echo _('This page lets you choose a file, in .csv format, and upload it so it can be inserted in the current subproject.'); ?>
16 <form enctype="multipart/form-data" method="post" action="<?php echo getStringFromServer('PHP_SELF')?>?group_project_id=<?php echo $group_project_id ?>&group_id=<?php echo $group_id ?>&func=postuploadcsv">
17 <?php echo _('Choose a file in the proper .csv format for uploading.'); ?><br />
18 <input type="file" name="userfile" size="30" />
19 <input type="submit" name="submit" value="submit" />
22 <h2>Record Layout</h2>
25 <tr><td><strong>Field Name</strong></td><td><strong>Description</strong></td></tr>
26 <tr><td>project_task_id</td><td>this is the ID in gforge database</td></tr>
27 <tr><td>external_task_id</td><td>optional, the equivalent of project_task_id but determined by
28 external application, such as MS Project. Primarily preserved for sorting purposes only.</td></tr>
29 <tr><td>parent_id</td><td>the project_task_id of the parent task, if any</td></tr>
30 <tr><td>external_parent_id</td><td>the equivalent of parent project_task_id but
31 determined by external application, such as MS Project. Primarily preserved for matching purposes only.</td></tr>
32 <tr><td>title</td><td>The summary or brief description</td></tr>
33 <tr><td>duration</td><td>Duration in days</td></tr>
34 <tr><td>work</td><td>Number of hours required to complete</td></tr>
35 <tr><td>start_date</td><td>The start date in MM-DD-YYYY HH:MM:SS format</td></tr>
36 <tr><td>end_date</td><td>The end date in MM-DD-YYYY HH:MM:SS format</td></tr>
37 <tr><td>percent_complete</td><td>Percentage of completion</td></tr>
38 <tr><td>priority</td><td>integers 1 to 5</td></tr>
39 <tr><td>notes</td><td>optional, the details of the task or a comment to add to a task</td></tr>
40 <tr><td>resource1_unixname</td><td>optional, the unixname or precisely-matched realname of the assignee </td></tr>
41 <tr><td>resource2_unixname</td><td>optional, same as above</td></tr>
42 <tr><td>resource3_unixname</td><td>optional, same as above</td></tr>
43 <tr><td>resource4_unixname</td><td>optional, same as above</td></tr>
44 <tr><td>resource5_unixname</td><td>optional, same as above</td></tr>
45 <tr><td>dependenton1_project_task_id</td><td>optional, the GForge task_id of a task to be dependent on</td></tr>
46 <tr><td>dependenton1_external_task_id</td><td>optional, the ID used by the external application</td></tr>
47 <tr><td>dependenton1_linktype</td><td>SS, SF, FS, FF, - The same types as MS Project</td></tr>
48 <tr><td>dependenton2_project_task_id</td><td>repetition of dependenton1</td></tr>
49 <tr><td>dependenton2_external_task_id</td><td>repetition of dependenton1</td></tr>
50 <tr><td>dependenton2_linktype</td><td>repetition of dependenton1</td></tr>
51 <tr><td>dependenton3_project_task_id</td><td>repetition of dependenton1</td></tr>
52 <tr><td>dependenton3_external_task_id</td><td>repetition of dependenton1</td></tr>
53 <tr><td>dependenton3_linktype</td><td>repetition of dependenton1</td></tr>
54 <tr><td>dependenton4_project_task_id</td><td>repetition of dependenton1</td></tr>
55 <tr><td>dependenton4_external_task_id</td><td>repetition of dependenton1</td></tr>
56 <tr><td>dependenton4_linktype</td><td>repetition of dependenton1</td></tr>
57 <tr><td>dependenton5_project_task_id</td><td>repetition of dependenton1</td></tr>
58 <tr><td>dependenton5_external_task_id</td><td>repetition of dependenton1</td></tr>
59 <tr><td>dependenton5_linktype</td><td>repetition of dependenton1</td></tr>