Document management conundrumn

14 posts by 3 authors in: Forums > CMS Builder
Last Post: January 27, 2015   (RSS)

By northernpenguin - January 25, 2015

Hi all!

I have a bit of a problem.  I am trying to figure out the best way to implement the following:

  1. the client site has a page (controlled by WebsiteMembership plugin) which list public documents and private documents;
  2. currently, I have created two multi-record editors, one to control public documents and the other private documents.

This works great!

The problem is that some documents are both public & private, and I am trying to avoid having the client upload the documents twice, once for each area.

The editors are defined as follows:

  1. Group Title
  2. Filename (includes document title - info1).  No maximum uploads.

I was thinking of adding 3 check boxes (Public, Private, Both) and based on which is checked, publish to those areas.... won't work, as that would not work at the document level, only at the Group level.

Any ideas?

Thanks...................ragi

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 26, 2015

Hey there - what's the code you're using to select which documents to show on each page?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - January 26, 2015

Hi Claire:  see attached file

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke
Attachments:

minutes.php 8K

By claire - January 27, 2015

Thanks. It's not clear which table the documents are attached to, however. Can you explain which section has the documents?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - January 27, 2015 - edited: January 27, 2015

Hi Claire:  it's both tables. Minutes_overview for the public files and minutes_rods for the private. 

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 27, 2015

Ah I see. Okay, it might be a problem if the documents are stored in two different sections, and there are multiple documents stored in each record.

Are all the documents for each record all set to the same status?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - January 27, 2015

Claire:  Right now, it works, but if the client wants to publish a document to both public and private, he posts them twice.  I was hoping to merge the 2 tables into one and have a checkbox (public, private, both) which would then allow publication in the appropriate area.  Not sure how I would do this. I have attached both schema definitions.

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke

By claire - January 27, 2015

The actual merge could be tricky, but it looks like the fields are the same. Assuming you could get all the records into one table, adding two checkboxes - one for public, one for private - would work fine. All you'd have to do is make a few changes to the logic in the two getRecords calls.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By northernpenguin - January 27, 2015

ok, but how do I add the checkboxes to each file entry?  Would I use info2 & info3??

--
northernpenguin
Northern Penguin Technologies

"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke