Microsoft Excel Files in WSS

I have an Excel file that has fields that are linked directly to the
properties of the file and have matching properties in my library. If I go
the the web page for the doc lib I can upload the document and it asks me
for the properties that I have setup. I do not fill them out thinking that
it will come in from my file. It does not. If I go through windows
explorer and copy the file to the appropriate doc lib the properties show
up. Why is this? Is there a way that I can get the properties to come
accross by uploading the document from the web page? I don't think I want
my users copy the files through windows explorer do I? Any help or
suggestions would be greatly appreciated.

Thanks

Tim Duell

Mike
Thu Nov 04 08:18:55 CST 2004

I think it's a "feature". It assumes if you have created additional fields
(which I presume they are) in the document library that you will be using
the values specified in the update form.

You could try updating (even a single file) using the multiple uploads
function. *That* seems to ignore the contents of the fields in the upload
form. (Which might have the same effect as using windows explorer to do it).

Let us know?

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please reply to the newsgroup

"Tim Duell" <someone@microsoft.com> wrote in message
news:eGqmG9lwEHA.1392@tk2msftngp13.phx.gbl...
>I have an Excel file that has fields that are linked directly to the
> properties of the file and have matching properties in my library. If I
> go
> the the web page for the doc lib I can upload the document and it asks me
> for the properties that I have setup. I do not fill them out thinking
> that
> it will come in from my file. It does not. If I go through windows
> explorer and copy the file to the appropriate doc lib the properties show
> up. Why is this? Is there a way that I can get the properties to come
> accross by uploading the document from the web page? I don't think I want
> my users copy the files through windows explorer do I? Any help or
> suggestions would be greatly appreciated.
>
> Thanks
>
> Tim Duell
>
>

Tim
Thu Nov 04 09:58:11 CST 2004

That worked exactly as you said. Thanks for the help.

Tim Duell

"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:ONrHiGowEHA.908@TK2MSFTNGP11.phx.gbl...
> I think it's a "feature". It assumes if you have created additional fields
> (which I presume they are) in the document library that you will be using
> the values specified in the update form.
>
> You could try updating (even a single file) using the multiple uploads
> function. *That* seems to ignore the contents of the fields in the upload
> form. (Which might have the same effect as using windows explorer to do
it).
>
> Let us know?
>
> Mike Walsh, Helsinki, Finland
> WSS FAQ at http://wss.collutions.com
> Please reply to the newsgroup
>
> "Tim Duell" <someone@microsoft.com> wrote in message
> news:eGqmG9lwEHA.1392@tk2msftngp13.phx.gbl...
> >I have an Excel file that has fields that are linked directly to the
> > properties of the file and have matching properties in my library. If I
> > go
> > the the web page for the doc lib I can upload the document and it asks
me
> > for the properties that I have setup. I do not fill them out thinking
> > that
> > it will come in from my file. It does not. If I go through windows
> > explorer and copy the file to the appropriate doc lib the properties
show
> > up. Why is this? Is there a way that I can get the properties to come
> > accross by uploading the document from the web page? I don't think I
want
> > my users copy the files through windows explorer do I? Any help or
> > suggestions would be greatly appreciated.
> >
> > Thanks
> >
> > Tim Duell
> >
> >
>
>

Mike
Thu Nov 04 13:02:21 CST 2004

A miracle :)

It was a wild guess ... (Maybe not so wild after all)

Thanks for letting us know!

Mike Walsh, Helsinki, Finland

"Tim Duell" <someone@microsoft.com> wrote in message
news:eJX1WcowEHA.4048@TK2MSFTNGP15.phx.gbl...
> That worked exactly as you said. Thanks for the help.
>
> Tim Duell
>
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:ONrHiGowEHA.908@TK2MSFTNGP11.phx.gbl...
> > I think it's a "feature". It assumes if you have created additional
fields
> > (which I presume they are) in the document library that you will be
using
> > the values specified in the update form.
> >
> > You could try updating (even a single file) using the multiple uploads
> > function. *That* seems to ignore the contents of the fields in the
upload
> > form. (Which might have the same effect as using windows explorer to do
> it).
> >
> > Let us know?
> >
> > Mike Walsh, Helsinki, Finland
> > WSS FAQ at http://wss.collutions.com
> > Please reply to the newsgroup
> >
> > "Tim Duell" <someone@microsoft.com> wrote in message
> > news:eGqmG9lwEHA.1392@tk2msftngp13.phx.gbl...
> > >I have an Excel file that has fields that are linked directly to the
> > > properties of the file and have matching properties in my library. If
I
> > > go
> > > the the web page for the doc lib I can upload the document and it asks
> me
> > > for the properties that I have setup. I do not fill them out thinking
> > > that
> > > it will come in from my file. It does not. If I go through windows
> > > explorer and copy the file to the appropriate doc lib the properties
> show
> > > up. Why is this? Is there a way that I can get the properties to
come
> > > accross by uploading the document from the web page? I don't think I
> want
> > > my users copy the files through windows explorer do I? Any help or
> > > suggestions would be greatly appreciated.
> > >
> > > Thanks
> > >
> > > Tim Duell
> > >
> > >
> >
> >
>
>

Bil
Thu Nov 04 18:36:22 CST 2004

Tim,

This is by design. During a single upload, SharePoint uses the values
from the NewForm.aspx (which like you said are blank). To get the
properties to auto-update you need to:

1. Using multiple file upload (Office 2003 clients only)
2. By cut'n'paste/drag-drop into Explorer view
3. Drag-drop into a network place or mapped drive to the doclib
4. Create the document from the new document link on the toolbar in the
doclib and set the file properties inside of Word/Excel/PPT and save the
document back to SharePoint

The single upload is annoying. What should happen (my preference and
hopefully something that gets into a future release) is that when you
browse for the file and select one, it automatically populates what
fields you have created to match custom properties in the file. Then you
just have to do browse and save to add it fully populated.

Also there are issues with properties like Author, Company, etc. that
are the default ones that Microsoft has internally to documents. Only
Title is populated initially (and you can't change it until after it's
been uploaded).

Sigh. I feel another blog coming on... ;)

"Tim Duell" <someone@microsoft.com> wrote in message
news:someone@microsoft.com:
> I have an Excel file that has fields that are linked directly to the
> properties of the file and have matching properties in my library. If I
> go
> the the web page for the doc lib I can upload the document and it asks
> me
> for the properties that I have setup. I do not fill them out thinking
> that
> it will come in from my file. It does not. If I go through windows
> explorer and copy the file to the appropriate doc lib the properties
> show
> up. Why is this? Is there a way that I can get the properties to come
> accross by uploading the document from the web page? I don't think I
> want
> my users copy the files through windows explorer do I? Any help or
> suggestions would be greatly appreciated.
>
> Thanks
>
> Tim Duell

Mike
Fri Nov 05 07:39:29 CST 2004

Now added to the appropriate WSS FAQ item (where there was already a lot
from Bil Simser just not this)

III.41 "Why can't I synchronize certain properties between a WSS
document library and Microsoft Word?"


Mike Walsh, Helsinki, Finland

"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:uDTSRDqwEHA.4040@TK2MSFTNGP11.phx.gbl...
>A miracle :)
>
> It was a wild guess ... (Maybe not so wild after all)
>
> Thanks for letting us know!
>
> Mike Walsh, Helsinki, Finland
>
> "Tim Duell" <someone@microsoft.com> wrote in message
> news:eJX1WcowEHA.4048@TK2MSFTNGP15.phx.gbl...
>> That worked exactly as you said. Thanks for the help.
>>
>> Tim Duell
>>
>> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
>> news:ONrHiGowEHA.908@TK2MSFTNGP11.phx.gbl...
>> > I think it's a "feature". It assumes if you have created additional
> fields
>> > (which I presume they are) in the document library that you will be
> using
>> > the values specified in the update form.
>> >
>> > You could try updating (even a single file) using the multiple uploads
>> > function. *That* seems to ignore the contents of the fields in the
> upload
>> > form. (Which might have the same effect as using windows explorer to do
>> it).
>> >
>> > Let us know?
>> >
>> > Mike Walsh, Helsinki, Finland
>> > WSS FAQ at http://wss.collutions.com
>> > Please reply to the newsgroup
>> >
>> > "Tim Duell" <someone@microsoft.com> wrote in message
>> > news:eGqmG9lwEHA.1392@tk2msftngp13.phx.gbl...
>> > >I have an Excel file that has fields that are linked directly to the
>> > > properties of the file and have matching properties in my library.
>> > > If
> I
>> > > go
>> > > the the web page for the doc lib I can upload the document and it
>> > > asks
>> me
>> > > for the properties that I have setup. I do not fill them out
>> > > thinking
>> > > that
>> > > it will come in from my file. It does not. If I go through windows
>> > > explorer and copy the file to the appropriate doc lib the properties
>> show
>> > > up. Why is this? Is there a way that I can get the properties to
> come
>> > > accross by uploading the document from the web page? I don't think I
>> want
>> > > my users copy the files through windows explorer do I? Any help or
>> > > suggestions would be greatly appreciated.
>> > >
>> > > Thanks
>> > >
>> > > Tim Duell
>> > >
>> > >
>> >
>> >
>>
>>
>
>