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.