Skip to main content
Question

Error "Failed to convert parameter value from a String to an Int32" in Import Scenario for Project of Construction

  • January 2, 2024
  • 5 replies
  • 297 views
vgonzalez
Freshman II

 

 

Good afternoon,

Happy New Year to everyone, I would like to ask for your help in creating an import scenario that is giving me an error.

I created the import scenario for construction projects with the necessary fields to upload, I need to import 180 projects, but when uploading the import it shows me an

I am going to attach the images of how I created the import scenario so that someone can guide me to correct the error, because I have reviewed, but I cannot identify the cause of this error.

I thank you in advance for the help and I hope you have a happy week.

 

 

5 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @vgonzalez 

Please share the XML file and excel sample file to review and assist here?

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
gorazem
Varsity I
Forum|alt.badge.img
  • gorazem
  • Varsity I
  • January 2, 2024

Without seeing the XML, is it possible on of your fields on the provider is marked as a String when it should be an Int?

Guy Orazem - Web Developer @ Wine Racks America - gorazem@wineracksamerica.com
Chris Hackett
Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • January 2, 2024

Hello,

Looking only at what you have shown us,

  1. I recommend skipping status and let the new project be added with Acumatica default status “In Planning”.
  2. You want to select Field/Action Name = Description  instead of Project ID for the second time, when mapping to Source Filed/Value Description.
  3. You want to select Field/Action Name = Project Manager  in Summary → Project Properties Target Object instead of Project ID for the third time, when mapping to Source Filed/Value Owner ID.
  4. It looks like a field called CITY is mapped to STATE in the address.  You will want to select State Source Field on the last visible line below.

Laura

~ Laura Barber, WM Synergy
Chris Hackett
vgonzalez
Freshman II
  • vgonzalez
  • Author
  • Freshman II
  • January 2, 2024

Hello, I am attaching the xml and an example of the Excel file that I want to upload.

Thanks in advance for the help.

3 Attachments
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • March 11, 2024

Hi @vgonzalez were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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