web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Updating project tasks via import

(0) ShareShare
ReportReport
Posted on by

Hi folks,

I am new at this forum, so please tell me if I don`t follow common rules... And I am not a native speaker, sorry.

What am I looking for:

I want to import project tasks into CRM/PSA. Therefore I want to use excel but one problem is left:

I want to have that the given monthly effort is set to the respective month, let's say 1st of each Month. But every time I do an import the effort is distributed over the total duration of the task. I saw that I could use "Effort contour" to place the effort on a specific day. But it seems as if I have to have an entry for each single day of the period. Examples

Period: 01.02.2018 to 01.03.18 (ddmmyy). So I would use something like:

[{"Date":"\/Date(1515452400000+0000)\/","EffortHours":1},{"Date":"\/Date(1519858800000+0000)\/","EffortHours":1}]

Import works, but I get in January an effort of 0.95 and in Feb of 1.05. Total is correct. But the effort is (approx.) 0.05 every day.

Only Idea is to have an "VDate" entry for every single day, already for a year it would be a lot...

Any better idea or a hint?

Thank's for your attention!

Best Regards

Dirk_P

*This post is locked for comments

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans