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
Solved

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

Posted on 2004-03-22
3
246 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to redirect https://www to non-www? 6 76
.htacess file 301 redirects that are strange 4 63
Webserver access problem 5 75
cookies analysis tools 2 99
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

766 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