DFP and a simple client usage

[dennis80094]

I was looking to find if DFP is the right tool for this job or if this and additional tools are needed.

The usage is simple, several companies with two or more employees. They need a simple login, which will be supplied to them, so that when they login they only see the files they can to download.

Example, a photographer setting up a system where art directors or designers can login and only see files specific to them for download.

The DFP solution recipes for downloads want to integrate e-commerce assuming files are going to be purchased.

[Ray Borduin]

It sounds like you would need DFP, DataAssist, and Security Assist to build this tool.

[dennis80094]

"DataAssist, and Security Assist."

Thank you for the quick reply.

I can understand utility of DataAssist, especially for building a CMS and maintaining a DB.

If high security is not a necessity and the users, in the 10s not 100s, are going to be sent User ID's and PW's is "Security Assist" a necessity or a convenience?

Finally, the clients site is Linux based hosting on (everybody's favorite) GoDaddy. Do you foresee any problems with DFP, DataAssist or Security Assist?

[Ray Borduin]

Security assist is for login and user groups and rules for who views what.

[kaptainkairos23100320]

Hi _ I need to do this for a members area (dynamic page) showing audio downloads specific to that user after login.

I also want to set-up a simple admin for my client who wants to be able to upload files or at least setup download links to already uploaded files - assuming a database can't contain audio files but can contain links and make them availabe to a particular user after login

which app would I use first? second? and third? to create this?

I have a database connection and a mysql database I can edit using phpmyadmin

[Ray Borduin]

I would start with DataAssist, you can add the admin login and make it for admin later. Use Digital File Pro to upload the files.

Then use SecurityAssist or the User Registration Solution to add user login and tie in downloads with digital file pro again.

[kaptainkairos23100320]

I've spent the whole weekend trying to follow tutorials that don't exactly address what I'm trying to do - I'm pretty close to giving up on webassist as its not simple and its not quick!

I appreciate you are trying to help but I need more information or I'm going to have to buy something else that just works.

[Ray Borduin]

Where are you getting stuck? What have you tried? Now that you have done the tutorials that don't do what you want, start working on what you are trying to do and let us know what your questions are.

[kaptainkairos23100320]

Hi Ray - I've read on another thread that you advise redirecting to a common page after login and then redirecting from that page to a user specific page - how would I do this?

I've set up user_downloads1.php, user_downloads2.php, user_downloads3.php ... etc with authentication set to user_level = 1,2,3...etc after adding a user_level field in the visitors table of the database.

I've given up with data assist for now as it creates a javascript error in dreamweaver when its installed and anyway I can use phpmyadmin to access the database.

I'm confused about how I can associate a user with his downloadable files given that each user will have several files to download - so they can't be stored in the same visitors table - do I need to create a recordset combining the visitors table and the items table?

if so how?

I have setup the database with the following tables using sql from one of the supplied databases:

countries
groups
itemcategory
items
orderdetails
orders
orderstatustypes
states_provinces
visitors

I've set up a repeating region on user_downloads.php but how do I get the correct users files on the page.

I'm thinking to have the login page as the first page of the download section as everyone will need to login anyway.

Any help will be greatly appreciated

[Ray Borduin]

The visitorID should be stored in the orders table, which then can be linked to the orderdetails table which can be linked to the items table, which is where you are likely storing the download locations.

You could probably use one page and just vary your SQL based on the login, but if you wanted to go to three pages, then :

1) Have the successful login send you to userdownloads1 and store the user_level as a session variable

2) Create a rule called "In group number 1" that checks to make sure a user is in group 1.

3) on userdownloads1 apply the server behavior to redirect to userdownloads2 if they are not part of the group "In group number 1"

4) repeat steps 2 and 3 for each group you want a separate redirect for.

[kaptainkairos23100320]

Hi Ray thanks for the response - I would prefer to go to one just page that outputs different downloads for different users after login - is it definitely possible?

"The visitorID should be stored in the orders table, which then can be linked to the orderdetails table which can be linked to the items table, which is where you are likely storing the download locations"

I don't understand how you link these tables together? using an sql query? how? do I need to create a recordset in dreamweaver?

[kaptainkairos23100320]

I'm searching google for advanced sql as I don't know how to link the visitor id with the itemname in the items table - I could be doing this for hours and getting nowhere - maybe I should simplify the database?

[kaptainkairos23100320]

I can't spend so much time trying to get stuff done - I need step by step instructions on how to do this or I will have to give up

[Ray Borduin]

Unfortunately when it comes to learning how to create a web application from scratch, designing your own database and adding complex featues, there will be a learning curve. Giving up is always an option when facing anything you have never done before.

You can join tables with an INNER JOIN statement. You won't need complex or advanced SQL, just the most basic concept of any relational database. If you aren't prepared to learn basic concepts of php, mySQL, Dreamweaver, and webassist products, or you don't want to spend time trying to get stuff done, then by all means give up.

People that are successful with WebAssist products are prepared to learn a little mySQL in order to build a database application and aren't afraid to try to get stuff done. Since you can build any application you want, the steps are up to you, so you could never find step by step instructions on everything you can build.

[kaptainkairos23100320]

Hi Ray - you've made some valid points - unfortunately I was attempting to get this done for a deadline which was monday and was pretty confident I could work it out over the weekend.

I can get a bit stressed - sorry

I would like to understand the joining tables together but for now it would be helpful if you could paste an example of he query that would be similar to what I need to use - obviously I would need to adjust to the fields and tables I'm actually using.

is this possible?

[Ray Borduin]

Here is a tutorial by someone else that might help explain joins to you.
http://www.tizag.com/sqlTutorial/sqljoin.php
The samples there are perfectly relevent and you could replace your table and column names.