Good evening.
I am not a Dreamweaver pro, like I'm sure many of you guys are, but I
desperately need your .

I was asked to build a small website for a local company, and I need to be
able to link the products on their pages to a database (I'm assuming something
like a csv file, or access database, etc...) that they will update nightly to
show current information (price, quantity available, etc).

I have no idea how to do that; can you point me in the right direction?

Thank you,
tina

Hello,

You might take a look at http://www.cartweaver.com/
It's got a very friendly admin section for updating product info, stock,
prices, etc.

If you are looking to build this rather than use a commercial application,
you have a very steep learning curve ahead.
You'll need to start by determining which Server Side Language and what type
of database the server supports.
Once you find that out, post back and someone will suggest a good book(s).

Take care,
Tim


"agapoula25" <webforumsuser@macromedia.com> wrote in message
news:g4esji$ape$1@forums.macromedia.com...
> Good evening.
> I am not a Dreamweaver pro, like I'm sure many of you guys are, but I
> desperately need your .
>
> I was asked to build a small website for a local company, and I need to be
> able to link the products on their pages to a database (I'm assuming
> something
> like a csv file, or access database, etc...) that they will update nightly
> to
> show current information (price, quantity available, etc).
>
> I have no idea how to do that; can you point me in the right direction?
>
> Thank you,
> tina
>

This could produce a large part of the solution and it's on sale through
Friday (50% off)
http://www.webassist.com/professiona...ls.asp?PID=131

--

Walt


"agapoula25" <webforumsuser@macromedia.com> wrote in message
news:g4esji$ape$1@forums.macromedia.com...
> Good evening.
> I am not a Dreamweaver pro, like I'm sure many of you guys are, but I
> desperately need your .
>
> I was asked to build a small website for a local company, and I need to be
> able to link the products on their pages to a database (I'm assuming
> something
> like a csv file, or access database, etc...) that they will update nightly
> to
> show current information (price, quantity available, etc).
>
> I have no idea how to do that; can you point me in the right direction?
>
> Thank you,
> tina
>

agapoula25 wrote:
> Good evening.
> I am not a Dreamweaver pro, like I'm sure many of you guys are, but I
> desperately need your .
>
> I was asked to build a small website for a local company, and I need to be
> able to link the products on their pages to a database (I'm assuming something
> like a csv file, or access database, etc...) that they will update nightly to
> show current information (price, quantity available, etc).
>
> I have no idea how to do that; can you point me in the right direction?
>
> Thank you,
> tina
>
IF its a very small website whereby they only need to alter the price,
quantity available etc i.e., that kind of very simple basic information
then you could do this via javascript rather than use an elaborate
database. What the client would do is alter a text file on their
computer and then upload that to the site.

Someone here should be able to give you more specific steps. I recently
did something similar whereby the client wanted to update hotel
information such as room availability etc and did it this way.......only
I can't quite remember how now unless I do some more indepth homework.

Client-side management? How did you do that?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Osgood" <notavailable@thisaddress.com> wrote in message
news:g4fpio$ccd$1@forums.macromedia.com...
> agapoula25 wrote:
>> Good evening.
>> I am not a Dreamweaver pro, like I'm sure many of you guys are, but I
>> desperately need your . I was asked to build a small website for a
>> local company, and I need to be able to link the products on their pages
>> to a database (I'm assuming something like a csv file, or access
>> database, etc...) that they will update nightly to show current
>> information (price, quantity available, etc).
>>
>> I have no idea how to do that; can you point me in the right direction?
>>
>> Thank you,
>> tina
>>
> IF its a very small website whereby they only need to alter the price,
> quantity available etc i.e., that kind of very simple basic information
> then you could do this via javascript rather than use an elaborate
> database. What the client would do is alter a text file on their computer
> and then upload that to the site.
>
> Someone here should be able to give you more specific steps. I recently
> did something similar whereby the client wanted to update hotel
> information such as room availability etc and did it this way.......only I
> can't quite remember how now unless I do some more indepth homework.

Murray *ACE* wrote:
> Client-side management? How did you do that?
>


Well sort of I suppose. If I can remember correctly it just involves the
client changing a text document then uploading it to the site. The text
document is called into the page where you want the information amended
via some javascript.

It might be too simple for what the OP is describing. It has its
limitations but if only a few details need changing it seems to do the job.

I think its quite a well known technique. You probably know it but I'm
describing it incorrectly.

Thanks. Sounds much too busy for me. 8)

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Osgood" <notavailable@thisaddress.com> wrote in message
news:g4fubc$had$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> Client-side management? How did you do that?
>>
>
>
> Well sort of I suppose. If I can remember correctly it just involves the
> client changing a text document then uploading it to the site. The text
> document is called into the page where you want the information amended
> via some javascript.
>
> It might be too simple for what the OP is describing. It has its
> limitations but if only a few details need changing it seems to do the
> job.
>
> I think its quite a well known technique. You probably know it but I'm
> describing it incorrectly.

Osgood,

you are describing EXACTLY what I am looking for! To give the client the
ability to upload a text file with updated information, which would then update
the respective information on their webpages (product description, quantity
available, price).

Please please please try to remember how you did that!

Thank you,
Tina.

Unless I'm misreading Osgood's post I think it could be done using
server-side includes (SSI). Use DW's (F1) and search for "server-side
includes".

--

Walt


"agapoula25" <webforumsuser@macromedia.com> wrote in message
news:g4hasm$64q$1@forums.macromedia.com...
> Osgood,
>
> you are describing EXACTLY what I am looking for! To give the client the
> ability to upload a text file with updated information, which would then
> update
> the respective information on their webpages (product description,
> quantity
> available, price).
>
> Please please please try to remember how you did that!
>
> Thank you,
> Tina.
>

agapoula25 wrote:
> Osgood,
>
> you are describing EXACTLY what I am looking for! To give the client the
> ability to upload a text file with updated information, which would then update
> the respective information on their webpages (product description, quantity
> available, price).
>
> Please please please try to remember how you did that!


You would go about it in this way. Say for example you have a televison
and a radio as products and you want to be able to let the client change
the 'description', 'price' and 'quantity'

What you would do is use some simple 'repeating' javascript, as shown
below and then create a 'text' file (see below code) which your client
can change. All they need to be able to do it upload this file to the
webserver in the same directory as the product page/s


So this is the sample code below (it looks complex but if you look
carefully it just repeats itself, the only thing which alters is
television_description, television_price and television_quantity

<h1>Televison</h1>
<h2>Description</h2>

<script src="products.txt" type="text/javascript"></script>
<script Language='JavaScript'>
document.write(television_description)
</script>

<h2>Price</h2>

<script src="products.txt" type="text/javascript"></script>
<script Language='JavaScript'>
document.write(television_price)
</script>

<h2>Quantity</h2>

<script src="products.txt" type="text/javascript"></script>
<script Language='JavaScript'>
document.write(television_quantity)
</script>



Below is what you would need to type into the text file then save the
file as 'products.txt' (which you can see is the linked src file in the
code above)

television_description = "32 inch wide screen. HD ready"
television_price = "£555.00"
television_quantity = "12"

radio_description = "Sony Digital (DAB)"
radio_price = "£65.00"
radio_quantity = "75"


To get the radio information onto the page all you have to do is change
television_description etc to radio_description etc in the javascript code



All the client needs to do is open the text file in a text editor change
the information between the quotation marks and then re-upload the file
to the webserver

This obviously relies on the end-user having javascript enabled...that
will be the vast majority.

<script src="products.txt" type="text/javascript"></script>

You would only need one of these - it doesn't need to be repeated for each
use.

<script
Language='JavaScript'>document.write(television_de scription)</script>

Should be (in each case) -

<script
type="text/javascript">document.write(television_description) </script>

television_description = "32 inch wide screen. HD ready"
television_price = "£555.00"

Wouldn't those really need to be -

var television_description = "32 inch wide screen. HD ready"
var television_price = "£555.00"

??

> This obviously relies on the end-user having javascript enabled

And it relies on the client being able to follow even simple directions.

> ...that will be the vast majority.

In some demographics, yes.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Osgood" <notavailable@thisaddress.com> wrote in message
news:g4hu9f$oq0$1@forums.macromedia.com...
> agapoula25 wrote:
>> Osgood,
>>
>> you are describing EXACTLY what I am looking for! To give the client the
>> ability to upload a text file with updated information, which would then
>> update the respective information on their webpages (product description,
>> quantity available, price).
>>
>> Please please please try to remember how you did that!
>
>
> You would go about it in this way. Say for example you have a televison
> and a radio as products and you want to be able to let the client change
> the 'description', 'price' and 'quantity'
>
> What you would do is use some simple 'repeating' javascript, as shown
> below and then create a 'text' file (see below code) which your client can
> change. All they need to be able to do it upload this file to the
> webserver in the same directory as the product page/s
>
>
> So this is the sample code below (it looks complex but if you look
> carefully it just repeats itself, the only thing which alters is
> television_description, television_price and television_quantity
>
> <h1>Televison</h1>
> <h2>Description</h2>
>
> <script src="products.txt" type="text/javascript"></script>
> <script Language='JavaScript'>
> document.write(television_description)
> </script>
>
> <h2>Price</h2>
>
> <script src="products.txt" type="text/javascript"></script>
> <script Language='JavaScript'>
> document.write(television_price)
> </script>
>
> <h2>Quantity</h2>
>
> <script src="products.txt" type="text/javascript"></script>
> <script Language='JavaScript'>
> document.write(television_quantity)
> </script>
>
>
>
> Below is what you would need to type into the text file then save the file
> as 'products.txt' (which you can see is the linked src file in the code
> above)
>
> television_description = "32 inch wide screen. HD ready"
> television_price = "£555.00"
> television_quantity = "12"
>
> radio_description = "Sony Digital (DAB)"
> radio_price = "£65.00"
> radio_quantity = "75"
>
>
> To get the radio information onto the page all you have to do is change
> television_description etc to radio_description etc in the javascript code
>
>
>
> All the client needs to do is open the text file in a text editor change
> the information between the quotation marks and then re-upload the file to
> the webserver
>
> This obviously relies on the end-user having javascript enabled...that
> will be the vast majority.

Murray *ACE* wrote:
> <script src="products.txt" type="text/javascript"></script>
>
> You would only need one of these - it doesn't need to be repeated for
> each use.
>
> <script
> Language='JavaScript'>document.write(television_de scription)</script>
>
> Should be (in each case) -
>
> <script
> type="text/javascript">document.write(television_description) </script>
>
> television_description = "32 inch wide screen. HD ready"
> television_price = "£555.00"
>
> Wouldn't those really need to be -
>
> var television_description = "32 inch wide screen. HD ready"
> var television_price = "£555.00"
>
> ??

No. It works as my instructions. There are probably alternatives ways
you could write the javascript as there are with most webby things.



>> This obviously relies on the end-user having javascript enabled
>
> And it relies on the client being able to follow even simple directions.

Client opens product.txt amends what's between the quotes. Say they want
the TV price to be £455.00 instead of £555.00 then just type the new
price in, save the txt file and upload the new file to the server,
overwriting the existing one........can't be any simpler than that. Even
if you build a client a proper CMS they will still need instructions on
how to use it.



>> ...that will be the vast majority.
>
> In some demographics, yes.

The wide majority and that's what you should be aiming for.


This IS NOT a replacement for a good CMS but that costs money, lots more
time to construct and not least you need to know how to build one. If
you have those skills and the client has the finances to pay you then
use that. If they don't then this is an alternative that will satisfy
the requirements of those that don't have the skills and clients that
don't have the money to put a better system into place

"Osgood" <notavailable@thisaddress.com> wrote in message
news:g4ih09$g0t$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> <script src="products.txt" type="text/javascript"></script>
>>
>> You would only need one of these - it doesn't need to be repeated for
>> each use.
>>
>> <script
>> Language='JavaScript'>document.write(television_de scription)</script>
>>
>> Should be (in each case) -
>>
>> <script
>> type="text/javascript">document.write(television_description) </script>
>>
>> television_description = "32 inch wide screen. HD ready"
>> television_price = "£555.00"
>>
>> Wouldn't those really need to be -
>>
>> var television_description = "32 inch wide screen. HD ready"
>> var television_price = "£555.00"
>>
>> ??
>
> No. It works as my instructions. There are probably alternatives ways you
> could write the javascript as there are with most webby things.
>
>
>
>>> This obviously relies on the end-user having javascript enabled
>>
>> And it relies on the client being able to follow even simple directions.
>
> Client opens product.txt amends what's between the quotes. Say they want
> the TV price to be £455.00 instead of £555.00 then just type the new price
> in, save the txt file and upload the new file to the server, overwriting
> the existing one........can't be any simpler than that. Even if you build
> a client a proper CMS they will still need instructions on how to use it.
>
>
>
>>> ...that will be the vast majority.
>>
>> In some demographics, yes.
>
> The wide majority and that's what you should be aiming for.
>
>
> This IS NOT a replacement for a good CMS but that costs money, lots more
> time to construct and not least you need to know how to build one. If you
> have those skills and the client has the finances to pay you then use
> that. If they don't then this is an alternative that will satisfy the
> requirements of those that don't have the skills and clients that don't
> have the money to put a better system into place

If the client is ready to edit a plain text file, I'd say it is better to go
with Walt's suggestion (using SSI) rather than implementing your JS
"solution".


--
Thierry
Articles and Tutorials: http://www.TJKDesign.com/go/?0
--
http://developer.yahoo.com/ s you build applications and mashups