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:
Andres Lopez Andrade
June 25, 2020, 3:04 AM

Triaged by Andres Lopez

  1. Create a new project, set Line Level Phase

  2. Create phase

  3. Create phaseline

  4. Export CSV

The CSV file just export Master (Project) and Detail (Phase) records.

Not reproducible

Diego Ruiz
June 25, 2020, 7:32 AM

Hi ,

So, can we close this ticket as resolved?

Carlos Ruiz
June 25, 2020, 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.

Mitch Hicks
June 25, 2020, 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

Assignee

Unassigned

Reporter

Mitch Hicks

Labels

Tested By

None

Components

Affects versions

Priority

Minor
Configure