close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Data Bridge - Date Assist Pages ERROR

Thread began 5/08/2012 9:13 am by hydraulicpump747422210 | Last modified 5/11/2012 10:52 am by Jason Byrnes | 1599 views | 9 replies |

hydraulicpump747422210

Data Bridge - Date Assist Pages ERROR

I am have a issue with data assistpages. All interfaces of data bridge work with the exception of data assist pages. When I load the interface it opens fine. All selections can be made with ease. But when I click finish I get 3 different error messages. The table creates fine in the mysql database. But nothing happens to the new PHP document in dreamweaver. Please review the following errors upon clicking finish.
1. The following JavaScript error(s) occurred:
At line 149 of file "C:\Program Files\Adobe\Adobe Dreamweaver CS4\Configuration\Floaters\WA_SiteTools_ProgressV2.Js"; setPreferenceInt: Argument number 3 is invalid. (I checked the path of my hard drive and this file is not even present) upon clicking ok the next error comes up;
2. Panel 151 could not be created. Removing it from the list. Not sure here? click OK for the next error
3. while Executing onClick in WADA_Main.htm, the following Javascript error(s) occurred:
At line 262 of file "C:\Program Files\Adobe\Adobe Dreamweaver CS4\Configuration\Shared\Common\Scripts\ListControlClass.js": The object is not currently contained in a document. (checked path and this file is there!)

I am not sure if the extension is installing correctly because half way through the loading bar a dialog box pops up and says databridge successfully installed. I also read the installation problem guide and winfilecache.dat file is not present at all. Please help

Sign in to reply to this post

Jason ByrnesWebAssist

This is a known issue In Data Bridge in DWCS4, we are working on an update that should be released in the next couple of days, hopefully as sone as today that will address this error,

Sign in to reply to this post

hydraulicpump747422210

Upgrade to CS6 Trial and it works fine but have a setup question

Jason, Per my statement above it works great with CS6. Thanks for the reply hopefully the update will be out before my trial expires.

I have an issue with databridge however. I purchased universal email which came with file manipulation. The file upload portion works great! I am able to setup one "file" field. Run the file upload wizard and set it up where one image is the normal image 640X480 and the thumbnail at 120X90. When I test the page it stores the 640X480 image in the proper /images folder and the thumbnail in the /images_thumbs folder. Works beautiful on on click of submit! The problem is; it will NOT store the path name in my mysql database column image1 and thumb1. After reviewing all the forums everyone said that you had to have databridge to get this to work. I can get it to work in databridge under data assist pages but, it appears that I have to have 2 "file" Fields. 1 for the main image and 1 for the thumb. It does store the path in the mysql database but not the full path.

Can you please tell me the proper procedure on setting up both file manipulation "upload" and data assist pages so that I only have to have one file field and the result will be the thumbnail and main image and the complete path displays in my mysql database? Any help would be greatly appreciated.

Sign in to reply to this post

Jason ByrnesWebAssist

to accomplish this in Data Assist, you need to manually add the Data Assist insert record behavior to your page.

It sounds like you already have the form set up and the upload behavior is working, if you look on the bindings panel, expand the "WA Uploaded File(File Field)" binding group (where File Field is the name of the file field in your form).

This binding group will contain bindings for the status, and server file extension, server file name. If you look further down the list, he binding begin to repeat. there will be section of bindings specific to the file created in the /images folder, and then another section of bindings specific to the file created in the /images_thumbs folder. each of those section will have a server file name bindings.

to add the insert behavior, go to the Server Behaviors panel and click the plus button. Select WebAssist -> DataAssist -> Insert -> Insert Single Record

on the first tab, you will select the table to insert the form data to, on the second tab, you will bind each column to the form.

select each column, then click the lightning bolt icon next to value and select the corresponding form element from the dynamic data bindings.

For the Main image column, expand WA Uploaded File(File Field)" binding group and select the Server File Name variable from the section for the /images folder.

for the thumbnail column, select the Server File Name variable from the section for the /images_thumbs folder.



A better alternative though, is to use Image Resizer. Instead of resizing the image using the File Upload and creating 2 copies, you would upload one large image and stoere that file name in the table. then use image resizer to add the thumbnail to your page.

The advantage to using Image Resizer is that it dynamically creates a new image for you. if you decided down the road that instead of 120X90 for the thumbnails, you want to use 120X120, you only need to change the image dimension on the page, and image resizer will automaticly recreate the thumbnails for you.

Sign in to reply to this post

hydraulicpump747422210

Follow Up to Setup Post Answer

Jason,
Thanks for the replay. Everything works now. The images are stored in the correct folder thanks to file upload. A path is generated in mysql database thru the web assist insert single record server behavior. When I check the path in the mysql database it is not storing the full path. It should be storing images/image1.jpg instead it is just writing image1.jpg.

Let me verify how I am creating the insert record function.
1. open server behaviors panel.
2. Click the + sign
3. Choose webassist-data assist-insert-insert single record
4. Webassist interface appears
5. General Panel; Trigger- Button:submit pressed
6. General Panel; Connection; (mysql database connection) Ok
7. General Panel; Table-images(my table)
8. General Panel; Store as: typed the word images in the field (just picked one that came to mind)
9. Bindings Panel; select column image1
10. Bindings Panel; Select lightning bolt next the the blank field of Value:
11. The Please "select a server entity" window opens.
12. In this window I see the following fields; Session, Upload Files Global Status, Upload Files (image1), Form1, and Server Variables.
13. I am expanding Upload Files (image1) and selecting images/[FileName]: Server File Name.
14. Click ok.
15. Lastly click ok to create the new server behavior.

When I test everything works correctly with the exception of storing the full path in the mysql table. images/image1.jpg.

I believed I have followed your instruction correctly. But, maybe there is something that I am not doing right. Any help would be greatly appreciated.

Sign in to reply to this post

Jason ByrnesWebAssist

The path is not really needed in the database, only the file name.

the reason for this is that path may be different from different pages. it's better practice to add the path to the image source on the page where you display the image, for example:

<img src="images/<?php echo($row_recordsetName['columnName']); ?>" />

Sign in to reply to this post

hydraulicpump747422210

Follow up to path in data assist

Perfect, Thanks alot.

Sign in to reply to this post

hydraulicpump747422210

Upgraded to Data Bridge 1.0.2 problems with File Manipulation - Upload

Jason,
I am using both CS4 and CS6. File upload was working fine in CS6 yesterday. It does not work in CS4. This morning I upgraded both CS4 and CS6 with the new 1.0.2 extensions. and now when I create a form in CS4 and CS6 and goto webassist-file manipulation - upload I get the same error message. Cannot seem to make it go away but all other data bridge apps work fine.

The error message is;

While executing onLoad in WA_DFP_FileUpload.htm, the following JavaScript error(s) occurred:
In file "WA_DFP_FileUpload":
initializeUI is not defined

Do you have any idea what is causing this problem?

Sign in to reply to this post

hydraulicpump747422210

File Upload and data pages insert record behavior

Jason,
You helped me figure out how to get the image to store in the images folder and the path to show in mysql table. Easy question can you do multiple images opposed to just one in a form? My table is setup form image1, image2, image3, image4, image5. When I conduct file upload for each image it shows [FileName] on each of the file upload. Then I goto webassist - insert behavior and bind each to the field name. When I test the page and upload all of the images the images are stored in the directory correctly but, it only inserts one file name in image1 field of mysql and image2, image3, image4, image5 are blank.

Sign in to reply to this post

Jason ByrnesWebAssist

for the error you are getting:
Delete the Dreamweaver Cache file from the users configuration folder:
common_installation_issues.pdf


for the file names:

for each file field, you need to add a file upload behavior.

For each upload behavior you create, there will be a binding group created for that file field

in the insert behavior, you need to bind each image column to the Server File Name binding from the corresponding File Upload binding group.

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