Microsoft Project – internal Names of Fields

Tuesday, December 20, 2016 Posted by

If someone needs the names of the properties that a Task has (pulled from the project.wsdl)

Have fun – at your own risk 🙂

PROJ_UID
TASK_UID
TASK_PARENT_UID
TASK_NAME
TASK_ID
TASK_IS_MILESTONE
TASK_IS_SUMMARY
TASK_IS_MARKED
TASK_IGNORES_RES_CAL
TASK_IS_EFFORT_DRIVEN
TASK_IS_CRITICAL
TASK_IS_EXTERNAL
TASK_IS_FROM_FINISH_SUBPROJ
TASK_IS_OVERALLOCATED
TASK_IS_RECURRING
TASK_IS_RECURRING_SUMMARY
TASK_IS_SUBPROJ
TASK_IS_READONLY_SUBPROJ
TASK_LOCKDOWN_BY_MANAGER
TASK_LEVELING_DELAY
TASK_LEVELING_DELAY_FMT
TASK_LEVELING_CAN_SPLIT
TASK_LEVELING_ADJUSTS_ASSN
TASK_DUR_IS_EST
TASK_DUR
TASK_DUR_FMT
TASK_DUR_VAR
TASK_EAC
TASK_VAC
TASK_ACT_DUR
TASK_REM_DUR
TASK_CONSTRAINT_TYPE
TASK_CONSTRAINT_DATE
TASK_ACT_START
TASK_ACT_FINISH
TASK_PRIORITY
TASK_PCT_COMP
TASK_PCT_WORK_COMP
TASK_TYPE
TASK_FIXED_COST_ACCRUAL
TASK_DEADLINE
TASK_WORK
TASK_OVT_WORK
TASK_REG_WORK
TASK_ACT_WORK
TASK_ACT_OVT_WORK
TASK_REM_WORK
TASK_REM_OVT_WORK
TASK_COST
TASK_OVT_COST
TASK_FIXED_COST
TASK_ACT_COST
TASK_ACT_OVT_COST
TASK_REM_COST
TASK_REM_OVT_COST
TASK_PHY_PCT_COMP
TASK_EVMETHOD
TASK_OUTLINE_LEVEL
TASK_OUTLINE_NUM
TASK_CAL_UID
TASK_START_DATE
TASK_START_VAR
TASK_FINISH_DATE
TASK_FINISH_VAR
TASK_RESUME_DATE
TASK_STOP_DATE
TASK_PRELEVELED_START
TASK_PRELEVELED_FINISH
TASK_EARLY_START
TASK_EARLY_FINISH
TASK_LATE_START
TASK_LATE_FINISH
TB_START
TB_FINISH
TB_COST
TB_WORK
TB_DUR
TB_DUR_FMT
TASK_BCWS
TASK_BCWP
TASK_ACWP
TASK_FREE_SLACK
TASK_TOTAL_SLACK
TASK_HAS_LINKED_FIELDS
TASK_WBS
AddPosition
AddAfterTaskUID
DurationType
WOBJ_DOC_REF_CNT
WOBJ_ISSUE_REF_CNT
WOBJ_RISK_REF_CNT
WOBJ_OTHER_REF_CNT
CREATED_DATE
MOD_DATE
PROJ_NAME
PROJ_TYPE
PROJ_OPT_CURRENCY_DIGITS
PROJ_OPT_CURRENCY_POSITION
PROJ_OPT_CURRENCY_SYMBOL
TASK_EXT_PROJ_UID
TASK_BUDGET_COST
TASK_IS_NULL
TASK_BUDGET_WORK
TASK_CONTACT
TASK_COST_VAR
TASK_CPI
TASK_CV
TaskCVP
TASK_START_SLACK
TASK_FINISH_SLACK
TASK_HYPERLINK_FRIENDLY_NAME
TASK_HYPERLINK_ADDRESS
TASK_HYPERLINK_SUB_ADDRESS
TASK_IS_ROLLED_UP
TASK_NOTES
TASK_SPI
TASK_SV
TaskSVP
TASK_TCPI
TASK_WORK_VAR
TASK_COMPLETE_THROUGH
TASK_IS_MANUAL
TASK_IS_ACTIVE
TASK_IS_DISPSUMMARY
TASK_SCHED_START
TASK_SCHED_FINISH
TASK_START_TXT
TASK_FINISH_TXT
TASK_SCHED_DUR
TASK_SCHED_DUR_FMT
TASK_DUR_TXT
StatusManager

Project Server – URL um ein Projekt direkt im Project Client zu öffnen

Tuesday, June 24, 2014 Posted by

Ich habe leider keine Dokumentation gefunden – nach dem Studium der HTTO Request von projects.aspx konnte ich folgendes finden:

Das Schema der URL sieht so aus

ms-project:osp|u|PROJECT_SERVER_URL|g|SERVER_GUID|p|<>\PROJECT_NAME|r|FLAG_READ_MODUS

PROJECT_SERVER_URL: URI des Servers, zB  https://projectserver.company.com

SERVER_GUID: GUID der PWA Site Collection die das Projekt öffnet – ist pro Server also stabil

PROJECT_NAME: Name des Projektes

FLAG_READ_MODUS: Flag, 1: Readonly, 0  Read/Write, automagisch ausgecheckt

Beispiele:

ms-project:osp|u|https://projectserver.company.com/projectserver|g|af5c31ee-184a-4ade-846c-b2e034663dc5|p|<>\Great Project|r|1

Öffnet das Projekt mit dem Namen “Great Project”

Sharepoint Designer öffnet keine ASPX Seite

Friday, June 13, 2014 Posted by
Eine mögliche Lösung:
In der Datei
   C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\SiteTemplates\PWA\XML\ONET.XML
ist der Eintrag DisableWebDesignFeatures=”wdfeditpages” .
Den Eintrag entfernen, iisreset und es geht!

 

File downloads with special Characters

Thursday, April 4, 2013 Posted by

It is possible to download files with special characters in it, it just looks very strange.

The Header looks like this:

Content-Disposition attachment; filename*=UTF-8”specialChar_%C3%A4%C3%BC%C3%B6%C3%9F.doc;

that is (in php)

header(“Content-Disposition: attachment; filename*=UTF-8””.  urlencode( $filename ) . “;” );

Ipad mit iOS 6 – massive Wlan Probleme beim Tethering

Tuesday, September 25, 2012 Posted by

Seit ein paar Tagen hab ich nun dieses I-Device. Aufgrund des ausgezeichneten Displays als e-book reader ist das Ding ja durchaus ganz nett. Ansonsten ists ein recht teurer Zugang zum Apple App Store.

Das kurzlich durchgeführte Upgrade auf iOS 6 dafür gesorgt das kein Tethering mehr mit meinem Android (Motorola Defy) mehr funktioniert. Somit ist der WLAN-only Ipad weitgehend nutzlos sobald ich aus Heim- oder Firmen Wlan draußen bin.

Weit entfernt von einem “truly magic device”. Mehr als ärgerlich.

Die Lösungen die durch Netz geistern “Wlan ab- und wieder aufdrehen” und “Wlan löschen und wieder eingeben” sind nicht zielführend. Da das Device für technisch nicht versierte User gemacht ist gibts auch keine sinnvolle Fehlermeldung.

Apple, you suck.

update: Workaround
Bluetoth verbindungen funktionieren

mysql import / export

Wednesday, September 12, 2012 Posted by

mysqldump –user=root –password=secret–databases dbname > D:\path\dumpfile.sql

mysql -u root  dbname < d:\tmp\dumpfile.sql

Xampp 1.7 / Xampp 1.8 activate Ldap

Tuesday, August 21, 2012 Posted by

Those xampp bulids need a little tweaking:

to get php with ldap to run you need to remove the comment in the file php\php.ini:

extension=php_ldap.dll

Next you need to copy the file  php\libsasl.dll to apache\bin\libsasl.dll

 

Sharepoint: how to deploy a wsp

Thursday, August 16, 2012 Posted by

Assuming your wsp is in c:\tmp and is called DemoWebService.wsp

cd C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>

stsadm.exe -o addsolution -filename c:\tmp\DemoWebService.wsp
stsadm -o deploysolution -name DemoWebService.wsp -immediate -allowGacDeployment

-allowGacDeployment deploys it in the Global Assembly Cache - that is Full Controll

mysql: first and last days of months

Tuesday, April 3, 2012 Posted by

SELECT
  date_sub(CURDATE(), INTERVAL DAYOFMONTH(CURDATE()) -1 day) FIRST_DAY_OF_MONTH,
  last_day( CURDATE() ) LAST_DAY_OF_MONTH ,
  date_add(date_sub(CURDATE(), INTERVAL DAYOFMONTH(CURDATE()) -1 day), interval 1 month) FIRST_DAY_OF_NEXT_MONTH

Reset NTFS file permissions with command line tool ICACLS

Tuesday, March 13, 2012 Posted by
give the ownership of <folde> to the Administrators Group - you need an elevated cmd
takeown /A /R  /F <folder>

reset a folder
ICACLS <folder> /reset /T /C /Q