Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 16.2 Import Problem

In the Open Standard
Yalçın GünerMember for 11 years 5 months
Created
10
3
0

Hi All,

 

I have a problem about importing my actual dates to primavera

When I selected my excel sheet to import Primavera, P6 notice me that

The User Preferences used to create this Excel file are not same as your current preferences. Importing this file could corrupt your data. Please refer to Help for more information about importing data from Excel. Are you sure that you want to continue?

 

Another thing I recognized that the cells in exported excel sheet doesn't contain apostrophe(') in front of data. I think Each cell should contain apostrophe. By the way my p6 version is 16.2

 

Thanks All in advance.

Save Follow Follow forum Report
Reply New topic

10 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    just EXPORT a few activities

    just EXPORT a few activities that have actual dates. Then use this as a template to import your actual dates. You must include the times also. 

    Report
  2. 0
    Yalçın Güner ·
    #2

    It didnt work Zoltan. To

     
     
     
     
    It didnt work Zoltan.
     
    To add time into the dates I have to convert my dates format to text but the exported cells doesnt contain apostrophe.
     
    I had been using 15.1 version before 16.2 and I havent had any problem regarding this issue.
    Report
  3. 0
    Zoltan Palffy ·
    #3

    lets say your dates are in

    lets say your dates are in column L to add the apostrophe just insert another column let's call that K and put the apostrophe in column K and copy it to the bottom. Now in column M use this excel function =K&L. Now copy column M and go to column L and select paste special and select value. Now delete columns K and M and import the excel file.

    I do this all of the time. 

    Report
  4. 0
    Yalçın Güner ·
    #4

    It didnt worked. I have been

    It didnt worked. I have been using ASAP for a long time. While I was using p6 15.1 I had no problem to import

     

    I couldnt anything from excel since we have installed P6 16.2.

     

    Note that My exported excel spreedsheet's cells doesnt include Apostrophe in front.

    Report
  5. 0
    Hisham Ahmed ·
    #5

    THIS IS VERSION 16.2

    THIS IS VERSION 16.2 PROBLEM!

    Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.

    I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.

    I hope someone with better IT background will take us through this issue.

    Report
  6. 0
    Hisham Ahmed ·
    #6

    THIS IS VERSION 16.2

    THIS IS VERSION 16.2 PROBLEM!

    Same as your case, I have been doing alot of shorcuts with excel expor=>import with versions 6.2 and 7, all was fine starting with updating to resource loading and relationships. Now, this feature simply does not work on 16.2 although I consider myself very familiar with excel import in earlier versions of P6.

    I noticed that the exported excel file is in Version 2010 instead of 2003 with P6 V7. I thought that Oracle wanted to keep pace with Ms Office but instead, they messed it up, giving us a very hard time. Taking weeks to do what took an hour before.

    I hope someone with better IT background will take us through this issue.

    Report
  7. 0
    Zoltan Palffy ·
    #7

    another excel utility is

    another excel utility is called KUtools I use the heck out of it I can add the tick marck in front of any cell even whole columns it has a lot things excel does not.  

    https://www.extendoffice.com/order/kutools-for-excel.html

    Report
  8. 0
    Montasir Abdelhalim ·
    #8

    Hi All, Please help me with

    Hi All, 

    Please help me with the same problem..

     I can't import my updated activities from excel to primavera 16.2 .. 

     Please provide with simple  steps to overcome it..

     

    Thanks and best regards

    Report
  9. 0
    Rafael Davila ·
    #9

    Consider using ASAP Utilities

    Consider using ASAP Utilities Free.

    http://www.asap-utilities.com/

    Report
  10. 0
    Zoltan Palffy ·
    #10

    you need the latest patch

    you need the latest patch 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?