Custom "spreadsheet" module to display data

Clay Gordon
Clay Gordon
@claygordon
8 years ago
733 posts
I want to crowd-source the creation of a database of chocolate companies.

I have a bunch of lists that I can upload to seed the database, and I am looking to enable my members to add to it and to suggest updates.

I know I can use Aparna to create a new database table for a module and then use the form designer to create the "Create" and "Update" forms, but I not a good enough programmer to be able to write the code to display and manipulate the contents.

The page would be visible to visitors (not logged in).
The table needs to be searchable (search scoped to this one table).
The table needs to be sortable.
Not all columns would be displayed.
Hidden content would be shown by expanding and collapsing the DOM.
Some companies will have multiple locations.
Only members who are logged in would be allowed to enter a new company.
All new entries would be flagged for review before being visible.
Anyone (visitor or member) would be able to suggest an update to an entry. The update suggestions are only available to admins.
Content would be downloadable only to members of specific quotas.
It would be nice to be able to interface to a mapping API to display the company on a map.
It would be nice to link this to Rating, Like-It, ShareThis, and Comments modules.
It would be nice if people could upload photos.
It would be nice if we could create a separate table of products each company makes.

Thoughts?

Has anyone already done something like this? I do have a modest budget to pay someone to adapt what they have already done the basics or I would be happy to partner with someone to do this and then rev-share selling it through the Marketplace.

TIA.

updated by @claygordon: 07/06/16 12:20:45AM
blindmime
@blindmime
8 years ago
772 posts
Sounds to me that rather than creating an Aparna module, you should just make a jamroom website. The profiles would each be chocolate companies. You would have galleries, blogs, videos, store products for each company profile. Everything you've listed above could be done and more. You would just need to customize your skin to display what you want.

I might like to help with this if you want.
updated by @blindmime: 04/06/16 12:21:31PM
Clay Gordon
Clay Gordon
@claygordon
8 years ago
733 posts
blindmime:
Sounds to me that rather than creating an Aparna module, you should just make a jamroom website. The profiles would each be chocolate companies. You would have galleries, blogs, videos, store products for each company profile. Everything you've listed above could be done and more. You would just need to customize your skin to display what you want.

I already have a JR site with about 10k members. I want to include the functionality within the existing community rather than create an entirely different site. Part of this is the amount of time in my day and I already know from experience that splitting this content off into another site is problematic for many reasons - only one of which is the requirement for a separate login.

Part of the UI is the ability as I was conceiving of it was to be able to display the data in a columnar format, like the profile browser, but sortable. I could create a new module and the form would collect all the data, and tie it into the existing Search functionality. I would lose the sortable tabular display (and scoped search and export) but I get all of the rest of the functionality "free."

Something to consider. Thanks. I still want to do the tabular display but will think about this approach if I can't end up doing that.

:: Clay
michael
@michael
8 years ago
7,715 posts
The user browser is sortable:
your-site.com/user/dashboard/browser/order_by=user_email/order_dir=desc

clikc on the headings for the user name, email, last login. they all sort the listings.

aparna is a good base for this module, quota config to allow the users to add companies then jrCore_list to output all the companies to a table.

Not too complicated, just needs to be built out.

Tags