Activity for Fernando Pérez Rodríguez
-
Fernando Pérez Rodríguez posted a comment on discussion Field evaluations
Pin Test Table example: CREATE TABLE IF NOT EXISTS `Pin_test` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `CellsWithRemains` int(5) DEFAULT '0', `UnopenedSealedCell` int(5) DEFAULT '0', `colony_info_ID` int(11) NOT NULL, PRIMARY KEY (`ID`), KEY `colony_info_ID` (`colony_info_ID`), CONSTRAINT `ced_st_fk` FOREIGN KEY (`colony_info_ID`) REFERENCES `colonies` (`colony_info_ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
Set of Database Relationship Rules (DRR) and Database Operational Rules (DOR) considered in the architecture of the generic database. Name | Name DRR1 | One apiary can have an infinite number of colonies DRR2 | One colony can fit into an infinite number of hives' elements DRR3 | One colony can be moved between apiaries in different time periods DRR4 | One hive can be moved between colonies in different time periods DOR1 | Every activity (evaluation or management) in the apiary must be registered...
-
This evaluation is related with colony level. The direct relationship with foreign key colony_info_ID gives information of where and when this evaluation have done. If you need create new evaluation at colony level, please see the generic code in files section for this level. Code example: CREATE TABLE IF NOT EXISTS `colonystate_queen` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Eggs` tinyint(1) DEFAULT '0', `Larvae` tinyint(1) DEFAULT '0', `Pupae` tinyint(1) DEFAULT '0', `Queen` varchar(10), `LayingWorker`...
-
This evaluation fields is related to colony level, so is directly link with the foreing key colony_info_ID. This store information like if a colony has Varroa, Deformed wing bee, etc. This variables ar declared as tinyint (or boolean). You can add more variables if you want, or create new evaluation field table related to colony level (see the code in files section) Code example: CREATE TABLE IF NOT EXISTS `deseases` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Varroa` tinyint(1) DEFAULT '0', `Deformed_Wing_Bee`...
-
The hive evaluation data is related to count, for example, items in esctructural elements. For example counter of bees, weight of honey, etc. This kind of tables are direct linked with Hive_info_ID foreing key, makig direct relationship with the chronological data associated to each evaluation. Code example: CREATE TABLE `hive_evaluation_data` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ElementID` int(1) NOT NULL, `Hive_info_ID` int(11) NOT NULL, `Frame` int(3) DEFAULT '0', `BeesFront` int(3) DEFAULT...
-
This evaluation fields is related to colony level, so is directly link with the foreing key colony_info_ID. This store information like if a colony has Varroa, Deformed wing bee, etc. This variables ar declared as tinyint (or boolean). You can add more variables if you want, or create new evaluation field table related to colony level (see the code in files section) CREATE TABLE IF NOT EXISTS `deseases` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Varroa` tinyint(1) DEFAULT '0', `Deformed_Wing_Bee` tinyint(1)...
-
This evaluation is related with colony level. The direct relationship with foreign key colony_info_ID gives information of where and when this evaluation have done. If you need create new evaluation at colony level, please see the generic code in files section for this level. -- CREATE TABLE IF NOT EXISTS `colonystate_queen` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Eggs` tinyint(1) DEFAULT '0', `Larvae` tinyint(1) DEFAULT '0', `Pupae` tinyint(1) DEFAULT '0', `Queen` varchar(10), `LayingWorker` tinyint(1)...
-
Data-Bee is an Open Source database scheme for chronological data storing based on apiaries system abstraction. The Data-Bee philosophy and main goal are to share the model, opening the possibility of change it or improve it. This discussion section is the windows to share the improvements or utilities.
-
Data-Bee is an Open-Source project to share chronologinal database scheme based on the abstarction of apiaries systems. The code is provided as sql script to run in MySQL (see the files section in this repository). If you doesn't have mysql installed, your first step is go to https://dev.mysql.com/downloads/ and install the MySQL Community Server. The workbench is an IDE to work with databases in MySQL. Here is posible to configure new conection and run sql script and manage data. To learn more about...
-
The index controller get all the information needed and set the View variable to send the web page to the client. The Index controller was developed as follows: public ActionResult Index(int langid = 1) { //Help strings Text Text_ = new Text (); ViewBag.Texto = Text_.textMainMenu(langid); ViewBag.Labels = Text_.textEtMenu(langid); ViewBag.Lang = Text_.textLang(); ViewBag.langid = langid; return View(); } Here, the controller call to the Text Model to get all the web page strings as (Text) that is...
-
The index controller get all the information needed and set the View variable to send the web page to the client. The Index controller was developed as follows: public ActionResult Index(int langid = 1) { //Help strings Text Text_ = new Text (); ViewBag.Texto = Text_.textMainMenu(langid); ViewBag.Labels = Text_.textEtMenu(langid); ViewBag.Lang = Text_.textLang(); ViewBag.langid = langid; return View(); } Here, the controller call to the Text Model to get all the web page strings as (Text) that is...
-
The models implemented in ForestMTIS helps to develop a generic tool, for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in the server directory. The model read each text line and set the text in his position. Change the text in particular .txt, change the text in the web page consecuently. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of...
-
The models implemented in ForestMTIS helps to develop a generic tool, for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in the server directory. The model read each text line and set the text in his position. Change the text in particular .txt, change the text in the web page consecuently. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of...
-
ForestMTIS is compiling under windows environment. The tool compilation is a set of folders and files properly of ASP.net project. This needs an interpreter to publish it online like IIS. This IIS or Internet Information System is a tool for Windows (see more information here. This IIS setup read a particular folder that contains the ForestMTIS compiled folder and publish it using particular computer port defined by the user. Here is need fixed IP. For more information we recoment read next tuto...
-
Starting to modify the dll of dynamic growth models. The first step is download the dynamic growth model project. To open it Visual Studio IDE or similar IDEs like SharpDevelop is needed to edit the code. When the project is open, it is structured as follows: Directives used: using System; using System.Collections.Generic; The library has been designed to allow at least three dynamic models. The information could be separate in four sections: i) Dynamic Growth Model (1 - 3), ii) Individual tree equations...
-
The models implemented in ForestMTIS helps to develop a generic tool, for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in the server directory. The model read each text line and set the text in his position. Change the text in particular .txt, change the text in the web page consecuently. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of...
-
The models implemented in ForestMTIS helps to develop a generic tool for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in server directory. The model read each text line and set the text in his possition. Change the text in particular .txt, change the text in the web page consecuently. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of each...
-
The models implemented in ForestMTIS helps to develop a generic tool for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in server directory. The model read each text line and set the text in his possition. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of each view send it as viewbag. public List<string> textMainMenu(int langid) { List<string>...
-
The models implemented in ForestMTIS helps to develop a generic tool for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in server directory. The model read each text line and set the text in his possition. public class Text { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of each view send it as viewbag. public List<string> textMainMenu(int langid) { List<string>...
-
The models implemented in ForestMTIS helps to develop a generic tool for example to integrate the user texts to each web application page. The procedure works reading a .txt file placed in server directory. The model read each text line and set the text in his possition. public class Texto { //read the text lines of *.txt files to each web page section. The model retur the lists of strings and the the controler of each view send it as viewbag. public List<string> textoMainMenu(int langid) { List<string>...
-
Starting to modify the dll of dynamic growth models. The first step is download the dinamic growth model project. To open it Visual Studio IDE or similar IDEs like SharpDevelop is needed to edit the code. When the project is open, it is structured as follows: Directives used: using System; using System.Collections.Generic; The library have been designed to allow at least three dinamic models. The information could be separate in four sections: i) Dynamic Growth Model (1 - 3) , ii) Individual tree...
-
Starting to modify the dll of dynamic growth models. The first step is download the dinamic growth model project. To open it Visual Studio IDE or similar IDEs like SharpDevelop is needed to edit the code. When the project is open, it is structured as follows: Directives used: using System; using System.Collections.Generic; The library have been designed to allow at least three dinamic models. The information could be separate in four sections: i) Dynamic Growth Model (1 - 3) , ii) Individual tree...
-
Starting to modify the dll of dynamic growth models. The first step is download the dinamic growth model project. To open it Visual Studio IDE or similar IDEs like SharpDevelop is needed to edit the code. When the project is open, it is structured as follows: Directives used: using System; using System.Collections.Generic; The library have been designed to allow at least three dinamic models. The information could be separate in four sections: i) Dynamic Growth Model (1 - 3) , ii) Individual tree...
-
El proyecto y el aplicativo han sido actualizados para solucionar el problema derivado de la no aceptación de los permisos para leer y guardar en la memoria del terminal. En este caso, la aplicación al no dar privilegios a la app, esta provocaba un error en la rutina para compartir los datos de una simulación. Este problema se ha solucionado desactivando la opción para compartir los resultados en el caso de que no se le den privilegios para ello, sin dejar que se pueda seguir utilizando la app correctamente....
-
ESTRUCTURA DE UN MODELO DINÁMICO
-
Se han implementado procedimientos para poder compartir los resultados vía Email y redes sociales. Para ello se convierte la tabla en un bitmap que se adjunta a un texto donde se describen las variables de entrada utilizadas para la obtención de los resultados. Este último texto no aparece al compartir la tabla en Facebook, ya que esta red social no admite el procedimiento "Intent.EXTRA_TEXT". En sucesivas mejoras se tratará de resolver este contratiempo. Esta mejora puede ser incompatible con versiones...
-
Se han implementado procedimientos para poder compartir los resultados vía Email y redes sociales. Para ello se convierte la tabla en un bitmap que se adjunta a un texto donde se describen las variables de entrada utilizadas para la obtención de los resultados. Este último texto no aparece al compartir la tabla en Facebook, ya que esta red social no admite el procedimiento "Intent.EXTRA_TEXT". En sucesivas mejoras se tratará de resolver este contratiempo.
-
En este espacio se describen las mejoras que se han desarrollado.
-
El proyecto y la aplicación han sido recientemente actualizadas para resolver ciertos problemas de cierres inesperados. El más importante ha sido derivado de que la primera aplicación generada tenía selector de idioma, sin dependencia de las opciones generales del dispositivo donde se instalaba. Actualmente el idioma se obtiene de la configuración global del dispositivo y se leen los ficheros de valor para cada idioma. Esto supone la ventaja de que se aligera notablemente el código, sin embargo posee...
-
En esta linea se introducirán las soluciones a los errores que van apareciendo.
-
MODELOS DINÁMICOS
-
Necesidad de transferencia: De la investigación al gestor forestal
-
Modificación de las ecuaciones del modelo dinámico forestal. El modelo dinámico que utiliza el aplicativo ApkFor son una seria de ecuaciones que relacionan ciertas variables "difíciles de medir" con otras que son de "fácil medición". Estas ecuaciones se obtienen de diferentes inventarios realizados en años consecutivos o con cierta frecuencia. Así pues, estos modelos suelen estar restringidos al área o región en donde son realizados estos inventarios. La filosofía Open-Source del proyecto ApkFor,...
-
ApkFor 1.0 Manual de usuario Autores: FERNANDO PÉREZ RODRÍGUEZ MARÍA MENÉNDEZ MIGUÉLEZ Resumen La evolución en el desarrollo de aplicaciones informáticas para el uso en gestión forestal se hace patente en la actualidad con numerosos ejemplos. Dichos ejemplos se pueden dividir en dos grandes grupos: los desarrollos de escritorio y los desarrollos en la nube. Sin embargo, pese a los avances informáticos, todavía sigue existiendo una limitación a la hora de establecer una conexión a un aplicativo OnCloud...
1
