使用唯一ID将任务与时间表系统匹配 [英] using unique ID to match tasks with timesheet system

问题描述

你好，

我只是想从这里的专家那里退出我的方法，看看我是否朝着正确的方向前进：

i just wanted to bounce my approach off of the experts here to see if i'm going in the right direction:

我计划自动化流程以从内部时间表系统获取实际时间并将其导入MS project professional 2010.

i am planning on automating a process to get actual hours from an internal timesheet system and importing it into MS project professional 2010.

- 我设法提取将资源使用情况视图与我想要的信息一起包括使用宏的资源的当前速率。

- I managed to extract into excel the resource usage view with the information i want including the current rate of a resource using a macro.

- 我将使用excel将整个计划加载到内部系统（我们有那个能力）

- i will be loading the entire plan into the internal system using excel (we have that capability)

现在我的目标是：

- 在内部系统中制作一张记录所有实际小时数的时间表，并包括唯一ID字段（不确定资源唯一ID或任务唯一ID）

- make a timesheet table in the internal system that records all of the actual hours and include the unique ID field (not sure if resource Unique ID or Task Unique ID)

- 一旦资源登录到该视图，他们就可以看到分配给他们的任务

- once resources log in to that view they can see the tasks assigned to them

- 他们可以将实际工作时间用于任务。

- they will be able to put their actual hours against a task.

- 将通知项目经理批准时间。

- project managers will be notified to approve the time.

- 一旦获得批准，我正在设想以下流程：

- once approved, i am envisioning the process to:

    - 使用唯一ID字段从时间表系统进行查询。

    - Query from the timesheet system using the Unique ID field.

     - 在MS项目的资源使用情况中找到唯一ID，并使用实际小时数进行更新。 （这可能会在未来更多地自动化）

    - locate the unique IDs in the resource usage in MS project and update with actual hours. (This may be automated more in the future)

我关注的是唯一ID：

1）我注意到资源使用视图中的唯一ID与任务视图中的唯一ID不同

1) i noticed the Unique ID in the resource usage view is different than the one in the Task view

2）如果我使用资源使用视图中的那个，是否存在风险这可能会改变？我做了一些测试，我注意到每次我向任务添加资源或删除资源;资源使用情况视图中的唯一ID递增。

2) if i use the one from the resource usage view, is there a risk this might change? i did some testing and i noticed that every time i add a resource to a task or delete a resource; the unique ID in the resource usage view increments.

我真的受此限制吗？除了制作自定义字段以确保唯一ID不会更改之外，还有其他方法。

am i really restricted with this? is there any way other than making a custom field to make sure the Unique ID doesn't change.

如果我的方法不是实用，请你帮我理顺一下吗？

also, if my approach is not practical, can you please help me straighten out my approach?

非常感谢

推荐答案

实际上有3组唯一身份证正在播放中。 每个任务都有一个唯一的ID - 您可以在任务视图中查看该ID。 （例如甘特图）。 如果查看"资源工作表"视图，还可以看到资源唯一ID。 当
通过将资源与任务配对来创建作业时，会创建作业唯一ID。 任务使用情况视图中的分配行（由资源名称表示）与
资源使用情况视图中的分配行（由任务名称表示）之间的分配唯一ID是一致的。

There are actually 3 sets of unique IDs at play.  Each task has a unique ID - you can view that ID in a Task view. (Gantt chart for example).  There is also a resource unique ID that is visible if you look at the Resource Sheet view.  When you create an assignment by pairing a resource to a task, an assignment unique ID is created.  The assignment unique ID is consistent between the assignment row in the Task Usage view (represented by the resource's name) and the assignment row in the Resource Usage view (represented by the task name.)

为了确保您正在记录分配资源的正确工作小时数，我认为您需要分配唯一ID。

To make sure you are recording the correct hours worked by a resource on an assignment, I would think you'll need the assignment unique ID.

这篇关于使用唯一ID将任务与时间表系统匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！