With the Organization Options application you can edit various datasets that support your organization's use of Weed Manager. Each dataset is available in a tab within this application.
Use this tab when you want to export your organization's data from Calfora
and load it into another copy of the MySQL database.
Check the tables you are interested in, and press . For each table you checked, the definition of the table will be extracted into a .sql file, and the data for your organization will be extracted into a .dat file. All of the extracted files will be archived into a .zip file, which is then downloaded to your desktop.
As an example, suppose you checked the Crew table. Then the .zip file will contain an orgcrew.sql file that looks like this:
and an orgcrew.dat file that looks something like this:
CREATE TABLE `orgcrew` ( `rid` int(11) NOT NULL AUTO_INCREMENT, `gid` int(11) NOT NULL, `name` varchar(48) NOT NULL, `wrole` varchar(36) NOT NULL, PRIMARY KEY (`rid`), KEY `orgcrew_gid` (`gid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
213|52|Ralph Gibsion|Full-time staff 214|52|Chris Wheelery|Part-time staff 215|52|Letitia Slighcarp|Seasonal staff 216|52|Janella Brisket|Seasonal staff 217|52|AAAAA Landscaping|Contractor
To use these files with a local copy of MySQL, you would define the table, and then load the data into the table as follows:
$ mysql -p LocalDataBaseName < orgcrew.sql $ mysql -p LocalDataBaseName mysql> load data local infile 'orgcrew.dat' into table orgcrew fields terminated by '|';
If you check a table, but your organization does not have any data in that table, it will not be incuded in the .zip file. If you ask for the Activities + Billing Codes table, it will be called orgsds in the .zip file.
July, 2017: v. 0.55: Includes the EXPORT tab.