Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
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
Show:
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.