Some notes on potential developments for this project.
- 100 000 users (clients)
- 1700 employees in 110 autonomous units (160 locations)
The project is essentially a huge CRM.
Unclear
- How to deal with thousands of groups, filtered by the 160 locations
- How to make a task-based perm system
CalDAV
- SabreDAV to make appointments available to external applications
Upload assistant
- Duplicate data detector
- Preview before import
https://code.google.com/p/jquerycsvtotable/
https://code.google.com/p/jquery-csv/
For sure .csv, and ideally .xls as well
Workspace management
- We'll likely need workspace admins to have more management possibilities of users in their workspace (change password, etc.)
User files
- Will need modernizing, or we'll improve as part of File Gallery Revamp
Trackers
- More configurable business rules in relations between trackers, in js, Smarty or PHP
- Tighten up User Trackers so we can reliably use things like CardDAV
Reporting
- Improvements to the GUI
- Probable use of Spreadsheets
- And maybe a DSL like we have for Advanced Ratings
- Save past queries and associated report
- Maybe save reports or at least email them
- Spreadsheet/query/report should be available somehow to be able to replay them (ideally)
Archiving / deletion rules
- Ex.: Delete all data older than 6 years and archive data over 2 years
Templates for export/print
- We want web-based tweaking of reports/forms
- From the HTML generated, Tiki can already do nice PDFs with wkhtmltopdf
- We need something similar for doc export. Ex. Tiki generates HTML for LibreOffice to convert to .doc
Security
Encryption
- Some of the fields will need to be encrypted and shown partially (ex: with stars)
More security for some of the users
- For super admins, we'll want some additional security
- VPN-only access, IP filtering, two factor auth, etc.
Log monitoring
- Probably out of the scope of Tiki, and done at the proxy level...
Performance
Newsletters for 100 000
Large data needs
- There will be a lot of data in trackers, so perhaps use Mongo or Elastic Search, etc.
- File Gallery Revamp
Sysadmin
- There will likely be some sort setup for more than one server (load balancing, failover, etc.)
Resource management
- Perhaps there will be some development for resource management, like room/projector bookings, along the lines of PluginTrackerCalendar