Skip to main content
Question

'Load Records from File' on Document Templates screen is missing properties

P
Freshman I
Forum|alt.badge.img
  • phat
  • Freshman I
  • 14 replies

I have created 'Load Records from File' on Document Templates screen.

 

 

However, when I Import, the 'TemplateId' attribute is missing in Property Name

In the AUTemplateData table, there is the attribute 'TemplateId'

 


Here is my code

   [PXImport(typeof(AUTemplateData))]
   public PXSelectJoin<AUTemplateData,
          InnerJoin<AUTemplate, On<AUTemplate.templateID, Equal<AUTemplateData.templateId>>>,
              Where<AUTemplateData.templateId,Equal<Current<AUTemplate.templateID>>>> Items;

How can i fix it ? Can someone please help me.

3 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+7
  • hkabiri
  • Acumatica Support Team
  • 226 replies
  • October 5, 2023

@phat In Acumatica Only those fields which are by default on Selected Columns, file uploader mapping is available. For those which are on Available Columns, this is not working.

Column Configuration Document Template

That field, TemplateId should be automatically set by system when the lines are added. Do you have any problem with your Uploader if you ignore mapping TemplateId?

SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Chris Hackett
P
2 people like this
  • Chris Hackett
    Chris Hackett
  • P
    phat
P
Freshman I
Forum|alt.badge.img
  • phat
  • Author
  • Freshman I
  • 14 replies
  • October 6, 2023
hkabiri wrote:

@phatIn Acumatica Only those fields which are by default on Selected Columns, file uploader mapping is available. For those which are on Available Columns, this is not working.

Column Configuration Document Template

That field, TemplateId should be automatically set by system when the lines are added. Do you have any problem with your Uploader if you ignore mapping TemplateId?



Hi @hkabiri 

When I import without TeplateId, I cannot save the data I just imported.
 

 

P
Freshman I
Forum|alt.badge.img
  • phat
  • Author
  • Freshman I
  • 14 replies
  • October 6, 2023
phat wrote:
hkabiri wrote:

@phatIn Acumatica Only those fields which are by default on Selected Columns, file uploader mapping is available. For those which are on Available Columns, this is not working.

Column Configuration Document Template

That field, TemplateId should be automatically set by system when the lines are added. Do you have any problem with your Uploader if you ignore mapping TemplateId?



Hi @hkabiri 

When I import without TeplateId, I cannot save the data I just imported.
 

 

 

In addition, I discovered that in Selected Columns there is no OrderID. 
 

 

 

 

 

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved