Home › Forums › Data Migration › DM Issue when using CSV files

Tagged: 

Viewing 3 reply threads
  • Author
    Posts
    • November 28, 2019 at 11:46 am #12393
      Henry ZaccakZaccak Solutions
      Participant

      Using Finance 9.2.2.0 and Dataimport 0.0.1.0 2

      Whenever loading a CSV using the DMFileChannel, CSV files always fail with a missing batchId. I’ve ensured that a batchId is always included but there is always a failure.

      Here is the error from the DMReport:

      “nexj.core.runtime.ValidationException: Invalid DM User (err.validation.invalidInstance) – { batchId: nexj.core.runtime.ValidationException: The batch id of DM User must be specified. (err.validation.requiredAttribute) – } ”

      The report is missing the batchId but it is included in the actual CSV file.

      0
    • November 28, 2019 at 12:01 pm #12403
      ddonciuddonciu
      Participant

      Could you please attach here the CSV file you used? Thank you.

      0
    • December 4, 2019 at 12:10 pm #12416
      Jonathan Cheungjonathan.cheung
      Participant

      @Henry, when you have a chance can you post resolution you had for this issue? thanks!

      0
    • December 4, 2019 at 12:21 pm #12426
      Henry ZaccakZaccak Solutions
      Participant

      Daniel had found that the CSV file we were using was in UTF-8 with BOM format. The file needs to be in UTF-8 without BOM format. It worked once we made the change. Thanks!

      0
  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.