logo Calflora Organization Options  HELP
Purpose

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.

 
CREW
ROLES
ACTIVITIES
BILLING CODES
CHEMICALS
SEARCHES
COLUMN SETS
EXPORT
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:

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;
and an orgcrew.dat file that looks something like this:
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.


RELEASE NOTES:

• July, 2017:   v. 0.55: Includes the EXPORT tab.