How to import .mpp file(microsoft project plan) into D365fo Using x++ code.

(3) Share

Report

Posted on by TestBot

950

Hi all,

I have .mpp (microsoft project plan) file with me and i want to import the same into d365fo using code.

Let me know if you hav any suggestions.

Thank you in advance

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report

What should happen when you import it? Should it be just attached to a record, or do you want to somehow interpret the data inside and act on it?

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (0)

Report

Hi @Shaik146,

First clarify your goal: if the intention is only to attach the file to a record (e.g., to a project in Project Management and Accounting), you can use the document handling framework ('DocuRef', 'DocuValue').

However, if you want to extract and act on data (like tasks, timelines, resources), you’ll need to parse the '.mpp' file. Since '.mpp' is a binary format, FO alone can not interpret it—you’d likely need an external service to extract data and then call a custom D365FO service to import it.

Do you want to extract task/resource data or only attach the file?

Was this reply helpful? Yes No
TestBot 950 on at

Like (0)

Report

HI @Raj Borad and @Martin Dráb,

I want to process the data in the mpp file like we process excel files though import code using x++ into d365fo .similarly i want to insert the rows in the mpp file(that contains resources,tasks,timelines etc ) to a table(custom or standard).

Raj

Can you pl elaborate on external service as mentioned in the second way of approach? as i want to extract the data in the mpp file

Was this reply helpful? Yes No
Martin Dráb 237,926 Most Valuable Professional on at

Like (1)

Report

Okay, so your key problem is actually finding a way how to parse the file, interpret the data and extract what you're interested in. There is Microsoft.Office.Interop.MSProject.dll that you could use for this purpose (Application is the class to begin with), although I wouldn't be surprised if you couldn§t use it directly inside F&O.

Anyway, I'd forgot F&O for now. I would create a C# console application and build a proof of concept verifying that I'm able to extract the data I need. If not, making other steps would be a waste of time. When the key question is answered, I would check if I can use the library it in F&O, Azure function or so.

Was this reply helpful? Yes No
TestBot 950 on at

Like (0)

Report

Hi Martin,

Can we convert the Mpp file using fileupload to binary stream(Base64) in d365fo using x++.?

Was this reply helpful? Yes No
Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report
Yes, you can, althought it's doesn't address your problem.

Yes, you can upload the file.

All files are actually bytes of data and can be read through data streams.

And you can convert bytes to a string with Base64, which is useful, for example, when you need to transfer binary data though a text-based protocol. In your case, I see no reason for using Base64. You need the actual data file, therefore you'd need to decode the string again to get the data.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to import .mpp file(microsoft project plan) into D365fo Using x++ code.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to import .mpp file(microsoft project plan) into D365fo Using x++ code.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates