Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Can form data be saved in a spreadsheet on the backend?

  Asked By: Leland    Date: Nov 28    Category: Sharepoint    Views: 1352

Most of my Web experience on the Unix side (Perl CGI, Apache,
Netscape Enterprise Server, etc.) and I'm trying to determine what
Sharepoint will and will not let me do. Any answers you can provide
to the following questions would be greatly appreciated. I'm using
Sharepoint Services 2003.

First, I know that I can rename a (sub)site's title, but can the path
be easily changed? Can (must?) this be done using the smigrate tool?

Second, can the categories on the left nav bar be changed? I suspect
not, since the categories are actually types of Web Parts, but there
are others in my company that would like to see something different,
and I haven't found anything yet that indicates that this can be done.

Third, can Web Parts (e.g. a document repository) be moved between
(sub)sites? The closest I could get was to create a template from
the one I wanted to move, create a new one on the target site, and
move docs from one explorer view to the next. I know there is also
an option to include content in the template, but I havn't tried that
yet.

Fourth, can a master list (for this discussion, we'll say it's a
customer list) be created on a site, with views into that list
available on subsites?

Fifth, I would like to publish an Excel spreadsheet for data entry,
but have it appear in the browser, perhaps with a plug-in or with OLE
integration. Has anyone done this with Sharepoint Services, and if
so, what (in general) was involved? Alternatively, can form data be
saved in a spreadsheet on the backend?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Alexandra Lewis     Answered On: Nov 28

>><snip>...can the path be easily changed?...using the smigrate tool?
>1. I believe you can do this by exporting in Frontpage 2003...
>
>>Second, can the categories on the left nav bar be changed? <snip>
>2. You can change the categories names and hyperlink values on the
>left using Frontpage 2003. <snip>

I suppose I need to get a copy of Frontpage 2003 ;-) I tried FP2002
yesterday and was able to fix the navigation bar, which led to a more
in-depth question. While awaiting a reply to this post, I did some more
research on the Net and, being the Unix-type that I am, found some
modification (read: hacking) guides for underlying files, specifically, the
default.aspx and ONET.XML. Having been heavily involved with Microsoft
applications (5 or 6 years ago), I know not to take too many risks with
files such as these; however, I did learn how to make a change to the
navigation bar on a site's template that would then cascade to its subsites.
My modifications with FP2002 did not cascade (not that I expected them
to), and I was wondering if there is a way to modify the template with
FP2002 or FP2003.

I did receive one warning from FP2002 when I tried to view the site
properties, stating that a newer release of FP is required to edit the site.
I will upgrade as soon as I can, but are there any serious ramifications
of using an older release, excluding reduced functionality? Will it cause
something the break?


>>Third, can Web Parts (e.g. a document repository) be moved between
>>(sub)sites? <snip>
>3. <snip>...create a template[,] include content, then create the new
>list, doc library or whatever and delete the old one...I wouldn't think
>this would be something you need to do very often.

I hope not. I'm putting together a prototype site for a client and the
requirements keep changing. Once under change control, I shouldn't have to
do this kind of thing often. Also, part- and site-templates are going to be
very useful in this regard.



>>Fourth, can a master list...be created...with views...[from] subsites?
>4. Sure, you can create a data  view to that list in Frontpage 2003
>by going to Insert-database-data view. You can then navigate to the site
>that contains the list and select the list for the data view.
>>Fifth, I would like to publish an Excel spreadsheet  for data entry, but
>>have it appear in the browser, perhaps with a plug-in or with OLE
>>integration. <snip> Alternatively, can form  data be saved  in a spreadsheet
>>on the backend?
>5. You can have a Excel file that is actually linked to a
>Sharepoint List and it will synchronize changes. You may want to check
>out:
>office.microsoft.com/.../....aspx
>3&CTT=1&Origin=EC790000701033&QueryID=MHf5bF_fB&Query=Sharepoint&Scope=RC
>It specifically deals with publishing an Excel list and synching it to a
>Sharepoint list.


Excellent! I will try these as soon as I can!

 
Didn't find what you were looking for? Find more on Can form data be saved in a spreadsheet on the backend? Or get search suggestion and latest updates.




Tagged: