Part of data in text file attachment get lost when saving to serve

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a few tab delimited text files that I receive as attachments in
Outlook 2003. The files contain rows of records with several columns.
Several of the columns contain date/time values in a mm/dd/yyyy hh:mm:ss
format (example: 05/25/2007 01:22:33). For some odd reason when I save the
attachment/s to a folder on our server (Windows 2000) the ":ss" (seconds
portion) of ALLTHE VALUES in these date/time columns gets lost somehow and is
not saved. In other words, using the value from the example above, the value
is saved as "05/25/2007 01:22" with the seconds missing. However when I save
the attachment locally on the workstation (Windows XP), it is saved
correctly. Any ideas? THX.
 
ricmart said:
I have a few tab delimited text files that I receive as attachments in
Outlook 2003. The files contain rows of records with several columns.
Several of the columns contain date/time values in a mm/dd/yyyy
hh:mm:ss format (example: 05/25/2007 01:22:33). For some odd reason
when I save the attachment/s to a folder on our server (Windows 2000)
the ":ss" (seconds portion) of ALLTHE VALUES in these date/time
columns gets lost somehow and is not saved. In other words, using
the value from the example above, the value is saved as "05/25/2007
01:22" with the seconds missing. However when I save the attachment
locally on the workstation (Windows XP), it is saved correctly. Any
ideas? THX.

Out of curiousity, what are you reading the file in once you save it?
 
After saving the attachment(text file) to the server, when I open it up in
Notepad, the portion of the data goes missing (as mentioned). I was
originally importing the text files into Excel after saving them. I thought
maybe something was happening in the import process. I was blaming Excel for
the problem. But after opening the file in Notepad I noticed the data was
already missing. The weird thing is that when I have the email containing
the attachment open and I click on the attachment itself to open it (it opens
in Notepad), when I view the data, all of the data is there, no missing data.
It goes missing once I save it to the server.

rm
 
ricmart said:
After saving the attachment(text file) to the server, when I open it
up in Notepad, the portion of the data goes missing (as mentioned).
I was originally importing the text files into Excel after saving
them. I thought maybe something was happening in the import process.
I was blaming Excel for the problem. But after opening the file in
Notepad I noticed the data was already missing. The weird thing is
that when I have the email containing the attachment open and I click
on the attachment itself to open it (it opens in Notepad), when I
view the data, all of the data is there, no missing data. It goes
missing once I save it to the server.

Ok, I don't buy it. Outlook doesn't care about the data inside the file,
and based on what you're saying, the Time field is located in more places
then just the end of the line, which leads me to think that there's either
an Add-on doing something weird in Outlook or something weird with the
server.

Does anyone else on your network see the same result if they save the file?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top