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.

  • 0

    Hi Etienne,

    I have checked and this is for imports only.  The details in the release notes are described as 

    Import a project

    A new project import template is now available from the Import/export templates function (GESAOE). Use the OPPORPJMI - Project management template to create or update one or more projects from a single import file. All elements of the project can be imported including budgets, budget lines, tasks, task products, task operations, and operation assignments.

    I did also then check the standard code OPPORPJMI and that does not have an entry for EXPORT.

    Regards

    David

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