close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Database Driven Websites.

Thread began 8/06/2013 10:18 am by Simon | Last modified 10/31/2013 6:53 am by Simon | 2112 views | 30 replies |

Simon

Database Driven Websites.

I am looking for a extension to help with building a marketing website for the South African Motorcycle Industry.
Basically a A-Z Guide with Categories and Listings, i have around 600 companies in a database that i need to manage.

Can you advise me whether you have the right tools for the job.

Simon.

Sign in to reply to this post

Ray BorduinWebAssist

Data Bridge sounds like the product you would need. It should have everything you would want to use to create the directory, searches and listings for your database.

Sign in to reply to this post

Simon

Data Assist

Great !!!!
I will give it a try..


Regards
Simon.

Sign in to reply to this post

Simon

Data Bridge

Currently the Database that we have got is in excel format. We need to create a SQL database with a infrastructure that will accept
the data from this excel spreadsheet. Are there extensions in Data Bridge which will allow us to create the database infrastructure
and transfer the excel data into it. If not can you advise on the simplest method and tools to achieve our goals ( we are not php coders )

Kind Regards
Simon.

Sign in to reply to this post

Jason ByrnesWebAssist

There is not a tool in Data bridge to convert an Excel Spreadsheet to a table in a MySQL database.

Through a google search for:
convert excel spreadsheet to mysql table

I found the following tool on the MySQL site that looks like it will help you:
http://www.mysql.com/why-mysql/windows/excel/

THere are also a number of other results that where returned that looked helpful.

Sign in to reply to this post

CraigRBeta Tester

If you have Microsoft Access, you can do it another way too, (in 2 stages)

You need to link your access database to your mysql database tables via an odbc connection, for which you will need a MySQL ODBC driver

Once this is done, you can simply copy and paste your excel data into your mysql database tables via the access interface.

Sign in to reply to this post

Simon

Database

Thanks for your information about Microsoft Access but we are working on Mac.
Do you know if the procedure you have mentioned would work with File Maker ?

Sign in to reply to this post

CraigRBeta Tester

Sorry. I'm a PC user, so can't give a definitive answer, but if you can get a mySQL ODBC driver for a mac then I can't see why it wouldn;t work

Try this link, see if it helps

http://dev.mysql.com/downloads/connector/odbc/

Sign in to reply to this post

Simon

I have bought Data Bridge as advised by Ray Borduin.

I having been working for the past few weeks on learning MySQL and making connections via dreamweaver.
Also i have done tutorial "getting started with dynamic websites".
I now have more understanding of dynamic websites.

I now wanting advise on where to go from here in terms of tutorials.

The type of website i am trying to create is similar to this: http://www.thejozikids.co.za
In my database i have categorized by type of business and region.
I am wanting to learn how to create queries and how to show results on a page.
and any other interesting features that databridge offers.

Regards
Simon.

Sign in to reply to this post

Jason ByrnesWebAssist

I would recommend the Data Bridge Getting started guide next:
http://www.webassist.com/tutorials/Getting-Started-with-Data-Bridge


The Data Bridge getting started guide contains links to Additional Getting started guides for the tools that are included in Data Bridge to help you become more familiar with the package.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...