Mysql insert jsoncông việc

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.

I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-pa...API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API -> MySQL...

..."Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there are lines that are not present or do not have a value, you must report them in the VAT control output file report (attached). 4- Starting from input file 1 (attached), look for the lines of column D "product details" in column A of the newly created VAT output file and insert the respective value present in column B of the file in column K of the example output file (attached). VAT output. 5- Starting from the output file just created, create a new file such as the VAT corresponding file (attached) in which in column A "DATE" there are the dates present in column A of the "Input 1" file (only 1 line per date). In co...

...React code - Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model - Thorough understanding of React.js and its core principles - Experience with popular React.js workflows (such as Redux) - Familiarity with newer specifications of EcmaScript - Experience with data structure libraries (e.g., ) - Knowledge of modern authorization mechanisms, such as JSON Web Token - Familiarity with modern front-end build pipelines and tools - A knack for benchmarking and optimization - Familiarity with code versioning tools, such as Git - Familiarity with basic CSS, and Figma designing. **Preferred Qualifications** - Proficient understanding of TypeScript with ReactJS - Working knowledge of Tailwind CSS - Able to replicate Figma design to React code. - Exp...

I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.

...Machine-side control: Adjustable field (Φ), torque, and speed. Overload Protection: Develop a feature to switch the device to idle mode during overload conditions. Measurement and Output: Provide optional output of all internal measurements, especially torque, speed, and power. User Interface: Implement a 4x20 LCD text display for function calls. Enable function calls through the RS232 interface using JSON format. Protect the interface with CRC for error-checking. Ensure PC commands are readable and outputs are optional and adjustable through a menu system using a rotary encoder. Quadrant Display: Implement a 4-LED display to indicate the quadrant of operation (motor or generator mode). Additional Features: Include Phase-Locked Loop (PLL) design for inverter grid connec...

We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.

...local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experience in working with PDF, XML, JSON, and Text file...

i need my aws rds mysql connceted with retool. it gives error and i am unable to link it. i need help fast so only if you can help in this moment not in 1 h

...annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking project progress. - Experience in creating automated Excel sheets using conditional formatting and data validation. - Attention to detail to ensure the accuracy and functionality of the sheet. - Good communication skills to unders...

I'm in need of an experienced PHP MySQL developer to handle data management and manipulation, database design and optimization, as well as web application development for my project. The goal is to create a robust e-commerce website with the following features: - Product listing and details - Payment gateway integration Ideal candidates should have a rich background in PHP MySQL, web application development, particularly in e-commerce platforms, and database design and optimization. Your skills in crafting systems that are user-friendly, secure, and streamlined will be essential. Emphasizing on data management and security is also paramount in this project. Let's connect if you possess these skills.

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.

...begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. Please provide your past experience and any relevant...

...details to the remote server. Design and develop a secure admin panel using Laravel 10, MySQL 8, and PHP 8: User registration and management. Device registration with approval workflow. Device blocking functionality. SMS panel to send SMS commands to registered devices. Ability to set the remote server IP for each registered device. Implement user authentication with: Login ID generation based on device MAC address. User-selectable password after admin approval. Login expiration for enhanced security. Write well-documented and commented source code for both the Android application and admin panel. Qualifications: Proven experience in Android app development (Java/Kotlin). Proficiency in Laravel framework, MySQL, and PHP. Strong understanding of security best practices for...

...AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monitor and scale applications. Looking For: - 3+ years of experience in software development - Experience with LAMP and MERN stacks - Knowledge of PHP, CSS, and JS and web technologies - Familiar with S3, cloud hosting, DNS, web security - Ability to use vanilla code and minimal libraries/frameworks - Can code fast and effective with simple Bootstrap and jQuery - Strong skills with MySQL and NoSQL (Firebase, MongoDB) - Good english communication skills in Slack and in meetings - Availability to work ~20hrs per week between 9AM-6PM PST - A passion for c...

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

...WordPress Developer, you will be responsible for both the frontend and backend development of our WordPress websites. Your main tasks will include creating and editing custom themes and plugins, optimizing website performance, and implementing new features (such as translating plugin language, or overwriting some existing AI features). The ideal candidate should have strong knowledge of WordPress, PHP, MySQL, and frontend technologies such as HTML, CSS, and JavaScript. Responsibilities: - Develop and maintain WordPress websites - Create custom themes and plugins - Optimize website performance - Implement new features and functionalities Requirements: - Proven work experience as a WordPress Developer - Strong proficiency in WordPress, PHP, HTML, CSS, and JavaScri...

Busco desarrollador web para realizar una página exclusivamente con Java, Javascript, HTML, CSS (puede usar Bootstrap) con base de datos MySQL utilizando XAMPP (phpmyadmin) y Apache NetBeans/Eclipse como entorno. La pagina tiene que tener un inicio de sesión/registro de 2 tipos de usuario (usuario cliente y administrador). La pagina tendrá un menú de navegación en la parte superior con varias pestañas: inicio (introduccion a la web, ultimas noticias, etc), videojuegos (aqui estaran todos los videojuegos de la web con un filtro de busqueda por genero y plataforma sacado de la base de datos donde se ve el nombre de cada uno, foto de su portada, genero, plataforma, fecha de lanzamiento, etc. y alguna opcion para ponerles nota, opinar, añ...

...frameworks, MySQL database, and E-commerce development to build a website. The developer should also have experience with Wordpress and integrating various platforms and APIs. Key project details: - The ideal candidate should have strong knowledge and experience in PHP frameworks like Laravel or Symfony, as well as Wordpress. - E-commerce development experience is essential, especially in designing and building secure and user-friendly online stores. - Proficiency in MySQL database is required. - The website will require integrating payment gateways, social media, and email marketing platforms. Hence, the developer should have experience in these areas. Ideal skills and experience: - PHP frameworks (Laravel, Symfony, CodeIgniter) - Wordpress - E-commerce site developmen...

...who will be responsible for carrying out the tasks listed on the job cards and the managers/administrators who oversee these tasks. Employees will need access to all past completed, active jobs, quotes, parts and customers. Managers will need to have access to send the completed job to QuickBooks, add / remove employee names and set an hourly labour rate. Ideal Skills: - Proficient in PHP and MySQL - Experience in developing web-based forms - Knowledge of job management systems - UX/UI Design capabilities for a user-friendly interface Please see the attached Specification PDF or view at: Please consider the functionalities I'm looking for and the primary users of the system when bidding. Please contact for

I'm in need of an experienced Java Full Stack Developer to build a comprehensive application with the following features and requirements: - **Fea...ability for users to share content and interact with the application through social media platforms. - Payment gateway integration: A reliable and secure payment gateway to facilitate transactions. - Email marketing services integration: Integration with email marketing services to streamline communication with users. Your expertise with Core Java, Java 8 features, J2EE, JDBC, servlets, MySQL, JSPs, HTML, Spring MVC, Spring Boot, ORM, MVC Architecture, and API Development will be essential. Additionally, experience with integrating and implementing third-party services will be highly valued. Looking forward to seeing ...

I'm in need of an experienced PHP ...following requirements: - User Authentication and Authorization: The developer will need to create secure login and registration systems for our websites. - Database Integration and Management: Proficiency in MySQL is a must. The developer will be responsible for managing and integrating databases effectively into our sites. - Payment Gateway Integration: The developer will have to implement payment gateways, ensuring a smooth and secure payment process for our users. Ideal Skills: - Proficiency in Core PHP and Wordpress Development - Strong understanding and experience with MySQL - Previous experience in User Authentication and Authorization - Previous experience in Database Integration and Management - Previous experience in Payme...

...require a proficient PHP programmer to handle a variety of tasks on my project. These tasks will include: - Website development: The core of this project involves visualization of the key concepts, hence proficiency in creating efficient and visually appealing websites is a must. - Database integration: The website functionality will be backed by a responsive and robust database. Expertise in MySQL or similar database is critical. - Custom script development: You will need to develop tailored scripts to meet the specific needs of my project. Familiarity with CodeIgniter is essential for this project since we will be using this framework for our site. Given the complexity of the work, I prefer a mid-level developer who has substantial experience in the aforementioned areas. Your...

I'm looking for a skilled PHP developer with experience in CodeIgniter for a new project in the e-commerce space. Ideal Skills and Experience: - Proficiency in PHP and CodeIgniter framework - Previous experience in e-commerce platform development - Strong understanding of front-end technologies, such as jQuery, JavaScript, HTML5, and CSS3 - Knowledge of MySQL and other relational databases - Familiarity with RESTful APIs and Web Services - Ability to work with version control systems like Git The primary goal of the project is to create a robust, scalable, and user-friendly e-commerce platform. The platform should be able to handle a large number of products, facilitate smooth transactions, provide a secure payment gateway, and have a user-friendly interface. A key part of th...

I'm looking for experienced Node.js develop...Node.js developers to create a RESTful API for my project. Key Requirements: - Develop a RESTful API: The API should follow REST principles for web services, ensuring easy consumption and compatibility with various applications. - JSON Format: The API should primarily support JSON format for data exchange. Ideal Skills and Experience: - Proficiency in Node.js: Thorough understanding and hands-on experience with Node.js for server-side scripting. - API Development: Prior experience in developing RESTful APIs is essential. - JSON Handling: Expertise in handling JSON data format within APIs. This project will involve working closely with the front-end team. If you have a solid experience in Node.js and API dev...

I'm looking for a PHP developer with substantial CodeIgniter framework expertise. The project at hand involves upgrading and optimizing an existing PHP application. Key Requirements: - Strong PHP skills and extensive experience with the CodeIgniter framework - Proficiency in MySQL database management for database optimization and management. - Familiarity with front-end development to be able to enhance the UI/UX as part of the upgrade. Your main responsibility will be to improve the existing codebase, making it more efficient and scalable. This will involve database optimizations, code refactoring, and possibly some UI/UX upgrades. An understanding of security best practices in web development will also be highly beneficial. If you have previous experience with similar pro...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, ...from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...

I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.

I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.

I'm looking for a skilled photo editor who can remove the existing date from a picture and insert a new one, as well as incorporate a text or logo to the image. Key Requirements: - **Date Replacement**: You'll need to completely remove the old date from the picture and add a new one in its place. - **Text or Logo Placement**: The text or logo should be elegantly placed on the image, in a manner that doesn't overshadow the main subject. Ideal Freelancer: - Proficient in photo editing software like Adobe Photoshop or GIMP. - Experienced in working with image manipulation and text overlay. - Attention to detail to ensure a seamless blend of the new date and the existing image.

...four cups of water, and 1-4 pounds of cubed chuck roast, or meat of your choice, to a slow cooker or instant pot. Instant Pot - Set to Pressure Cook, on High, for two hours, then natural release for 15 minutes. Slow Cooker - Cook on low heat, covered, for 8 hours. Optional: Add the juice of 2 limes to the liquid mixture. Sear the beef before adding to mixture. Empty, wash, and dry the insert of the pressure cooker. Add 1/4 cup avocado oil to the pressure cooker and heat on the highest Sauté setting for 5 minutes. Add half the beef and sear until browned on a few sides, 8 to 10 minutes. Transfer to a plate. Repeat searing the remaining beef. " - Allergy Info - packed in a factory that handles nuts, peanuts and sesame....

I'm seeking a expert to seamlessly integrate the Gemini API within my existing app. This integration needs to facilitate real-time updates on specific information. Key Project Details: - The primary focus of this integration is to enable real-t...indicating first what the top 5 security risks they are exposed to when using the cloud, second a brief description of the consequences would be if they do not mitigate each risks, third a recommendation summarized in 2 lines to mitigate each risk, fourth include NIST Framework control with its title, fifth provide real-life example in this industry of this year and last year. Provide the output in json array format.) If you're an expert developer who can handle this task efficiently and effectively, I'd love to hear fr...

...Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability and reliability of the platform. Write clean, well-documented, and maintai...

I want a script that reads me some JSON files and enters the data in each of the custom WordPress fields, and creates new articles if they are not created and if they are, I update them.

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

...colors and the functionality of selecting each option. The system must run on WordPress and work on it until it is 100% functional. My website is made with Wordpress + Elementor + acf STEP 2: After having the complete system in its entirety, you must import comments that are in a json, in said JSON are the perfumes + their comments and leave it linked and when you add manual comments to each entry, add them normally and add them without problem. The idea is to import all the perfumes + their comments. IT IS IN A JSON WHICH I ALREADY HAVE UPLOADED TO MY SERVER. IT WOULD JUST CREATE SOME SCRIPT TO MAKE THE INTRODUCTION OF THE DATA TO MY WEBSITE. EYE: You must tell me your prices and time, don't ask me my budget, just tell me when you charge and the time it...

I'm currently facing a Forbidden error in my Laravel project that's connected to a MySQL database. I'm looking for a skilled developer to troubleshoot and resolve this issue, and potentially optimize the database connections for a smoother performance. Key tasks: - Troubleshoot the Forbidden error in my Laravel project - Review and potentially modify the existing database connections - Ensure that the database connections are optimized for performance The ideal candidate will have: - Strong experience with Laravel framework - Proficient in MySQL database management - Proven track record in troubleshooting and resolving similar issues

We are a web development company looking to expand our team. We need someone highly skilled in PHP and MySQL. Our work primarily involves custom projects, and occasionally WordPress. Currently, we have a job ready to start using the BigCommerce platform. This project requires code customization, assistance with connecting to shipping, and more. Thank you.

I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Mig...migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly transferred and op...

...native code should be done via Platform Channels (MethodChannel and EventChannel). User Interface ----------------------- The app should have three main screens: - Splash Screen: Displays the app logo. - Login Screen: User authentication with username and password. When the login button is pressed, a POST request should be made to an API (which I will provide) sending the username and password in JSON format. The API will respond with the login status (granted/denied) and a token for future requests. On successful login, the Foreground scan service should be started and navigate to the Status screen. The login state should be saved locally (in local storage). If the user is already authenticated, future app accesses should go directly to the Status screen. - Status Screen: D...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...Release Creation System Catalog management Content tracking Analysis Daily Trends Analysis Audience targeting Monitoring of music lists Video editor Royalty accounting software Neighbouring Rights Collection DMCA automated takedown Min. Requirements: - Must have experience with DDEX music supply chain and infrastructure - Experience with B2B DDEX implementation - Experience with technologies such as JSON/XML, AWS, NoSql, Python, Javascript - Familiar with MEAD standards provided by DDEX, Ruby on rails knowledge. Please only apply if you have build something like this before! More info: Key Features: - Rights Management: Implement a secure and reliable mechanism for managing music

...like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site...

I'm looking for a skilled professional who can meticulously guide me in video call through setting up a VPN using Google Cloud and OpenVPN. The primary aim is to ensure secure remote access to a MySQL database from my Windows laptop. Key requirements: - In-depth knowledge of Google Cloud and OpenVPN - Proven experience in configuring secure VPNs - Expertise in MySQL database security and remote access Your role will be to provide detailed, step-by-step instructions on how to properly configure the VPN to meet my security needs. Please bear in mind that I may require access to the MySQL database from multiple remote locations, but most likely will only need it running from 1 remote laptop - the VPN should be flexible enough to accommodate this added funct...

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

...backend developer who can build a robust REST API. The ideal candidate should be proficient in MySQL, and have experience in user authentication, data retrieval, and data modification. Key Requirements: - Develop User Authentication: The API should include secure user authentication functionality. - Implement Data Retrieval: The API must be able to retrieve data from MySQL database as needed. - Data Modification Capability: The API should also support updating and deleting data in the database. Additional Needs: - Third-Party Integrations: The API will need to integrate with a payment processing system and also be able to send WhatsApp messages. If you have a strong background in Node.js, MySQL, and building REST APIs, I'd like to hear from you. Please incl...

i got my code pine script i need some when to add messge to the code and ill link it to webhook to send the signals Json signals fit to Cornix bot i need it asap in hours thanks