Unanswered question-Re: Using data from a worksheet

Using FrontPage 2003 SP3

This is a message (edited) I posted to open an earlier thread which died
before an answer relevant to my situation appeared. In reposting I am
hoping for useful guidance.

Details of my golf club's fixtures, events and bookings are listed in a
worksheet on a daily basis for a calendar year and frequently edited for
changes and new bookings. There are 11 columns of data and this work is
done in the club's office. The current worksheet is emailed to me monthly.

To get started I created a page for each month by saving from the
worksheet each month's data as a .csv file, importing that file into
FrontPage, opening it in Notepad in FrontPage (Open with), copying and
pasting into each new page and using Table | Convert | Text to Table to
create the table of data. I then formatted the table using HTML.

However I cannot see a way to update the data other than manually!
Ideally I would want to delete the data from its table and copy and
paste the newly issued data into the table not disturbing the formatting
(similar to the copying and pasting of data in Excel).

But elsewhere I have been told to use ASP (of which I have no knowledge)
as a better way of updating the pages. I have since tested the server,
provided by a member of my family and as ASP is not supported I am need
of an alternative. Is there a way more suited to my limited abilities
while continuing to use FrontPage?

Malcolm Walker

What I would be doing is putting that information into an Access DB, and
having a query inside of that db to only pull the current months
information. In FP then, you can use a Database Results Wizard to pull the
data from that query.
As you are using '03 and I was on 2k, there was advancement done to FP- so
you may have a little more that you can do in FP than I could




"Malcolm Walker" <mewalker@uwclub.net> wrote in message
news:%23rDtvr0jIHA.5660@TK2MSFTNGP02.phx.gbl...
> Using FrontPage 2003 SP3
>
> This is a message (edited) I posted to open an earlier thread which died
> before an answer relevant to my situation appeared. In reposting I am
> hoping for useful guidance.
>
> Details of my golf club's fixtures, events and bookings are listed in a
> worksheet on a daily basis for a calendar year and frequently edited for
> changes and new bookings. There are 11 columns of data and this work is
> done in the club's office. The current worksheet is emailed to me
> monthly.
>
> To get started I created a page for each month by saving from the
> worksheet each month's data as a .csv file, importing that file into
> FrontPage, opening it in Notepad in FrontPage (Open with), copying and
> pasting into each new page and using Table | Convert | Text to Table to
> create the table of data. I then formatted the table using HTML.
>
> However I cannot see a way to update the data other than manually!
> Ideally I would want to delete the data from its table and copy and paste
> the newly issued data into the table not disturbing the formatting
> (similar to the copying and pasting of data in Excel).
>
> But elsewhere I have been told to use ASP (of which I have no knowledge)
> as a better way of updating the pages. I have since tested the server,
> provided by a member of my family and as ASP is not supported I am need of
> an alternative. Is there a way more suited to my limited abilities while
> continuing to use FrontPage?
> Malcolm Walker

Mike, Thank you for your reply. But in my message . . .
>as ASP is not supported (i.e. on the server I am using) I am need of
an alternative.

From my very limited knowledge the Database Results Wizard cannot be
used without ASP or ASP.NET. Please correct me if (hopefully!) I am wrong.

Mike Mueller wrote:
> What I would be doing is putting that information into an Access DB,
> and having a query inside of that db to only pull the current months
> information. In FP then, you can use a Database Results Wizard to pull
> the data from that query.
> As you are using '03 and I was on 2k, there was advancement done to
> FP- so you may have a little more that you can do in FP than I could
>
> "Malcolm Walker" <mewalker@uwclub.net> wrote in message
> news:%23rDtvr0jIHA.5660@TK2MSFTNGP02.phx.gbl...
>> Using FrontPage 2003 SP3
>>
>> This is a message (edited) I posted to open an earlier thread which
>> died before an answer relevant to my situation appeared. In
>> reposting I am hoping for useful guidance.
>>
>> Details of my golf club's fixtures, events and bookings are listed in
>> a worksheet on a daily basis for a calendar year and frequently
>> edited for changes and new bookings. There are 11 columns of data
>> and this work is done in the club's office. The current worksheet is
>> emailed to me monthly.
>>
>> To get started I created a page for each month by saving from the
>> worksheet each month's data as a .csv file, importing that file into
>> FrontPage, opening it in Notepad in FrontPage (Open with), copying
>> and pasting into each new page and using Table | Convert | Text to
>> Table to create the table of data. I then formatted the table using
>> HTML.
>>
>> However I cannot see a way to update the data other than manually!
>> Ideally I would want to delete the data from its table and copy and
>> paste the newly issued data into the table not disturbing the
>> formatting (similar to the copying and pasting of data in Excel).
>>
>> But elsewhere I have been told to use ASP (of which I have no
>> knowledge) as a better way of updating the pages. I have since
>> tested the server, provided by a member of my family and as ASP is
>> not supported I am need of an alternative. Is there a way more
>> suited to my limited abilities while continuing to use FrontPage?
>> Malcolm Walker
>

That information is correct- asp / .net are are required for out-of-box
success
However, there are similiar options that can be done in other scripting
languages such as PHP- it will not be a drop in place project for FP,
instead a custom script would be needed. Expression Web V2 beta does have
PHP support in it, the best person to ask about it would be Veign in the
microsoft.public.expression.webdesigner NewsGroup





"Malcolm Walker" <mewalker@uwclub.net> wrote in message
news:ut4Wmi2jIHA.4196@TK2MSFTNGP04.phx.gbl...
> Mike, Thank you for your reply. But in my message . . .
> >as ASP is not supported (i.e. on the server I am using) I am need of
> an alternative.
>
> From my very limited knowledge the Database Results Wizard cannot be used
> without ASP or ASP.NET. Please correct me if (hopefully!) I am wrong.
>
> Mike Mueller wrote:
>> What I would be doing is putting that information into an Access DB, and
>> having a query inside of that db to only pull the current months
>> information. In FP then, you can use a Database Results Wizard to pull
>> the data from that query.
>> As you are using '03 and I was on 2k, there was advancement done to FP-
>> so you may have a little more that you can do in FP than I could
>>
>> "Malcolm Walker" <mewalker@uwclub.net> wrote in message
>> news:%23rDtvr0jIHA.5660@TK2MSFTNGP02.phx.gbl...
>>> Using FrontPage 2003 SP3
>>>
>>> This is a message (edited) I posted to open an earlier thread which died
>>> before an answer relevant to my situation appeared. In reposting I am
>>> hoping for useful guidance.
>>>
>>> Details of my golf club's fixtures, events and bookings are listed in a
>>> worksheet on a daily basis for a calendar year and frequently edited for
>>> changes and new bookings. There are 11 columns of data and this work is
>>> done in the club's office. The current worksheet is emailed to me
>>> monthly.
>>>
>>> To get started I created a page for each month by saving from the
>>> worksheet each month's data as a .csv file, importing that file into
>>> FrontPage, opening it in Notepad in FrontPage (Open with), copying and
>>> pasting into each new page and using Table | Convert | Text to Table to
>>> create the table of data. I then formatted the table using HTML.
>>>
>>> However I cannot see a way to update the data other than manually!
>>> Ideally I would want to delete the data from its table and copy and
>>> paste the newly issued data into the table not disturbing the formatting
>>> (similar to the copying and pasting of data in Excel).
>>>
>>> But elsewhere I have been told to use ASP (of which I have no knowledge)
>>> as a better way of updating the pages. I have since tested the server,
>>> provided by a member of my family and as ASP is not supported I am need
>>> of an alternative. Is there a way more suited to my limited abilities
>>> while continuing to use FrontPage?
>>> Malcolm Walker
>>

Mike, Thank you for your advice. I will post in expression.webdesigner.

Mike Mueller wrote:
> That information is correct- asp / .net are are required for
> out-of-box success
> However, there are similiar options that can be done in other
> scripting languages such as PHP- it will not be a drop in place
> project for FP, instead a custom script would be needed. Expression
> Web V2 beta does have PHP support in it, the best person to ask about
> it would be Veign in the microsoft.public.expression.webdesigner
> NewsGroup
> "Malcolm Walker" <mewalker@uwclub.net> wrote in message
> news:ut4Wmi2jIHA.4196@TK2MSFTNGP04.phx.gbl...
>> Mike, Thank you for your reply. But in my message . . .
>> >as ASP is not supported (i.e. on the server I am using) I am need of
>> an alternative.
>>
>> From my very limited knowledge the Database Results Wizard cannot be
>> used without ASP or ASP.NET. Please correct me if (hopefully!) I am
>> wrong.
>>
>> Mike Mueller wrote:
>>> What I would be doing is putting that information into an Access DB,
>>> and having a query inside of that db to only pull the current months
>>> information. In FP then, you can use a Database Results Wizard to
>>> pull the data from that query.
>>> As you are using '03 and I was on 2k, there was advancement done to
>>> FP- so you may have a little more that you can do in FP than I could
>>>
>>> "Malcolm Walker" <mewalker@uwclub.net> wrote in message
>>> news:%23rDtvr0jIHA.5660@TK2MSFTNGP02.phx.gbl...
>>>> Using FrontPage 2003 SP3
>>>>
>>>> This is a message (edited) I posted to open an earlier thread which
>>>> died before an answer relevant to my situation appeared. In
>>>> reposting I am hoping for useful guidance.
>>>>
>>>> Details of my golf club's fixtures, events and bookings are listed
>>>> in a worksheet on a daily basis for a calendar year and frequently
>>>> edited for changes and new bookings. There are 11 columns of data
>>>> and this work is done in the club's office. The current worksheet
>>>> is emailed to me monthly.
>>>>
>>>> To get started I created a page for each month by saving from the
>>>> worksheet each month's data as a .csv file, importing that file
>>>> into FrontPage, opening it in Notepad in FrontPage (Open with),
>>>> copying and pasting into each new page and using Table | Convert |
>>>> Text to Table to create the table of data. I then formatted the
>>>> table using HTML.
>>>>
>>>> However I cannot see a way to update the data other than manually!
>>>> Ideally I would want to delete the data from its table and copy and
>>>> paste the newly issued data into the table not disturbing the
>>>> formatting (similar to the copying and pasting of data in Excel).
>>>>
>>>> But elsewhere I have been told to use ASP (of which I have no
>>>> knowledge) as a better way of updating the pages. I have since
>>>> tested the server, provided by a member of my family and as ASP is
>>>> not supported I am need of an alternative. Is there a way more
>>>> suited to my limited abilities while continuing to use FrontPage?
>>>> Malcolm Walker
>>>
>

Following on from Mike's answer - you can still do this in frontpage without
asp.

Create a form and save the results to the private folder (which are csv).
It is very simple to code a button to pull this information into an access
database - so you don'r need to cut and paste. Or, if you want, you can
automate this by using windows scedular to run an autoexec macro in your
access db.

Mind you I think if you ask your server IT they may be able to handle the
data in mysql (which I think most servers can run). But, unless you have
zillions of records, access is much better at this type of thing


--
Wayne
Manchester, England.



"Malcolm Walker" wrote:

> Mike, Thank you for your advice. I will post in expression.webdesigner.
>
> Mike Mueller wrote:
> > That information is correct- asp / .net are are required for
> > out-of-box success
> > However, there are similiar options that can be done in other
> > scripting languages such as PHP- it will not be a drop in place
> > project for FP, instead a custom script would be needed. Expression
> > Web V2 beta does have PHP support in it, the best person to ask about
> > it would be Veign in the microsoft.public.expression.webdesigner
> > NewsGroup
> > "Malcolm Walker" <mewalker@uwclub.net> wrote in message
> > news:ut4Wmi2jIHA.4196@TK2MSFTNGP04.phx.gbl...
> >> Mike, Thank you for your reply. But in my message . . .
> >> >as ASP is not supported (i.e. on the server I am using) I am need of
> >> an alternative.
> >>
> >> From my very limited knowledge the Database Results Wizard cannot be
> >> used without ASP or ASP.NET. Please correct me if (hopefully!) I am
> >> wrong.
> >>
> >> Mike Mueller wrote:
> >>> What I would be doing is putting that information into an Access DB,
> >>> and having a query inside of that db to only pull the current months
> >>> information. In FP then, you can use a Database Results Wizard to
> >>> pull the data from that query.
> >>> As you are using '03 and I was on 2k, there was advancement done to
> >>> FP- so you may have a little more that you can do in FP than I could
> >>>
> >>> "Malcolm Walker" <mewalker@uwclub.net> wrote in message
> >>> news:%23rDtvr0jIHA.5660@TK2MSFTNGP02.phx.gbl...
> >>>> Using FrontPage 2003 SP3
> >>>>
> >>>> This is a message (edited) I posted to open an earlier thread which
> >>>> died before an answer relevant to my situation appeared. In
> >>>> reposting I am hoping for useful guidance.
> >>>>
> >>>> Details of my golf club's fixtures, events and bookings are listed
> >>>> in a worksheet on a daily basis for a calendar year and frequently
> >>>> edited for changes and new bookings. There are 11 columns of data
> >>>> and this work is done in the club's office. The current worksheet
> >>>> is emailed to me monthly.
> >>>>
> >>>> To get started I created a page for each month by saving from the
> >>>> worksheet each month's data as a .csv file, importing that file
> >>>> into FrontPage, opening it in Notepad in FrontPage (Open with),
> >>>> copying and pasting into each new page and using Table | Convert |
> >>>> Text to Table to create the table of data. I then formatted the
> >>>> table using HTML.
> >>>>
> >>>> However I cannot see a way to update the data other than manually!
> >>>> Ideally I would want to delete the data from its table and copy and
> >>>> paste the newly issued data into the table not disturbing the
> >>>> formatting (similar to the copying and pasting of data in Excel).
> >>>>
> >>>> But elsewhere I have been told to use ASP (of which I have no
> >>>> knowledge) as a better way of updating the pages. I have since
> >>>> tested the server, provided by a member of my family and as ASP is
> >>>> not supported I am need of an alternative. Is there a way more
> >>>> suited to my limited abilities while continuing to use FrontPage?
> >>>> Malcolm Walker
> >>>
> >
>