Standard Data Exchange Format
Microsoft Project Expertise:
Project is used to schedule tasks for management and reporting purposes. The US Army Corp of Engineers USACE has their contractors use a Quality Control System QCS that requires an input of the Network Analysis System NAS from a text file commonly known as the Standard Data Exchange Format SDEF which we can support:
A nice tutorial with examples is posted at -> (MS-Project tutorial link)
An example process of importing my SDEF into QCS is posted at -> (QCS import emample)
Our software converts MS-Project format into USACE SDEF format.
Click link to download SDEFmpp.exe software ( link ) then Register for immediate password sent to your e-mail. No e-mail addresses will appear online, and never distributed or posted.
Registration is now required for the software to work in full, plus a valid USACE QCS contract number is also required. All registered users are allowed to use a contract number of 123456 this year, so we can provide the software for free during this trial period.
In Microsoft Project, use File->Properties to put your registration e-mail into Comments, and your contract number into Keywords. Contact Iverson@GeoComputer.com to register (for free) additional contract numbers.
Software last updated February 2012.
Following are not defined in MS-Project, so done via the existing MS-Project "Text" fields for each Task: WorkersPerDay Text1 3 leftmost characters converted to SDEF file RespCode Text2 4 characters maximum WorkArea Text3 4 " ModNum Text4 6 " BidItem (CLIN) Text5 6 " <---******* THIS IS IMPORTANT TO USE FOR QCS Phase Text6 2 " Category Text7 1 " Feature of Work Text8 30 "
And for the .mpp file properties, in File->Properties use the following: SDEF spec: Will be taken from MS-Project: Project Name (48 characters) Title Contract Name (36 characters) Subject Project Identifier (4 characters) Manager Contract Number (6 or 7 digits) Keywords <---***** THIS IS NEEDED FOR QCS E-mail address (site registration) Comments (SDEF specifies 6 digits, but I was given a 7 digit Contract, so I make this work too.)
contact Bill Iverson for more information: Iverson@GeoComputer.com
Other specifications and information can be found at many of the Corp web sites:
http://140.194.76.129/publications/eng-regs/er1-1-11/entire.pdf