Mysql transpose rows to columns example jobs
I urgently need assistance converting a PDF file into an editable Word format. The purpose of this conversion is to have a document I can easily modify and manipulate. The PDF is relatively simple, comprised of plain text without images, tables or the complexity of multiple columns. If you have a strong background in data entry and PDF-to-Word conversion, this project should be straight forward and quick. Ideally, you've worked on similar projects and you're able to start immediately. Skills in data entry, word processing, and PDF conversion will be highly valued. Handling text with accuracy is also required. I'm looking forward to your prompt responses.
I'm looking for a talented, experienced React JS and Laravel developer to join my team on a monthly salary basis. You'll be responsible for a range of tasks. Your responsibilities will include: - Front-end development: You'll need to be proficient in React JS, with the ability to create attractive, responsive user interfaces. - Back-end development: Strong Laravel skills are essential. You'll be responsible for building and maintaining the core functionality of our platform. - Bug fixing: You should have a keen eye for detail and be able to identify and resolve bugs in both the front-end and back-end. - Experience with mySQL is a must. In your application, please include your relevant experience in React JS and Laravel. I'm look...
Description: I am seeking an experienced WordPress developer to create a custom user profile management system for my franchise. This system is intended for internal use only and will not be accessible to the users themselves. The primary function is to help me manage and consult detailed records of investors, similar to handling personal files. Requirements: Plugin Installation and Setup: Install and configure one or more suitable WordPress plugins that allow the creation of custom fields and profiles in the admin backend. Custom Fields for Detailed Information: The ability to add custom fields to user profiles is essential. These fields should include but are not limited to personal information, investment history, contact details, etc....
I require an experienced drafter to create comprehensive workshop fabrication drawings for structural steel components (specifically beams and columns). These drawings need to be in PDF format. While no specific standard or code was requested by me, it would be beneficial for potential candidates to have a strong knowledge of structural steel design codes. Proficiency in tekla, advance steel or similar software is a minimum requirement for this project. A set of drawings for review will be required prior to the release of the milestone payment, once the engineer approves the drawings for fabrication the payment will be processed via freelancer. I have architectural and engineering plans reflecting all critical specifications
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single...
We are seeking a skilled and experienced java developer to create a custom JMeter backend listener that can send real-time test results directly to a PostgreSQL database. This project aims to enhance our testing capabilities by enabling seamless integration of JMeter results into our PostgreSQL environment, similar to existing solutions for MySQL like the one found at "" Requirements: Proven experience with Java programming and JMeter test development. Strong knowledge of PostgreSQL and experience in integrating it with Java applications. Familiarity with the JMeter API and backend listener framework
...proficient in MySql, Php, HTML and Css, who can add a functional back office and payment system to my existing website. Key Requirements: - Your primary task will involve adding a back office and payment system that will be database-driven. - The system should include user management capabilities, payment processing functionality, and robust sales and customer record tracking. - Specific features for user management include: user registration, login, and profile management. - For the payment system, you'll need to integrate a payment gateway, provide for invoice generation, and ensure that the system maintains comprehensive transaction history tracking. The website is already designed, so your task will be to add the necessary functionality to ...
...script to build my AWS infrastructure from scratch. Key Components: - The infrastructure should be deployed inside its own VPC in AWS - The infrastructure should deploy an RDS database, specifically MySQL, that is securely accessible from the backend and frontend servers, but not accessible from outside the VPC or internet. Instance size: , allocated storage: 100Gb. Admin user/password should be supplied as variables -- I will specify them in the command line. Also a separate user account should be created to access this database. The user should have read/write access, I will again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend services. I want to be able to m...
Need fulltime laravel developer immediately individual developer only Minimum Experience- 6month to 2 year Database- mysql knowlegde Salary 10000 inr to 25000inr only Remote desktop interview on ruskdesk software mandatory coding interview
I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know what's going on with the above message.
I'm looking for a versatile developer with extensive experience in WordPress plugin development and maintenance. The ideal freelancer for this project should have: - Proficiency in WordPress PHP, MySQL, JavaScript and CSS. - Experience developing and mataining WP plugins. - Exceptional problem-solving skills and the ability to work under minimal guidance. - Bug fixing and refactoring code as needed. - Comfort working with APIs and authentication (e.g., OAuth flows). - Ability to provide maintenance support post-plugin implementation. Good communication skills are a **must** for eventual clarifications and regular updates. Please provide examples of similar projects you've worked on. Thanks for your interest!
...implemented and it's not working few functionalities need to check and fix. 2. Migrate few working module files from this test server to production server. 3. ONDC TSL implementation with the vendor. I am in need of a Php yii1 and MySQL expert to tackle some key tasks on my existing project. Immediate tasks include: - Bug fixing: We have some lingering issues that need to be resolved to optimize functionality. - Adding new features: We require new elements added to enrich the user experience, which is currently our area of greatest need. - Improving existing features: Amplify current features for better functionality and seamless user interaction. The successful freelancer should have significant hands-on experience with Php yi...
As discussed in chat I am ready to make changes in exam result of students As you want some fixes and some new rows with student division and grades and averages and need to calculate whether the student is passed or not.
An app similar to Uber and Lyft. 1. Mobile App Development: Proficiency in mobile app development platforms such as iOS (Swift) and Android (Java/Kotlin). Experience with cross-platform development frameworks like React Native or Flutter can be beneficial for building apps that work on both iOS and Android. 2. Backend Development: Strong understanding of backend development technologies and frameworks like Node.js, Python (Django/Flask), or Ruby on Rails. Knowledge of databases such as MySQL, PostgreSQL, or MongoDB for storing user data, ride information, and other relevant data. 3. Geolocation and Mapping: Familiarity with geolocation services and APIs for tracking user location and providing real-time navigation. Experience integrating mapping and routing APIs such as Go...
I'm seeking...developer with expertise in React.js, PHP, and MySQL to create an e-commerce website for me. The website will require a shopping module, account module, and a cart. Key Features of the Shopping Module: - Product search and filtering - Product categories and subcategories - Product recommendations Account Module Functionality: - User registration and login - Account settings and profile management - Order history and tracking Cart Module Implementation: - Add to cart functionality - Quantity adjustment - Seamless checkout process I will need the full source code once the project is completed. Experience in e-commerce website development and with the technologies mentioned is a must. Prior work samples or references are highly appreciated. Looking...
I'm requiring an experienced deployment specialist for Odoo 17 on Google Cloud. As a company owner, I possess an active Google Cloud account hence you won't need to facilitate that. For the database system, we'd like to incorporate MySQL, necessitating a strong knowledge in this area. Key skills needed: - Familiarity with Odoo 17 - Expertise in Google Cloud operations - Proficiency in MySQL configurations Cease this opportunity to work on a highly professional project and bolster your profile.
...below. Of course, this is a very rough “plan and description” We would like to arrange a non-binding Zoom meeting to talk about our project. In the end, we need much more than what is written or listed here. We assume that you understand our requirements and that you work in a solution-oriented manner and with us in mind. Here you have a first description. This is how I made the advertisement: We are a brokerage platform. We refer customers to suitable workshops and need a solution in Salesforce for our lead management. 1. the customer makes an inquiry via our website (I could do this via WordPress by my own) 2. we check the request in an “admin area” and distribute the anonymized lead the anonymized lead manually to 3 partner wor...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
I need a professional to scrape specific details from a website directory for a one-time project. - Specifics: The data of interest includes the company names, their URLs, and their expertise. This information is laid out in rows on the website. - I wish for the freelancer to carefully extract this data, ensuring no errors or omissions are made. - The final output is essential to be in a CSV file format. I require this scraping to be done just once, and I do not foresee a need for ongoing scraping after this initial task. As the data is crucial for my business development, I am seeking someone who can deliver accurate and complete results in a timely fashion. Prior experience with web scraping and proficiency in data management are highly desira...
I'm currently encountering connectivity issues with my existing Azure Virtual Networks specifically with connecting to the MySQL database. I have a main Vnet with my mysql database in there. I have a virtual machine in there too which can connect to the database I have a second vnet which is peered to the main vnet. I have a virtual machine in this vnet too. It can talk to the virtual machine in the main vnet, but cannot connect to the database. I need it to be able to, and I cannot figure out why. You can tell me how to do it and I can test, this doesn’t need to be a long project!
I consider my self a linux user with more than 10 years of experince. I have having some issues with a linux server running mysql. From time to time it stops responding. I am unable to find the root cause. Therefor i need a linux guru to connect to my anydesk/teamviewer and debug with me till we find the error and fix it. We have various logs in the system so it will be helpful to debug
Here is a list of zip files on a US Govt website. You must write a Python program that uses a network library to download each zip file on this site, then find each .csv file in the zip archive, and copy each .csv file in each zip archive to a hard drive directory on the local windows machine. The directory will be "C:/MedicareDownloadFiles". The files cover the years 2017 to 2024. You may not hardcode file names ... you must extract the filenames from the above https URL. The fee for this will be $30. You must have it done within 60 minutes. Thanks for participating!
I'm looking for a skilled developer to migrate our Java-based desktop application onto the AWS cloud. The project involves: - Hosting the existing Java-based desktop application on an AWS cloud instance. - Implementing a multi-user access system. - Integrating a MySQL database component. - Developing a Python-based web interface for users to change settings. The ideal candidate should have: - Proficiency in Java, Python, and MySQL. - Prior experience with cloud hosting, particularly on AWS. - Knowledge of user access control systems, particularly Discretionary Access Control. - A good understanding of desktop-to-cloud migration. - Strong communication skills and attention to detail. We need a developer who can take a Java based desktop a...
I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a significant advantage. A sample pa...
I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.
Hi Dears, I am looking Laravel Expert on hourly basis. He should be able to improve the quality of code. Also, he should have experience to improve the performance of Laravel website. While bidding; kindly mention: 1. Your per hour rate 2. Previous Laravel Projects 3. Previous Laravel Projects detail where you improved Laravel Project/API Performance 4. Previous projects where you improved MYSQL performance for laravel
**Project Title:** Transfer and Enhance PHP/Mysql/Ajax Team Organisation Tool to Flutter Web App **Project Description:** We are seeking a skilled developer to assist in migrating an existing PHP/Mysql/Ajax Team Organisation Tool to Flutter, with the aim of releasing it as a web application. The primary objectives of this project include implementing a robust user authentication system, enhancing work organisation capabilities through calendar events, introducing user profile management for self-updating special user data, incorporating team management by assigning role models such as Teammember, Teamorganiser, Controller, Boss, and Admin, adding communication options to send team emails, chats, SMS, and WhatsApp messages, including timestamp func...
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 organized manner. As electricity supply continues to be a critical issue in Zimbabwe, it is imperative to have a system in place that can effectively manage the limited supply of electricity during periods of high demand or supply constraints. The Load shedding Scheduler System aims to provide utilities, grid operators, and other stakeholders with a powerful tool ...
I require a Linux WHM expert to assist with a critical data recovery issue. Specifically. Suddenly our mysql stop working. We had a dump of data but we need to solve the mysql issue or reinstall it (we can provide WHM and root access), and upload the data dump. Key Responsibilities: - Troubleshoot and resolve the MySQL data recovery issue. - Ensure the retrieved data is accurate and complete. We would like to know why this happends, to avoid it happends in future, by checking server logs. Ideal Skills and Experience: - Extensive experience with Linux WHM. - Proven track record in MySQL data recovery. - Understanding of data security and privacy best practices. - Prompt and effective communicator.
I need an experienced Shopify app developer to create a specialized app for me. This app should have the following functionalities: 1. Select the Order Date and time slot in the local delivery 2. Select the store pickup address for order 3. Very Pincode for local develiry is available or not this pincode? Require Skill - Shopify Order Edit - Shopify Webhook - REST API - Node.js and React.js - MySQL and Postgres - Javascript, HTML, CSS, Jquery A critical feature I require is the ability to gather specific information with each order. This should include: - The ability to select an order date via a calendar date picker. - Collect and record this order date. Ideal candidates for this project should be experienced in the development of Shopi...
...professional to help migrate my existing Grafana 8 alerts to Grafana 10. Your proposal should include detailed project plans and timelines for completing the following tasks: - Alert Configuration: This includes setting up and configuring alerts based on specific metrics, thresholds and conditions. - Alert Rule Mapping: You'll be responsible for ensuring that all alert rules are correctly mapped from Grafana 8 to Grafana 10. - Alert Notifications: Set up the necessary alert notifications to ensure they are received by the relevant parties promptly and efficiently. Ideal candidates should have: - Extensive experience with Grafana and its alerting system - A proven track record of successful alert migration projects - Excellent communication skills and a...
..., and its MySQL database on Cloudways. I'm looking for a professional to transfer both the frontend and backend to DigitalOcean. I need help in setting up the server and transferring the database as well. Key Project Requirements: - Transfer existing Angular project from to DigitalOcean - Move existing MySQL database hosted on Cloudways to DigitalOcean - Set up the server on DigitalOcean for hosting the Angular project - Transfer and configure the MySQL database on DigitalOcean - Ensure the migration process is smooth and without downtime - No manual deployment used, so expertise in this area is crucial Ideal Freelancer: - Proficient in Angular for frontend transfer - Experienced with setup and configuration of servers on Digita...
I'm in need of a skilled Shopify App Developer to create an innovative, new application that specifically includes an 'Order Date' feature. Key Function: - The primary function of this app needs to be the ability to select an order date. Additional Requirements: - The app must be easy to use and intuitive. - Requires seamless integration with my Shopify store. Ideal Skills & Experience: - Shopify App Development - UI/UX Design - Knowledge of eCommerce and order processing. - Node.js and React.js Expertise - Mysql and Postgres - Javascript, HTML, CSS, Jquery Looking forward to discussing potential approaches and ideas.
Custom Task Management System By ARABIC Language RTL , From Scratch SDLC To Deploy. I have Some Screens to understand Most Requirement> Requirement: PHP Laravel 11 MySQL Jquery CSS Bootstrap All Must be the last versions.
I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewe...
We have a device which is transmitting using JT808 , we want to capture that transmission and write in a mysql db. We will not provide documentation on JT808. Do NOT bid if you do not have experience with this protocol. If you have worked before with this protocol, please give a brief explanation of what you did.
I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.
...professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. ...
...a script that enables a user to input a unique pupil ID to look up their information, displaying only that specific row. The script should also include the following functionalities: - Show a direct link to the data in the selected row on another sheet, namely 'mywork sheet'. Ideal Skills and Experience: - Proficiency in Google Apps Script. - In-depth understanding of Google Sheets functionalities. - Experience in creating interactive scripts for Google Sheets. - Ability to build clear user interface for data lookup. - Familiarity with data linking across sheets. And in my words below I have a list of names on a Google sheet. - Pupils and their grades in each row. Currently I share this in view mode but they can all see each other's row of ...
At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, w...revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a ba...
...Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a download link to Excel Template PRO. * The email system should also forward invoice details to the buyer with a c...
...online web research in order to complete a spreadsheet with links to publicly available information. The spreadsheet contains a list of local council authorities in the UK. Each local authority maintains a list of private hire taxi vehicles. Your job would be to identify the URL of this list of vehicles for every council authority in the list. The job will involve using Google, or similar, to review and the relevant council website, find the link and update the spreadsheet. You may wish to use a tool such as ChatGPT to speed up the process. How you do this is up to you. Deliverables A completed online Google Sheets spreadsheet The skills you will need Self sufficient, strong search engine knowledge, efficient. I need someo...
I'm in need of an expert with outstanding knowledge of Gluster Configuration, Forge Laravel, Linode, an...of an expert with outstanding knowledge of Gluster Configuration, Forge Laravel, Linode, and nginx configuration to help deploy my Laravel application. You will employ the Forge Laravel server operating system for this project and will be required to set up a MySQL database to work in concert with my app. I'm looking for someone with: - A solid understanding of Laravel application deployment using Forge - Proficient skills in server configuration with nginx - Extensive knowledge of MySQL databases and their integration with Laravel projects - Experience with Linode If you are proficient in these areas, then you're the person I'm...
Excel expert. In excel, I have the following columns: Tasks, Responsible, Workload hours, and one column for each month with deadlines. For each responsible, I need the summarized workload by week. This is to be able to evaluate (based on the estimated workload-hours) if each responsible has enough available hours to deliver the tasks.
I'm looking for a Python expert who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will...
As I work to organize my impending exam schedule, I find myself needing assistance with expanding the current table. I have a standard, portable table, representing my schedule, which presently has less than 10 rows. I'm seeking help in modifying it by adding less than 10 more rows while maintaining its format. Here's what I require from you: * Experience in organizing and editing tables * Ability to discern formats and replicate them consistently * Capability to add rows as per requirements * Knowledge of moving text up and down the page Your task will entail the careful insertion of new rows and subsequent data filling. Your attention to detail will be vital in this project.
I'm looking for a talented and innovative graphics designer to create a logo from existing example.
...have around 70-80 tabs in excel that have projects and some other tabs that it’s not projects and I don’t need them . If I can give you list of tabs that I need to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ? The main tasks required are: - Merge the selected tabs i...
I am in need of a professional to convert a CSV file with about 3000 lines into a .sql file, ready for flawless loading into a MySQL database. THIS HAS TO BE DONE WITHIN THE NEXT 60 MINUTES. PLEASE DO NOT BID UNLESS YOU CAN DO IT IMMEDIATELY. THANKS. Payment will be $25. US Key tasks: - Convert provided CSV file into a .sql file - Ensure Date/Time values are formatted according to MySQL Date/Time format - Format numeric values as FLOAT within MySQL - Configure date/time values to match my local timezone Skills & Experience: - Proficient in SQL - Experience with MySQL databases - Attention to detail and accuracy Understanding of Time Zones would be a complimentary bonus. This project requires quality and accuracy. T...
