Hi Anoop,
I have also experienced the issue you described. Is another kind of problem. You could solve it in two steps:
1. Add a javascript function to all html templates that use the upload applet. This function controls the file name before uploading it and, if finds any special character, alerts you and blocks the execution of the upload. I can suggest you this example:
function hasInvalidCharacters(sText) {
var ValidChars = "QWERTYUIOPASDFGHJKLZXCVBNMqwertyuiopasdfghjklzxcvbnm0123456789.-_ "
var hasInvalidChars = false;
var sChar;
var lastIndex;
lastIndex = sText.lastIndexOf('\\');
sText = sText.substring(lastIndex+1);
for (i = 0; i < sText.length && hasInvalidChars == false; i++) {
sChar = sText.charAt(i);
if (ValidChars.indexOf(sChar) == -1) {
hasInvalidChars = true;
//alert("Special Character: " + Char);
}
}
return hasInvalidChars;
}
function changedFile() {
if (!hasInvalidCharacters(document.documentForm.primaryFile.value)) {
if ( document.documentForm.primaryFile.value.length > 0 ) {
document.documentForm.rememberedFile.value = document.documentForm.primaryFile.value;
document.documentForm.File.value = document.documentForm.primaryFile.value;
}
document.documentForm.targetType.value = "FILE";
}
else {
alert("You can not use special characters for file naming. Please modify the name before saving the document.");
document.documentForm.primaryFile.value = document.documentForm.rememberedFile.value;
document.documentForm.rememberedFile.value = "";
return;
}
}
2. Make an update query directly on the database, in the APPLICATIONDATA table, to edit the field FILENAME and rename the file reference avoiding any special cheracter. For example:
update applicationdata d
set d.FILENAME = replace(d.FILENAME,'à','a')
where instr(d.FILENAME,'à') > 0;
update applicationdata d
set d.FILENAME = replace(replace(d.FILENAME,'%20',' '),'%','percent')
where instr(d.FILENAME,'%') > 0;
My problem is on the file content, not on the file name. After the upload, you can download it, but when you open the file is not readable.
Regards,
LAURA
