Fill in an additional fields of the type Choice with existing data

by cdeschamps February 18, 2009

Fill in an additional fields of the type Choice with existing data

In PlanningPME, you have the possibility to add additional fields of the type Choice in the Tasks, Clients, Projects and Resources windows.

 

PlanningPME put at your disposal a field of the type "Choice" that appears as a combo box. The list of values can be filled in PlanningPME in the box "Values" or it can be fed by a script while opening PlanningPME.

Here is an example:

'Register PlanningPME.dll before -> c:\windows\system32\regsvr32 PlanningPME.dll

Set ppme = CreateObject("PlanningPME.Application")
ppme.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Target Skills\PlanningPME\PlanningPME.pp"
ppme.Connect

set dfs = ppme.GetDataFields(84) ' PpTask1

for i=0 to dfs.Count()

   if dts.Item(i).Field = "MYCHOICE" then

      dts.Item(i).Data = "Item1" & vbCrLf  & "Item2" & vbCrLf  & "Item3"

   end if

next i 

You just need to register this script with the extension .vbs and put it in the settings while launching PlanningPME (Menu Tools -> Options -> Integration) as shown below:

 

If you want to feed the values from an external database, you can open your own connexion and to browse the elements to add them...or just ask us for an integration.

Add comment

biuquote
  • Comment
  • Preview
Loading