x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 25 subscribers
  • Views 823 views
  • Users 0 members are here
Browse Forums
Annonces
100
topics
4
replies
Discussion Générale
247
topics
715
replies
Distribution
35
topics
98
replies
Finance
50
topics
135
replies
HR
10
topics
23
replies
Technique
225
topics
753
replies
Etienne Silvio

Affaire PJM Import : Export possible?

SUGGESTED
Posted By

Bonjour,

Le modèle d'import de projet PJM est désormais disponible dans la nouvelle version 2022 R2 de Sage X3.
Nous avons remarqué que le modèle utilise des tables temporaires pour importer des projets.
Sachant que la case "Export" a été coché sur le modèle, quelqu'un a-t-il réussi à exporter des projets existants ? L'idée est d'avoir un aperçu du format de fichier plat qui doit être importé.

Parents
  • 0

    Après quelques essais, voici l'exemple d'un tel fichier avec des taches, activités et affectations à importer :

    "P","C","","FR011","FR011","0501 ESI REGIE","Affaire 001","FR001","000000000000001","FR251","",1,"EUR","EUR",,31/10/19,01/12/22,803,0,0,"",1,"",1,2,1,1,1,"","",1
"PB","C","CB",0,"","FR011","Budget","Budget",0,"",1,"STD",""
"PBL","C",10,"ENGINEER","CB","HR",10,,267500,25/05/21,1, , , ,
"PB","C","CB2",0,"","FR011","Budget2","Budget2",0,"",1,"STD",""
"PBL","C",10,"ENGINEER","CB2","JR",100, ,45000000,25/05/21,1, , , ,
"PT","C","MIXED","PH",0,"","FR011","Phase","Phase",31/10/19,31/10/22,"780","",1,"CB",0,"R1",2,"STD",""
"PTP","C","ALUMSHEET","FR011","article service ALUMSHEET",1,"","",31/10/22,1,1,1,1,1,"","",""
"PTO","C",10,"DES001","",31/10/19,31/10/22,780,"SPH","HR",10,1,"STD"
"PTOA","C","ADMIN","SPH",31/10/19,00:00,31/10/22,00:00,10,9,""
"PT","C","MIXED","PH2",0,"","FR011","Phase2","Phase2",01/12/20,01/12/22,"523","",1,"CB2",0,"R1",1,"STD",""
"PTP","C","ALUMSHEET","FR011","article service ALUMSHEET",1,"","",31/10/22,1,1,1,1,1,"","",""
"PTO","C",10,"DES001","",31/10/19,31/10/22,780,"SPH","HR",10,1,"STD"
"PTOA","C","ADMIN","SPH",31/10/19,0000,31/10/22,0000,1, ,"HNF"

Reply
  • 0

    Après quelques essais, voici l'exemple d'un tel fichier avec des taches, activités et affectations à importer :

    "P","C","","FR011","FR011","0501 ESI REGIE","Affaire 001","FR001","000000000000001","FR251","",1,"EUR","EUR",,31/10/19,01/12/22,803,0,0,"",1,"",1,2,1,1,1,"","",1
"PB","C","CB",0,"","FR011","Budget","Budget",0,"",1,"STD",""
"PBL","C",10,"ENGINEER","CB","HR",10,,267500,25/05/21,1, , , ,
"PB","C","CB2",0,"","FR011","Budget2","Budget2",0,"",1,"STD",""
"PBL","C",10,"ENGINEER","CB2","JR",100, ,45000000,25/05/21,1, , , ,
"PT","C","MIXED","PH",0,"","FR011","Phase","Phase",31/10/19,31/10/22,"780","",1,"CB",0,"R1",2,"STD",""
"PTP","C","ALUMSHEET","FR011","article service ALUMSHEET",1,"","",31/10/22,1,1,1,1,1,"","",""
"PTO","C",10,"DES001","",31/10/19,31/10/22,780,"SPH","HR",10,1,"STD"
"PTOA","C","ADMIN","SPH",31/10/19,00:00,31/10/22,00:00,10,9,""
"PT","C","MIXED","PH2",0,"","FR011","Phase2","Phase2",01/12/20,01/12/22,"523","",1,"CB2",0,"R1",1,"STD",""
"PTP","C","ALUMSHEET","FR011","article service ALUMSHEET",1,"","",31/10/22,1,1,1,1,1,"","",""
"PTO","C",10,"DES001","",31/10/19,31/10/22,780,"SPH","HR",10,1,"STD"
"PTOA","C","ADMIN","SPH",31/10/19,0000,31/10/22,0000,1, ,"HNF"

Children
No Data

*Community Hub is the new name for Sage City