Author Topic: EA excel Importer error processing xml document  (Read 4582 times)

BCGoitcwoodard

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
EA excel Importer error processing xml document
« on: May 26, 2021, 02:33:04 am »
An invalid character was found in text content.

How do I attach a screenshot?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13379
  • Karma: +563/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: EA excel Importer error processing xml document
« Reply #1 on: May 26, 2021, 03:38:26 am »
you can link to a public image hosting site. You can't upload images here.

What excel importer are you using? If it's the one I developed you can send me an email directly and I'll have a look.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: EA excel Importer error processing xml document
« Reply #2 on: May 26, 2021, 04:07:29 am »
Which EA version? Which DB? Maybe a Jet4-upgrade might solve the issue.

q.

Richard Freggi

  • EA User
  • **
  • Posts: 489
  • Karma: +18/-7
    • View Profile
Re: EA excel Importer error processing xml document
« Reply #3 on: May 26, 2021, 01:59:21 pm »
You could use the Excel CLEAN function on the text to be imported to remove all extended ASCII including non-printing. 

Another thing that worked for me was to open the file with Notepad++ and run a Regex replace deleting all non-XMI compliant characters (or all extended ASCII characters): you can find some ideas here

https://stackoverflow.com/questions/397250/unicode-regex-invalid-xml-characters