Skip to main content
Solved

Insert 'Load Records from File' on Release Production Orders screen

  • January 31, 2022
  • 4 replies
  • 391 views

Forum|alt.badge.img

Hi there,

 

I have a requirement to read the Production Order Nbr. from Excel file and update the Select checkbox accordingly.

 

I tried adding a ‘Load Records from File’ function to Release Production Orders screen by setting the ‘Allow Upload’ in Customization Project Editor to true and extended the graph by adding the PXImport as shown below:

public class ReleaseOrd_Extension : PXGraphExtension<ReleaseOrd>
  { 
        public PXCancel<AMBatch> Cancel;
        [PXImport]
        [PXFilterable]
        public PXProcessing<AMProdItem,
            Where<AMProdItem.statusID, Equal<ProductionOrderStatus.planned>,
                And<AMProdItem.hold, Equal<False>,
                And<Where<AMProdItem.function, Equal<OrderTypeFunction.regular>,
                    Or<AMProdItem.function, Equal<OrderTypeFunction.disassemble>>>>>>> PlannedOrds;

        public PXSetup<AMPSetup> ampsetup;
  }

 

However when I tried to upload the Excel, the system didn’t manage to read other columns related to Production Orders as shown below:

 

I have tried using both

[PXImport(typeof(AMProdItem))]

//////////and//////////////

[PXImport(typeof(AMBatch))]

but the result remains unchanged. Am I doing it wrong?

Best answer by denisperez28

Hi @ericklasimin61,

I believe I've found a solution to the Excel import issue you're experiencing.

To successfully import Excel files into Acumatica, please follow these steps:

  1. Add the [PXImport] tag: Place the [PXImport] tag at the top of the view associated with your grid.
  2. Enable file uploads: Set the AllowUpload property to true on the ASPX page.
  3. Address missing fields:
    • Enable DAC fields corresponding to the grid's primary keys by setting the Enable property to True.
    • In case that you want to disable this field in the grid, you can block them within a rowSelected event in the graph.

I've tested these steps in my local environment, and they successfully resolved the Excel import issue.

View original
Did this topic help you find an answer to your question?

4 replies

  • Freshman I
  • 1 reply
  • March 17, 2022

Did you get an answer to this question? if so, could you please post the solution. I am also getting into the same issue.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 48 replies
  • April 8, 2022

Hi @rvontela71 , unfortunately no answer to this question as well. Hopefully there are people out there who can resolve this issue and reply to this post.


Any update on this please? 


  • Freshman II
  • 1 reply
  • Answer
  • August 6, 2024

Hi @ericklasimin61,

I believe I've found a solution to the Excel import issue you're experiencing.

To successfully import Excel files into Acumatica, please follow these steps:

  1. Add the [PXImport] tag: Place the [PXImport] tag at the top of the view associated with your grid.
  2. Enable file uploads: Set the AllowUpload property to true on the ASPX page.
  3. Address missing fields:
    • Enable DAC fields corresponding to the grid's primary keys by setting the Enable property to True.
    • In case that you want to disable this field in the grid, you can block them within a rowSelected event in the graph.

I've tested these steps in my local environment, and they successfully resolved the Excel import issue.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings