Vanishing simple quotes using Import Utility

Post Reply
gunther.lachambre
Posts: 19
Joined: 17 Feb 2013, 15:52
Location: Rennes, Britany, France

Hi,

When I try to import string data from .xlsx files with Import Utility, all simple quotes (') disappear. I've not found the way to protect/escape them.
Does anyone have any idea about how to solve it ?

Thanks
Environment :
Protégé 3.5 | Essential Meta Model 6.1.1
Essential Viewer 6.1 | Essential Import Utility 1.7.2
Java 1.8.0_91 | Tomcat 8.0.28 | Server CentOS 7
Java 1.8.0_201 | Tomcat 8.5.38 | Desktop Windows 10
User avatar
jonathan.carter
Posts: 1087
Joined: 04 Feb 2009, 15:44

Hi,

Thanks for posting.

There are a number of invalid characters that we explicitly strip from the content before it is imported via the Import Utility.

Several of Microsoft Office’s “smart characters” are excluded because they use character codes that are not valid Unicode characters.

Are your missing characters examples of these, e.g. ` or are you seeing ‘valid’ characters such as ‘ being dropped? (I hope you can see the difference between my two single-quote examples!)

Jonathan
Essential Project Team
gunther.lachambre
Posts: 19
Joined: 17 Feb 2013, 15:52
Location: Rennes, Britany, France

Hi Jonathan,

Thanks for your reply.

Here are some test results of various simple quotes characters import :
  • import spreadsheet with strings containing ASCII characters #39 #96 #145 #146 and #180
  • import specifications according to spreadsheet content
  • viewer result screen capture
As shown, all simple quotes characters are well imported and published, except the one we usually use : #39

Has this one to be considered as an excluded "smart character" ?

Gunther
You do not have the required permissions to view the files attached to this post.
Environment :
Protégé 3.5 | Essential Meta Model 6.1.1
Essential Viewer 6.1 | Essential Import Utility 1.7.2
Java 1.8.0_91 | Tomcat 8.0.28 | Server CentOS 7
Java 1.8.0_201 | Tomcat 8.5.38 | Desktop Windows 10
jmk
Posts: 137
Joined: 31 May 2012, 12:08
Location: France

BTW, une tentative de traduction française pour le viewer :

https://sourcesup.renater.fr/plugins/sc ... e7;hb=HEAD

@+,

Jean-Marie
Post Reply