View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Template Report Plugin - ProjeQtOr
 
 

Template Report Plugin

More
15 Apr 2021 14:23 #1 by service.automation
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
 

Please Log in or Create an account to join the conversation.

More
15 Apr 2021 18:04 #2 by babynus
Replied by babynus on topic Template Report Plugin
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]

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
16 Apr 2021 07:42 #3 by service.automation
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
 
Attachments:

Please Log in or Create an account to join the conversation.

More
19 Apr 2021 09:07 - 19 Apr 2021 09:11 #4 by babynus
Replied by babynus on topic Template Report Plugin
Syntax is not 
[object.activityplanningelement.realwork]
but
[activityplanningelement.realWork]
(pay attention to the case)

Babynus
Administrator of ProjeQtOr web site
Last edit: 19 Apr 2021 09:11 by babynus.

Please Log in or Create an account to join the conversation.

More
19 Apr 2021 16:59 - 19 Apr 2021 17:03 #5 by service.automation
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

 
Attachments:
Last edit: 19 Apr 2021 17:03 by service.automation.

Please Log in or Create an account to join the conversation.

More
29 Apr 2021 10:12 #6 by service.automation
Hi,

No answer ?

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

I don't undestrand why I have this behaviour !

 
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.064 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.