(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Dear Planners,
I am having an issue with the SDK module and its running of the Dictionary 6x Excel sheet. I have begun to construct a new database instance on the P7 system and have imported a list of Resources using the Dictionay 6x. The Resources were set fine and I can use them. I now use 'Get Resource Rate' and the resources all appear as set. I then return to the login page and 'Set Resource Rate' without making any alterations to the data but this causes an error;
Row 3: Invalid Value XoType:1 for column:start_date with XoType:11.
I now have several hundred resources that are on in the Resource Library but I am unable to mass manipulate these to add the varying rates for their Price/Unit or set the Effective dates;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Internal ID (Read-Only) |
Resource ID |
Description |
Shift Number |
Effective Date |
Max Units/Time |
Price/Unit |
Price/Unit2 |
Price/Unit3 |
Price/Unit4 |
Price/Unit5 |
DELETE |
|
1817 |
SAL |
Stephen Allen |
|
01.01.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1975 |
SAL |
Stephen Allen |
|
02.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1976 |
SAL |
Stephen Allen |
|
03.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1977 |
SAL |
Stephen Allen |
|
04.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1799 |
MAL |
Mohammed Al-Sheikhly |
|
01.01.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1921 |
MAL |
Mohammed Al-Sheikhly |
|
02.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1922 |
MAL |
Mohammed Al-Sheikhly |
|
03.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1923 |
MAL |
Mohammed Al-Sheikhly |
|
04.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1800 |
MBA |
Michael Bailey |
|
01.01.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1924 |
MBA |
Michael Bailey |
|
02.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1925 |
MBA |
Michael Bailey |
|
03.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
|
1926 |
MBA |
Michael Bailey |
|
04.11.2010 |
1 |
0 |
0 |
0 |
0 |
0 |
|
Can anyone reccommend a route to add Price/Unit values and associated Effective Dates to the resources, preferably with a fix to the SDK - Dictionary process or another process?
Many thanks for your planning help.
Regards
Robin Kilmister.
Printer-friendly version
Send to friendEmail: PPadmin@planningplanet.com
