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

S
Shahrol Sabaruddin 👤 Member for 21 years 4 months



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.

V
Vishwas Bindiganavale 👤 Member for 22 years 1 month

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.

K
kamran hazini 👤 Member for 21 years 5 months

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

M
Ming Cheung 👤 Member for 21 years 4 months

Please visit the Primavera’s Knowledgebase to download the correct version of the Excel file.

K
kamran hazini 👤 Member for 21 years 5 months

Dear Ming, My available P3e CD is not containing this excel file. could you please forward it to me with this email address: [email protected]

thanks in advance.

K
kamran hazini 👤 Member for 21 years 5 months

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

[email protected]

P
Phil Palmer 👤 Member for 23 years 1 month

Guys,

If you can wait till June P3e V5 will have import/export functionality.

Regards

Phil

S
Shahrol Sabaruddin 👤 Member for 21 years 4 months

How to use the SDK to export or import data (MS Excel)especially? Is there a step by step instruction?

S
Shahrol Sabaruddin 👤 Member for 21 years 4 months

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

A
Alex Wong 👤 Member for 23 years 4 months

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


D
Dinesh Kumar Damavarapu 👤 Member for 24 years 3 months

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

H
Henk van der Heide 👤 Member for 21 years 10 months

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

Forum Sponsor

Top Posters

MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Hunais M J
0 posts