Solved

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

Posted on 2004-03-22
3
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

623 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