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.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts