HELP - Batch Import/Publish

I

irish_archer68

Hello and thank you for reading this posting... I have a client that
has over 3000 project schedules tracked in spreadsheets. Their current
process is to create MPP files from the spreadsheets and then they have
a batch checkin script for a custom Project Management system.

They want/need to migrate to MSPS.

My options as I see them are:
Option 1 - Update MSPS Database directly. From everything I have read,
this is considered a big No No. Is this even possible?

Option 2 - Batch Import/Publish. Are there any utilities that perform
this function? Macros seems to be a painful approach to this. Other
thoughts?

Option 3 - Change business processes. While this is the Politically
Correct answer, most of my clients are the Military and this is not
likely an option.

If ANYONE has any thoughts on this or ideas on where I can dig deeper,
please response to this posting OR email me at
[email protected].

Thank you in advance for your thoughts.
 
R

Rod Gill

Hi,

As the projects are already in Excel, I would look at creating a macro to
reformat the spreadsheets into the Project Workbook format as created by
Project when saving as an Excel workbook.

I would then have a simple Project macro that looped through all
spreadsheets in a nominated folder and opened them in Project then saved
them to Project Server. Use the EnterpriseResourceGet method to convert the
resources before saving to Project Server.

This should enable at least 80% of your schedules to be read in without much
effort. You can then review the remaining projects manually and determine
which ones can also be automated with a little extra work, before importing
the last few manually.

You can update the project database, but it would probably be safer to push
your data to an Access database then open from there before saving to
Project Server.
--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 
Top