Price/Unit & Effective Date setting for Resources using SDK and Dictionary 6x

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.