PJM Import template: Possible export?

SUGGESTED

Hello,

PJM project import template is now available in the new Sage X3 release 2022 R2. We noticed that the template uses temporary tables to import projects. The "export" check box has been ticked on the template, have anyone managed to export existing projects? The idea is to have a blue print of the flat file format that should be imported.

Parents
  • 0
    SUGGESTED

    This import template does not do exports, and the export check box is only for the generation of error files.

    For those who need an import file example, please find it below. 

    "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
    SUGGESTED

    This import template does not do exports, and the export check box is only for the generation of error files.

    For those who need an import file example, please find it below. 

    "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