How to import Microsoft Project?

Is there a way to import Microsoft Project into Knime? I’m currently stuck converting the .mpp file to an .xlsx file, but the dates are stuck as a string. E.g. September 28, 2023 8:00 AM. I’m having difficulties converting the string to a date.

Found a way to manipulate the string via another discussion topic. It would be easier to be able to import a .mpp file with the dates already usable.

April 02, 2021 String to Date 02/04/2021 - How to convert string to date? - KNIME Analytics Platform - KNIME Community Forum

1 Like

Hey nwittmann,

Glad you find the solution. To convert one data type to another, there are plenty of nodes for different case. In this situation, we can use String to Date&Time node.

Hope this help.

Jinwei Sun

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.