Forum Discussion
Replacing Smartsheets with MS Project for the Web
Hello crodamer ,
Regarding the Project for the web entities / tables, these will be in the Default CDS environment - have you looked there?
Paul
Hello crodamer ,
Regarding the Project for the web entities / tables, these will be in the Default CDS environment - have you looked there?
Paul
Hi Paul,
Have another question regarding migrating from Smartsheets to MS Project for the Web.
We have nearly 1,000 smartsheet sheets to migrate. I just tried to import and export of a Smartsheet tasks .csv file. I was able to do the mapping but when it ran I got the following error, "We're sorry. You cannot directly do 'Create' operation to 'msdyn_projecttask'. Try editing it through the Resource editing UI in Dynamics or via Project."
Obviously, if we are trying to migrate 1,000 smartsheets, with lots of related tasks, we wouldn't want to have users to have to manually recreate all of the projects and tasks. It doesn't seem like we can use the normal import method directly to the cds table.
Do you have any suggestions?
Thanks- Clayce
Hello crodamer ,
Currently it is not supported to programmatically create tasks in Project for the web - it is blocked as you have seen. Unfortunately until it is supported to programmatically create tasks in Project for the web, there is no migration process.
Paul
Wow, seems like a pretty basic requirement to be able to migrate to PFW...
Thanks for the info Paul_Mather , really appreciate your feedback.
Clayce