The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Grid insert - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Form Tools 3 alpha (https://forums.formtools.org/forumdisplay.php?fid=21)
+--- Thread: Grid insert (/showthread.php?tid=30713)



Grid insert - MosheYossef - Feb 28th, 2018

Hi all,
I have tried to implement form tools in the past, for something that became unnecessary eventually.
A new requirement came up that I am looking for a simple solution to.
Here is the scenario:
I am designing data warehouses for organizations, that often end up adding data to the data warehouse using some kind of excel file, which I then load using SSIS.
These files, while very easily edited, are a big hassle for loading into the DWH - because it is extremely easy to mess them up - add a column, insert text where a number is expected, change column header, etc.


I am looking for a solution that can replace the excel as my data source (for that matter, Form tools writes into mySQL which can easily be read using OLEDB), and in the same time, maintain an excel-like user experience - mostly referring to the grid UI.

so basically, i need an app that could show a grid on a screen. that grid contains rows and columns, that maintain the basic rules of the table - data types, limited input options, foreign keys etc, enable a user to scroll through to a row that he wishes to edit, and edit it as he wishes.
It should also allow users to copy and paste data from excel into the target, yet prevent illegal input - preferably ending it with a break of all data entry.

Do you think Form Tools can support this kind of functionality?

Thank you
Moshe