Import from csv file

[nicoletta.serraino]

Hi,
I'd like to import daily resorce's amounts from a csv ( file.
I've found how to import (and export) percentage or amount for each activity
from files, but I was able to insert daily amounts only from the microsoft
project application...

I wonder if it is possible to import a detailed daily resources file...
thank you very much!
Nicoletta

 

[John]

(e-mail address removed)

Hi,
I'd like to import daily resorce's amounts from a csv ( file.
I've found how to import (and export) percentage or amount for each activity
from files, but I was able to insert daily amounts only from the microsoft
project application...

I wonder if it is possible to import a detailed daily resources file...
thank you very much!
Nicoletta

nicoletta,
I assume you performed the import using an import map. Import/export
maps only work with static data, that is non-timescaled data. Timescaled
data, (i.e. daily, weekly, etc.), can be imported/exported, but it
requires the use of VBA.

So yes it is possible as long as you know the structure of the csv
string.

John
Project MVP

 

[Rod Gill]

Yes it is, but you must have a unique identifier such as a Unique ID so
imported data can be accurately merged with existing data. Resource name is
unreliable as they do change sometimes.

--

Rod Gill
Project MVP

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

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx