I am new to phpwebsite as well as mysql. My question is:
Is there a simple way to mass upload a series of events into the calendar?
Can I go from excel into the database etc.
Any help or tips would be greatly appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I haven't tried, so I'm doing a little guessing here, but using something like phpMyAdmin (a php/browser-based admin front end to your db) you should be able to mass upload a flat file, exported from excel. You would have to be carefull that the excel columns were in the right order first and maybe for safety, pass the exported file through something like BBEdit (a MacOS app) or some equivalent plain text editer to be sure excel didn't include any extraneous quotes and stuff.
I've done this with other CMS systems and it is a LOT faster. It could take a little trial and error but would be worth it if you have a lot of data.
best luck!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-06-17
Well, I finally did figure out how to do it. Thanks for the help. I used a program called mysqlstudio
Anyway my next questions is. Now that I have uploaded all the data, everything is working fine but my Search Function. When I go into try a search I get the following error.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /public_html/mod/weblink/weblink_functions.php on line 974
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /public_html/mod/weblink/weblink_functions.php on line 975
Any help? thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am new to phpwebsite as well as mysql. My question is:
Is there a simple way to mass upload a series of events into the calendar?
Can I go from excel into the database etc.
Any help or tips would be greatly appreciated.
I haven't tried, so I'm doing a little guessing here, but using something like phpMyAdmin (a php/browser-based admin front end to your db) you should be able to mass upload a flat file, exported from excel. You would have to be carefull that the excel columns were in the right order first and maybe for safety, pass the exported file through something like BBEdit (a MacOS app) or some equivalent plain text editer to be sure excel didn't include any extraneous quotes and stuff.
I've done this with other CMS systems and it is a LOT faster. It could take a little trial and error but would be worth it if you have a lot of data.
best luck!
Well, I finally did figure out how to do it. Thanks for the help. I used a program called mysqlstudio
http://www.mysqlstudio.com/
Lots of functions I love it.
Anyway my next questions is. Now that I have uploaded all the data, everything is working fine but my Search Function. When I go into try a search I get the following error.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /public_html/mod/weblink/weblink_functions.php on line 974
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /public_html/mod/weblink/weblink_functions.php on line 975
Any help? thanks