đź“„ Export Tableau de bord - Actions

Export Tableau de bord - Actions


Le wadSetting  : EXPORT_ACTIONS_DASHBOARD

Le full export - le schéma complet

Colones particulières (tout idem que pour l’export des actions depuis jobs) 

Action_full_name : sera le concaténation de l'action parent et enfant avec un sépérateur alphanum personalisable. “>” par défaut

​“Tonte > Pelouse”

Action_full_name_w_grid : idem mais on rajoute en première position le nom de la grille d’action

​“Entretien > Tonte > Pelouse”

Action_ref : C’est la référence de l’action du plus bas-niveau. Niveau Action si pas de Sous-action et niveau Sous-action si existante

Action_count : Si exportation avec regroupement = le nombre d’actions


Full schéma

{
	"Row_num": "Row_num",
        "Work_date" : "Work_date",
	"ActionCategory_name": "Action_grid_name",
	"Action_ref": "Action_reference",
	"Action_ref_parent": "Action_reference_1",
	"Action_ref_child": "Action_reference_2",
	"Action_parent_name": "Action_name_1",
	"Action_child_name": "Action_name_2",
	"Action_full_name": "Action_full_name",
	"Action_full_name_w_grid": "Action_full_name_wgrid",
	"Action_count" : "Action_count",
	"WorkUserLog_action_time": "Action_work_time",
	"WorkLog_quantity": "Action_quantity",
	"Action_quantity_unit": "Action_quantity_unit",
	"Work_id" : "Work_id",
	"Project_ref": "Project_ref",
	"Project_ref_external": "Project_ref_ext",
	"Project_id": "Project_id",
	"Project_name": "Project_name",
	"Project_leader": "Project_leader",
	"Project_workforce_estimated": "Project_wf_estimated",
	"Project_planning": "Project_planning",
	"Customer_ref": "Customer_ref",
	"Customer_ref_external": "Customer_ref_ext",
	"Customer_name": "Customer_name",
	"Customer_name_alias": "Customer_name_alias",
	"Pow_name": "Pow_name",
	"Pow_zip": "Pow_zip",
	"Pow_city": "Pow_city",
	"Pow_country": "Pow_country",
	"Pow_street": "Pow_street",
	"Pow_address_extra": "Pow_address_extra",
	"Pow_geo": "Pow_Geo"
}


Par defaut ou si Wadsetting n'existe pas

{
   "Row_num" : "#",
   "Work_date" : "Action date",
   "ActionCategory_name" : "Grille d'action"
   "Action_ref" : "Action Ref"
   "Action_parent_name" : "Action",
   "Action_child_name" : "Sous-action",
   "Action_full_name" : "Actions",
   "Action_full_name_w_grid" : "Grille et actions"
   "WorkUserLog_action_time" : "Temps",
   "WorkLog_quantity" : "Quantité",
   "Action_quantity_unit" : "Unité quantité"
   "Work_id" : "Job num",
   "Project_ref_external" : "Projet Ref",
   "Project_name" : "Projet Nom", 
   "Project_leader" : "Project_leader",
   "Customer_ref_external" : "Client Ref",
   "Customer_name" : "Client Nom", 
   "Customer_name_alias" : "Client Surnom", 
   "Pow_name" : "Pow Nom", 
   "Pow_zip" : "Pow CP", 
   "Pow_city" : "Pow Ville"
}


{
   "Row_num" : "#",
   "Work_date" : "Action date",
   "Work_id" : "Job num",
   "Customer_name" : "Client Nom",
   "Pow_name" : "Pow Nom",
   "Pow_city" : "Pow Ville",
   "Project_name" : "Projet Nom",
   "ActionCategory_name": "Grille d'action",
   "Action_full_name" : "Action",
   "WorkUserLog_action_time" : "Temps",
   "WorkLog_quantity" : "QuantitĂ©",
   "Action_quantity_unit" : "UnitĂ© quantitĂ©",
   "Action_count" : "Nombre de fois"
}