| 1 |
*** MAIN SCHEDULE 2022 *** |
| 2 |
|
| 3 |
+ Finish Data Forms V2 |
| 4 |
|
| 5 |
*** ISSUES *** |
| 6 |
|
| 7 |
+ Check for rewrite rules with URL parameters (Martin) |
| 8 |
+ Cannot import sample_test.csv with old CSV import feature |
| 9 |
+ Add filter to LOV - allowing to use WordPress environment variables (Marco) |
| 10 |
+ Add order by to LOV (Barbara) |
| 11 |
+ Dashboards |
| 12 |
+ Start cache update after sending response |
| 13 |
+ Charles |
| 14 |
+ Allow to override search features for publications: |
| 15 |
+ Wildcard versus normal search |
| 16 |
+ No search condition = show no rows |
| 17 |
+ Allow column specific search |
| 18 |
+ Two lookup autocomplete relationships with the same table, but referencing different fields, gives an error (Jay) |
| 19 |
+ If wildcard search is enabled on numeric field, the plugin returns all rows on all searches |
| 20 |
+ Tarik |
| 21 |
+ Datetime column not handled as date in search builder |
| 22 |
+ Add limit option to Data Projects (Jay) |
| 23 |
+ Add radar chart (Niels) |
| 24 |
|
| 25 |
+ Norman |
| 26 |
After adding a record in Data Forms, the modal window currently stays open. Can you add an option so that it eithers: |
| 27 |
a remains as is, open showing the record that was added |
| 28 |
b clears out the entered values so another entry can be made, saving time to closing and clicking the add button |
| 29 |
c close the modal window |
| 30 |
+ Jay |
| 31 |
+ Add details to master-detail export |
| 32 |
+ Make queries from Query Builder available from: |
| 33 |
- Shortcodes |
| 34 |
- Publications |
| 35 |
- Sue > integration with phpdocx |
| 36 |
+ Mieke |
| 37 |
+ Make fields read-only or hidden |
| 38 |
+ Make parent read-only and child updatable |
| 39 |
+ Howard - csp issue |
| 40 |
+ https://wordpress.org/support/topic/content-security-policy-breaks-wp-data-access/ |
| 41 |
+ https://observatory.mozilla.org/ |
| 42 |
+ https://hackdefense.nl/publicaties/csp-het-hoe-en-waarom-van-een-content-security-policy/ |
| 43 |
+ Disable premium dashboard access if not paid |
| 44 |
+ CSV premium features |
| 45 |
+ Update from CSV file (Mark Gibbs) |
| 46 |
+ Add to Data Projects |
| 47 |
+ The need is to import data from CSV in a shared table by different users (Robert) |
| 48 |
+ For non-admin users |
| 49 |
+ Add logging |
| 50 |
+ Add auto mapping (match column names | case (in)sensitve | exact) |
| 51 |
+ Use google maps json style declaration |
| 52 |
https://developers.google.com/maps/documentation/javascript/styling#specifying_styles_to_features |
| 53 |
+ Improve Code Manager hints in PHP, JSON, HTML and JS editor (like SQL editor) |
| 54 |
+ Add content editor support for TEXT columns (editor.js?) |
| 55 |
|
| 56 |
*** REQUEST *** |
| 57 |
|
| 58 |
+ Store image via Data Project in blob or on file system? (Lukasz) |
| 59 |
|
| 60 |
*** BUGS *** |
| 61 |
|
| 62 |
+ After updating a table design the user (sometimes) has to reconcile to reflect the real database table structure |
| 63 |
+ Recreate repository not working as expected on WordPress multisite |
| 64 |
+ Cannot not use Screen Options for child tables when having more than one child tabs |
| 65 |
+ Data Project pages not editable when a remote host is down (solution: use ajax to fill listboxes; does this apply to other plugin pages as well?) |
| 66 |
+ After adding new parent the child tab is not directly shown (Sebastian) |
| 67 |
|
| 68 |
*** LONG TERM IMPROVEMENTS *** |
| 69 |
|
| 70 |
+ Copy project page (Gaetan) |
| 71 |
+ Remove all schema and table names from all/get requests |
| 72 |
+ Problem exporting large table (Tony) |
| 73 |
Fatal error: Allowed memory size of 805306368 bytes exhausted (tried |
| 74 |
> to allocate 20480 bytes) in |
| 75 |
> /home/customer/www/leecountyhgs.org/public_html/wp-includes/wp-db.php |
| 76 |
> on line 2720 |
| 77 |
+ Allow to export all rows from a Data Projects page (Manivannan ) |
| 78 |
+ Support Classic Press? (Pauhana) |
| 79 |
|
| 80 |
*** WORK IN PROGRESS *** |
| 81 |
|
| 82 |
+ Priority |
| 83 |
+ Add default values to Data Forms |
| 84 |
+ Make a field read-only (Forum: rvwill48) |
| 85 |
+ Add option to disable search in Data Projects (Jim Hunter) |
| 86 |
+ Use WordPress|plugin date format in Data Publisher and Data Forms (Joseph + Barbara + Kennie) |
| 87 |
+ Improve autocomplete in Data Forms |
| 88 |
+ Geolocation > update location info on update/insert |
| 89 |
+ In data Explorer, Manage, search columns, you cannot enable search check box if the column name has a space in it. The update does not change anything. (Charles) |
| 90 |
+ Earlier I reported that Data Explorer->Manage->settings->search settings hung if there was a space in the column name. |
| 91 |
Today we learned that the same thing happens if there is a ’-‘ in the table name. For example catalogue-1r2 failed/hung but a rename to catalogue_1r2 worked just fine. |
| 92 |
|
| 93 |
+ Requests |
| 94 |
+ Map to multiple tables (Carl) |
| 95 |
+ Data backup to CSV (@kfedorov) |
| 96 |
+ Listboxes individual search not using lookup (if applicable) (Alex) |
| 97 |
+ Allow users to add lookup values to non SQL exports in a Data Project (Kennie) |
| 98 |
+ Define "No search result = show no rows" per page (Charles) |
| 99 |
+ Is it possible to support relationships for view in project templates? (Steve) |
| 100 |
+ Allow to add (1:n | n:m) relationships over multiple databases (Jeremy Gadd) |
| 101 |
+ Make column name available in Data Publisher - for example function fnRowCallback (Cory - https://wpdataaccess.com/docs/documentation/plugin-settings/plugin/#comment-473) |
| 102 |
+ Add WordPress user info to WPDADB connection (connect + reuse) |
| 103 |
+ Add bulk edit support (Luis) |
| 104 |
|
| 105 |
+ Improvements |
| 106 |
+ Replace checks table|column exists with backticks (to improve performance) |
| 107 |
+ Check for spaces and escape chars when converting schema, table and column names (JS does not support these character in IDs) |
| 108 |
+ Check for wrong usage of schema_name (when used from WPDADB > use $wpdadb->dbname) |
| 109 |
+ Isset - multiple at once |
| 110 |
+ Add jQuery UI to publications |
| 111 |
+ Update date picker to jQuery UI date picker |
| 112 |
+ Move icon to first column for publications with buttons |
| 113 |
+ Show only selected tables in Data Publisher for non admin users |
| 114 |
|
| 115 |
+ Data Forms |
| 116 |
+ LOV > unselect previously selected rows when popup is opened repeatively |
| 117 |
+ Add custom button support |
| 118 |
+ Add data import |
| 119 |
+ The date format is YYYY-mm-dd no matter what is defined in the wp data access settings (Barbara) |
| 120 |
+ Add advanced customizing |
| 121 |
+ jQuery DataTables > options |
| 122 |
+ Is there a possibility to change the database symbol at the end of a row? (Barbara) |
| 123 |
+ Angular > extend controller |
| 124 |
+ Check min|max on tinyint|smallint|mediumint|int|bigint not correct |
| 125 |
|
| 126 |
+ Documentation |
| 127 |
+ Default database schema per user |
| 128 |
+ Filter option Data Projects |
| 129 |
+ Default order by Data Projects |
| 130 |
+ Video tutorial Data Forms |
| 131 |
+ Video tutorial add Export buttons to publication |
| 132 |
|
| 133 |
+ Ideas |
| 134 |
+ Add PHP logger |
| 135 |
|
| 136 |
--- |
| 137 |
|
| 138 |
+ Add premium videos |
| 139 |
+ Advanced search (multiple) |
| 140 |
+ Inline editing |
| 141 |
+ Data Publisher |
| 142 |
+ Adding buttons |
| 143 |
+ Adding filters > add premium search |
| 144 |
+ Data Projects |
| 145 |
+ Adding filters |
| 146 |
+ Adding inline editing |
| 147 |
+ Data Forms |
| 148 |
+ Update existing videos (how to use Project Templates) |
| 149 |
+ Add videos to documentation |
| 150 |
+ Data Backup tool |
| 151 |
+ Data Explorer |
| 152 |
+ Data Designer |
| 153 |
+ Data Menus |
| 154 |
|
| 155 |
+ Improve demos (show possibilities - premium + code manager) |
| 156 |
+ Offer apps (FAQ, SAS, BAS) |
| 157 |
|
| 158 |
+ Add support for computed columns (allow to use videos/images in slider/carousel from multiple media columns) |
| 159 |
+ Add premium forms builder (dataforms, inline forms?) |
| 160 |
+ Add premium report builder (list + single row display, both responsive) |
| 161 |
|
| 162 |
+ Update documentation |
| 163 |
+ Update readme (add premium features) |
| 164 |
+ Update screenshots |
| 165 |
|
| 166 |
+ Add media library to front-end (Nick) |
| 167 |
+ Built layer around wpdb class to limit dcl, ddl and some dml access to admin users only |
| 168 |
+ Load attachment in TEXT column to allow full-text indexing |
| 169 |
+ Add remove remote database connection to documentation |
| 170 |
+ Add Export to PDF to publication (support forum Danielle) |
| 171 |
+ Add setting: allow only add existing + delete relationship on child tables for n:m relationship (Mieke) |
| 172 |
+ Make parent readonly and child editable (forum support - larryhines) |
| 173 |
+ Is it possible to add data to the relationship table in a n:m relationship (Michiel) |
| 174 |
+ Use parent column value in child default where (forum support - bb-4) |
| 175 |
+ Edit set with checkboxes instead of multi line listbox (Michiel) |
| 176 |
+ Overwrite media in WordPress media library (Michiel) |
| 177 |
|
| 178 |
+ Showing child rows in edit mode (single child with back-next buttons) (vincent) |
| 179 |
+ Add forward/backward buttons to data entry forms related to selection in Data Explorer (form post #12275882 - dizwell) |
| 180 |
|
| 181 |
+ Create unique element IDs for parent and child tables having the same column name |
| 182 |
+ Capitalize text input (Wolter) |
| 183 |
+ Change recreate repository button/action to repair repository |
| 184 |
+ Allow to export view data from bulk actions menu (forum support #12131944 - dsbking) |
| 185 |
+ Add awesome video tutorials on how to create a scheduled export (comment nacho) |
| 186 |
|
| 187 |
*** RESEACRH *** |
| 188 |
|
| 189 |
+ Use custom posts in a Data Project |
| 190 |
+ Complex registration page (parent-child) |
| 191 |
+ View building (including unique row identification) |
| 192 |
+ Add new entry to lookup (Chiara) |
| 193 |
+ Perform searching and sorting with ajax WPDA_List_Table (forum support #12470588 - sarveon) |
| 194 |
|
| 195 |
*** NEXT & FEATURE REQUESTS *** |
| 196 |
|
| 197 |
+ Search on date column (from-to) (forum: georg2791 - #12490607) |
| 198 |
+ Display multiple lookup columns |
| 199 |
+ Implement foreign keys in Data Designer |
| 200 |
+ Implement compare in Data Designer |
| 201 |
+ Use GET and POST vars (old and new) in default where (form post #12232151 - khansadi) |
| 202 |
+ Add media to export for media columns |
| 203 |
+ Disable edit mode for parent and enable mode for child (form post #11889053 - wpsd2006) |
| 204 |
+ Nested lookup in ADD and EDIT page (review wmuskie) already done??? |
| 205 |
+ Number field formatting |
| 206 |
+ Display a float number with 2 decimal places, or no decimal places etc. |
| 207 |
+ For extra credit a way to display the integer 305623456 as 305-62-3456 |
| 208 |
+ A way to display leading 0s so 123 would display as 000123 |
| 209 |
+ Field formatting e.g. phone number, credit card (review wmuskie) |
| 210 |
+ Create and modify views (support forum #11907073 - @Gbade) |
| 211 |
+ Backup data to Google Drive and OneDrive |
| 212 |
+ Improve table availability check on menu construction |
| 213 |
+ Export posts related to static pages in data projects (id + author) |
| 214 |
+ Is it possible to add grid editing with DataTables as an add-on? (YES) (forum post #11660769) |
| 215 |
|
