[sllug-members]: File Upload / Character Set Issues

[Eric Huber]

I have been researching this one for a couple of days now with out much 
success.  Here's the scenario...

At work we use Siebel OnDemand for CRM and it is the source of the 
information that I'm am retrieving to do some analysis of data.  We 
don't have direct interface capability right now, so I've built an 
export report in Siebel that users can run to dump data into a text file 
(tab-delimited).  Then I wrote a Perl CGI script that uses a multi-part 
form to upload the file (using CGI.pm).  Here's the issue:  The file 
looks okay in Windows (using notepad), but once it gets uploaded to the 
linux server with the script, it's all messed up (every other byte is a 
garbage character).  I can open the text file on my windows box with 
UltraEdit and turn on the Hex editor and see the extra bytes between all 
the characters (even though I don't see them using standard editing).  
Also, using UltraEdit, I ran a Unicode-to-ASCII conversion before I 
uploaded it using the form in the script, and everything works great, 
but I'd rather not create an extra step for users, if there is a way to 
upload and convert on the linux server with my script somehow.

Any ideas?

-- 
Eric Huber - eric at hubernet.com
Moonlight Design, LLC - Web Development and Hosting
(801) 299-0851    FAX: (801) 683-7300