close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Best Method of Populating Image Database?

Thread began 3/05/2010 11:19 am by drolett_it_info402192 | Last modified 3/05/2010 3:03 pm by CraigR | 718 views | 3 replies |

drolett_it_info402192

Best Method of Populating Image Database?

I'm new to mysql but have average Dreamweaver knowledge. I use a Mac and DW CS 4.

I need to import about 100 products into my site. I used SiteAssist to setup the categories and pages. My first hurdle is to build an administrative page so my assistants can add pricing, descriptions, etc. to each record. The next is to build a page where records can be maintained.

I have 3 related questions:
My first is: How do you suggest I initially populate my database with all of my images? I have thumbnails and actual size of each. Secondly, once the images are in the database, can I use FormsAssist to build my maintenance pages? Finally, should I build my maintenance and import pages before importing my images?

TIA
-tom

Sign in to reply to this post

CraigRBeta Tester

1. don't populate your database with images, just use varchar fields to store the image names (and paths if you want).

2. you can use dataassist to build your maintenance pages, there is a wizard to create the pages you need

3. if you have a lot of images, you can populate your image and thumbnail fields with the image name (and path ?) and ftp the image files to the appropriate folder. This will be quicker than using the maintenance pages

Sign in to reply to this post

drolett_it_info402192

Additional Info Requested Please

Graig,

Thanks for your help.
You said:
"1. don't populate your database with images, just use varchar fields to store the image names (and paths if you want)."

Could you please elaborate on how to do this step by step or point me towards a solution in the documentation?

Thanks again,
tom

Sign in to reply to this post

CraigRBeta Tester

what you need to do is upload your image(s) to a folder(s) in your server, and what goes into the database is a text description of the image name and (if you wish) where the image is located

if you have digital file pro, it makes things easier. take a look at the documentation for dfp2 digital-file-pro/

you could take a look at the blue sky music database (items table) as an example

Sign in to reply to this post

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...