Project window CSV import does not honor C_Project.ProjectLineLevel to expose C_ProjectLine>C_ProjectPhase_ID[Name] causing a import fail.
Description
iDempiere Version : 6.2.0.201909031251 test.idemmpiere.org 9/4/2019 Operating System (OS and version): Linux 4.15.0-58-generic unknown Database (engine and version): unknown Java version: OpenJDK 64-Bit Server VM 11.0.4+11-post-Ubuntu-1ubuntu218.04.3
Last migration script applied: Unknown What steps will reproduce the problem? 1. Create a CSV file to import Project and Project Phase with Phaselines 2. AD_Org_ID[Name],Value/KT,Name,Description,IsActive,IsSummary,Note,ProjectLineLevel,C_Phase_ID[Name],DateContract,DateFinish,C_BPartner_ID[Value],C_BPartnerSR_ID[Value],C_BPartner_Location_ID[Name],AD_User_ID[Name],C_PaymentTerm_ID[Value],POReference,M_Warehouse_ID[Value],C_Campaign_ID[Value],M_PriceList_Version_ID[Name],C_Currency_ID,PlannedAmt,PlannedQty,PlannedMarginAmt,C_ProjectPhase>C_Project_ID[Value]/KT,C_ProjectPhase>SeqNo,C_ProjectPhase>Name,C_ProjectPhase>Description,C_ProjectLine>C_ProjectPhase_ID[Name]/K,C_ProjectLine>Line,C_ProjectLine>Description,C_ProjectLine>M_Product_ID[Value],C_ProjectLine>M_Product_Category_ID[Value],C_ProjectLine>PlannedPrice,C_ProjectLine>PlannedQty,C_ProjectLine>PlannedAmt 2. Select Import from Project window 3.
What is the expected result? Create Project, Phase, and Phase lines Data was checked using import project then going to the phaselines and importing phaselines this worked but it is two imports.
What happens instead? Error “C_ProjectLine>C_ProjectPhase_ID[Name]/K is not displayed” With or with out the /K it would seem that the import is not checking C_Project.ProjectLineLevel value to expose C_ProjectLine>C_ProjectPhase_ID[Name] Not tested but I would guess the same error will happen for project line level task.
Environment
6.2.0.201909031251 test.idemmpiere.org 9/4/2019
Activity
Mitch Hicks
June 25, 2020 at 8:38 PM
Andres Lopez Andrade, Thank you for taking the time to look into this issue for me.
This issue is when you try to IMPORT. The Export works.. but trying to create new records(alter the exported file to try to create a new project/phase.. the import expects a TASK.. and fails to import Phases
Carlos Ruiz
June 25, 2020 at 2:27 PM
Reading the comment on GridTabCSVExporter.isExportableTab > just export display tab, one level deep, not read only and not account tab
I think this is by design.
Diego Ruiz
June 25, 2020 at 7:32 AM
Hi @Andres Lopez Andrade,
So, can we close this ticket as resolved?
Andres Lopez Andrade
June 25, 2020 at 3:04 AM
Triaged by Andres Lopez
Create a new project, set Line Level Phase
Create phase
Create phaseline
Export CSV
The CSV file just export Master (Project) and Detail (Phase) records.
iDempiere Version :
6.2.0.201909031251 test.idemmpiere.org 9/4/2019
Operating System (OS and version):
Linux 4.15.0-58-generic unknown
Database (engine and version):
unknown
Java version:
OpenJDK 64-Bit Server VM 11.0.4+11-post-Ubuntu-1ubuntu218.04.3
Last migration script applied:
Unknown
What steps will reproduce the problem?
1. Create a CSV file to import Project and Project Phase with Phaselines
2. AD_Org_ID[Name],Value/KT,Name,Description,IsActive,IsSummary,Note,ProjectLineLevel,C_Phase_ID[Name],DateContract,DateFinish,C_BPartner_ID[Value],C_BPartnerSR_ID[Value],C_BPartner_Location_ID[Name],AD_User_ID[Name],C_PaymentTerm_ID[Value],POReference,M_Warehouse_ID[Value],C_Campaign_ID[Value],M_PriceList_Version_ID[Name],C_Currency_ID,PlannedAmt,PlannedQty,PlannedMarginAmt,C_ProjectPhase>C_Project_ID[Value]/KT,C_ProjectPhase>SeqNo,C_ProjectPhase>Name,C_ProjectPhase>Description,C_ProjectLine>C_ProjectPhase_ID[Name]/K,C_ProjectLine>Line,C_ProjectLine>Description,C_ProjectLine>M_Product_ID[Value],C_ProjectLine>M_Product_Category_ID[Value],C_ProjectLine>PlannedPrice,C_ProjectLine>PlannedQty,C_ProjectLine>PlannedAmt
2. Select Import from Project window
3.
What is the expected result?
Create Project, Phase, and Phase lines
Data was checked using import project then going to the phaselines and importing phaselines this worked but it is two imports.
What happens instead?
Error “C_ProjectLine>C_ProjectPhase_ID[Name]/K is not displayed”
With or with out the /K
it would seem that the import is not checking
C_Project.ProjectLineLevel value to expose C_ProjectLine>C_ProjectPhase_ID[Name]
Not tested but I would guess the same error will happen for project line level task.