John
My file increases in size any where from 1 mb to 5 mb's per week.
There are about 2000 lines of data - with about 40 columns of
information.
The data size has been fairly consistant, but yet grows, I have to
convert this file every week to a .csv file to send to our customer.
The file a one time was about 10 mbs and is now 80 mbs.
The bloat may indeed be the problem but the solutions on FAQ 43 don't
work for me, when I try to save as I get a Winproj.exe error.
I've tried the save as soon as you open with out any success - does not
change the size of the file. I've tried to save to another directory
but I get the Winproj.exe error.
I've tried to pull back in my own .csv file but it doesn't come with
the calendar so it doesn't look right.
The caledar issue is when I bring the .csv back to Project my duration
of the program goes from 1743 days to 1813 - I'm guessing the
difference in no holidays vs holidays. 7year program 10 holidays per
year equals 70 days.
The linking issue is that sometimes when I bring it back into Project I
see that the links SS or FF or whatever get truncated to just the
predecessor or successor.
I've called our IT people to come reload Project.
Any other ideas???
breppucc,
You're right, for a Project file with 2000 lines, several megabytes is
definitely bloated. You said the methods in FAQ 43 don't work for you.
Does that mean you are unable to save as a .mpd and re-open as .mpp or
simply that doing so has no noticeable effect on the file size?
You said you convert the file every week for your customer. The word
"convert" bothers me. Are you really converting the file or simply doing
a "Save As" to a .csv? If it's the latter then I see no problem but if
you are actually converting and re-opening the file between .mpp and
..csv, I'd say that is an process that is ripe for causing corruption.
The fact that you get a Winproj.exe error tells me there might be a
problem with Project itself. Before the IT folks show up I'd try running
Detect and Repair found under the Project menu. However you need the
installation CD to run that repair and if the IT folks are the only
people who have the CD then you have to wait for them anyway.
It sounds like the calendar and link issues are related to .csv
conversion. I'd dispense with all the converting, get the file squared
away and then re-configure the calendar and links as necessary. Then
just work with the file as a standard .mpp. Use a "save as" for the
customer's .csv but keep that conversion one-way.
John
Project MVP
