J
Joy
a problem bothers us for a long time
we usually save MS project as csv file using import map / export map.
then the csv file is sent to the server to process.
sometimes, corrupted characters are generated especially with very large MS
Project files (>2000 tasks). the file is not corrupted, and it only has one
or two bad characters in it which causes errors when parsing the csv on the
server side.
the bad characters are really random. sometimes in the Name filed, sometimes
in Start/Finish fields, and only 1 filed in the middle got corrupted each
time.
we cannot replicate the case.
my question is what the possible causes for the corrupted characters?
1. is it possible that the map in MS project has some bug?
2. we also suspect that it is the software (client/server system) some users
to store their MS project file that creates the problem. however, some users
told us that they never use such software.
3. we also ask them whether they use non-English language, and some of them
never use non-English language.
is there any advice on how to avoid or at least reduce bad characters?
we do have a checker to check a few columns, but that cant catch all
columns..
to check each field before save as a csv file and then send to the server
seems time -consuming, cos we have > 20 columns in the MS Project file that
needs to be sent to the server side to get processed.
thank you!
we usually save MS project as csv file using import map / export map.
then the csv file is sent to the server to process.
sometimes, corrupted characters are generated especially with very large MS
Project files (>2000 tasks). the file is not corrupted, and it only has one
or two bad characters in it which causes errors when parsing the csv on the
server side.
the bad characters are really random. sometimes in the Name filed, sometimes
in Start/Finish fields, and only 1 filed in the middle got corrupted each
time.
we cannot replicate the case.
my question is what the possible causes for the corrupted characters?
1. is it possible that the map in MS project has some bug?
2. we also suspect that it is the software (client/server system) some users
to store their MS project file that creates the problem. however, some users
told us that they never use such software.
3. we also ask them whether they use non-English language, and some of them
never use non-English language.
is there any advice on how to avoid or at least reduce bad characters?
we do have a checker to check a few columns, but that cant catch all
columns..
to check each field before save as a csv file and then send to the server
seems time -consuming, cos we have > 20 columns in the MS Project file that
needs to be sent to the server side to get processed.
thank you!