Solved

Create new MS Project files (.mpp) based on query?

Posted on 2004-03-22
3
244 Views
Last Modified: 2013-12-24
Hi all,

I have a project plan template that I would like to do the following:

1.  run a query to my MS Access table for project numbers and project status fields
2.  create a new .mpp file for each project number in query 1
3.  change two fields in the new .mpp files to match the project numbers and project status fields from the query
4.  save the files on my local PC

(all work for this is done locally)

I have no idea of how to get started with this, except for the query.  So, I am looking for lots of help and code examples.

Is this possible using CF?
0
Comment
Question by:g118481
3 Comments
 
LVL 5

Accepted Solution

by:
M256 earned 200 total points
ID: 10652742
Hi g118481,

I am not familier with Microsoft Projected.  However, you may see if there is an option to "save as web page", or export in *.htm format.  If so, we can expect that it is possible to import one.  Try exporting it (if you have the option) and open it in Notepad.  This should give you and idea what kind of output you need.

If you get that figured out, you could either save it as a file with <cffile> or open it in Microsoft Project with the following:

<cfheader
  name="Content-Type"
  value="application/vnd.ms-project">
<cfheader
  name="Content-Disposition"
  value="attachment; filename=project.mpp">

I think this is correct, but I don't have Project to test it with.

Sorry I can't give you a complete answer, but I hope this is a starting place for you.

Matthew
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question