Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Template Report Plu...
 
Notifications
Clear all

Template Report Plugin

6 Posts
2 Users
0 Reactions
1,938 Views
(@service-automation)
Posts: 26
Active Member
Topic starter
 
[#7492]

Hi,

I have purchased the Template Plug in, but I would like to know  how I can access to the following data ?

What is the syntax in Excel, to retrieve eg : realwork ?
assignmentAssignationassignment.ididassignment.idProjectprojetassignment.nameProjectprojet (nom)assignment.refTypetype d'élémentassignment.refIdid de l'élémentassignment.idResourceressourceassignment.nameResourceressource (nom)assignment.uniqueResource[colUniqueResource]assignment.idRolefonctionassignment.nameRolefonction (nom)assignment.commentcommentairesassignment.assignedWorktravail assignéassignment.realWorktravail réelassignment.leftWorktravail restantassignment.plannedWorktravail réviséassignment.notPlannedWorktravail non planifiéassignment.ratetaux (%)assignment.realStartDatedate de début réelleassignment.realEndDatedate de fin réelleassignment.plannedStartDatedate de début planifiée
Many thnaks,
Fred
 


 
Posted : 15 Apr 2021 16H23
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Could you please explain ?
You want a template for which object ?
Single value on list of assignment values ?

For instance for total real on Activity, use [activityplanningelement.realWork]


 
Posted : 15 Apr 2021 20H04
(@service-automation)
Posts: 26
Active Member
Topic starter
 

HI,

I try to create a template to extract real work for activty.

But in my final template, I would like to extract the real work from time sheet each end of month, in order to import the time sheet in our ERP.

I think my syntax is not correct in Excel Cell to retreive data . 

Many thanks for your help,

Regards

Fred
 


 
Posted : 16 Apr 2021 9H42
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Syntax is not 

[object.activityplanningelement.realwork]

but

[activityplanningelement.realWork]
(pay attention to the case)

 
Posted : 19 Apr 2021 11H07
(@service-automation)
Posts: 26
Active Member
Topic starter
 

Many thanks Babynus for your answer, and help,

But something still wrong in my template report.

Le link to [activityplanningelement.realWork] is interpreted as string ....

I have attached a print screen of result, and the template file...I don't know what is wrong.

Regards,

Fred

 


 
Posted : 19 Apr 2021 18H59
(@service-automation)
Posts: 26
Active Member
Topic starter
 

Hi,

No answer ?

I respect the syntax, but the [activityplanningelement.realWork] still interpreted as string ?

I don't undestrand why I have this behaviour !

 


 
Posted : 29 Apr 2021 12H12
Share:

Scroll to Top