Solved

Import From SQL to the Labor Screen AM301000

  • 24 February 2022
  • 6 replies
  • 89 views
cmoreland
Rank
Userlevel 4
Badge

All - I have an Import Scenario created the goal is to import time from a SQL table to the Labor Screen and create the labor batch. 

See Scenario

 

The data comes in with out issue when I prepare it however the import is giving me the following error.  

 

Any help is greatly appreciated. 

icon

Best answer by Naveen Boga 25 February 2022, 05:53

View original
It does not matter what you bear, but how you bear it. ~Seneca

6 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

@cmoreland  Please share the XML format of the import scenario file.

Naveen B
cmoreland
Rank
Userlevel 4
Badge

@Naveen B  - here you go and thanks in advance for your help. 

1 Attachment
It does not matter what you bear, but how you bear it. ~Seneca
cmoreland
Rank
Userlevel 4
Badge

I did try recreating this as a csv import with the same error. 

1 Attachment
It does not matter what you bear, but how you bear it. ~Seneca
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @cmoreland  I was updated in another post. Just posting the same here.

 

I have tried with the Excel Data Provider and modified your mappings and it is working for me. You can check the same for the SQL provider for the same mapping.

 

Hope this helps!

Naveen B
cmoreland
Rank
Userlevel 4
Badge

@Naveen B thanks so much for your help

It does not matter what you bear, but how you bear it. ~Seneca
Naveen Boga
Rank
Userlevel 7
Badge +17

Most Welcome @cmoreland  I'm glad I was able to help you on this

Naveen B

Reply


Terms & ConditionsCookie 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