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 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (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.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



Form Tools
Importing Data - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Importing Data (/showthread.php?tid=124)

Importing Data - Maverick - Apr 22nd, 2009

I have just changed servers and I have found your great software. I have got everything running just the way I want. I have downloaded the last database I had into excel about 200 entries is there an easy way to import the data from this into my new form database. I have looked all over the forum but I can't see any answers relating to this. Or is it just a stupid question?

RE: Importing Data - Ben - Apr 22nd, 2009

Hey Maverick,

No - not a stupid question at all. I've encountered this scenario myself several times.

I've sketched out an "Import Manager" module that will do exactly this: import data from different formats, but it's still far from being complete. I'm afraid that your best bet would be to export it as a CSV and write a script to convert the rows into SQL queries. A drag? Yup.

It's possible there's some other scripts out there that may do this too.

Sorry I couldn't be more help!

- Ben

RE: Importing Data - Maverick - Apr 23rd, 2009

(Apr 22nd, 2009, 11:32 AM)Ben Wrote: Hey Maverick,

No - not a stupid question at all. I've encountered this scenario myself several times.

I've sketched out an "Import Manager" module that will do exactly this: import data from different formats, but it's still far from being complete. I'm afraid that your best bet would be to export it as a CSV and write a script to convert the rows into SQL queries. A drag? Yup.

It's possible there's some other scripts out there that may do this too.

Sorry I couldn't be more help!

- Ben

Thanks for your reply, with no-one bringing up the subject before, I thought it wouldn't be that easy. Please continue with the good work, as I said before, great product!

RE: Importing Data - mpmonty - Jul 26th, 2010

Hi Ben any updates on this? I was able to import into my database with phpmyadmin and I can view them in the table there but cannot get them to show up in any views on my formtools?