Import/Export Data to and fro P3e and MS Excel - A

Submitted by Shahrol Sabaruddin on
Oracle Primavera - PM6

Member for

20 years 9 months
Member for 20 years 9 months
Submitted by Shahrol Sabaruddin on Sun, 2005-02-13 11:56
Permalink



Well guys, I do not know that my question leads to lot of thing............ I guess it is not a stupid question after all!



Cheer up, everybody especially Brad, this is the only place for planner and scheduler to ask a lot of question whether it is stupid or not!



I consider myself a newbie, rest asure there bound to be more stupid question.



Thanks.

Member for

21 years 6 months
Member for 21 years 6 months
Submitted by Vishwas Bindig… on Sun, 2005-02-13 09:18
Permalink

Report to the Moderators -



Please delete the post by Brad Lord. His reply is unprofessional and completely against the fundamental ethics/concepts of Project Management.



Please also make it a point to use punitive measures on PPers who abuse this forum.

Member for

20 years 9 months
Member for 20 years 10 months
Submitted by kamran hazini on Sun, 2005-02-13 00:48
Permalink

of course this is an expert. Maybe he can teach everybody some lessons how to be polite, how to become a taxi driver or ......!!!

Member for

20 years 9 months
Member for 20 years 10 months
Submitted by kamran hazini on Fri, 2005-02-11 03:12
Permalink

Hi Guys;

Where can I find this SDK for P3e? As far as I understand it is a free tool. Is there anybody could introduce me the web-site (except for Primavera web site!!) or could forward it to me?

thanks

kamran

kamranhazini@yahoo.com

Member for

20 years 9 months
Member for 20 years 9 months
Submitted by Shahrol Sabaruddin on Thu, 2005-02-10 23:27
Permalink

Alex,



How about importing it back (paste it in P3e) after doing some modification or adjustment in Excel? Will it update in P3e without any problem or error?



Thanks

Member for

22 years 8 months
Member for 22 years 9 months
Submitted by Alex Wong on Thu, 2005-02-10 23:18
Permalink

Dear All,



There are few ways to export data to excel speardsheet



1. Copy and paste - Select the column you want to copy in the activity and copy to a excel speardsheet. It would work on data that is not time related.



2. Report - In the report area in P3e you can select 99.999% of the fields you want to export including time distribution information. Once you set up the report when you run the report you can then select the option as generate a CSV file. Then you can simply open the exported file in Excel



3. SDK (Free) - By Primavera



4. API (you need to paid $ to get API) - By Primavera



Importing function



1. SDK



2. API



3. Software kits developed by other user - I think one call SunTech.



Regards



Alex


Member for

23 years 8 months
Member for 23 years 8 months
Submitted by Dinesh Kumar D… on Wed, 2005-02-09 23:44
Permalink

Mr.Hank,



Did you use the Import/Export utility provided by P3E for ver 3.1 which works with Excel?



I have problem in using it.any comments advice on how to import progress from Excel.



Thanks & regards



Dinesh

Member for

21 years 3 months
Member for 21 years 3 months
Submitted by Henk van der Heide on Wed, 2005-02-09 16:28
Permalink

Dear shahrol,



Yes their is a way.

It is the SDK in combination with Activity.xls sheet (for example) However it’s not as powerfull as P3win (import/export.)

If you want to set up a new project and you want to use a lot of existing data i suggest an import to p3win (if you still have p3win availabel) and then import this file into P3e.



Regards



Henk