Skip to main content
Answer

Getting a field not part of the view to show on a grid import

  • May 22, 2024
  • 3 replies
  • 49 views

Joe Schmucker
Captain II
Forum|alt.badge.img+3

I added import functionality to the Physical Inventory Types screen IN208900.

The override for the View for the grid is as follows:

  public class INPIClassMaint_Extension : PXGraphExtension<PX.Objects.IN.INPIClassMaint>
  {
  [PXImport(typeof(INPIClassLocation))]
  public
      PXSelectJoin<INPIClassLocation,
      LeftJoin<INLocation, On<INPIClassLocation.FK.Location>>,
      Where<INPIClassLocation.pIClassID, Equal<Current<INPIClass.pIClassID>>>>
      Locations;
  }

When you import the Excel file, the Pick Priority field is not available to map.  I assume that is because the field is not in the INPIClassLocation table.

Does anyone know of a trick to get that field added to the view?

 

 

Best answer by Naveen Boga

@Joe Schmucker Can you please try below. I  have not verified and hope it should work.

 

 public class INPIClassMaint_Extension : PXGraphExtension<PX.Objects.IN.INPIClassMaint>
  {
  [PXImport(typeof(INPIClass))]  // This should be always PRIMARY DAC
  public
      PXSelectJoin<INPIClassLocation,
      LeftJoin<INLocation, On<INPIClassLocation.FK.Location>>,
      Where<INPIClassLocation.pIClassID, Equal<Current<INPIClass.pIClassID>>>>
      Locations;
  }

 

Also, in .aspx make sure to add the AllowUpload = true for the Mode

 

 

3 replies

Joe Schmucker
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • May 22, 2024

Sorry about this question.  The Pick Priority is assigned on screen IN204000.  I was unaware of this.

@Chris Hackett, feel free to cancel this question.  I was not familiar with the screens involved when I was asked to add import functionality.  I should have done more homework.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • May 22, 2024

@Joe Schmucker Can you please try below. I  have not verified and hope it should work.

 

 public class INPIClassMaint_Extension : PXGraphExtension<PX.Objects.IN.INPIClassMaint>
  {
  [PXImport(typeof(INPIClass))]  // This should be always PRIMARY DAC
  public
      PXSelectJoin<INPIClassLocation,
      LeftJoin<INLocation, On<INPIClassLocation.FK.Location>>,
      Where<INPIClassLocation.pIClassID, Equal<Current<INPIClass.pIClassID>>>>
      Locations;
  }

 

Also, in .aspx make sure to add the AllowUpload = true for the Mode

 

 


Joe Schmucker
Captain II
Forum|alt.badge.img+3
  • Author
  • Captain II
  • May 22, 2024

Thank you for your guidance @Naveen Boga.  Since the Priority is managed on a different screen, we have decided to not try to do any changes to the Priority field on the import.