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

• Workers

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