Mysql transpose rows to columns example jobs
I'm looking for a talented and detail-oriented designer to create an eye-catching front elevation for my single-floor house, based on a traditional style. Key Requirements: - Style: The design should reflect traditional aesthetics. - Materials: Incorporate a mix of glass, wood, stone, or any materials that could enhance the visual appeal. - Features: I would like the design to include a porch, balcony, and columns. Your Proposal: - Submit a portfolio showcasing your design skills, particularly in traditional architecture. - Provide a detailed proposal that outlines your approach to this project. - Budget is open to negotiation based on your experience and the quality of your proposal. Ideal Skills: - Proficiency in architectural design software....
Hello, I need a reliable, fast, and affordable installation of the Stripe payment processor for my website, from someone who keeps their commitments. This person must have knowledge of HTML, PHP, and MySQL. Regards
bjective: To create a website where parents can enter their child’s name, and the name will be automatically integrated into a pre-recorded audio story. The child’s name will be generated using Text-to-Speech (TTS) technology and merged with the main audio file. Scope of Work: Setup and Configuration: Install and configure WordPress on a suitable hosting platform. Ensure the environment is secure and optimized for performance. Frontend Development: Create a user-friendly form for parents to input their child’s name and provide consent. Ensure the form is responsive and works seamlessly across different devices and browsers. Backend Development: Develop a custom WordPress plugin to handle form submissions, generate TTS audio, ...
I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience...
...seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to...
...automation tools. We're looking to build a sophisticated website and dashboard, which will be later integrated with API and MySQL. The final product should be a robust, blockchain-based automation platform. Key responsibilities include: - Building a website and dashboard from scratch - Implementing blockchain technology for automation - Ensuring seamless integration with API and MySQL The ideal freelancer should have: - Extensive experience in web development, particularly in creating automation tools - Proven track record in implementing blockchain technology - Strong understanding of API and MySQL integration - Ability to deliver high-quality work within a short timeframe This is an urgent project, and we need someone who can start immediatel...
I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.
I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases
● Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker.
...talented full stack developer, specialized in Flutter, jQuery, MySQL, AWS, and Google Cloud Platform, to help me bring my vision to life. I plan to develop a premium content platform for the web. The platform will provide a seamless user experience yet restricts premium content behind pay walls. Key requirements: - Develop a web-based premium content platform using Flutter and jQuery - Implement a secure and reliable system for MySQL database management - Integrate an inbuilt payment gateway for user subscriptions - Utilize AWS and Google Cloud Platform to ensure the platform's scalability and performance Ideal candidates should have: - Extensive experience in full stack development - Proven expertise in Flutter, jQuery, MySQL, AWS...
Project Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly
I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.
...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficien...
...developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices...
...have a multi-story building project that requires an experienced structural engineer. Your primary task would be to evaluate the necessity of central RC columns in the building by checking the load distribution from the provided load calculation sheets. Key responsibilities: - Evaluate the need for central RC columns in a multi-story building - Thoroughly analyze the provided load calculation sheets for structural integrity - Provide alternative design solutions if necessary Ideal skills for this job would include: - Professional experience in structural engineering, especially for multi-story buildings - Expertise in evaluating load distribution and structural integrity - Ability to provide alternative design solutions based on your analysis Your work wil...
I'm sea...automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data ...
My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for...
Website Designer , Php , E Commerce having knowledge of MySQL
As trading markets speed up to a millisecond pace, I need a tool that offers a competitive edge. I'm specifically looking for a PC program that can live monitor order flow in a DOM (Depth of Market), successfully identify three-digit numbers and subsequently provide a sound alert to notify me. Key Details: - The program needs to be fast to cater for frequent changes in millisecond time-frames. - I don't have a preference for a programming language. Python, Java, and C++ are all acceptable. - At this stage, I'm unsure which order flow software I'll be using. Therefore, the program needs to be built with adaptability in mind to synchronize smoothly with any potential order flow software. - A sound alert should be triggered when...
I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.
...goal of this project is to improve our React application so it looks professional and has a better overall UX. Everything below should work on Chrome, Edge, Firefox and Safari of windows desktop, iPhone and android. Milestones will be created. Results card layout improvements: a) Currently, for layout with multiple laptops per row, it shows specs only on mouse-over, lets remove that and show that in the card itself, between the laptop image and the hyperlink of the laptop title. Lower the font a little bit and add a special css class to control the style of the specs. b) The cards need a bit more padding/margin so they dont look too crowded with information. Show Details popup: c) Show details popup needs to occupy 90% of the screen width showing the specs in two ...
Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend interface. Develop APIs for data retrieval and manipulation. Ensure seamless integration with the chosen frontend framework. Sections Requiring Backend Functionality: User Authentication and Authorization Data Retrieval for Services Newsletter Subscription Management Interactive Content Management Blog and Opinion Management Event Management Comment Section Functionality Social Media Integration Contact Form Submission Handling Specific Requi...
I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.
I need a professional to customize the invoice and sales quotation layouts on my Odoo 12 instance hosted in Google Cloud. The project involves: - Customizing the 'Header' section by changing the font style and size. Additionally, you'll be required to incorporate a company logo as well as a company stamp in the footer. - The 'Order Summary' section may involve rearranging columns, adding additional columns, customizing subtotals as well as adding a background image to the bottom of the layout. Ideal candidates should have: - Proficiency in Odoo 12 and experience in customizing its modules. - Strong background in Linux VM, specifically Ubuntu 18, and Google Cloud hosting. - A keen eye for design aesthetics and the ability to...
Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.
I am seeking an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. T...
??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candidate must be available until 3 pm New York time. ????????????????: ✅Develop fully automated strategies, indicators, and innovative software solutions using the NinjaTrader platform ✅Oversee the implementation and migration to GitLab ✅Develop and maintain back-testable signal indicators and server-based setups ✅Lead software migration projects to other platforms like TradingView and TradeStation ✅Perform quality assurance on all products, including webapps (internal/external), indicators, a...
...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficien...
We have a website developed in PHP & MySQL database. We need to add news section in the home page. The same should be available to be edited from the Admin Section for the user to change contents in the News Section.
...professional to help integrate PayPal legacy buttons into my existing shopping cart system. PayPal's documentation for the legacy buttons is not helpful. My add-to-cart button gets information from a mySQL database, but I'm unable to get the add-to-cart and view-cart buttons to work together. These used to work on an older web site. Key Requirements: - The main functionality is to enable my shopping cart to be able to process payments via PayPal. - The integration should direct customers to the PayPal website for payment processing. - I am looking for a manual coding integration, so experience in this is a must. Your Skills: - Proficiency in PayPal integration - Experience in manual coding for sh...
I'm seeking a skilled developer to build a professional and user-friendly dashboard using NextJS Ideal Skills: - Proficiency in NextJS for building feature-rich, responsive dashboards. - Experience with Paddle API integration, particularly for subscription management. - Strong knowledge of MySQL for robust database functionality. - A keen eye for UX design to ensure the dashboard is intuitive and user-friendly. - Ability to work efficiently and communicate effectively throughout the development process.
I'm currently looking for a skilled and experienced developer for backend CMS development. Key responsibil...looking for a skilled and experienced developer for backend CMS development. Key responsibilities: - Develop a Content Management System using PHP, Laravel, MySQL, and Python. - Design, implement and maintain python-based backend application. Essential Skills: - Proficient in PHP, Laravel, MySQL, Python. - Extensive experience in backend development. - Knowledge in CMS development and implementation. - Strong understanding of data structures and algorithms. Your analysis skills will also be put to good use to solve complex problems in this role. As an experienced backend CMS developer, you can expect to work closely with me to ...
...Sheets who can help me with a one-time analysis. The dataset to be worked on is quite large, with over 1000 rows, so I need someone who is well-versed in handling and analyzing large datasets in this platform. Key tasks for this project include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within Go...
Our website/bloge has been planned in these rows: 1. Head: our logo 2. Blog with 3 news 3. Field of actions (aree di intervento) 4. Events 5. Services/Programs 6. Books to buy 7. Video to watch The changes we need in our website template, row to row: 1. Head: our logo It is ok. 2. Blog with 3 news 2.1 Titles of the news has to be changed in lowercase (only first letter uppercase) 2.2 The text of the news have to wrap at the end of the word, not interrupting the word 3. Field of actions (aree di intervento) 3.1 The the written texts (Empowerment delle Persone, Empowerment delle Aziende, Empowerment delle Comunità Locali) have to be centred in the middle (horizontal direction) of 3 columns of news 4. Events 4.1 The width of...
...have a Wordpress plugin called Sales Agents B2B and I'm looking for a skilled Wordpress developer to make 4 small customizations to it. The customizations required are as follows: - Adding new functionality: - Creating a new user auto-filled commission - Allowing a 'Rol' option for subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plu...
I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the ...
I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run fo...
...integrates Paddle for subscription management and MySQL as database Key requirements: - Create a NextJS dashboard: The design needs to be clean and professional. I'm not looking for something overly complex, but rather a streamlined and user-friendly interface. - Integrate Paddle for Subscription Management: This functionality is crucial for the success of my project. I need the dashboard to seamlessly handle subscription management through Paddle. Ideal skills and experience: - Proficiency in NextJS: You should have a good understanding and experience working with NextJS. - Experience with E-commerce integrations: Ideally, you have previously worked on projects that involved integrating billing systems like Paddle. - Design capabilities: You are able to...
We are looking for a skilled freelancer to assist us with a high-speed web scraping project. Our existing web scraping scripts have been developed and deployed, but we need to optimize the scraping process to achieve faster data extraction rates. Responsibilities: Optimize existing web scraping scripts for speed and efficiency. Deploy and manage web scraping scripts on platforms such as Scrapy Cloud, Apify, AWS Lambda, or Azure. Implement techniques to ensure high-speed data extraction (e.g., parallel processing, distributed crawling, efficient request handling). Monitor and troubleshoot scraping processes to ensure uninterrupted operation. Collaborate with our team to understand project requirements and adjust scraping strategies as needed. Requ...
...a well-versed structural engineer to conduct a comprehensive review. To provide a bit of context: - The design is in its detailed stage and ready for a granular assessment. - I want a thorough examination of the entirety - from foundation to roof. This includes but is not limited to footing, columns, walls, beams and slabs. A successful bidder will ideally possess the following skills and experience: - Significant experience in residential project and structural design. - Attention to detail for detecting potential weak spots or errors. - Knowledge in the latest safety standards and building codes. - Ability to provide creative, practical, and cost-effective solutions for detected issues. It would be beneficial if you can also sugges...
I'm currently in need of a proficient backend developer who specializes in Node.js. Key responsibilities include: - Developing user authentication - Integrating the database - API Development The chosen candidate will preferably be experienced in and MySQL, although this isn't obligatory. knowledge is a bonus. In light of a tight deadline, applicants who can start as soon as possible will be prioritized.
I'm going to build auth login page using the react , tailwind css, express Mysql DB. Also we have to join with google acc , facebook acc, apple acc.
...a task of about 2-3 weeks to create an interactive workflow with React front-end and Python backend (see the 3 attachments to this post with the main job description is in the file MTQ - Upwork - Interactive Front Panel - and the other attachments are supporting documents). SUMMARY: Tabbed ReactJS forms with a Python backend that can interact with each other. The front-end can have a few input fields and a few interactive subcomponents in the form of either tables or images (with possibly overlaid hand-picked polygons), organized in a few columns. The layout can be customized (in the spirit of React-Json-Schema Form). The change in any Frontend component will be handled by a Python backend and the Python backend, in turns, can generate new data to update th...
...dedicated team, I am looking for an experienced Laravel developer who can bring their expertise and contribute to an ongoing School ERP project. Here's what I need - * Enhancement of Student Management module, streamlining the process of student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project stri...
I'm seeking a freelancer to assist with a simple data entry task. The project involves populating a spreadsheet with dates, expenses, and descriptions. I'll require this to be done just once. Key Requirements: - Entering data such as dates, expenses, and descriptions into a spreadsheet - The spreadsheet should consist of 3 columns - There will be about 200 rows I have made the spreadsheet already in Google Docs, all you need to do is fill it out with text from 200 File names which I will include This task is straightforward and should not take too long to complete. I'm looking for someone who can get this done accurately and in a timely manner. Please reach out if you fit the bill. Budget is ideally $10 AUD
...detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficien...
...developer in CodeIgniter and MySQL to help me enhance a school grading system. Please note, developers who can communicate in Spanish are particularly welcome. Key Upgrades Needed: - **New Features**: Primarily, I want to introduce online grade submission for teachers and a parent portal for keeping track of students' progress. These features will significantly elevate the utility of the existing system. - **Optimization**: It's crucial that the performance of the system is optimized during these upgrades to ensure it remains fast and responsive. Specific Design Requirements: - **Modern and Sleek Design**: The new features should be incorporated into a modern-looking interface. - **Simple and Intuitive Layout**: The design should be user-friendly ...
...dedicated team, I am looking for an experienced Laravel developer who can bring their expertise and contribute to an ongoing School ERP project. Here's what I need - * Enhancement of Student Management module, streamlining the process of student data collection, storage, and retrieval, along with student-related functionalities. * Improvement of Attendance Tracking module, allowing real-time tracking and management of student attendance. * Development and implementation of a functional Gradebook module, enabling easy, efficient tracking, storage, and retrieval of student grades. As for the technology stack, we work with Laravel, MySQL, and HTML/CSS. These are the tools you'll be using to modify and improve the functionalities. Finally, our project stri...
