Re: [UrbanSim-Users] getting the simulation to use MySQL

Hi Rick,

Sorry to hear that you're having difficulty with the documentation not
matching the codebase.

Did you use the windows installer to setup UrbanSim? If so, I think that
you may be using the latest development version of UrbanSim code (which
the installer installs); unfortunately, in the current development
version, the Eugene tutorial's tools are in the process of being
migrated to another GUI toolkit, which is why those tools do not exist.
This problem stems from an oversight on my part: the self-installer
should not be linked to yet on the windows installation pages.

If this is the case, you have two options: (1) reinstall UrbanSim using
the non-self-installer option from
http://www.urbansim.org/docs/installation/windows_install.html and then
retry the Eugene tutorial; (2) use your current installation whose
codebase is ahead of the documentation in some parts. If you decide for
(2), you should be able to get the Eugene cache into your mysql database
by running the following script (w/ command line arguments):
opus_core/tools/do_export_cache_to_sql_database.py --cache_path [path to
simulation results] --database_name [desired name of resulting database].

Hope that helps.
Travis

Rick wrote:
> I have MySQL set up and running.
> I have the User variables set in Windows as described in this document:
> http://www.urbansim.org/opus/stable-releases/opus-2006-11-21/docs/windows_install.html
> <http://www.urbansim.org/opus/stable-releases/opus-2006-11-21/docs/windows_install.html>
>
> Some of the tools referred to by documentation do exist, such as
> create_indicator.py
> and
> run_simulation_on_baseyear_cache.py
>
> but others, such as
> export_cache_to_mysql.py
> do not exist in my installation.
>
> My long term goal is to put custom events into a MySQL database and have
> the OPUS/urbansim software use the MySQL, but for the moment, I'd be
> happy if I could even get the OPUS/urbansim software to even export data
> to the MySQL database.
>
> I don't know how to get the simulation software to use the database.
>
> If anyone can advise me on how to do this, I'd appreciate it.
> Thanks in advance.
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users_at_urbansim.org
> http://www.urbansim.org/mailman/listinfo/users
Received on Sun Dec 09 2007 - 15:39:19 PST