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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist - Not just for websites

Thread began 2/01/2010 7:41 pm by Office Guy-172461 | Last modified 2/02/2010 2:07 pm by Jimmy Wu | 523 views | 1 replies |

Office Guy-172461

DataAssist - Not just for websites

I have a vendor that supplies product info in an Excel spreadsheet (never in the same way). The layout never fits the the way the store is organized and I had to scroll and compress columns just to see everything when it came time to update the DB.

Solution:

  1. Create a database on the local testing server named after the vendor.
  2. Import Excel spreadsheet into database.
  3. Create a simple one column template using CSS Sculptor.
  4. Use the DataAssist wizard to create pages that contain just the columns you need in the order you want to see them.
  5. Use the detail pages to hold all of the info you need to add an item.


In about 5 minutes I had a very easy to use search page that kept track of where I was, enabled me to quickly check prices of old items, and find the ones that needed to be added. When I find a new item, I just click the detail button and all the info is right there on one page. The vendor DB isn't connected to the store DB, I just use it to find the information I need in the format I want. I update through the store Admin pages. It is far easier to copy and paste from, than a spreadsheet.

If I want to change the order or columns shown, I just delete all the pages and run the wizard again. You end up with your own custom database tool for whatever you want in a matter of minutes.

Not only does it speed the update process, it looks a lot better than most quick-and-dirty solutions. That becomes important when going through hundreds of items. :)

Sign in to reply to this post

Jimmy Wu

That sounds like a good use of the product. Glad the product has helped you with that as well. Thanks for sharing your experiences for other users.

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