Destination Entity Name Field
You use the Destination Entity Name field to determine into which People Planner table you want to import the external data.
Before you start importing data into the People Planner tables, you should understand the following.
When you import via Custom Import Mappings, you have almost free rein in terms of how you choose to import the external data into the People Planner database. However, as with any powerful and flexible tool, this requires that you know what you are doing.
Although you cannot directly violate the People Planner business logic, you can easily fill its tables with data in a manner for which they are not intended, and which would not occur in connection with a manual operation of People Planner via its GUI. The result could be a People Planner database that differs differ significantly from how it would appear if you entered the same data manually.
Great efforts are put into optimizing the performance of the People Planner software. However, this work has been focused on how customers normally use the system; for example, certain database tables tend to contain a lot of data-and the functionality has been optimized for this-while other tables tend to be quite small-and have so far not required a lot of attention. If you do the import incorrectly, you may therefore end up with a setup that does not perform as well as a more appropriate import would do.
The problem is made worse by the fact that Custom Import Mappings can be used effectively to import large amounts of data -so big that they could never possibly occur in a manual operation.
Although there are differences, the structure of the Destination Entity Name field mimics the structure of the View menu. This makes it easy to determine which tables go together with which views.
The following table describes the most important imports.
| Import | Destination Entity |
|---|---|
| Projects and tasks | Projects » Project Task Milestone |
| Budgets | Projects » Project Task Milestone |
| Customers | Dimensions » Customer |
| Resources | Resources » Resource |
| Users | Security » User |
| Assignments | Assignments are automatically created when you book a resource on a task. |
| Bookings/Allocations | Entries » Man hour entry |
| Absences | Entries » Man hour entry |
| Time Registrations | Entries » Time registration entry |