Back to forum list… Back to Issues and Problems...

IMan 4.1 - Unable to map "Order Comments/Instructions"."Comments/Instructions" (2 replies)

Randy
5 years ago
Randy 5 years ago

When I attempt to map to the "Order Comments/Instructions"."Comments/Instructions" field I get the following error:

Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType)
at Realisable.Utils.Converter.ConvertTo[T](Object value)
at Realisable.JobDefinition.CustomConnectorTransformAdapter.IsValidAttribute(String attribName, Object value)
at Realisable.JobDefinition.CustomConnectorTransformAdapter.c__DisplayClass40_0.b__3(String attribName)
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.d__81`1.MoveNext()
at System.Linq.Enumerable.d__92`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Realisable.JobDefinition.CustomConnectorTransformAdapter.SetAttributesOntoField(TransformRecordField fldDef, Dictionary`2 attributesToSet)
at Realisable.JobDefinition.CustomConnectorTransformAdapter.GenerateRevisionList(TransformDefinition transformDefinition, DataTable fieldMap, TransformRecordDefinition recordDefinition)
at Realisable.IManWebUI.SystemConnectorTransform.SaveGridToTransform(FieldMappingGridState state)
at Realisable.IManWebUI.SystemConnectorTransform.FieldMappingGrid_BarButtonItemClicked(Object source, ButtonBarItemClickEventArgs e)

 

I'm including a screenshot of the FIELD MAPPING screen as an attachment.

Randy
5 years ago
Randy 5 years ago

I need a comment to attach a file.

https://www.realisable.co.uk/wp-content/uploads/2020/02/Screenshot-from-2020-02-06-12-33-44.png
Support
5 years ago
Support 5 years ago

Randy, we can see a potential improvement to handle the potential problem (but not sure how you arrived at the issue).

You can however get around the issue yourself if you edit the Integration Configuration.

Open the configuation, find the transform, and then find the RECORD node for the Comment level.

We believe you should see a 'logkey' attribute with an empty or non-numeric value. Simply remove that attribute.

(See attached screenshot)

 

https://www.realisable.co.uk/wp-content/uploads/2020/02/EmptyLogKey.png

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close