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.