Sql statement display column currency decimal places työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Hei, Haluaisitko kääntää työhakemukseni suomesta englantiin? Tarvitsen käännöksen opintotehtävääni varten, opsikelen yliopistossa ja sen takia teksti edellyttää tieteellisestä rakennetta. Deadline on jo perjantaina... Ystävällisin terveisin, Simon Rundlöf
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
...ommerce-3d-product-modelling-realistic-rendering-prototype-animation?context_referrer=listings_page&source=your_recently_viewed_gigs&ref_ctx_id=8e935e79237d4bbcb6c825a617f4cee4&context=recommendation&pckg_id=1&pos=1&context_alg=recently_viewed&imp_id=ce172e78-cf4d-45ca-8fe2-0a9d177a75be My product is a padded girdle and I just need to rotate it similar to the headphones in this ad, and then display 3 or 4 levels of the hip pads, kind of like them exposing the inner parts of the ear pad... Your role will include: - Creating a 3D model from the provided design references - Producing an animation that effectively showcases the product's functionality Ideal abilities for this project include: - Competency in popular 3D modelling and animation soft...
I'm looking for a skilled video editor to crea...- Feature extracurricular activities, sports teams, arts programs, and community service initiatives. - Show students participating in clubs, sports events, or creative projects. 4. **Campus Life & Facilities (45-60 seconds)**: - Display modern facilities, libraries, labs, and recreational spaces. - Capture the school's vibrant campus life with shots of students socializing, studying, and enjoying campus events. 5. **Closing (60 seconds)**: - End with a strong call-to-action inviting prospective students to join the Sep 2025 cohort. - Display the school's contact information and website for further details. Remember to keep the video visually appealing, concise, and engaging to leave a lasti...
...publicist with the following qualities and responsibilities: - Research: I need you to look up the best restaurants, events, festivals, and tourist attractions in the city and surrounding areas. These should be in line with the current trends and cater to my interests. - Brainstorming: I expect us to have regular brainstorming sessions so we can come up with fresh and exciting ideas for things to do, places to visit, and outfits to wear. - Communication: I am looking for a professional who can communicate with me daily via video and phone calls. I'm looking for someone with a knack for researching and an eye for trends. Ideally, you would have experience in fashion, lifestyle, or event planning and be comfortable on video calls. Your communication skills should be impecca...
...client, I am looking for a skilled developer who will create a custom webpage for conducting polls. The key functionalities I need include: 1. Email Verification: The webpage should limit voting to one time per institutional email address. If an invalid email is entered, the interface should display an error message. 2. Voting Display: The voting results should be displayed in real time using bar graphs. It's crucial for the freelancer to have experience in creating such an interactive visual display. 3. Commenting Feature: I want users to be able to create notes as comments under the poll. This gives people a space to share thoughts or elaborate on their vote. The ideal freelancer for this job will have a strong background in web development, with specific...
Creating a resonating digital presence for our business is my main priority. I'm seeking an experienced web developer to design a robust, user-friendly landing page and ecosystems for our various services and products. The page will serve multiple purposes including to: - Present detailed information about our various services - Facilitate user bookings - Display our range of products. We cater mainly to general consumers (B2C), so the design should be easy to navigate, engaging, and visually appealing. Additionally, the project extends to the development of multiple ecosystems comprising specific product pages. Each of these pages will be linked to several subpages outlining the services related to that particular product. Key features to include in the different service pag...
I'm looking for an expert web developer to implement a multilingual feature on my website, with automatic currency conversion capabilities. Below are the specifics: - **Language and Currency Conversion**: The developer should setup a language selector that corresponds with specific currencies just as it is on Footshop.pl. This will allow my website visitors to choose their preferred language and see prices in their local currencies. - **Currency Update Feature**: The currencies should be updated regularly to reflect the current exchange rates. You should be able to leverage both fixed, real-time, and custom conversion rates. - **G|Translate Service Integration**: I desire to have the translation service on my website powered by G|translate service. Ideal fr...
I'm looking for a 14 developer who can help me with a quick job. I need to up...quick job. I need to upload data to MongoDB and images to Firebase, then retrieve the image URLs to display them in a gallery. Key Requirements: - Upload data to MongoDB - Upload images to Firebase - Retrieve image URLs - Display images in a gallery I don't require any extensive proposals or past work; just someone who can complete this task quickly. The project should ideally be completed within a day. I have 90% of the code already done but I do not have time to finish it. But i do need it to be easy to replace the dummy data when I want to deploy/publish. Ideal Skills: - Proficiency in 14 - Experience with MongoDB and Firebase - Basic understanding of data retrieval and displ...
I am working with GridCore library from .NET Core. I am having issues getting the column headers to be displayed with the filters added. Now, I am only able to display the column headers titles. I need someone that has proven experience using this library and can give me the solution.
I'm seeking a proficient developer to create a web-based BTC lottery application with integration to Coinbase for payments and Two-factor authentication (2FA) for additional security. The application is aimed at providing a secure and engaging platform for users to participate in a lottery using BTC as the primary currency. Therefore, it's crucial to have a good understanding of cryptocurrency and blockchain technology. Key Requirements: - Development of a web-based BTC lottery application - Integration with Coinbase for cryptocurrency payments - Implementation of Two-factor authentication (2FA) to enhance security Ideal Skills: - Proficiency in web development, particularly with experience in creating secure applications - Prior experience in working with cryptocurrenc...
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...
...perhaps. I'm looking for a talented designer to create a logo that's significantly catered toward brand recognition for my educational company. It's crucial that the design is well-structured and distinct. Ideal skills: - Proficiency in modern design software - Previous experience with educational logos or similar - Strong understanding of branding principles The concept I desire should display the highest degree of professionalism. Your objective should be to merge aesthetics with functionality, creating an immediately recognizable and meaningful identity for our brand. Please provide examples of your previous logo design projects with your bids....
Project Budget: $125 Project Level: Standard Project Overview: Simple Python script with a HTML front end to allow a user to upload a CSV list of “prompts” and have each one sent as a request to the OpenAI API. There will be multiple prompts on each row. The script will need to move through each column, retrieve the output from OpenAI API, before moving onto the next row. The script should insert the result/text output from each column/prompt/request into a prompt output column of the CSV, then over onto the next row & then automatically download the updated CSV file for the user. Technical Requirements - Server Type: Ubuntu 22.04 - Script Type: Python - Front End Type: HTML - Front End Functionality: - Input API Key into a text field - Upload CSV...
...a skilled developer to create a custom indicator using Pine Script v5 for the TradingView platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. My requirement will be as below; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, Trailing SL/Trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code...
...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...
I need a skilled Android developer who can build an efficient, user-friendly Events Calendar app using Android Studio Native code. Here are the features required: - Reading event parameters from a URI: The app must be able to fetch event details from the specified URI and display them effectively in the application layout. - Video and background music playback: The app should offer a feature to stream a related video accompanied by background music during the event display. Kindly note, the design specifics are already decided and will be shared for further implementation. Proficiency in Android Studio Native Code, understanding of integrating media playback functionalities, and experience in fetching and displaying data from a URI are indispensable skills for this project...
...we already have. Additionally, we require conducting a competitive analysis to identify the keywords that will allow us to effectively compete with other air taxi services. The revamped or improved page should include an integrated Local Bank payment gateway to accept all credit cards. It should also have a booking system that allows customers to select dates and destinations. The system will display the different available aircraft, as well as additional services, such as escort from arrival at the international airport to the domestic flight terminal, or customized tours and overflights on the destination route. The flight route should also be displayed on a map of Costa Rica or Central America. Once the customer has selected the flight, aircraft, and additional services, th...
I'm see...is to create an application that can take a 50Hz 1024x640 video stream from a remote URL and display it on a local monitor through the HDMI output. Key Requirements: - The application must ensure the playback of the video stream without dropping frames. - The latency between the incoming video stream and its display on the local monitor should not exceed 2 frames. Ideal Skills and Experience: - Proficiency in C++ is a must for this project - Prior experience working with Raspberry Pi would be a significant advantage - Experience in real-time video streaming and low latency applications would also be highly beneficial. Please note that the primary use of this application is for media display, not surveillance or teleconferencing. Looking forward ...
I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.
I need an experienced developer to build a crypto wallet application compatible with Android devices and also a website for the app. The critical functions of this application include, but are not limited to: • Display real-time prices of all types of cryptocurrencies. • Execute common wallet functions such as sending and receiving payments. • Facilitate fundraising by hosting a dedicated section for donations. Any interested developer should also ensure that users are required to create an account before they can use the wallet. Your expertise in mobile and web application development, especially with experience developing crypto wallets or similar financial apps, will be highly valued. Familiarity with blockchain technology and a deep understanding of crypto token...
I'm seeking a skilled professional capable of converting GPT chats with code samples into interactive, running HTML pages. This project requires: 1. Expertise in HTML, JavaScript, JSON, GitHub, retrospective mobile display and the use of ChatGPT. 2. Proficiency in transforming chat scripts with intermediate level programming concepts into functional code. 3. The ability to generate dynamic HTML pages from these chats, complete with buttons that trigger specific code executions. This is aquick and challenging, yet rewarding task for those interested in innovative ways of transforming GPT chat conversations into executable, interactive web pages. Result will be stored as a github project, We will send invitation to awarded freelancer. Current budget is 62$+8$ bonus if fi...
...their name and email only. Key Project Details: - Creation of a User-friendly Form: The form you'll create needs to be non-intrusive, only asking for a visitor's name and email. - Successful Data Capture and Shipment: After form completion, the data must be sent effectively to Brevo utilizing either their SDK or API’s. - User Interaction: After a user submits their info, the website should display a "Thank You" message, further enriching User Experience. Ideal Skills: - Proficiency with React.js - Experience with API integration - Understanding of user-friendly design - Good knowledge of data handling and transfer The perfect freelancer for this project would be acquainted with Brevo's SDK or API, as well as having strong experience in Rea...
...comprehensive details of each order, such as purchased products, quantity, price, customer contact information, etc. Marketing Expenses Tracking: Incorporating a feature to track marketing expenses (e.g., Google Ads, Facebook Ads, TikTok Ads) and associating them with each day's data. Integration with Urgent Cargus: Ensuring seamless integration with Urgent Cargus' delivery tracking system to display shipping costs and provide real-time updates on delivery status (delivered, out for delivery, refused, etc.). Calculation of Net Profit: Implementing functionality to automatically calculate the net profit for each order, considering production costs, shipping fees, taxes, and other associated expenses. Purchase Price Input: Including a feature where we can input the pu...
...the dropdown fields in these graphs, specifically the 'day' dropdown filter. For clarity of work: - Problem: The dropdown values are not updating properly. While the code is already in place, it might contain some bugs. Your task is to debug this issue and ensure the functionality works as intended. - Desired Behavior: When a specific day is selected from the dropdown, the graph is expected to display data for the selected day only. - Graph Element Adjustment: Once you've resolved the dropdown issue, the next task involves rearranging the placement of the graphs. I will guide you through the process to ensure the result aligns with my expectations. Skills required include a solid foundation in React and TypeScript, significant debugging experience, and proficiency ...
...organization's LDAP. The fronted also need to authenticate to the opensearch backend with a given client key. Data Types: The search frontend should be able to handle different types of data including Text, Images, Audios, Videos, and more. This means the frontend should be able to communicate effectively with the backend to retrieve and display all these data types during search. Search Results Display: An important aspect of this project is the display of search results. I'd like the user to have the option to choose how they want to view the search results. This could be in a List view, Grid view, Carousel view, or any other format that the user finds most convenient. Ideal Skills and Experience: - Strong experience with frontend development, particu...
... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...
...provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month...
at the lowest level of advancement, let's hope only 80% of the requirements are included in the application ;) Subject: Application for booking parking spaces. Design (in Android Studio) an adequate user interface (visual layer, navigation, i.e. transitions between screens, animations) The application should contain (at least): - Welcome Screen - Login Screen - Two-factor authentica...gallery (the gallery can be freely adapted to the theme of the application) - Adding a new item to the gallery screen (non-functional) - Focus Screen (e.g. presenting a new application feature) - Personalization/change settings screen - Characteristic Screen (e.g. if we are creating an application similar to Spotify, it is a music playback screen, if a game or library, it is a gameplay or book displ...
...app, and a **QR code** will be associated with their profile. - They will use this QR code to check in at the fair. - The app will display a map of the fair (which should be an image stored online) along with a list of exhibitors. - When a visitor visits an exhibitor's booth, they will use the app to scan the exhibitor's QR code for check-in. - The app will provide a list of stands that the visitor has checked in to. - Visitors can also vote for the most creative, innovative, and best-service stand. 2. **Exhibitors**: - Exhibitors must register in the app, and a **QR code** will be associated with their profile. - The app will display the fair map (an image stored online) with the location of their booth (the address will be stored in a data...
I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...
Seeking a skilled React developer for a quick project. We need a simple task management app built using React.js and JSONPlaceholder API for backend simulation. Expected completion time: 3-4 hours. Key Features: Task List: Display a list of tasks with options to mark tasks as completed, edit task details, and delete tasks. Add Task: Enable users to add new tasks to the list with a title and optional description. Edit Task: Allow users to edit task details, including the title and description. Delete Task: Provide the functionality to delete tasks from the list. Mark as Completed: Allow users to mark tasks as completed, visually distinguishing them from incomplete tasks. Requirements: Proficiency in React.js and JavaScript. Experience with frontend development and RESTful API...
...swatches for different sizes and colors. - The website should have an inventory management system that allows for the addition of product quantities in the backend. The quantity should be dynamically updated upon each purchase and trigger a notification to admin in low stock. - The website should have an order management system that send notifications to customers and the owner when a customer places an order. - The website should have a shipping method that allows for self-shipping and integration with third-party shipping providers. - The website should have a shipment tracking system that updates customers and the admin on the status of their orders. - The website should have a secure payment gateway that requires OTP for added security and offers a refund option (My Fato...
I'm in need of an experienced Wordpress expert who can assist me in fixing some critical plugin issues on my website. The ideal freelancer for this job should have solid experience in troubleshooting and optimizing Wordpress plugins. Key Tasks: - Fix the order/checkout/pay section - Create a minimum order of 6 for 7 products - Adjust product display from 9 products per page to 30 products - Rearrange product placement in the catering section (I want to put the most popular items first in line) - Implement "Message on Cake" only for cake items. as the previous developer add it to all the products :( - Include add-ons for two products Please, only apply for this job if you have demonstrable expertise in resolving plugin-related issues in Wordpress. Your past projects ...
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
...provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month...
...the search function of a webshop. I want to do this by adding extra data to the products (in the form of tags). I have a list of 11,000 product names in Dutch. These product names consist of a piece of proper name, noun and then sometimes some content information. For example: Orange Cleaner degreaser 5L c We are looking for a quick way to see the noun plural in the column next to it. Also, one or more synonyms in the column(s) next to it would be nice. Example: degreasers (=plural) I understand this can be done with a Python script that performs these tasks. This script uses the Natural Language Toolkit (NLTK) library to identify multiples and synonyms. This script assumes you have a list of product names and want to find the plurals and synonyms for each of them. It ...
...supports and deflection check. Additionally calculations for one timber post (probably glue-lam) determining the demand stresses making sure the bending stresses about y and x axis are both 0, determine strength capacity (design for compressive and bending strength) check cross section resistance adequacy and check member stability Finally with a rough working out to calculate the transfer load of column needed for a clay stiff pad foundation in my design Skills & Experience: - Proven civil engineering background with a heavy bias on structural design - Proficiency in load calculations - Extensive experience in material specification - Sound understanding of technical manuals and structural design - Superior problem-solving abilities Involvement in similar projects in ...
Looking to develop a hiking App in Flutter. Key Requirements: 1: It will need to work both online and offline and display/use offline maps. (Normally a topo map. ) 2: It will need to allow the user to select different layers to display, eg / tracks / waterways / POI. These could be Polygon shape files, CSV files, KML or GEOJSON files. 3: It will need allow the user to save: tracks as they hike around, POIs, and maybe take a photo at a point and Geolocate it? 4: User will need to be able to add/save waypoints 5: User will need to be able to select items in KML /shape files to display data.