Mysql importing sql gzip fileKazi

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need an experienced programmer to develop a custom-built website for a Loadshedding scheduler. The project has a high priority and needs to be completed as soon as possible Before 20 May 2024 Basics Summary: The Load shedding Scheduler System is a comprehensive solution designed to address the challenges associated with managing and implementing load shedding in an efficient and org...generation. - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing this project promptly. Please provide your relevant experience and a proposed timeline for the project. for skills required on this platform i can only put 5 but include Web Hosti...

I'm urgently seeking a freelancer who can assist in modifying the formatting in a PDF file I have. Your responsibilities will include: - Adjusting the text charges in the document. Ideal candidates for this project will have excellent attention to detail, proficiency in working with PDF files, and the ability to work swiftly as this task needs to be completed ASAP. Knowledge of diverse formatting styles will be a real asset. Please provide examples of similar work you've done in your proposal.

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...

I need an experienced programmer to develop a custom-built website for a Loadshedding scheduler. The project has a high priority and needs to be completed as soon as possible Before 20 May 2024 Basics Summary: The Load shedding Scheduler System is a comprehensive solution designed to address the challenges associated with managi...generation. - Understanding of e-commerce and secure online payment methods. - Ability to work under tight deadlines and deliver high-quality work. I'm looking for someone who can start immediately and commit to completing this project promptly. Please provide your relevant experience and a proposed timeline for the project. for skills required on this platform i can only put 5 but include Web Hosting MySQL. Anyone that i can charge the price range...

I need someone with specialized skills in password recovery to restore a forgotten password for an Outlook .pst files. I have an old *.pst file (outlook) from the year 2010. I put on password, and now I didnt remember, I need to find this password I m looking for somebody to find password for pst file

...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should

I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skills and Experience: - Strong proficiency with Frontend JavaScript, and Backend Node.js. - Proficient understanding of databases particularly MySQL. - Comprehensive experience in building authentication and authorization systems. - Knowledge of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastName Ema...

I am looking for an experienced freelancer capable of creating a simple web scraping tool, able to extract text content, images, and links from a specific url (you just need to do one single url and I take it from there). The extracted information should be in a python dictionary and saved to pkl Skills: - Experience in web scraping - Proficient in handling js and automation This is a very simple project for the right individual. I need all the visible info and images (no maps) plus the info in the JS that must be reached by clicking a button. This is a couple of hours of work max, and needs to be done in Python and for today. I will provide the URL when I make sure you can handle the job. Thanks

I have an Application build in last 2022 with MYSQL Database and Node.js Backend. I am looking for a developer who can administrate it in a long term. Your responsibility will be - 1) Database Architecture 2) APIs Development 3) Supporting the Front End Developer 4) Supporting The Mobile Apps Developer 5) maintain the APIs collection on the Postman 6) Maintain the APIs and Database Model Documentation My Hourly rates are (INR) 800/Hr Max (Including all taxes/Freelancer fee etc..)

...need immediate help with importing a .mbox file into my Gmail account. The .mbox file contains all my email data from a previous job and is very important to my work. I have attempted this myself before, but the process was too complex for me to complete. I'm specifically looking for support with: - A step-by-step guidance through the import process. - Ensuring all the emails are correctly transferred to my Gmail account. I do NOT need assistance with: - Organizing the emails into specific folders or labels. Ideal Freelancer for the job: - Proficient in Gmail and its import features. - Skilled in providing clear and easy-to-follow guidance. - Available for an immediate Zoom session to assist with the import. - Understands the complexity of .mbox...

I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site

Please read the attached document. There is a hidden code in the document. You must include this code when bidding. No code means bid is deleted. Skills: MySQL ReactJS HTML/CSS C#

I'm seeking an experienced fullstack web developer with proficiency in HTML/CSS, JavaScript, RESTful web services, and MySQL to create a website with a minimalist aesthetic. While no specific target audience has been identified, the successful applicant will have the ability to attract and engage a broad range of users with intuitive design and effortless functionality. Key skills and experience needed: * HTML/CSS * JavaScript * web services (REST) * MySQL * Website design with a minimalist aesthetic I am looking for a freelancer who can help me customize existing web based applications and make additions to them. The application already contains similar two forms. Preferred Programming Language: - Javascript, Jquery, Angular 1, C#,css, bootstrap Timeline: - The time...

I'm in need of a web developer skilled in Python Flask. The purpose of my project is to build a web application with specific functionalities. The deliverables for the project are: 1. Flask Backend: - User authentication - Database integration - API development 2. Bootstrap5 Theme Customization: - Layout modification - Integration with Flask backend and MySQL database Ideal candidates with robust experience in Python Flask, layout modification and database integration will provide an immense value to this project. Your expertise would facilitate a smoother workflow and better end product outcome.

...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

...candidates should have plenty of experience with Flutter Development, as well as a portfolio of past work to demonstrate their expertise. - Proficiency in Flutter development - Experience in developing for both iOS and Android platforms - Ability to work independently with minimal guidance You have to setup and configure both the flutter application (iOS and android) as well as the backend PHP, my SQL, firebase, docker etc. As the client, I did not specify the key features to be prioritized, giving you the flexibility to design the app in a way you find most effective. Similarly, there is no predesignated design requirement for the app, paving the way for creative freedom. Given the lack of specifications, the ideal freelancer should be highly creative and intuitive, capable...

I need group of skilled programmers that are aware of a game called “rise of kingdom”. Project budget is 20k-40k. Basically i want to make a bot for the game that does most of the things.

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

Looking for an experienced professional to convert an existing dwg (autoCAD file) of a building's top view into SVG. This will be used in creating an interactive map through the Mapplic platform. Here's what is needed: 1. Inclusion and Highlighting: - Building outline - Room labels 2. Color Scheme: A neutral toned color scheme will be best suited for our needs. 3. Interactivity: - No specific additional functionalities are needed, as mapplic features already suffice. The task is focused on adjusting the dwg file into suitable SVG for use on mapplic. Ideal candidates will have experience in file conversion, AutoCAD operation, and interactive map creation. Knowledge of Mapplic's functionality is a plus.

I need someone who can research the regulations for importing and selling industrial RFID reader in Hong Kong. A brief report needs to be made with the following information: 1) Regulations related to the import of RFID reader ・ Approval and license that importer and distributor are obliged to obtain prior to the import and selling of RFID reader (such as OFTA license) ・ Related laws and regulatory authorities 2) Regulations and standards related to the sale of RFID reader, such as Quality standards or quality requirements, Environmental requirements (RoHS etc.) that need to be satisfied (if any) ・ Regulations regarding labels (labeling requirements, if any) ・ Each report needs to be made in English and will be of about 4 sheets of A4 paper (about 2,000 words). I want the reports...

I need a skilled designer to create a captivating car branding for my Maruthi Eeco. I have specific details that I would like to be included in the design: - Incorporate my logo in a creative and visually appealing way. - Integrate my contact information which includes my phone number, adress, and website. Ideal skills for this project include graphic design, brandi...Eeco. I have specific details that I would like to be included in the design: - Incorporate my logo in a creative and visually appealing way. - Integrate my contact information which includes my phone number, adress, and website. Ideal skills for this project include graphic design, branding, and experience in creating designs for vehicles. The final deliverable should be a high-resolution print file. I need by ...

...examine a pre-existing React file to identify any import statements that may be missing and automatically add the missing imports. Key responsibilities: - Analyze the React file to identify missing import statements - Add the identified missing imports automatically - Append multiple missing imports as grouped together in a single statement - Code should be in Typescript This task requires a solid understanding of Node.js. Having previous experience with jscodeshift is a must. The solution also need to use a package named @hypermod/utils. () This is the function that I need function fixMissingImports(code: string, importsMapping: Record<string, string>): string The code is a string of a content of a file tsx or jsx file. the function should first

I am seeking an experienced WordPress developer to help finalize the setup of my travel agency website. I have purchased the Travolo theme and need assistance with installation, configuration, and customization to ensure the site is travel-agent friendly. Key tasks include theme installation, importing demo content, setting up essential plugins (like booking systems), and customizing the site to match my brand's aesthetics. Additionally, I need to integrate functionality that supports booking, customer management, and inquiry forms.

Tengo un ERP desarrollado en Vbasic 6.0, necesito un desarrollo complementario que permita tomar el xml generado por el ERP y que termine el proceso. Ademas necesito que la aplicacion pueda ser accesada por un movil android y generar Guias de Despacho, las cuales deben llegar al ERP con base de datos en MYSQL

...experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require u...

I'm looking for a skilled individual who can help me read a file and extract specific data from it. Key Requirements: - Extraction of File names, File sizes, File creation dates, and messages stored in the DB file. - Ability to adapt to extracting all messages or specific ones, depending on my future needs. - Delivery of the extracted data in a Spreadsheet format, preferably Excel or Google Sheets. Ideal Skills and Experience: - Proficiency in reading and interpreting files. - Advanced skills in data extraction, particularly from database files. - Experience in delivering data in a spreadsheet format. - Flexibility to accommodate future changes in the extraction requirements. - Strong communication skills to clarify requirements and deliverables...

I am in need of a print spooler designed to work on Windows, written in Python, c++, c#, and capable of printing multiple PDF files simultaneously. Key Requirements: - The application must be able to handle printing multiple PDF files concurrently, providing a more efficient and streamlined printing process. - The print spooler must be designed to operate solely through a Command Line Interface (CLI), so there is no need for a Graphical User Interface (GUI) or Web Interface. Ideal Freelancer: - Proficient in Python with a strong understanding of how to handle printing tasks programmatically. - Prior experience developing print spoolers or similar printing software would be highly advantageous. - Familiarity with working in a Windows environment, particularly in relation to system-level ...

I'm in need of an intermediate-level PostgreSQL developer to convert MySQL scripts into PostgreSQL. The tasks I need completed include: - Converting existing MySQL scripts to PostgreSQL. Expect to handle scripts that are between 100 and 500 lines. - Ensuring that the converted scripts work correctly and efficiently. Ideal candidates will have a solid background in both MySQL and PostgreSQL, with a focus on performance optimization. Proficiency in debugging and problem-solving is highly preferred. Please submit your bid if you can confidently translate these scripts while ensuring full functionality and optimized performance. Your experience and portfolio will be a decisive factor in this project, as I place a great importance on proven skills.

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

Para este proyecto, estoy buscando a alguien con experiencia en integrar el SDK de Meta en una aplicación existente (desarollado en PHP, mysql, javascript, taiwind). La url es: Estas son las principales habilidades y experiencia que necesito: - Experiencia sólida en el SDK de Meta PHP y su integración - Fuerte comprensión de cómo seguir eventos con el pixel de Meta - Experiencia previa con la configuración de parámetros de eventos - Capacidad para trabajar con el servidor Godaddy Los eventos a configurar son: Comprar: Cliente llega a la página Iniciar Pago: Cliente llega a la página Agregar al carrito: Cliente llega a la página Ver Contenido: . Cliente llega a la página Agregar información...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

I am in search of a proficient developer to design and build a minimalist ecommerce website. The project will be implemented in several stages, including UI and database design, database creation, and the development of web pages using PHP. The proposed website should have the following specifications: * The website should have various pages including a main page, category page...skills include: * Proficiency or beginner in PHP programming for ecommerce website development. * Can use online templates in UI and database design. * Familiarity with creating a user-friendly and minimalist design approach. * Strong understanding of developing user-friendly product pages and checkout processes. * What most important is creating database according to the required document (using mysql ...

Necesito una persona que tenga conocimiento en parches de seguridad en php y mysql ya que tengo un sitio en donde los usuarios se modifican el saldo lo cual es una inconsistencia y de igual manera agregan anuncios sin tener saldo y también es una inconsistencia. Adicional necesito que ajuste el sitio para que los depósitos se acrediten de forma correcta a nivel de usuario ya que en mi cuenta si llega el saldo pero no se otorga al usuario cuando se confirma el saldo eso es del saldo de servidor que deben corregir. De los 2 puntos el que tiene mayor prioridad son los parches de seguridad.

I need an experienced professional to create an XML file for me. The file will be primarily text-based, with no need for images or tables. Key Responsibilities: - Create a custom schema for the XML file - Ensure that the text content is structured appropriately within the XML file - Deliver the file in a timely manner Ideal Skills and Experience: - Proficiency in XML creation - Experience in creating custom schemas - Attention to detail - Ability to work independently - Good communication skills, as you may need to clarify certain aspects of the project. Please note, I will rely on your expertise to create a suitable schema for the XML file. The end goal is to have a well-structured and functional XML file.

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

...have access to different sections of the site, with content being restricted accordingly. - API Integration: I currently do not have an API set up for accessing data from WebFlow's MySQL. This will need to be implemented on the WebFlow side. - Data Import: I'm looking to import specific data from the API into the WebFlow site. This includes membership level information and orders submitted. Ideal candidates for this project should have: - Proficiency in WebFlow and a strong portfolio demonstrating membership system integration - Experience working with API integrations, especially those involving WebFlow's MySQL - A keen eye for detail and the ability to ensure a seamless user experience - Strong communication skills to discuss and implement the necessary f...

I need a skilled developer to create a simple HTML file that prints 'Hello World @sainath_reddy' in any language. This file will be hosted on Azure Cloud using extended support services. I have a DNS and would like the deployment to be done on that DNS. The specific requirements are as follows: - Develop a single HTML file with 'Hello World @sainath_reddy' output - Host and deploy the file on Azure Cloud - Utilize extended support services for the hosting - Ensure deployment is done on my own DNS There's no need for a continuous deployment setup, as this is a one-time deployment. Ideal skills for this project include: - Proficiency in HTML - Experience with Azure Cloud services - Understanding of DNS and deployment processes - Abilit...

Edit PDF file, easy work must complete today

...updating in real-time to reflect any changes in the forecast. The ideal freelancer for this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

When I open the PDF, it doesn't show me the data on the second page. By changing the code (I provide pictures), it shows the data, but the graphics are bad. The project is small and simple. An opportunity for beginners. I pay max $5 and give a good review. Ideal opportunity for new freelancers.

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I'm looking for an Azure expert who can provide me with comprehensive documentation on how to connect my dbForge client to an Azure MySQL App Services Database. Key Requirements: - **Azure Proficiency**: The ideal candidate should be highly experienced with Azure, especially in working with Azure MySQL App Services Database. - **dbForge Expertise**: Familiarity with dbForge would be an added advantage. Your main goal should be to create a step-by-step, comprehensive guide that will help me effectively use dbForge with Azure, particularly for database management purposes. I'm not looking for a one-time setup, but rather a detailed documentation that will serve as a reference for future tasks.

I am in need of an experienced professional who can work hand in hand with me in exporting my old MySQL database into my new Node.js website. There are a few discrepancies in column names that need attention, so attention to detail is crucial. This is a personal project, and the chosen freelancer should be comfortable providing remote assistance through anydesk, and maintaining open communication over a call throughout the duration of the task. I will personally guide you through the necessary steps and the specific level of accessibility that should be set for the new database. Ideal skills and experience: - Solid understanding of MySQL - Experience in Node.js website development - Exceptional problem-solving abilities - Excellent communication skills - Ability to follow...

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I've built a React website with separate pages, and I need a skilled developer to connect them and integrate a chatbot. Here's what I'm looking for: - Connect: Link the home page with another page that opens through the navigation bar. Ensure the transition is seamless and the user experience is smooth. - Chatbot Integration: I have a chatbot that's been designed to work with the ChatGPT API. I need it to be integrated within the content of the website. The chatbot should be able to provide product/service information and answer customer queries. The integration should be user-friendly and should not interfere with the design and functionality of the website. Ideal Skills: - Proficient in React - Experience in connecting separate pages in a React website - Familiarity...