Using GRLOADER with XML files containing special/national characters like (it is only an example) accented 'a', the result is a partial load of the data.
The command used to upload the data is:
grloader -u <userid> -p <password> -s http://localhost:8080 -a -E -n -tf "C:\Program Files (x86)\CA\Service Desk Manager\bin\rules.xml" -i
The result is that only the items before the one having the accented letter have been inserted.
In grloader.log there are these error messages:
ERROR grReader 189 Invalid UTF-8 character detected during processing of input.xml
ERROR grReader 191 java.io.UTFDataFormatException: Invalid byte 2 of 3-byte UTF-8 sequence.
A wrong behavior having the same root cause can be noticed simply when trying to see the input.xml file via Internet Explorer: the file is partially
displayed and where the accented 'a' is found the following error message is noted:
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
An invalid character was found in text content. Error processing resource 'file:///C:/Folder1/Folder2/Folder3/input.XML
<name>Name containing accented a
The problem in both the cases is due to the encoding of the input.xml file not in UTF-8.
A workaround is the following:
Open the input.xml file with a notepad
- Click on File, Save As
- In the Encoding dropdown select 'UTF-8'
- Click on Save
The input.xml file saved with UTF-8 encoding can now be successfully used by GRLOADER with no loss of data and can be correctly opened by Internet Explorer
without error message.