Hello Team,
We upgraded EasyMorph Desktop and Hub to 6.1 build 14 yesterday. Since then, the “Export to SharePoint list” action fails when exporting numeric values into SharePoint Number columns. The same project worked fine in 5.9.8 (last successful run on Oct 13).
Error (SharePoint site in French; the message means “Only numbers are accepted here”):
Error: 40 SharePoint batch operations failed.
- Field 'field_7': Seuls les nombres sont acceptés ici.
Field 'field_8': Seuls les nombres sont acceptés ici.
Field 'field_9': Seuls les nombres sont acceptés ici.
- (same for a 2nd row)
- Field 'field_15': Seuls les nombres sont acceptés ici. (x38)
Source: action "Export to SharePoint list", table "ProduitsFlashes"
What we observed:
- The rows reported as failed are actually created in SharePoint, with correct numeric values. For example, item x shows
field_15 = 5.5(Number), with all other fields filled in. Despite this, the action reports them as failed. - The export then stops. The 40 “failed” operations are exactly the first 2 batches of 20 rows. No further rows are sent (40 of 253 rows reach the list).
- The input data is clean. We checked every cell just before the export action: only numbers or empty cells, with no text and no error values. Integers (98, 70, 10) trigger the error as well as decimals (5.5, 1.55).
- The target columns are plain Number columns, with no validation formula and no min/max. In an earlier run, integer values in another Number column (e.g. 62754) were accepted, while the error appeared on other numeric columns.
- What we tried, without success: converting the values to text, replacing the decimal point with a comma, and “Convert data type” to number with either a comma or a dot as the decimal separator. Each time, a few rows are written and then the action stops.
As a workaround, we inserted the same 253 rows through the SharePoint REST API: all of them were accepted without error, including the numeric values. So SharePoint itself accepts the data.
Could you check how the 6.1 version handles the SharePoint batch responses for Number fields?
Thanks,
Christophe