The following warnings occurred:

Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (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.31 (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.31 (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.31 (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.31 (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.31 (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 "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error

Import Excel - Printable Version +- Form Tools (https://forums.formtools.org) +-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8) +--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16) +--- Thread: Import Excel (/showthread.php?tid=4789)

Import Excel - chillifish - Nov 18th, 2014 I've been searching the modules, but I don't think what I want to do is possible with current available modules. My client wants to export the database to Excel, modify it, then re-import. Is this achievable? RE: Import Excel - Joe - Dec 9th, 2014 Sorry, you won't be able to import an Excel Spreadsheet back into Form Tools. Cheers, Joe RE: Import Excel - Sir-Win - Jan 30th, 2017 FYI you can import a CSV file into the formtools db via phpMyAdmin as I have done when moving around data from other sources into formtools. Could even create an upload and execute page if you're into a bit of hard coding! RE: Import Excel - Kayzer - Jul 26th, 2017 Can you recommend a fast way to import data into formtools db from excell or csv file? RE: Import Excel - nelsondcosta - Jul 31st, 2017 Use phpmyadmin to import CVS file, may not work as you wish. So test before do a final import. RE: Import Excel - nelsondcosta - Aug 22nd, 2017 I imported 140.000 rows with 100% sucess. 1- compile everything in your EXCEL, dont forget to organize eveything in the same order of your DB 2- convert to CSV using - > https://convertio.co/pt/xls-csv/ (tested) 3- upload using phpmyadmin I tested excel to convert and others ways, this one was the best to import mass information. RE: Import Excel - paullittrell - Aug 31st, 2017 Just be careful of your date formatting as Excel has a history of messing them up when you save as csv. I tend to save as Unicode text right from Excel and import as tab delimited. Another advantage of Unicode, is that it eliminates the utf-8 error that sometimes occurs when importing foreign names.