Import error: Type mismatch DELMETHOD field should be integer

Sage 300 2020 PU5

Importing AR customer records to change the delivery method.

Import screen displays the field and when I select value I get only a selection box with the 4 available values. When I select a value, it appears in the field list as the value text eg "mail", but when I run the import I get the error  "Type mismatch DELMETHOD field should be integer"

Does anyone have a workaround other than editing the text of the import file to enter the value as an integer then import that ?

I am seeing more and more of this type of error. The later the Sage revision, the more places I find it.

Is this just bad programming and worse quality control at Sage?

Parents
  • One of the things I've noticed about importing using Excel is that the first row of the import file determines the data type that Sage is expecting. So if you have a numeric value in a field and later on in the same column you have alpha field values, sometimes the import will complain about the data type and stop even though the alpha values are perfectly legitimate values.

    So, in your case, do you have a DELMETHOD field in your import file and what is the value in the first record even though you are trying to override the contents of the file's value?

  • in reply to Django

    The file is single .csv. If I import it without opening it or changing any contents, or changing any values in the import interface, the import works, but of course doesn't change anything.

    If I use the Sage-supplied user interface to change DELMETHOD, the only option it offers is to select a text in a dropdown box. After being selected, the field value displayed in the import screen shows as a text, although the Field Type beside it still says "Integer". So it appears the import program is incorrectly trying to import a text, not an integer.

    However, if I edit the export file in Excel to change DELMETHOD on every customer to the same (eg 2) , make no other changes then save as a .csv file, when I try to import, I get a different error, which is even more irrelevant:

    Error: “Value 4 for Customers and Customer Groups does not exist for optional field CATEGORY.”

    I havent touched the optional fields in the import file.

    The import file contains 3 header rows, all being texts. The label DELMETHOD is in the first row. In the DELMETHOD column, the 2nd and 3rd header rows are empty, as are the fields corresponding to them. All the DELMETHOD field values are integers (0, 2, 4 or 5)

Reply
  • in reply to Django

    The file is single .csv. If I import it without opening it or changing any contents, or changing any values in the import interface, the import works, but of course doesn't change anything.

    If I use the Sage-supplied user interface to change DELMETHOD, the only option it offers is to select a text in a dropdown box. After being selected, the field value displayed in the import screen shows as a text, although the Field Type beside it still says "Integer". So it appears the import program is incorrectly trying to import a text, not an integer.

    However, if I edit the export file in Excel to change DELMETHOD on every customer to the same (eg 2) , make no other changes then save as a .csv file, when I try to import, I get a different error, which is even more irrelevant:

    Error: “Value 4 for Customers and Customer Groups does not exist for optional field CATEGORY.”

    I havent touched the optional fields in the import file.

    The import file contains 3 header rows, all being texts. The label DELMETHOD is in the first row. In the DELMETHOD column, the 2nd and 3rd header rows are empty, as are the fields corresponding to them. All the DELMETHOD field values are integers (0, 2, 4 or 5)

Children
No Data