Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How do I import Projec...
Microsoft Dynamics AX (Archived)

How do I import Project Tasks and Journal lines for hours using DIXF?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have began researching DIXF and there are a lot of templates for import, including the options to create custom ones. I found that there is a template for the ProjJournalTrans table which covers the Journal lines for hours, but I didn't find a template for importing the Project's tasks.

Basically every few hours or so I want to import a Project's tasks and time entries from an internal website into AX 2012. My question is the following:

Is there a "smart way" to import the WBS for a Project (including all the Jounral lines for hours), or do I have import the data, table by table (and therefore creating new templates for the SMMActivities, PSAActivitySetup and PSAActivityEstimates tables, coresponding to a Project task)? 

Basically the new Projects and Journals are created by the users, but the Project's tasks and time entries for these tasks are managed in our website so we need to import them.

Thanks.

Best Regards,

Evgeni Dyulgerov

*This post is locked for comments

  • Verified answer
    Crispin John Augustine Profile Picture
    Crispin John Augustine 37,081 on at
    RE: How do I import Project Tasks and Journal lines for hours using DIXF?

    Setting up a new DMF Entity, and mapping is a one time effort, a significant part of which you can do graphically. So I usually recommend it.

    You can setup multiple (related) table imports within a single processing group. So when the processing group is executed, all the tables are filled simultaneously.

    The "..every few Hours.." is simply done by setting up a DMF processing group to run in Batch.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I import Project Tasks and Journal lines for hours using DIXF?

    Hi,

    I read about that integration, but unfortunately it's not based on MS Project, so we would need to use the DIXF to do the integration.

    Best Regards,

    Evgeni Dyulgerov

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How do I import Project Tasks and Journal lines for hours using DIXF?

    Hello Evgeni,

    Is your 'internal website' based on MS Project?

    If this is the case then you can make use of the standard MS Project - AX integration.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans