Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Most Popular Topics |
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Copyright NoticeThis material is copyright protected. No material may be reproduced or transmitted in any form or by any means for any purpose without expressed written consent of VideoRay LLC. Copyright © 2021, VideoRay LLC - The Global Leader in Micro-ROV Technology |
Language Support
|
Table of Contents |
About this DocumentDocument NavigationYou can navigate through the documentation to specific topics using the menu, or step through sequentially using the Next and Previous arrowhead buttons. The Next button will step you from the current topic to the next topic at the same level unless the current topic has a sub-topic. If the current topic has a sub-topic, the Next button will step you into the first sub-topic. The Previous button works similarly, but in reverse sequence. Your current location within the document is shown as a "breadcrumb" trail at the top of each page under the document title. You can click on any level of the breadcrumb hierarchy to go that location. You can also use the following keyboard shortcuts:
Links are shown in brown font. Finding InformationThis document includes a Table of Contents, Glossary / Index and Google search on each page. You must be connected to the Internet in order to be able to use the Google search, and you can select whether to search VideoRay's online document library only (the default) or the Internet. Document ConventionsSeveral symbols are used throughout this documentation to add emphasis and to assist in relocating important information. The following table describes these symbols and their uses.
Document Customization - My_NotesThis document has been developed to allow local online versions to be customized using the My_Notes feature. Users can add their own notes to each page. See the Customizing this Document page for more information about how to customize this document. Beyond this DocumentThere is no substitute for experience and/or training, especially with respect to the real purpose for which you plan to use this equipment. We encourage you to explore options beyond the scope of these materials to expand your knowledge and skills necessary to support your applications. In addition to this documentation, VideoRay offers training and technical support and hosts a general user discussion forum and user image gallery. We also realize that collectively, users of our products spend considerably more time operating our systems than we do ourselves. Users also encounter more diverse operating environments across an extremely broad range of applications. We highly value this vast experience base, and invite and encourage you to share your experiences and suggestions with us. Please feel free to contact us by any of the methods listed below. Quality CommitmentVideoRay strives to design, manufacture, deliver and support the highest quality products and services, including this documentation. We have made every effort to ensure that this documentation is accurate and provides you with the most up-to-date information. If you find any errors in this documentation or have suggestions for improvements, each page contains a "Help us improve this document" feedback link in the left margin (you must be connected to the Internet to use this link).
DisclaimerThis document is deemed accurate at the time of its writing, however it is not a legal contract and the information contained herein should not be construed to represent any form of commitment. This document as well as the associated products and services are subject to change without notice. Alternate FormatsSingle HTML Page Format Portable / Printable Format HTML File Set |
Customize this Documentation - My_NotesMy_Notes are easy to incorporate directly into the pages of this manual. They can be used to clarify content, add additional information, or document your custom settings, operational tactics or procedures. My_Notes are page specific and display at the bottom of the desired page under the "My_Notes" heading. No programming is required - it is as simple as saving a file with your notes. Creating My_NotesMy_Notes can be written in HTML or plain text. HTML allows for more flexible formatting and inclusion of images or links to other web pages. To add a My_Note, create an HTML or text file containing the note and save it in the VideoRay\My_Notes\ folder, which can be found in the computer account user's documents folder (Documents\ for Windows 7, or My Documents\ for Windows XP). The file should be named the same as the page in which you want the note to appear, with a "my_" prefix (without the quotes). For example, if you want a My_Note to appear at the bottom of this page, the name of the file to create is: my_custom_my_notes.html. The name of the page being viewed can be found in the address bar of the browser being used to display this documentation. Even if you are using a text file, the file name must end with the ".html" extension. All My_Notes files are processed as HTML, so if you are using a plain text file, you will need to add "<pre>" (without the quotes) at the beginning of the file and "</pre>" (without the quotes) at the end of the file if you want to preserve the layout. The "<pre>" and "</pre>" will not show up in the display. When using HTML, the My_Notes folder serves as the root for relative links. An images folder is included for you to store images. You may add other folders or files as desired. Viewing My_NotesWhen you reload the page, your My_Note will appear - there is nothing else to install or configure. A sample My_Note file has been included to display the My_Note below. You can use this file as a model for creating your own My_Notes. Updating My_NotesTo update a My_Note, simply edit and re-save the My_Note file. Removing My_NotesMy_Notes can be removed by deleting or renaming the My_Note file. Sizing My_Notes Display (Optional)The default vertical size for My_Notes is set to 200 pixels, which is used for the sample My_Note below. Due to browser limitations, My-Notes do not size dynamically. This means that a long My_Note may display a scroll bar in order to view the whole My-Note. You can adjust the size to eliminate the need for the scroll bar. To set the size of a My_Note, you need to edit the file named "my_notes_size_table.js" in the My_Notes\ folder (location defined above). The file contains one line for each page of this document using the following format: window.page_name = size_in_pixels; Find the line for the page that includes the My_Note you want to resize and replace the value of size_in_pixels with the desired size in pixels. The page names are listed alphabetically. Example line from the "my_notes_size_table.js" file for this page: window.custom_my_notes = 200; Note that ".html" in not included in the page name, and the line must end with a ";" Also, the optimum size required is dependent upon the size and aspect ratio of the browser window. |
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
How to Get HelpHelp for your Convert .csv to GSS .yml is available through several channels. All Hours Self-Service / Crowd-Source Tools
Global Support
Regional Support
Training
Operational Strategies and Tactics SupportIf you need help understanding how to apply your system to a specific project, contact VideoRay or you local VideoRay dealer. We can provide guidance or help you find a certified consultant. > |
Before Contacting SupportPlease make sure to consider the following information before contacting VideoRay's Technical Support to report a problem. The following information should available:
Once you have collected the recommended information, visit the "How to Get Help" page for contact information. In addition, please review VideoRay's Support website for additional information about:
|
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Convert .csv to .yml Overviewconvert_csv_yml.py converts a coordinate file in .csv format into a Greensea .yml mission file. It is designed to be as easy to use as possible:
The program can run on Ubuntu on the Control Console or on Windows on a PC / Laptop. Before converting your .csv file, you will likely need to set up the defaults to match your data requirements. This manual will explain how to do that. |
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Quick StartInstallationThe program and necessary files are delivered as a zip file. These files can be downloaded and unzipped to the folder of your choice. First Time Program ExecutionTo start the program: Ubuntu on the Control ConsoleOpen a terminal window and navigate to the folder where the program was installed. Enter: python convert_csv_yml.py Window on a PC / LaptopNavigate to the installation folder and click on the convert_csv_yml.exe file. When the program starts, click on the Show / Set Defaults button. Check and set the defaults according to your preference. See the Setting Defaults page for more information. Addition information about the data format and defaults is provided in the remainder of this manual. A sample .csv data file, mission.csv, is included as part of the installation for a test execution. After the defaults are set as desired, save the defaults by clicking on Save Defaults to File button and then click on the Convert button. Subsequent Program ExecutionsFor future executions using data in the same format, you will only need to start the program, select the filenames and click on the Convert button. |
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Files and FormatsIn addition to the program itself, convert .csv to .yml requires a configuration file (a .cfg file), and input file with data about the mission and waypoints in .csv format. Additionally, two template files, one for the mission and one for the waypoints, are used in the background to create the .yml file. When executed, it creates a Greensea mission file in .yml format for use in Greensea's Workspace ROV control program.The files will be described on the following pages, starting with the .yml mission file. |
The .yml File Format and InformationGreensea mission files contain general information about the mission, such as its name, and a series of waypoints. Mission files are stored in a .yml files. The .yml file is in text format that is easy to read. An example mission file with two waypoints is shown here:
You may notice that there are many parameters associated with the mission and each waypoint. The program allows you to set defaults for all of these values so you do not have to include these data elements in your file if you do not want to. Here is the full list of .yml data elements with descriptions. Additional information about each these parameters can be found on the CFG File page. Mission DataMission ID (Auto generated by the program) Mission Name (Text) Mission Color (Hex RGB color value, range: #000000 - #9999FF; the program includes a graphic color picker.) Mission Color Propagate (True / False) Mission Locked (True / False) List of Waypoint IDs (Auto generated by the program) Waypoint DataWaypoint ID (Auto generated by the program) Waypoint name (Text) Waypoint color (Hex RGB color value, range: #000000 - #FFFF00; the program includes a graphic color picker.) Waypoint y [North] (Number - Degrees value) Waypoint x [East] (Number - Degrees value) Waypoint z [Depth / Altitude] (Number, meters) Waypoint tolerance (Number) Waypoint z_alt [Z is Altitude] (True / False) Waypoint z_matters [Use Depth Lock] (True / False) Waypoint speed (Number, speed in meters/second) Waypoint use_speed [Use Speed Lock] (True / False) Waypoint effort [% Effort] (Number, range: 1 - 100) Waypoint display_rb (True / False) Waypoint locked (True / False) Waypoint heading (Number, range: 0 - 360) Waypoint heading_mode (NONE / ALONG_LINE / FIXED) Within the .yml, the Units Type is Meters and the Degrees Format is always Decimal Degrees. Your .csv file can contain units of feet and other degrees formats (Degrees Decimal Minutes or Degrees Minutes Seconds) by specifying these as default units to use. |
The .cfg File Format and InformationThe Configuration file is used to store default values for the program and can be modified to meet your data requirements. This table provides comprehensive information about the data and default values. An initial configuration file is provided as part of the installation and there are tools within the program to modify it.
This configuration file is provided with the initial installation:
The configuration file is named convert_csv_yml.cfg and is a text file. It can be edited using the Show / Set / Save Defaults feature provided within the program, or manually in a text editor. Either method can be used. You may use whichever is more comfortable for you. |
The .csv File Format and InformationThe .csv file contains your data. It may be manually created or generated by another program. If you are not familiar with .csv files, you can view a brief .csv primer.For the purposes of using the convert_csv_yml.py program, the data represents coordinates or waypoints with one waypoint per line. Here is a sample of a typical coordinate file in .csv format with a header row.
Commas are not allowed within a value, because they are used as the separator between values. In addition to the list of coordinates/waypoints, the program requires that the first line of the .csv file provide information about the mission, and the header row either needs to be removed or identified as a comment by using a "#" as the first character. Lines with the "#" symbol as the first character on the line are considered comments. You can also use the "#" to exclude specific coordinates from the conversion. Here is the required mission information: Name,Color,Color Propagate,Locked,Units Type,Degrees Format,Auto Increment Waypoint Names
The sequence of the mission data elements must be in the order listed above, and this order cannot be modified like it can be for waypoint data elements. Here is an example of a working .csv file that the program can read and convert correctly (defaults must be set accordingly). This example conforms to the defaults as defined in the initial installation.
Mission Information
Waypoint 1 Information
You may notice that this data does not include many of the .yml parameters. The program will insert the default values for any missing parameters. You can also omit entire columns as long as they are at the end of the rows. For more information about data elements and their definitions, see the CFG File page. A sample data set is included in the mission.csv file that is included as part of the installation. It uses a blank line as the first line - All mission data is defined by defaults and not the .csv file. |
Template FilesThe program uses template files to structure the .yml. These files should not be modified without training. They are presented here for your information. Mission Template
Waypoint Template
|
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
Setting DefaultsThe program includes tools to set or modify the defaults. To set the defaults, start the program and click on the Show / Set / Save Defaults button. Enter or select the values for the defaults for each piece of information listed. If you want to reorder the waypoint data elements or specify columns to ignore, click on the Reorder Waypoint Data button. This will bring up a list of the waypoint data elements. You can select an element and use the Move Up or Move Down buttons to achieve the order that matches your data. Any data elements that you do not plan to include in your data should be moved to the bottom and the columns for these data elements do not need to be included in your .csv file. If your data includes columns that are not required by the .yml file format, you can specify that these columns should be ignored or not used. To designate that a column should be ignored and not used click on the Insert Unused Column button and then move the "Unused" column marker to the correct position to match you data. For example, if your data has a date in the first column, insert an Unused column marker and move it to the top of the list. If you no longer want to use the Unused column marker, you can remove it by selecting it and clicking on the Remove Unused Column button. When you are finished reordering the data elements, click on the Update Waypoint Column Order button. If you decide you do not want to reorder the columns, click on the Close without Updating button. At this point, the default values are enabled, but not saved. If you execute the conversion, the defaults will be used as assigned. However, tif you want to save these defaults for future executions of the program, click on the Save Defaults to File button. If you only want to use the defaults this one time, click on the Close without Saving to File button. |
Convert .csv to GSS .yml
Operator's Manual, 1.00.00 |
|
Download the convert_csv_yml Program FilesDownload convert_csv_yml.zip |
CSV File Format PrimerThe .csv file format is a general purpose method of storing data. CSV stands for Comma Separated Values and is generally used to store data the can be arranged in rows and columns. Each row represents a record and the columns represent data values (or fields) for that record. A simple example for the use of a .csv file is an address book. The data could include a record (or row) for each person and the records might contain the following information: name, street address, city, state and zip code.Example address book in .csv file format with a header (or title) row:
|