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

Hi @vgonzalez 

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

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?

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

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

Thanks in advance for the help.

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