CODEWITHSUNDEEP
acumatica
EricP.
EricP.

Reputation: 489

Using Load Records from File on Custom Table

I want to set up the Load Records from File button on a custom table grid that I added to the ProjectEntry_Extension BLC. I have the view set up with PXImport:

[PXImport(typeof(CFPMItemReq))]
public PXSelect<CFPMItemReq, Where<CFPMItemReq.projectID, 
   Equal<Current<PMProject.contractID>>>> ItemReqs;

I set the grid Mode -> Allow Update = true. I added IItemPlanMaster to the DAC of CFPMItemReq:

[Serializable]
public class CFPMItemReq : IBqlTable, IItemPlanMaster
{
    ....
}

However, when I go to upload the file, nothing happens. The button opens the file browser, I select the file, click upload, and the window just closes and nothing happens. I double checked and the excel file is formatted properly with the IDs of the columns in the first row. I'm not sure what I'm missing to get this working.

Upvotes: 0

Views: 841

Answers (1)

Brendan
Brendan

Reputation: 5623

If using PXImport on a view in your extension which is based on ProjectEntry, you will need to use the primary DAC of that graph which should be PMProject like this...

[PXImport(typeof(PMProject))]
public PXSelect<CFPMItemReq, Where<CFPMItemReq.projectID, 
   Equal<Current<PMProject.contractID>>>> ItemReqs;

Here are similar questions:

Nothing happen after click upload excel

Adding “AllowUpload” to the landed code tab in the Bill and adjustment screen

Upvotes: 1

Related Questions