Mysql update database large cvs file jobs
I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your proposal. Thank you.
Hi Moufi K., We just noticed that you posted a project for "Development of a Virtual Employee (AI) for Building and Modifying Systems in Laravel, PHP, and MySQL" (https://www.freelancer.com/projects/php/Development-Virtual-Employee-for/details)
...various business services, including branding, printed materials, social media management, and ERP software solutions. Project Overview Platforms: Web Application Mobile Applications (iOS and Android using React Native Expo) Dashboards: Client Portal Admin Portal Employee Portal Guest Portal Preferred Tech Stack: Frontend: React (Web) and React Native Expo (Mobile) Backend: NestJS or Database: Prisma ORM Core Features Guest Portal (Web & Mobile): Welcome screen showcasing platform highlights. Options to sign in, sign up, or continue as a guest. Menu with sections: Products, About Us, Portfolio, Branches, and Client Portal. Product browsing with category filtering and portfolio examples. Checkout process with a questionnaire (except for Social Media and Software Developm...
I am looking for a professional with expertise in engineering and automation to design and build a device capable of sorting large pieces of plastic waste. Key Requirements: - The device should specifically handle large plastic scraps, which are over 5 inches in size. - The sorting process must be fully automated, eliminating the need for manual intervention. - The design of the device should be robust and efficient, capable of processing a significant volume of waste. Ideal Skills and Experience: - Prior experience in designing waste segregation machines. - Strong background in automation and engineering. - Proven track record of delivering high-quality, efficient solutions. Your expertise will help in creating an effective solution to manage plastic waste, contributing t...
Aarambh Events Tagline - Moments Made Magical I need minimalist & modern brandable logo for Event Management company which is mainly in to wedding and organizing large events and parties. Logo should carry exact words of the brand, appropriate creative elements like images or abstract shapes. Expecting to give more prominence to Aarambh in logo. While designing logo one should keep in mind target audience and offerings. Ideal Skills: - Graphic Design - Logo Design - Typography - Adobe Illustrator Experience: - Proven track record in creating modern, minimalist logos - Strong portfolio of Logo Making - Ability to work with specific color schemes - Excellent understanding of typography
I need a professional with experience in file editing to modify both a STEP and DXF file. Requirements: - Change the width dimension of the file. - Update the title block with new part number, description and material. Ideal skills include proficiency in CAD software and experience with STEP and DXF file formats. Attention to detail is crucial for ensuring the modifications are accurate.
I have multiple .stl and .obj files that require modification before they can be 3D printed. Specifically, the tasks will involve: - Adding or removing structural components from the files. Ideal candidates for this project should have: - Proficiency in 3D modeling software. - Prior experience in preparing files for 3D printing. - Strong attention to detail. - Ability to understand and implement necessary changes to structural components.
I need a professional graphic designer to update my current logo. The goal is to give it a cleaner, more professional appearance while retaining the existing logo shape/design. - Key Requirements: - A strong portfolio of logo design - Ability to create minimalist and modern designs - Experience with web-focused design The updated logo will primarily be used on my website, so it needs to be optimized for web use.
...engagement, and mobile usability. The website is built on WordPress and primarily uses the **Divi Theme** and the **Fancy Product Designer (FPD)** plugin for custom product designs. A new website design is also required to meet the mentioned requirements. Key Requirements: 1. **Performance Optimization:** - Improve site loading speed using caching, image optimization, minification, and database cleanup. - Implement GZIP compression and assess plugins for performance impact. 2. **User Engagement and Conversion:** - Redesign navigation for intuitive user flow. - Add clear call-to-actions (CTAs) and social proof elements like customer reviews. - Optimize the checkout process for a seamless user experience and higher conversion rates. - Set up ab...
i Need Royal look & update India map & world map(HD images ) Purpose: To create wooden jigsaw puzzle design. (But you share me a plan images not cutting images) Pls Don"t copy paste from google images. size: For India map -34x40 cm for world map-40x34 cm For example, check the attachments. If any quires, contact me
...Website and E-commerce Specialist. In this role, you will be responsible for managing and optimizing our website, eBay, and Amazon platforms. Your primary focus will be to ensure that our online presence is up-to-date, user-friendly, and competitive in terms of pricing. This is a remote position, allowing you to work from the comfort of your own home. Responsibilities: Website Management: Regularly update and maintain our company website, ensuring accurate product listings, pricing information, and images. E-commerce Platforms: Manage our presence on eBay and Amazon, including adding new products, updating existing listings, and optimizing content for maximum visibility and sales. Competitor Analysis: Conduct ongoing research to monitor competitor prices, promotions, and strate...
I want to watch the changes in holder numbers, bio, etc over time of one website, two different sections: and There is a list of agents on each of them. Once one clicks on one of them there is plenty of info. Collect and put in json on file (2 jsons, 1 for each of the sectors) Important: Deliverable is the python script. I want to be able to update the data daily.
...ticket or product purchases trigger the appropriate commission logic. Testing and Quality Assurance: Thoroughly test the system to ensure accurate commission calculations, smooth integrations, and error handling. Key Requirements: // Expertise in WordPress and WooCommerce development. // Familiarity with Ultimate Affiliate Pro or similar affiliate marketing plugins. // Strong skills in PHP, MySQL, and WordPress plugin customization. // Ability to handle custom logic and conditional workflows. // Experience with dashboard UI customization. Additional Details: Specific details about the business model and affiliate structure will be shared after signing a Non-Disclosure Agreement (NDA). This project involves implementing both standard features and customizations to match uniqu...
I'm looking to completely renovate my bathroom with a modern design. This will include layout changes and a full update of various elements. Key Renovation Areas: - Plumbing and Fixtures: All existing plumbing and fixtures will need to be replaced. - Flooring and Tiles: A complete overhaul of the flooring and tiles is necessary. - Cabinets and Storage: The current cabinets and storage will need to be replaced with modern alternatives. Ideal Skills and Experience: - Extensive experience in full bathroom renovations. - Strong understanding and capability in modern design aesthetics. - Proficiency in plumbing and fixture installation. - Expertise in tiling and flooring. - Experience in designing and installing modern cabinets and storage solutions.
Update the Order max Condition & Warning on add new project I managed to restore the first version, just have lost the correct version and the warning update on add new project
I'm looking for a skilled individual to manage various clients' social media accounts. The platforms include Facebook, Instagram, Twitter, LinkedIn, and TikTok. Your role will involve developing these pages, creating engaging content, and ultimately helping to increase our follower count. Key Responsibilities: - Regularly update and manage the mentioned social media platforms - Develop social media pages for different clients - Create a variety of content including images and graphics, videos, written posts, and ads - Strategize and implement ways to boost follower count Ideal Skills: - Proficiency in managing multiple social media accounts - Experience in content creation, specifically images, videos, and written posts - Knowledge of social media growth strategies - Fam...
I'm seeking a web developer to create a small-scale HR management system. The application should allow the addition of new employees, inclusive of basic details and department allocation. It should automatically generate offer letters and send them to the respective employee's Gmail account. Key Features: - Employee Management: HR can add new employees and update their salary. The system should capture the employee's name and contact information, position and department, emergency contact and ID proofs. Additionally, there should be an option to upload various documents like Adhaar card, PAN card, education and experience letters. Employee onboarding page where they can enter all personal and professional details and attach the above mention documents. - Attendance ...
...strictly deadline end of January [3 weeks] Can code in React (Frontend) frpm scratch as on but with some modern technologies which elements you can see in attach scope of work and Node.js (Backend) which we already have. Developer must have previous experience with hotel-related platforms and can provide proof of previous work. Understands the intricacies of developing large-scale platforms similar to Booking.com. Project Overview: We are developing an advertisement platform for hotels, not a booking platform. This platform will: 1. Allow hotels to list themselves using advanced AI technology. 2. Be user-friendly, simple, and interactive, requiring no involvement from us in the listing process. 3. Be designed to handle 500,000 to 1 million hotel listings seamlessly
...A visually appealing and responsive landing page that dynamically displays content. 2. Contact Us Page: A functional and dynamic contact form where user inputs are saved to a database and can be accessed via an admin panel. 3. Blog Page: A blog section where I can add, edit, and delete posts dynamically using an admin panel. The blog should support categories, tags, and a search function. Key Features Required: • Fully responsive design (desktop, tablet, and mobile). • Admin panel/dashboard for managing content (blog posts, contact form submissions, etc.). • Backend development with database integration (MySQL or similar). • Framework/Platform: [Specify your preferred framework, e.g., Laravel, Django, Node.js, or WordPress if dynamic featu...
I'm a beginner in Power Queries, seeking a tutor to guide me through data transformation and merging queries. Together, we'll improve an existing Excel file for better data organization. Sessions will be over Zoom, which will be recorded for future reference. Ideal skills and experience include: - Proficiency in Excel, particularly Power Queries - Prior experience in online tutoring or teaching - Ability to simplify complex concepts - Strong communication skills - Patience and understanding towards beginners
...requests. Key Goal: Have a minimal but complete system that you (the owner) can log into and manage all your property-related data—without the complexities of a multi-tenant or SaaS platform (that may come in a future phase). 2. Scope 1. Single-User Authentication • A single admin login (username/password). • Basic session or JWT-based security. 2. Property & Unit Management • Create, read, update, delete (CRUD) properties. • Each property has multiple units, also managed via CRUD operations. • Track status of units (occupied, vacant, under maintenance). 3. Tenant & Lease Tracking • Add and edit tenant profiles (contact info). • Assign each tenant to a specific unit, with lease start/end dates. • Store basic lease...
I need a MySQL stored procedure that calculates both the Exponential Moving Average (EMA) and the Simple Moving Average (SMA) for stock prices. Key Requirements: - The stored procedure should execute daily. - It should process stock prices data. Ideal Skills: - Proficiency in MySQL. - Experience in writing stored procedures. - Strong understanding of stock price data. - Familiarity with EMA and SMA calculations. The successful freelancer will have the opportunity to work on this project regularly as I need this procedure to run daily.
I need help configuring New Relic on my Linux server. The New Relic PHP agent is already installed, but I need help with monitoring MySQL and Apache. Key monitoring tasks: - MySQL: Performance metrics, Query analysis, Error tracking - Apache: General health and performance - Php performance data, average response time, max execution time in peaks, peaks of memory usage and how much memory is used then. - response data from third party applications monitored. Ideal candidates for this project should have extensive experience with New Relic, Linux servers, PHP, MySQL, and Apache. The ability to analyze and interpret performance data is essential.
I need a skilled PHP developer to help me fix some issues on my website that have recently arisen. The problems include: - Pages not loading - Error messages being displayed - Slow performance These issues started following a recent update to the site. I'm looking for someone who can troubleshoot and resolve these problems swiftly, so my site can get back to normal operation. Experience with PHP and web server management is crucial for this job. I believe it will take 2-3 hours.
I need a professional who can help synchronize my MySQL database with my Telegram mini app. This will allow my webapp users to validate their earnings accurately. Key Requirements: - Database Synchronization: You will be responsible for ensuring seamless communication between my MySQL database and the Telegram mini app. - MySQL Proficiency: A deep understanding of MySQL is crucial, as this is the platform currently in use. - Data Validation: The primary focus will be on validating users' reward points. Ideal Skills: Webapp: php Laravel backend, frontend Vue.js Tailwind CSS php frontend react - Expertise in Database Management - Proficient in MySQL - Experienced in working with Telegram Bots - Strong understanding o...
My current Filemaker to Xero integration needs an update. The connection should support exporting invoices and adding sales analysis code. The access token has expired and is not refreshing. Performance issues are impacting the efficacy of the integration. Ideal Candidates Should Have: - Extensive experience with Filemaker and Xero integrations - Familiarity with OAuth2 protocols - Problem-solving skills for troubleshooting connection issues - Ability to implement necessary changes for performance improvement I would also like them to add a 'Sales Analysis' field within my Datafile stock items and then have this sales data transfer to Xero with the associated invoices so i can analyze the data in Xero.
I need assistance in removing and updating the footer on my WordPress site to change its design/layout. This task requires a keen eye for design and understanding of WordPress theme settings. Your expertise in WordPress will ensure a smooth and efficient process.
...APIs or GraphQL for communication between frontend and backend. Database: Use MongoDB or PostgreSQL to store user data, course details, and transactions. Cloud Integration: Use AWS or Firebase for cloud services like video storage, live streaming, and user authentication. Payment Processing: Include APIs for payment integration (e.g., PayPal, Razorpay, Stripe). Video Streaming: Use platforms like AWS MediaLive, , or Twilio for live and on-demand video streaming. Deliverables: A functional prototype of the app for both Android and iOS. Backend APIs for user authentication, course management, and payment processing. Frontend UI with seamless navigation for users and instructors. Scalable architecture for supporting large volumes of users and video streams. Additional Not...
...aspects of our website and improve our search engine rankings. The ideal candidate should have strong experience with WordPress development, optimizing site performance, and implementing SEO best practices to drive traffic. You’ll be responsible for ensuring our website is running smoothly, user-friendly, and optimized for search engines to help us grow our audience. Responsibilities: Maintain and update the WordPress website. Implement SEO strategies to improve content ranking. Troubleshoot website issues and optimize page loading times. Collaborate with the content and design teams to ensure a seamless user experience. Qualities Needed: Strong technical skills in WordPress development. Passion for SEO and improving website performance. Adaptability to stay updat...
I'm in need of a Zoho Books professional who can assist with the setup and configuration of Zoho Books, specifically focusing on data import and migration, as well as customization and integrations. Key Requirements: - Importing large Excel files containing product information into Zoho Books - Customizing and integrating Zoho Books to suit my business needs - Initial setup and configuration of Zoho Books Ideal Skills and Experience: - Extensive experience with Zoho Books - Proficiency in data import from Excel to Zoho Books - Ability to customize and integrate Zoho Books - Previous experience in setting up Zoho Books
I'm looking for a talented designer to create a T-shirt print design for my fashion clothing brand, Miami Surf Wear. The design should evoke a sense of 1990's fashion nostalgia, filled with vibrant neon colors and bold primary hues. Key Elements: - A combination of striking artwork and large or small 90's style fonts. The text should include "Miami Surf Wear" text in the design. - Creative use of vibrant patterns typical of the 90's era. - An understanding of the surf culture aesthetic. - Ability to infuse the essence of 1990's nostalgia into a contemporary design. Ideal Skills: - Proficient in graphic design and T-shirt design. - Strong background in 1990's fashion and surf culture. - Expertise in creating designs using neon colors, vibrant...
I have a Python file that works but needs finishing off with the addition of new API endpoints. It also requires quality assurance, integration to AWS Lambda, setting up API Gateway and an EC2 instance. Ideal Skills: - Proficient in Python - Telegram inline markup - Experience with AWS services (Lambda, EC2, API Gateway) - Strong in Quality Assurance The additional functionality required includes: - Implementing new API endpoints - Ensuring these endpoints facilitate data retrieval and data submission Please note, the existing Python file is functional, the work mainly revolves around adding new features and ensuring everything runs smoothly on AWS.
Need a database of companies: Location: Singapore Industries: any Company Name: 100% Email: 100% Industry: 100% Phone: optional Address: optional Postal Code: optional Numer of companies: max
I'm a streamer. I need a program/overlay that can show the number of my Instagram followers on my stream in real time. They must update in real time.
...style. Style: We are looking for a design that keeps the essence of the symbol while making it more abstract and clean. Lines should be smooth, fluid, and geometric. Colors: Preference for a metallic golden tone or a monochrome color palette. Avoid overly bright colors or complex gradients. Usage: The logo should be versatile, working both with and without text. It must look great in both small and large sizes (favicon, banners, business cards, etc.). Format: Deliver the logo in high-resolution formats (vector files like .AI, .EPS, .SVG, and raster files like .PNG, .JPG). Inspiration Examples: We have a base idea inspired by the traditional Eye of Horus design, but we want to get creative and modern reinterpretations. (attached) The logo should evoke elegance, technology, and a ...
...Responsibilities: -Building out modular/component-based visual frontends in tandem with HTTP APIs and modern CMS platforms. -Bring visual designs to life using the latest in libraries, frameworks, and tooling. -Experimenting with advanced visual techniques and animations to test the limits of what is possible in modern CSS. -Defining and setting up a strong foundation for long term maintainability for large scale design systems, and architecting solutions for today's problems and accommodating what future iterations might bring. -Consult with our in-house visual design team on technical feasibility, prototyping complex interactions or dynamic interfaces, or brainstorming on possible solutions to the problem at hand. -Learn new technologies on the job. We do not specialize in...
I'm seeking a skilled 3D modeler to create high-detail, dark and metallic, futuristic spaceship models based on provided sketches. Key Responsibilities: - Design and model intricate, high-detail spaceship exteriors. - Texture models using Adobe Substance to fit a dark and metallic pale...each model: one ready for Unity integration and another fully textured for external use. Compensation: - Simple designs: $15, Regular designs: $25, with potential for increased rates as the project progresses. Ideal Skills: - Proficiency in 3D modeling software (e.g., Blender, 3ds Max). - Expertise in texturing with Adobe Substance. - Experience with Unity integration. This project is part of a large, expanding venture in its early stages. A successful collaboration could lead to long-term...
I'm in need of a skilled freelancer with extensive experience in Zoho CRM and database management to synchronize our Zoho CRM with our database. Key Responsibilities: 1. Data Update & Cleanup: - Align our CRM with the database by adding missing fields, such as 'Subscription', 'Rating'. - Identify and clean duplicate and dead records, i.e. blocked email addresses. 2. Database Synchronization: - Develop a Python script for fetching data from our database and updating or adding records in Zoho CRM. - Ensure the script is capable of handling incremental updates and can operate on a set schedule. 3. Documentation & Automation: - Create clear and concise documentation detailing the cleanup and synchron...
I'm seeking a freelancer who can compile a full list of estate agents across the entire UK. The deliverable should be a CSV file containing the following information for each estate agent: - Name and Address - Contact Details (including email and phone numbers) The ideal candidate for this project would have experience in data collection and market research, particularly in the real estate sector. Proficiency in using tools for data extraction and a keen eye for detail will be crucial for ensuring the accuracy and completeness of the database.
I need a system that uses a Large Language Model to summarize and condense lengthy educational materials, such as full-length lectures and PDFs, into concise and easily digestible formats like video snippets, infographics, and text summaries. The goal is to enhance learning efficiency by transforming complex information into byte-sized content. Key requirements: - The system should be able to process a variety of sources for content generation, including full-length lectures, PDFs, and web articles. - It should also be capable of incorporating interactive elements into the summarized content, such as quizzes, clickable links, and interactive diagrams. Ideal skills and experience for the job: - Proficiency in developing systems powered by Large Language Models. - Experience ...
Please create 6x product packages as per zip file instructions send via message.
... - Classification of Expenses and Income: I correctly organize and classify transactions into the appropriate categories. - Duplicate Removal: I look for and eliminate duplicate transactions or unnecessary records that may inflate financial reports. - Inventory Regularization: If you manage inventory, I verify the accuracy of inventory records and adjust quantities as necessary. - Missing Data Update: I complete any missing information in transactions, such as descriptions, invoice numbers, or supplier/customer data. - Report Generation: I create personalized financial reports that clearly show the business's financial health. - Ongoing Support: I offer ongoing support services to address questions and issues as they arise. - Automation: I help automate recurring processes a...
...report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code to to comunicate with an AI the plugin (uncanny o Ai engine): Finally it is necessary show the report inside a web page and create a pdf. The report must have an excellent design, it must chart and tables create with the information of report of AI. So it is necessary use insi...
...retailers to view past purchases and make forecasts. 3. Target Audience: Farmers: Small, medium, and large-scale farmers looking to sell their crops directly to retailers. Organic and sustainable farmers who want to promote their products. Retailers: Local and regional grocery store owners, supermarket chains, and other businesses in need of fresh produce. Wholesalers who want to buy in bulk directly from farmers. 4. Key Features and Functionality: 1. User Registration & Profiles: Farmers: Create profiles with crop types, location, and harvest details. Retailers: Register their business with location and contact info. Profile Management: Ability for both farmers and retailers to update their profiles and product listings. 2. Product Marketplace: Search and Filter: ...
...services/products with buyers from academic institutions, biotech companies, and pharmaceutical firms. Project Requirements The project will include the development of the following core components: 1. Admin Panel Comprehensive dashboard to manage users, transactions, approvals, and overall platform settings. 2. Vendor Panel A dedicated space for service providers to list their offerings, manage orders, update availability, and communicate with buyers. 3. Buyer Panel A user-friendly interface for researchers and companies to browse services, request quotes, place orders, and track project progress. 4. Marketplace Frontend A public-facing platform where buyers can search for vendors, explore services, and engage in transactions securely. Key Features Service Listings Detailed se...
... Employee role for accessing personal data and requesting leaves. 8. Additional Features: Secure login system with role-based access. Responsive design compatible with desktop and mobile devices. User-friendly interface for seamless navigation. Technical Requirements: Frontend: React.js, Angular, or similar modern frameworks. Backend: Node.js, Django, or Laravel (or suggest the best fit). Database: MySQL, PostgreSQL, or MongoDB. Hosting Platform: Use my existing hosting and domain. Security: Implementation of HTTPS, secure data storage, and user authentication. Deliverables: Fully functional and responsive CRM system. Documentation for system usage and maintenance. Deployment on my hosting server. Post-launch support for bug fixes (for an agreed period). Timeline and Budge...
I'm seeking a designer to develop six, two-page, A4, multi-coloured, creative and modern resumes/CVs. Key Requirements: - Each design needs to be a single page, with a second page designed for run over in the same style. - The design should be professional and clean, integrating elements of creativity and modernity. Design Elements: - The use of photos, graphics and Icons is allowed. I want the resumes to stand out visually and convey information in a clear, engaging way. - Typography and Fonts are also a key consideration. The text should be easy to read and aesthetically pleasing. - Layout and Structure will be critical to the overall design. Each resume should be well-balanced and easy to navigate. I have a general idea of what I want, but I need a designer who can bring...
Backend API Development Using TypeScript & Node.js - Sign-in, Signup, Reset Password, Forgot Password & Verify OTP - Dashboard Stats - Workspace and Project APIs - Packages and Payment APIs - Profile Update and Change Password - Contact Us - Admin APIs
I want to create a website in domain , I am going to launch first product as baby carrier bag and will update products in future, i want my customers to land up in this page, website pages templates should be like it is a imaginary world where mewz roam with his friends and care more about his friends, my customers need to enter to this website, giving their contact details like name,phone, email,address etc, and i can give them offers if they rate me in amazon website I will give them freegifts, I want a full clarified attractive website design for my baby products, here below I attached imaginary lion mewz photos which can be used to create templates