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
Vanishing simple quotes using Import Utility
-
- Posts: 19
- Joined: 17 Feb 2013, 15:52
- Location: Rennes, Britany, France
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
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
- 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
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
-
- 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 :
Has this one to be considered as an excluded "smart character" ?
Gunther
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
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
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
BTW, une tentative de traduction française pour le viewer :
https://sourcesup.renater.fr/plugins/sc ... e7;hb=HEAD
@+,
Jean-Marie
https://sourcesup.renater.fr/plugins/sc ... e7;hb=HEAD
@+,
Jean-Marie