Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Smartsheet XML export to P6 Import

edited 01/28/25 in Smartsheet Basics

I am trying to import into P6 the XML file from Smartsheet. The fields do not map correctly, for example start date maps to baseline start date. Also, Assigned Field in Smartsheet does not seem to map into P6 at all. I am working with 2 Smartsheets developed and owned by others. I am trying to use the Smartsheet info in a P6 master schedule. One does seem to map the dates correctly, the other does not. I assume there is a setup option different, but don't know where to look. Neither brings over Assigned To. Searched all over and can't find any guidance on this issue. Thanks

Answers

  • Community Champion

    This would be a P6 issue, rather than a Smartsheet issue I believe. Unless the columns in your export are named incorrectly, or your import mapping is not set correctly.

    Here is an article from Oracle that might help?

    Oracle Primavera P6 Professional Importing and Exporting Guide Version 22

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

  • Thanks Michelle, I have followed your link and tried a zillion other things. In P6 dates map into baseline date fields not start and finish. "Assigned to" in Smartsheet does not appear in any field I can find in P6. Seems a P6 mapping issue. Field names in Smartsheet export file look OK to me so not sure where process is going astray. I am using P6 23.12, not sure if that is issue. regards, Paul

Trending in Smartsheet Basics