{{indexmenu_n>1}} ====== XOneStudio 4.0 ====== \\ **XOne Studio** is a development tool used to support programmers, that is, it is an Integrated Development Environment (IDE) that allows to program, modify or distribute the applications developed in XOne in a simple, fast and efficient way.\\ **XOne Studio** gets that with help in the programming and with the templates offered to the new or experienced developers, practically no great knowledge of the device is needed, nor of the database where the system is being created. \\ That way, a programmer can consume unthinkable times in the construction or expansion of modules, considerably reducing the programming time..\\ The wide scalability of this solution, totally modulated, allows starting with pilot project of scarce complexity and transform them into very finished and versatile products. \\ ====== FOLDERS STRUCTURE. Way of working with XOneStudio 4.0 ====== ==== Folders Structure ==== \\ Inside the root folder of the project we will have folders and new files that we did not have in the previous version: \\ \\ {{ :f.-herramientas:f01.-xonestudio:carpeta1.png |}}\\ \\ \\ {{ :f.-herramientas:f01.-xonestudio:carpeta2.png |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:carpeta3.png |}}\\ \\ \\ {{ :f.-herramientas:f01.-xonestudio:carpeta4.png |}}\\ \\ \\ ==== Structure inside the XOneStudio ==== \\ In this section we will explain the new way of working with the new **XOneStudio**.\\ \\ This new way of working is based in the partition of the //mappings// by collection, por colecciones, which makes it easier to work since we will only have on screen the collection which we are working with.\\ \\ See examples: Figure 1.5 and Figure 1.6 \\ {{ :f.-herramientas:f01.-xonestudio:carpeta5.png |}}\\ \\ Besides, we will count on some similar features for the __functions and the CSS.__ \\ \\ See examples: Figure 1.7 and Figure 1.8 respectively \\ {{ :f.-herramientas:f01.-xonestudio:carpeta6.png |}}\\ \\ By last, we will count on a files explorer which will show us the files existing in the folder of the project. \\ \\ In this listing of files we will see, we have the **mappings and mappignsV2**, as in the new way of working of the **XOneStudio** it is not worked with the //mappings// file totally, these files **ONLY** will be opened into **read mode** and it won´t count with any of the new features of the new **XOneStudio**. \\ \\ See example: Figure 1.9 \\ {{ :f.-herramientas:f01.-xonestudio:carpeta7.png |}} ===== MAIN MENU ===== \\ In the following image we can see the start screen we will have once we access to the development tool **XOne Studio**: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen1.png?900 |}}\\ \\ The following image shows us the screen we will get once we open the project we want which we are going to work with: we will see that the main screen is divided into several windows:\\ \\ __The first window__ (following order from left to right) is the window corresponding to the **files explorer** where we see all the files, collections, files... which our project has.\\ __The second window__ is the **home page**, where we could open the project, files, creating a new project... \\ __The third window__ is the **text editor**, here is where we can see the XML edition codes.\\ __The fourth window__ is where we visualize the **designer, toolbox and properties**. \\ __The last window__ that we can see is placed on the bottom place and it corresponds to the **errors list, to the searching list, and to the messages console**. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen2.png?900 |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagen3.png?900 |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagenprincipal2.png |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagenprincipal3.png |}}\\ \\ At the top of the screen of the **MEIN MENU** of the **XOneStudio** we can find a **Tools bar** with a series of tabs containing the main functions of the development tool, these tabs are:\\ - **FILE** - **SEE** - **TOOLS** - **DATABASE** - **PUBLISH** - **HELP** \\ {{:f.-herramientas:f01.-xonestudio:imagen4.png?700|}} \\ Next, we will see in more detail the functionalities of each one of these main tabs.\\ \\ \\ ===== FILE===== \\ This tab is the menu which assign the core functions for the management of the project´s documents, that means, the administrative part of it. \\ By clicking into this, it will show a drop-down menu with the following functions: \\ \\ * **New project** * **Open project** * **Open file** * **Close project** * **Save** * **Close** * **Recent files** \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen5.png |}} \\ \\ ==== New project ==== \\ If we click into this function, a **box** with some fields to fulfill it will be shown, such as **project´s name, path, review** and finally the **ACCEPT and CANCEL** buttons: \\ \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen_6.png |}} \\ If we click into the **REVIEW** button, the following searching screen will be shown, in order to select the path where we want to save the new project, or creating a new folder:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen7.png |}} \\ \\ ==== Open a project ==== \\ By clicking on this function all the files of the program will be opened in order to examine the different files and project and from hiere we will be able to open the file of the project we want to: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen8.png |}} \\ When opening a specific project, we will see all the data of it, such as the files it contains, the databases, the list of errors, the different sources, functions, icons, ... etc: \\ {{ :f.-herramientas:f01.-xonestudio:imagen9.png |}} \\ \\ ==== Opening File ==== \\ This function will allow opening the file of the project we want to. \\ \\ ==== Closing Project ==== \\ It is a function to close the project which we are working with. \\ \\ ==== Saving ==== \\ It is a function to record and save all the changes we have entered. \\ \\ ==== Closing==== \\ It is a function to close the project and exit from the **XOne Studio** app. \\ \\ ==== Recents Files ==== \\ It shows the record of the all the recents files we have openened. \\ \\ \\ ===== VIEW ===== \\ The drop-down menu shown if we click into the “**VIEW**” tab has all the controls related to the different options of visualization of the tools which we are going ot work with, if we click into the drop-down menu the controls it counts on will be openend, these controls are: \\ \\ * **Home page** * **Tools bar** * **Properties** * **Files explorer** * **Collections explorer** * **Designer** * **Errors list** * **Searching list** * **Messages console** * **Document outline** * **Mappings structure** \\ {{ :f.-herramientas:f01.-xonestudio:imagen10.png |}} \\ \\ ==== Home Page ==== \\ By clicking on this function, the XOneStudio home page will be opened with different files such as: \\ \\ **INDEX**, in which we will have the **New project, Open project, Turn into project, Open file** actions. \\ **RECENTS**, where we will have a list with the recents projects we have opened. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen11.png |}} \\ \\ ==== Tools Bar ==== \\ **__Toolbox__**: Are the common controls that the **XOne** technology provides to the developers, such as tags, text, video, picture, frames…\\ This box can be moved and it allows dragging all the controls we want to our app in order to include them in it:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen12.png |}} \\ The **Tools Bar** is made of a series of action buttons, such as:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen13.png |}} \\ \\ **The buttons will be explained in detail below, in the following icons box**: \\ ==== ICONS ==== \\ \\ ^ ICON ^ **FUNCTION** ^ | {{ :f.-herramientas:f01.-xonestudio:icono1.png |}} |New File| | {{ :f.-herramientas:f01.-xonestudio:icono2.png |}} |Open File| | {{ :f.-herramientas:f01.-xonestudio:icono3.png |}} |Save| | {{ :f.-herramientas:f01.-xonestudio:icono4.png |}} |Save All| | {{ :f.-herramientas:f01.-xonestudio:icono5.png |}} |Copy| | {{ :f.-herramientas:f01.-xonestudio:icono6.png |}} |Cut| | {{ :f.-herramientas:f01.-xonestudio:icono7.png |}} |Paste| | {{ :f.-herramientas:f01.-xonestudio:icono8.png |}} |Previous| | {{ :f.-herramientas:f01.-xonestudio:icono9.png |}} |Next| | {{ :f.-herramientas:f01.-xonestudio:icono10.png |}} |Expand| | {{ :f.-herramientas:f01.-xonestudio:icono11.png |}} |Inserta text| | {{ :f.-herramientas:f01.-xonestudio:icono12.png |}} |Next| | {{ :f.-herramientas:f01.-xonestudio:icono16.png |}} |Select Mode| | {{ :f.-herramientas:f01.-xonestudio:icono17.png |}} |Combo| | {{ :f.-herramientas:f01.-xonestudio:icono18.png |}} |Android Icon | | {{ :f.-herramientas:f01.-xonestudio:icono19.png |}} |Android- Windows icon| | {{ :f.-herramientas:f01.-xonestudio:icono20.png |}} |Select device| | {{ :f.-herramientas:f01.-xonestudio:icono21.png |}} |Copy All| | {{ :f.-herramientas:f01.-xonestudio:icono22.png |}} |Copy Modified| | {{ :f.-herramientas:f01.-xonestudio:icono24.png |}} |Pause the debugger| | {{ :f.-herramientas:f01.-xonestudio:icono23.png |}}|Start up the debugger| \\ If we click into this icon {{:f.-herramientas:f01.-xonestudio:icono25.png|}} the **Tools bar** with the additional icons will be deployed:\\ \\ \\ {{:f.-herramientas:f01.-xonestudio:icono26.png?900|}} \\ \\ \\ **New icons will be shown, in addition to those shown in the previous table** \\ \\ ^ ICON ^ **FUNCTION** ^ |{{:f.-herramientas:f01.-xonestudio:icono27.png |}}|Showing only coincidences | |{{:f.-herramientas:f01.-xonestudio:icono28.png |}}|Showing only complete words| |{{:f.-herramientas:f01.-xonestudio:icono32.png |}}|Using regular expressions| |{{:f.-herramientas:f01.-xonestudio:icono29.png |}}|Show types of docuemnts| |{{:f.-herramientas:f01.-xonestudio:icono30.png |}}|Replace following| |{{:f.-herramientas:f01.-xonestudio:icono31.png|}}|Replace all| \\ \\ ==== Properties==== \\ This function shows us the name and type of properties the visual elements have. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen14.png |}} \\ \\ For this, if we stand on top of a //prop//, for instance, as in the following image, in the properties screen it will show us all the properties of this //prop// we have pointed out, such as, description, colour, size, width, alignment, margings, font type...etc: \\ Example of a prop properties \\ {{ :f.-herramientas:f01.-xonestudio:imagen15.png?800 |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagen16.png?800 |}} \\ \\ ==== Files Explorer ==== \\ It will show us all the files that the project has, such as:\\ * database * files * fonts * icons * functions * ... \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen17.png?800 |}} \\ It has a series of icons:\\ \\ {{:f.-herramientas:iconosexplorador.png|}} \\ \\ |{{:f.-herramientas:f01.-xonestudio:iconoexplorador1.png|}}|Open project location| |{{:f.-herramientas:f01.-xonestudio:iconoexplorador2.png|}}|Update| |{{:f.-herramientas:f01.-xonestudio:iconoexplorador3.png|}}|Contract all| |{{:f.-herramientas:f01.-xonestudio:iconoexplorador4.png|}}|Add CSS| |{{:f.-herramientas:f01.-xonestudio:iconoexplorador5.png|}}|Add VBS| \\ ==== Collections explorer ==== \\ Function showing up all the files there are into the **Collections, Functions and CSS** of the project. \\ \\ The section of the **Colecciones**: has all the collections of a project. We can use filters to look for the collections we want. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen18.png?800 |}} \\ If we click into the **ADD ITEM** icon {{:f.-herramientas:f01.-xonestudio:iconoanadir.png|}} the **Collection Assistant** will appear with all the available templates: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen19.png |}} \\ **COLLECTIONS ASSISTANT**\\ \\ Here is where we will have an extensive variety of templates we can use in our app. It is very easy to use, we just only must look for the template we want and configure it. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen20.png?900 |}} \\ \\ If we click into the **BROWSER** option , it will look for all the templates to include into our project, such as:\\ * schedules * brochures * listing * graphics * maps * browsers * menus * login * web view * etc...\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen21.png?900 |}}\\ \\ If we select any template, it will show in a bigger size to the right side of our screen for a better visualization. We will save it with thge name we want to. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen22.png?900 |}}\\ \\ Once we have put the name we want to our template, we click into the **OK** button and it will show the following form with the data of the template selected:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen23.png?800 |}}\\ \\ And if we click into the **ACCEPT** button, it will be shown in our collection the template selected before, with the name we have assigned it. \\ \\ Example, we select the COLLECTIONS FILTER option: \\ {{ :f.-herramientas:f01.-xonestudio:imagenprueba1.png |}} \\ \\ And, once we accept it, it will appear the **COLLECTIONS FILTER** option or the template we have selected before, integrated into our collection, and in the **DESIGNER** screen we will be able to visualize it with higher resolution. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagenprueba2.png?800 |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagenprueba3.png |}} \\ The **FUNCTIONS** section shows up the different functions of the project´s collections.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen26.png?600 |}}\\ \\ The **CSS** section: they are style sheets in cascade to control the visual aspect or the presentation of our app. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen27.png?800 |}}\\ \\ \\ ==== Designer ==== \\ The “**Designer**” function allows viewing the way our app is taking. \\ It counts on several functionalities: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen28.png?400 |}}\\ \\ **DESIGNER OPTIONS**: By clicking in this combo we will have several options to visualize different types of devices and operative systems, such as iPhone, Galaxy, WP8. \\ Besides, we will be able to change the the resolution of the width and height of the image, as well as decrease and reduce the view of it. (see image below). \\ * The **FILL** button allows to return to the initial position. \\ * The **REFRESH** button allows to update the data. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen29.png?600 |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen30.png?500 |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen31.png?600 |}} \\ \\ ==== Errors List ==== \\ The app gives us a complete list of errors and warnings which contain the files of the project, it shows us the error data, such as the type of file, the collection, the line number or column to which it belongs to, the type of error, a brief description of the error, as well as the date and time field. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen32.png |}} \\ If we point out an error any of those that we have in the errors list window, it will show us the exact location of that error in the XML editor window:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagenerror.png |}} ==== Searching List ==== \\ By clicking in this function it will show us all the searchs we have made, and it will inform us to which file, line and column belongs that search: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen33.png |}} \\ \\ ==== Messages Console (XOne Output)==== \\ It will show us the type of messages sent: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen34.png |}} \\ If we deploy the **ALL** combo,{{:f.-herramientas:f01.-xonestudio:iconoall.png|}} placed in the in the upper left part of the screen, it will show us all types of messages there are: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen35.png |}} \\ \\ We will have the possibility of blocking the text, edit it or start the Logcat.{{:f.-herramientas:f01.-xonestudio:iconologcat.png|}}\\ \\ \\ ===== TOOLS===== \\ This tab contains a set of tools that allow to support the project.\\ In the drop-down that we obtain when opening it, the following tools appear:\\ \\ * Compile * Optimize * **Translate mappings** * Install modules * Android Runner * Android VNC Server * **Options** * **Update XOne Studio** \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen36.png |}} \\ \\ ==== Translating Mappings ==== \\ In this function the following mapping translator box will appear with diverse fields to select the original language and the language to translate that we want (if we click into the combo a list with the available languages will appear). \\ \\ It will be possible to delete data, export files or using the Google translator. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen37.png?800 |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagen38.png?800 |}} \\ If we use the Google translator, the following screen will appear with a progress bar of the translation from the original language to the language to be translated:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen39.png?800 |}} \\ When we have finished translating all the commands that we have indicated, they will appear on the translated screen:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen40.png?800 |}} \\ \\ ==== Options ==== \\ In this function we have the following optional functionalities, in other words, we can select them or we cannot, as we need: \\ * **Generals** * **ADB** * **Updates** \\ * **Generals**: it serves to set diverse recording functions, compiling files or increasing versions automatically. \\ {{ :f.-herramientas:f01.-xonestudio:imagen41.png?900 |}}\\ \\ * **ADB**: function to configure the //ADB//. For this, it is necessary to put the //adb// file path, or look for it in our PC and try with the device: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen42.png?900 |}} \\ * **Updates**: function to configure the updates automatically. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen43.png?900 |}} \\ \\ ==== Updating XOne Studio ==== \\ If we click on this function, the app will tell us the updates we have and we will be asked if we want to make the update. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen44.png |}} \\ \\ ===== DATABASES ===== \\ This tab contains the following functionalities:\\ \\ * **Generate/Update management.db** * **Gen RL** * **Database Tool** * **Database Manager** \\ {{ :f.-herramientas:f01.-xonestudio:imagen45.png |}} \\ \\ ==== Generate/Update management.db ==== \\ If we click into this function, the app will generate and update the database: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen46.png?400 |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagen47.png?400 |}} \\ Once the database was executed, we have four buttons located in the upper part, such as:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen47a.png?400 |}} \\ If we click into the **SOURCE** button: it will appear the following screen with data of the initial database, data such as type of file, mappings, script or database, database provider, the file path or the connection string: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen48.png?400 |}} \\ If we click into **DATABASE**, in the drop-down menu of the **PROVIDER** field we will be able to see the type of database: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen49.png?400 |}} \\ We can continue with the **NEXT** button or we can click on the following **SELECTION** button where we will have several options:\\ \\ * **Generating script /database**, here, we can generate the tables structure, the date and the indexes. * **Comparing destination with source**. * **Generating using subqueries**. \\ If we click into the first option, that one of **generate script/database**: it is necessary to put the path of the //sql//, or look for it, putting the //MIDS//, and selecting the tables.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen50.png?400 |}} \\ Same than in the previous section, we can go forward with the **NEXT** button or with the following button **DEST**. \\ \\ In this point we have to choose between **file and database**.\\ Besides, it will give us the file path and the connection string, as well as the database destination (by clicking in the combo we will have several databases) and the date format.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen51.png?400 |}}\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen52.png?400 |}} \\ {{ :f.-herramientas:f01.-xonestudio:imagen54.png?400 |}} \\ The **WIZZARD** button, placed in the lower right side of the screen, serves to configure the connections of the databases, it is a kind of assistant.\\ \\ In the following image we can see the screen it comes up if we click into the **WIZZARD** button, to generate the //SQL// of the database.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen56.png?600 |}} \\ **WIZZARD** \\ We notice that the WIZZARD assistant is made of six different tabs: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen58.png |}}\\ \\ **THE FUNCTIONS OF EACH OF THE SIX TABS CONTAINED IN WIZZARD ARE EXPLAINED BELOW** ==== System.Data.Odbc ==== \\ By clicking on tis tab, it will appear a screen with a kind of form to fill the **USER** and **PASSWORD** fields: \\ \\ {{:f.-herramientas:f01.-xonestudio:pestana77.png?100|}}\\ \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen59.png |}}\\ \\ In the third field of the form there is a combo placed in the right side, by clicking on it different types of databases will appear: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen60.png |}} \\ We point out the one we want and we click into this icon{{:f.-herramientas:f01.-xonestudio:imagen61.png|}} to validate the data, and they will be shown in the window at the bottom:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen62.png |}}\\ \\ In the bottom part of the screen, there are two buttons. **TEST and OK**. \\ If we click into the **TEST** button, we get the message that the script generation has been successfully completed:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen63.png |}}\\ \\ \\ === MySql.Data.MySqlClient === \\ By clicking on this tab we have another form with diverse fields to be filled such as **HOST, PORT, USER ID, PASSWORD and DATABASE.**\\ \\ {{:f.-herramientas:f01.-xonestudio:imagen64.png|}}\\ {{ :f.-herramientas:f01.-xonestudio:imagen65.png |}} \\ We do the same than in the previous time, and the data will appear validated in the window of the bottom side .\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen66.png |}}\\ \\ If we click into the **TEST** button and the operation has been made successfully, it will appear the same message than before, or if we haven´t put any data, it will show an __error message__, as we can see in the following image: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen67.png |}}\\ \\ \\ === System.Data.OracleClient === \\ By clicking in this tab, we can see that this one has three options: \\ \\ {{:f.-herramientas:f01.-xonestudio:imagen73oracle.png|}}\\ \\ - **USING TNS** - **INTEGRATED SECURITY** - **OMITING TNSNAMES.ORA** In the first option, **USING TNS** we will have another new form to insert data such as **TNS, USER ID, PASSWORD** and we validate the data:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen68.png |}}\\ \\ In the second option, **INTEGRATED SECURITY**, we must put the **TNS** and we validate the data: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen69.png |}}\\ \\ In the third option, **OMITING TNSNAMES.ORA**, we will have another form with data to insert such as **HOST, PORT, SERVICE NAME, USER ID, PASSWORD**: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen70.png |}}\\ \\ Once inserted the data we click into the validate icon {{:f.-herramientas:f01.-xonestudio:imagen61.png|}} and theh data will appear again in the lower window: \\ {{ :f.-herramientas:f01.-xonestudio:imagen71.png |}} \\ If by clicking on the **TEST** button and everything was made successfully it will come up the corresponding message, but in case the action wasn´t complete successfully the following message will come up: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen72.png |}}\\ \\ \\ === System.Data.SqlClient === \\ By clicking on this tab it will appear another form to be fulfilled, which is made of two options: \\ \\ {{:f.-herramientas:f01.-xonestudio:imagen73.png|}}\\ \\ - **STANDARD** - **INTEGRATED SECURITY** \\ In the **STANDARD** option, we must insert data from **DATA SOURCE, USER ID, PASSWORD and INITIAL CATALOG**.\\ Once entered the data, we click into the validate icon {{:f.-herramientas:f01.-xonestudio:imagen61.png|}} and then to **TEST**, to check that everything is **OK**. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen74.png |}} \\ In the **INTEGRATED SECURITY** option, we have two fields to fulfill, such as **DATA SOURCE and INITIAL CATALOG**. \\ \\ We do the same than in the previous steps, we validate and check that everything was made successfully. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen75.png |}}\\ \\ \\ === System.Data.SqlServerCe === \\ {{:f.-herramientas:f01.-xonestudio:imagen76.png|}}\\ By clicking on this tab we must fulfill the **PATH** field and in the magnifying glass icon {{:f.-herramientas:f01.-xonestudio:imagen79.png|}}, we can look for the path and validate it with the icon {{:f.-herramientas:f01.-xonestudio:imagen61.png|}}. If everything is correct, the data of the path will appear in the lower window. \\ If we click into the **TEST** button, we check that what we have created before was been made successfully: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen77.png |}} \\ \\ === System.Data.SQLite === \\ {{:f.-herramientas:f01.-xonestudio:imagen78.png|}} \\ By clicking on this last tab we will be able to generate the **SQLite**, for this, we have to make the following:\\ \\ In the magnifying glass icon {{:f.-herramientas:f01.-xonestudio:imagen79.png|}} we can look for the path:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen80.png |}} \\ And in the icon {{:f.-herramientas:f01.-xonestudio:imagen61.png|}} we validate the data and the data of the initial database will appear in the lower box: \\ {{ :f.-herramientas:f01.-xonestudio:imagen81.png |}}\\ \\ Si pulsamos sobre el botón **TEST**, nos aparece el siguiente mensaje de que todo se realizó con éxito, y pinchamos sobre **Aceptar**:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen82.png |}}\\ \\ When we have finished using the **WIZZARD** to configure the **CONNECTION STRING**, we will return to the screen we had at the beginning, by clicking on **START**, the screen we will have it will be the one corresponding to the **OUTPUT** button, in which we will have all the information of the database created with WIZZARD such as__path, destination, MID, data creation, tables creation…etc__.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen83.png?400 |}}\\ \\ \\ ==== Gen RL ==== \\ In this functionality we can generate the relation of tables, that is, specifying the table which links with another table and through which field does it. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen84.png |}} \\ \\ ==== DB Tool ==== \\ Same than in the first section about **GENERATE/UPDATE MANAGEMENT DB,** a screen will come up in which we must insert diverse data. \\ \\ This function is made of four main buttons such as:\\ - **SOURCE** - **SELECTION** - **DEST** - **OUTPUT** \\ {{ :f.-herramientas:f01.-xonestudio:imagen85.png?500 |}}\\ \\ In the **SOURCE** button, we must fulfill the data of the file, such as **Mapping, Script or Database**.\\ \\ In the **MAPPINGS and SCRIPT** options, if we click on the red-color icon of the magnifying glass, we will be able to look for the corresponding file, in the **DATABASE** option, in the field located under the **PROVIDER** field, will be deployed the types of database provider to indicate the one we want, as it is shown next: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen86.png?400 |}}\\ \\ To configure the **CONNECTION STRING** or the **FILE PATH**, we have in the lower side of the screen the **WIZZARD** assistant button.\\ If we click on the **WIZZARD** button, we must do exactly the same than in the previous section, that is, fulfilling the corresponding fields to every database and validate them to configure the __connection string__. \\ \\ Once we have configured the **CONNECTION STRING**, we click on the **NEXT** button, and it will take us to the corresponding screen, the one of the **SELECTION** function:\\ \\ Here, also, same than in the first section, we must generate the script, the database, comparing destination with source, or generating the subqueries use. \\ To generate **Script/Database**, we must generate the table structure, generate the data, or generate the //RL// indexes. \\ \\ It is necessary to indicate the **MIDS**, as well as indicating the **SQL** path (in the red-color icon of the magnifying glass we will be able to examine and look ford the path ).\\ In the **TABLES** section, located in the bottom part of the screen, we must specify the tables, by selecting all of them or just one in particular:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen87.png?400 |}} \\ \\ Once we have entered the data in the right way, we click on the **NEXT** button and it will take us to the next screen corresponding to the **DEST** function: \\ \\ Here, we will have to fulfill the data to the corresponding fields such as **type of file** **SQL** or from the **Database**: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen88.png?400 |}}\\ \\ In order to look for the file type, we can use the red-color icon of the magnifying glass:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen89.png?400 |}}\\ \\ To look for the database, in the **PROVIDER** field will come up a drop-down menu with the types of databases, we choose the one that corresponds:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen90.png?400 |}} \\ To find the connection string we click on the **WIZZARD** assistant button and we fulfill the form corresponding with the necessary data, as we have made before. \\ Once we have the connection string we must indicate the **DBMS DESTINATION**, for this, we click on the drop-down and the several options will come up, for this, we mark the one that corresponds . \\ \\ Finally, we indicate the date format in the corresponding field of **DATE FORMAT**\\ {{ :f.-herramientas:f01.-xonestudio:imagen91.png?400 |}}\\ \\ If we click on the **START** button, the screen corresponding to the **OUTPUT** button will come up and it will show us all the data of the destination database: **the path, creation date, MID…**\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen92.png?400 |}} \\ \\ ==== Database Manager ==== \\ This function allows us execute and look for queries:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen93.png |}}\\ \\ If we deploy the whole image of the screen (bottom image) we will get diverse options containing the data of the table we have indicated in the left column belonging to the tables. \\ The options are:\\ * **TABLE DATA** * **OBJECTS** * **TABLE INDEXES** * **RESULT** \\ {{ :f.-herramientas:f01.-xonestudio:imagen94.png?800 |}}\\ \\ In the**TABLE DATA** option (bottom image) we have the data of the table such as **codes, description, options, ROWID**… etc, we can delete, use searching filters... etc.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen95.png |}} \\ In the **OBJECTS** option, we have data from the **catalogue of the table, table scheme, table name, column name, position, errors or fails, tabs, if it is null or not, or data such as if it is an integer…**\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen96.png |}}\\ \\ In the **TABLE INDEXES** option (bottom image) we have data from the **catalogue of the table, table scheme, indexes catalogue, indexes scheme, indexes name, if it is primary key, if it is unique, if it is a //cluster// (it is a part of a group), type, size, if it is null…**:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen97.png |}}\\ \\ In the **RESULTS** option, we have the tables results. \\ In the **COMMIT** function we can send the data:\\ {{ :f.-herramientas:f01.-xonestudio:imagen98.png |}} \\ If we click on the icon **+**(placed in the left upper side of the screen) it appears in the following screen to execute the query: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen99.png |}}\\ \\ In this point, we must configure the connection string **(CnnWizard)**, by inserting the right data in the **CONNECTION STRING, PROVIDER** fields (if we click on it, the drop-down menu will be opened with the databases to indicate which corresponds) and the **NAME** field.\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen100.png |}} \\ There are two buttons placed in the upper side of the screen:\\ \\ The green-color button {{:f.-herramientas:f01.-xonestudio:imagen101.png|}} indicates that the database is connected.\\ \\ The red-color button {{:f.-herramientas:f01.-xonestudio:imagen102.png|}} indicate that the database is disconnected. \\ \\ By clicking on the **CnnWizard** button {{:f.-herramientas:f01.-xonestudio:imagen103.png|}} placed in the upper side of the screen, they appear the same screens than in the previous sections concerning the databases. \\ This button has the same function than before, it is to configure the connection string with the **WIZZARD** assistant. \\ We must fulfill all the forms with the correct data, validate them and test them in order to check that everything is OK: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen104.png?600 |}} \\ \\ \\ ===== HELP ===== \\ In this tab we will obtain diverse XOne support tools, in the drop-down menu the following help tools will come up: \\ * Help * Tutorials * Templates * **XOne Wiki** * **XOne Foro** * **Youtube Channel** * Index * Search * **About XOne Studio** \\ {{ :f.-herramientas:f01.-xonestudio:imagen105.png |}}\\ \\ \\ ==== XOneWiki ==== \\ In this function the app will take us to the XOne Wiki page: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen106.png?800 |}} \\ \\ ==== XOne Forum ==== \\ The app will take us to the XOne Forum:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen107.png?800 |}}\\ \\ \\ ==== YouTube Channel ==== \\ The app will take us to the XOne YouTube Channel :\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen108.png?800 |}}\\ \\ \\ ==== About XOneStudio ==== \\ In this function we will get some data of the XOneStudio app, such as versions, improvements, updates, developer...\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen109.png |}}\\ \\ Besides, we can send logs, by clicking on the **SEND LOG** the following box will appear:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen110.png |}}\\ \\ \\ ===== PUBLISHING ===== \\ It is a tab for publishing the project we have made with XOne Studio and we want to publish:\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen111.png |}}\\ \\ \\ ==== Publishing a Project ==== \\ By clicking on this function, it will come up a **xonepublish ** box to publish any project we want, we must indicate the **URL** and enter the user and password keys and finally on the corresponding button to validate the data entered: (See image below)\\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen112.png |}}\\ \\ Once the data are validated, if they are correct, the tool will connect with the **XOne Publish** server to publish the project: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen113.png |}}\\ {{ :f.-herramientas:f01.-xonestudio:imagen114.png |}}\\ \\ The fields we must fulfill are:\\ \\ - **CONNECTION STRING**: it is the connection string of the database where the data of the app will be stored in. (the client´s database). - **USER/PASSWORD**: depending on which we want to do **UNPUBLISH/PUBLISH** they will be put the user´s data with permissions to publish an app or to delete it from the system.\\ - **Bbms NAME y DateMask**: Database system and its date format.\\ - **App Name**: The name we are going to give to the app we want to publish. With this name it will appear in XOneManager and with this name it will be created its database. \\ \\ When validating (previous screen) and appearing this screen, we can see that in the lower part data server appear, such as its **URL**, the version and date of XOnePublish and the available licenses (number of apps that can be published).\\ \\ Once published in the server, if we click on the **PUBLISH** button it returns the message of the following image by indicating the app was published, with which license and how many it has from now on: \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen115.png |}}\\ The following screen will appear as soon as we click on the **UNPUBLISH** button. It indicates it was properly deleted and with which license, and how many licenses it has. \\ \\ {{ :f.-herramientas:f01.-xonestudio:imagen116.png |}} \\