Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Help planning my 1st DNN portalHelp planning my 1st DNN portal
Previous
 
Next
New Post
5/23/2006 1:43 PM
 
Hello, and I hope I'm putting this in the correct location.

I've written some code, in c#, to connect to Excel spreadsheets(basic columns of data) and build various tables from the spreadsheet data that help to show trends in the data.

I want to incorporate this logic into a web application, and I think DNN might be a good choice.  I have DNN 4.x installed and configured, so I don't really need much help there.  What I want is advice from experts/experienced DNN developers as to how you would approach this.

In the end, I'd like to have a portal where I can register users, allow them to upload spreadsheets(and be able to restrict access to uploaded spreadsheets based on role/membership), view the tables and graphs that I build with the spreadsheets by clicking a button, link, or menu item representing one of the many tables available.

So, I have a few questions:
1.  All the literature I've read so far, is all about database this and database that.  Can I work with just the uploaded .xls files directly, or do I need to pass them through a database layer?

2.  How do I set up a situation that would restrict access to uploaded files on a per-user/ -account basis and when a user logs in he/she can choose from a list of previously uploaded spreadsheets?

3.  Do I need to build a custom module to display the tables and graphs?  Basically, how do I show my tables?

Any help, general or detailed, is very much appreciated.  Thanks in advance!
 
New Post
5/23/2006 3:11 PM
 
  1. It is up to you, where your module gets its data from and where it stores data - in most cases, this is the database, but it can also be a file.
  2. you can restrict access to folders based on security roles, although this currently does not prevent from bypassing DNN file management and accessing files directly. you can prevent direct file access by renaming files with suffix .resources. Look e.g. into template settings for repository, how to list files.
  3. yes, all functions in DotNetNuke are incorporated in modules. have a look into this tutorial about creating DNN 4 modules.

Note, that there will be a secure file storage in DNN 3.3/4.1.

 


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Help planning my 1st DNN portalHelp planning my 1st DNN portal


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out