Sql select from csv fileKazi
We are looking for an experienced Windows Server & VPS specialist to assist us with server migration, ongoing support, and future maintenance. Our infrastructure consists of multiple VPS instances, online backups, and SQL databases, all of which need to be migrated seamlessly to a new hosting provider. We want to host on OVHcloud. Key Requirements: ✅ 5+ years of experience with Windows Server (2016/2019/2022) ✅ Proven experience migrating VPS servers (Europe-based hosting required) ✅ Expertise in IIS, SQL Express, SQL server Web edition and online backup solutions ✅ Fluent in English (must be able to explain technical details clearly) ✅ Ability to provide ongoing support & troubleshooting when needed ✅ Knowledge of server security, performance tuning, and mon...
I'm in search of dedicated and dependable Virtual Assistants from the Philippines, India, Pakistan, and Bangladesh to join my team! This is a great long-term opportunity with increasing hours based on performance. The tasks I need assistance with primarily include: - Data Entry: Managing spreadsheets and updating databases - Social Media Management: Content creation, posting and scheduling, engagement and moderation Flexible hours will increase to several per day based on performance. Please confirm your available working hours, the days you can work and any religious or national holidays you observe. No prior experience is required as full training will be provided. Requirements: - A reliable internet connection - Strong communication skills - Detail-oriented and proacti...
...the Bill of Materials tab/page, along with an export and import data feature that supports Excel and CSV file formats. There are also some issues with the backend-frontend connection that need to be resolved. Scope of Work: -Enhancing Application Functionality: -Implement new features based on project requirements. Modifying SQLite Database Design: -Alter existing database schema to support the changes in the Bill of Materials tab/page. -Ensure data integrity and migration from the old schema to the new one. Implementing Data Import and Export Features: -Develop functionality to import data from Excel and CSV files with acceptable data points. -Enable export of data in both Excel and CSV formats. -Validate imported data to prevent inconsisten...
...skills in web development, Python programming, and database management. I'm dedicated to delivering high-quality results on time. Skills I offer: Web Development: Expertise in HTML5, CSS3, JavaScript, React.js, and GSAP for creating responsive and dynamic websites. Backend Development: Proficient in Flask and TypeScript for API design and server-side programming. Database Management: Skilled in SQL for designing, querying, and optimizing relational databases. Machine Learning: Experience in building and training deep learning models using TensorFlow and Keras. Project Experience: Worked on healthcare apps, event management systems, and personal websites with robust UI/UX. My Services Include: Full-stack web development Front-end animations and interactive features Databas...
I need a skilled developer with expertise in to implement a UI from my existing Figma designs. The project is not asking for design services, but rather for the translation of the designs into a functional UI. Complex pages were already designed remaining need to design as per existing ui and ux. There are 20-30 pages our fixed budget is $50 Ideal Skills and Experience: - Proficient in - Experienced with Figma - Able to transform designs into functional user interfaces - Understanding of best practices in UI/UX - Familiar with responsive design principles - Experience with e-commerce, blog/content, or dashboard/admin panel UIs.
I need someone skilled in data entry to help me transfer text data from online SQL databases into a different format. Ideal Skills: - Proficient in SQL and data handling - Excellent attention to detail - Fast and accurate typing skills - Experience with data entry from online databases Please bid if you are capable and experienced in SQL database operations and data entry.
My web application is experiencing sluggish SQL queries affecting user authentication, data reporting, and transaction processing. I require an expert in MySQL and Ruby to diagnose and resolve these issues. Ideal Skills: - Proficient in MySQL and Ruby on Rails - Experience with optimizing SQL queries I am unsure if recent modifications to the database or application code have contributed to the slowdown. Therefore, a thorough investigation and optimizations are necessary to enhance the application's performance.
We have a csv file with customer lists. They need to be re-formatted so they can be uploaded to our google ads. Right now, google can't read the files. there are 2 please bid
...should include comprehensive details about EPC certificates, their importance, an 'About Us' page featuring our team and mission statement, a Contact page, and Terms and Conditions. - Booking System: The main page will feature a booking system similar to This system should allow customers to select their preferred date and time slot. - Payment Processor: The booking system must be integrated with a reliable payment processor. - SEO: The website should be optimised for good quality SEO across all towns in the North West of England. A list of towns will be provided. Ideal Skills & Experience: - Proven experience in web development, specifically creating booking systems. - Strong understanding
...their work for publication. - The winner will be offered a standard traditional publishing contract, with terms disclosed upon selection. - Entrants retain copyright unless they agree to the terms of the publishing contract upon winning. - Forge Publishing reserves the right not to select a winner if submissions do not meet quality standards. - The winner agrees to work exclusively with Forge Publishing to prepare the manuscript for publication. - Forge Publishing is not liable for technical issues preventing entries from being received. - Runners-up may receive an offer for a hybrid publishing contract. - The contest may be amended or canceled at Forge Publishing's discretion. * Please include complete (already written) manuscripts ONLY. *...
I have a window form application developed in vb.net and sql server and I need some bug fixes in my application using vb.net code. The bugs are primarily found in the data processing and user interface. Key Issues: - Data Processing: The application is currently experiencing slow performance. This issue is impacting the overall usability of the application. - User Interface: Bugs in this area are causing unexpected behavior for users. Ideal skills and experience for the job: - Strong proficiency in VB.Net - Experience working with SQL Server - Previous experience in debugging window form applications - Good understanding of UI/UX design principles.
Project Title: Mini AI Code Generator for BDD Files Project Overview: I’m looking for an experienced developer/data scientist to create a compact AI tool that translates Behavior Driven Development (BDD) files into code. The project involves building a data model that learns from existing documentation and code, then uses that knowledge to generate code that calls the correct documented methods. Project Details: - Objective: - Develop a small-scale AI model trained on your provided documents and code examples. - The model should accept BDD feature files as input and output code that correctly implements the described behavior using specified methods. - Key Requirements: - Data Model: - Create and train an AI model using frameworks like TensorFlow, PyT...
...verified conversion. This approach is outlined in the “Flow of Telegram ” and we’d like the hired freelancer to implement it from start to finish. ------------------------------------------------------------------------------------------------------------------- Google Ads & GTM: Familiarity with Google Tag Manager triggers, events, and server-to-server conversion tracking. Programming Languages/Frameworks: Node.js or a similar server-side framework for both the bot and backend logic (preferred). Telegram Bot API: Experience creating and managing Telegram bots, handling bot commands, and subscribing to chat/member updates. Database: Experience with SQL or NoSQL databases to store the UUID/GCLID pairs and conversion status. -------------------------...
Google Ads Expert Needed – Full Setup & Management We are looking for a highly skilled Google Ads expert who can take full ownership of our Google Ads strategy, from setup to ongoing management. Our main goal is to increase relevant traffic to our website and drive conversions for our hunting exam courses in Sweden. What We Need: We are not looking for someone who will simply optimize existing campaigns. Instead, we need a specialist who will: * Set up Google Ads campaigns from scratch * Research and select high-performing keywords * Structure and manage all ad campaigns for maximum efficiency * Optimize ad copy, targeting, and conversion tracking * Continuously monitor and improve campaign performance * Ensure cost-effective bidding and high ROI Expectat...
...of Lillestrøm. Please note that the colors black and yellow are Lillestrøm Football clubs colors and that we are open to variation on these elements. The logo must be simplistic enough to print on glasses and we would like one element (such as the L) to be simple to take away to print on public spaces to instantly draw assosiation to our brewery. Following the three samples we will as a team select a way forward and make adjusments to the end product which should include both the final logo with all deliverables as well as a mockup similar to the one attached....
I'm looking for a professional lead generator who can find businesses in Perth, WA, specifically in the industries listed below. The leads should be provided in a CSV format. Business types: - Scaffold Company - Car Sales Yard - Panel Beater - Car Wrecker - Mechanic - Scrap Metal Yard - Construction Company - Trucking Company - Freight Company - Retail - Corporate Office - School - College - University - Hospital Key Requirements: - Gather leads from various sources: online directories, social media, company websites, etc. - Focus on collecting email addresses of these businesses. - Deliver the leads in a CSV format Ideal Skills and Experience: - Proven experience in lead generation - Proficient in data collection and analysis - Excellent understanding of the...
I am looking for an experienced professional to convert approximately 90 BLK format scan files from the plenum space above a drop ceiling into a detailed 3D Revit BIM model. The model should cover HVAC, electrical, and plumbing systems in high detail. The final deliverable will be a complete ceiling plan in Revit format. Key Responsibilities: - Merging BLK files and generating point clouds using Cyclone software. - Creating an intricate 3D Revit BIM model from the point cloud data. - Annotating and labeling all components in the Revit model. - Ensuring the model complies with International building codes. Ideal Skills and Experience: - Proficient in using Cyclone software for point cloud generation. - Highly skilled in Revit with a strong portfolio of BIM modeling. - Exten...
*Job Description*: We are looking for a talented and creative graphic designer to create a unique and professional logo for our brand. The logo must be versatile, scalable, and easily recognizable. *Skills Required*: - Proficient in Adobe Illustrator (or other design tools like Photoshop if necessary). - Experience in logo design ...composition. - Ability to provide multiple initial concepts and revisions as needed. - Portfolio showcasing previous logo design projects. *Project Details*: - Deliverables: Final logo in vector format (AI, EPS), PNG, and JPG. - Timeline: 7 days. - Budget: 500-1000 INR. *How to Apply*: Please submit your portfolio along with a brief description of your design process and relevant experience. We will select candidates based on their previous work and c...
I've just returned from a two-week international trip with my family, and we've captured over 1000 photos and 360 videos. I'm looking for a skilled video editor to help me compile this content into a single YouTube video, along with 6 short highlight videos tailored for each family member. Main Video: - Tone: Fun and lively. - Theme: Family bonding. Highlight Videos: - One video for each of the 6 family members. There are no restrictions on the choice of soundtrack, but the editor should be able to select suitable music that enhances the footage and fits the desired tone. Ideal candidates for this project: - Experienced video editors with a knack for creating engaging, family-centric content. - Able to select fitting music/soundtrack that complement...
...Design Style & Theme: ✔ Minimalist, yet futuristic ✔ Sleek metallic finish with subtle glow effects ✔ Professional, premium, and scalable (no overly complex designs) ✔ Balanced fusion of nature and blockchain aesthetics ? What We Expect from the Contest Winner ✅ Original, high-quality vector files (SVG, AI, PNG, JPG). ✅ Multiple versions (Full-color, monochrome, transparent, and favicon). ✅ Revisions if needed before finalizing the design. ✅ A chance to work with us on the full brand identity package (social media, website UI, pitch deck, etc.). ? We will select the best submission based on creativity, quality, and how well it aligns with our vision. ? Submission Guidelines: Only submit original work (no stock icons or templates). Provide a short explanation of you...
...consumption data as CSV. - Set alerts for excessive power consumption. - View and compare data for both locations. ### *Graphical Representation - Daily electricity consumption graph. - Weekly and monthly consumption trends. - Comparison charts for both office locations. - Interactive filtering and selection of date ranges. 5. Technical Requirements - *Frontend HTML, CSS, JavaScript (Bootstrap, jQuery) - *Backend PHP (Laravel/CodeIgniter preferred but not mandatory) - *Database MySQL - *Charting Library or similar - *Authentication Secure login with role-based access - *Hosting Compatible with LAMP stack 6. Security Considerations - Secure authentication and authorization mechanisms. - Data encryption for sensitive information. - Protection against SQL Injection ...
I need a professional to extract inventory details from the Ornate server and transfer them to my ERP NEXT system. The data is currently in JPEG and thumbnail format. It's crucial to note that the inventory data is only in image format, but the file names contain descriptive text and numeric data. The ideal freelancer for this project should have experience with data extraction and manipulation, and be proficient in working with image files.
I'm looking for a freelancer skilled in data entry to help me digitize some information from printed documents into a database. The data consists of both text and numbers, so attention to detail and accuracy is crucial. Ideal skills and experience for the job: - Proficient in data entry - Experience working with both text and numbers - Familiarity with database management - High attention to detail - Able to adhere to deadlines
Looking for High-Quality Backlinks from DP 50+ Websites (Netherlands Preferred) Description: Hi, I am looking for high-quality backlinks for my website in the Netherlands. I need backlinks that meet the following criteria: ✅ Domain Power (DP) 50+ websites only ✅ Netherlands-based (.nl) or authoritative global websites preferred ✅ Dofollow backlinks only (no nofollow links) ✅ Guest posts or editorial backlinks required ✅ Low spam score, high-quality and trusted websites ❌ No comment backlinks, profile links, or forum links When submitting a proposal, please provide: ? A list of websites where you can place the backlinks ? Whether content writing is included or if I need to provide the article ? Delivery time I am looking for a long-term collaboration with reliable freelancers. If...
...Work: API Integration: - Integrate OpenAI API key with the LMS. - Manage requests and responses efficiently, ensuring scalability and performance. AI Assistant: - Develop an AI-powered assistant that reads LMS data, including analytics and content. - Enable the assistant to respond to admin and learner queries based on the analyzed data. AI-Generated Images for Courses: - Add an option to auto-select images using free tools or generate images via AI during course creation. Content Summarization: - Implement a feature to summarize all content types within the LMS. - Use OpenAI to generate summaries for each topic and content piece. AI-Based Course Recommendations: - Create a recommendation tab powered by AI. - Suggest courses to learners based on their search behavior and LMS...
We are looking for an experienced ERP Specialist to implement and optimize an Enterprise Resource Planning (ERP) system for our business. The ideal candidate will be responsible for customizing, integrating, and maintaini...ERP modules to align with business processes (finance, inventory, HR, production). Integrate ERP with third-party applications and cloud services. Automate workflows and improve data management & reporting. Provide technical support & user training. Ensure data security & compliance with industry standards. Required Skills: Experience with ERP systems and business process automation. Knowledge of SQL, Python, Java, or ERP-specific languages (ABAP, X++). Expertise in API integrations & cloud-based ERP solutions. Strong understanding of finance, sup...
I'm looking for a designer who can create graphics and a mood board for a beauty-focused business. The design style should be clean ans creative, evoking a sense of fun and exclusivity. Key Requirements: - Develop a refined and sophisticated color palette that aligns with the beauty industry and the brand's desired aesthetic. - Expertly select and design typography that complements the brand's elegant and sophisticated style. - Create a range of graphics that will help to visualise and express the brand's identity. - Prepare a comprehensive mood board that encapsulates the brand's design vision. Ideal Skills: - Strong graphic design skills with a focus on brand development. - Experience in creating designs for the beauty sector. - Excellent understanding ...
I need a data analyst who can sift through our customer data to help us improve our customer service. The primary focus will be on understanding customer satisfaction levels. Ideal Skills: - Proficient in data analysis tools (e.g., Excel, SQL, Python) - Experience with customer data analysis - Ability to interpret and present data insights clearly Please provide examples of similar projects you've completed.
I'm in need of a professional with strong data entry skills to help me transfer numeric data from PDF files into a SQL database. Ideal Skills: - Proficient in numeric data entry - Experienced with handling PDF files - Familiar with SQL databases - Attention to detail - Ability to maintain data integrity
I'm looking for a skilled Python developer with experience in web scraping to help me extract text data from a specific web application. Key Requirements: - Proficiency in Python, particularly in libraries used for web scraping like Beautiful Soup, Scrapy, and Selenium. - Previous experience in scraping text data from web apps. - Ability to deliver clean, structured data in a timely manner. - Understanding of web app structure and how to navigate it for data extraction. If you have the necessary skills and experience, I look forward to seeing your bid.
I'm looking for a professional with excellent data entry skills to help me transcribe mixed data from physical documents into an Excel spreadsheet. Requirements: - Proficient in Excel and data transcription - Able to accurately transcribe mixed data (text and numeric) - Experience working with physical documents - Attention to detail to ensure data is entered correctly
...seeking a professional web scraper to assist in gathering data from various online platforms. The specifics of the project are yet to be fully determined, but ideally, I would like to scrape: - Product Information - User Reviews - News Articles The primary sources for the data collection could potentially include: - E-commerce Websites - Social Media Platforms - News Websites In terms of delivery format for the scraped data, I am considering options such as CSV, JSON, or Excel. However, the exact requirements will be finalized in consultation with the selected freelancer. Ideal skills for this job include: - Proficiency in web scraping tools and programming languages such as Python - Experience with data collection from various online platforms - Ability to d...
...which comes with WooCommerce uses the Listeo theme, however the CURCY multi-currency switcher third-party plugin that is installed does not work properly. The plugin only converts the generic products in the woocommerce online shop, and not the bookable Listeo related products. I need an plugin add-on that will convert the default currency of my wordpress online marketplace from USD to other currencies which users can select and pay in. The currency switching module must switch all the visible prices on the website pages, cart, checkout, bookings page and the order page. I want the multi-currency switcher plugin/extension integrated in my website to enable payments in different currencies through corresponding payment gateways. I need users to convert currencies using...
I'm looking for a seasoned digital marketing professional from Egypt to assist with my e-commerce project targeted at the Jordanian market. Key Responsibilities: - Oversee and manage social media platforms, primarily Facebook and Instagram, as well as my e-commerce website. - Implement effective SEO strategies to enhance our online visibility and drive organic traffic to our site. - Develop and manage PPC campaigns to increase our reach and drive sales. Ideal Skills: - Proven experience in digital marketing, specifically within the e-commerce sector. - In-depth knowledge of SEO and PPC strategies. - Strong background in social media management, particularly on Facebook and Instagram. - Familiarity with the Jordanian e-commerce market would be a plus.
I'm facing a bug in CodeIgniter 4 on my Ubuntu 22 server. The error is as follows: CodeIgniterDatabaseExceptionsDatabaseException #1055 Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by The issue seems to be affecting the user interface of my application. I'm not sure if it's related to recent changes in the code or if it appeared suddenly. Ideal candidates for this project will have: - Extensive experience with CodeIgniter 4 - Strong debugging skills - Familiarity with Ubuntu 22 Please provide a brief description of your experience with similar issues in your bid.
Tafadhali Jisajili ama Ingia ili kuona maelezo.
I'm looking for a freelancer with expertise in Power BI to create a network graph visualization for mapping out business processes. Key requirements: - The primary focus of the visualization will be on the steps within our workflows. - Data for this project will primarily be sourced from Excel/CSV files, so proficiency in handling these formats is essential. - The ideal candidate will have a strong background in business process mapping and data visualization, with experience using Power BI. - Excellent attention to detail and ability to communicate complex visualizations in a clear and concise manner.
I'm looking to integrate a 'select all' functionality for lighting data table into my Lightning Web Component (LWC) project. This feature needs to work across pages in pagination. Key Requirements: - we should use inbuilt select all checkbox at header level and shouldn’t create any separate checkbox - This functionality should facilitate bulk updates on selected items. - The feature needs to be consistent and function smoothly across different pages within the application. - selecting and deselecting should also work Ideal Skills and Experience: - Proficient in Salesforce LWC development. - Experience working with Lightning data tables.
I need a simple WooCommerce plugin that allows me to upload 4-5 PDF files in the backend. The plugin should enable users on the front end to select a PDF file from a dropdown menu and pose a pre-defined question to Chat-GPT about the chosen document. The response from Chat-GPT, which will be set up in the backend, should be displayed as a text summary on the page. Ideal skills and experience for the job: - Proficiency in WooCommerce plugin development - Familiarity with integrating AI tools like Chat-GPT - Experience with WordPress and PHP - Understanding of frontend/backend development in eCommerce context - Ability to create intuitive and user-friendly interfaces
I'm looking for a talented video editor who can help me edit some personal videos shot on my smartphone. The editing will primarily involve basic cuts and transitions to create a smooth and engaging final product. Ideal Skills and E...for a talented video editor who can help me edit some personal videos shot on my smartphone. The editing will primarily involve basic cuts and transitions to create a smooth and engaging final product. Ideal Skills and Experience: - Proficiency in video editing software - Experience with basic editing techniques - Creative approach to storytelling through editing - Ability to work with footage from a smartphone - Good communication skills to understand my vision and preferences I look forward to collaborating with someone who can help bring my ...
...measures, including firewall configuration, software updates, and other best practices, to protect the server from vulnerabilities. Post-Migration Support: Provide comprehensive post-migration support to address and resolve any emerging issues. 2. LMS Development & Enhancement: UI/UX Overhaul: Lead a comprehensive UI/UX redesign, focusing on a simplified and child-friendly interface. Implement single sign-on (SSO) and intuitive login processes. Develop distinct user interfaces for three user levels (students, teachers, and administrators). Ensure clear navigation, information architecture, and a visually appealing design. Facilitate easy enrollment for schools, classes, and users via CSV imports. Create a customizable interface for microsites and implement a mobile-fi...
ERPNext LEGO CSV Data Import Project goal Accurately import 12 CSV files containing LEGO-related data into ERPNext 15 without custom development or manual adjustments. Scope of work - One-time import of LEGO-related data from 12 CSV files into ERPNext 15. - Ensure correct mapping and dependencies between entities like Parts to Colors and Sets to Inventories. - LEGO part numbers must remain unchanged (scanable & searchable, no modifications). Additional information - DO NOT create new Doctypes or Custom Apps – the import must work with ERPNext's default structure. - No automation scripts or future update tools needed – this is a one-time import.
I'm seeking a professional designer to create a complete branding guideline for my logo, including its application on various stationery items such as business cards, letterheads, and envelopes. The ideal candidate will: - Construct a versatile logo with variations for different uses. - Develop a clear and cohesive color palette. - Select appropriate typography that aligns with the brand's identity. - Create intricate patterns and stationery designs (prints). - Define clear space requirements and develop a monochrome version of the logo. Deliverables will include all logo files in various formats (png, jpeg, svg) and a detailed branding guideline chart. Skills and experience required: - Proven graphic design experience, particularly in logo design and branding. - Stro...
I'm looking for a freelancer to help me import 1-50 automotive parts from Aliexpress to my Shopify site. The job includes making minor adjustments to product descriptions when necessary. Ideal Skills and Experience: - Proficient in Shopify - Familiar with Aliexpress - Attention to detail for product description adjustments - Knowledge or experience in automotive parts is a plus
I'm seeking an experienced technical content writer with expertise in e-commerce platforms. The job involves creating various technical documents and visual aids to facilitate product/system understanding. Key Responsibilities: - Writing user manuals and API documentation - Crafting product descriptions - Drawing architecture and flow diagrams using Microsoft Visio or any other tools Ideal Skills: - Proficiency in technical writing - Familiarity with e-commerce platforms - Experience in creating user manuals and API documentation - Ability to create clear and concise product descriptions - Skilled in using Microsoft Visio for diagram creation Please note that familiarity with specific e-commerce platforms like Shopify, Magento, or WooCommerce is a plus,. The focus is on the abilit...
I'm an English literature student seeking a dedicated tutor to help me improve my English skills from A1 to C2. I'm currently at an intermediate level (B1-B2) and would like to have lessons twice a week. The lessons should encompass: - Grammar and vocabulary - Speaking and listening - Reading and writing Ideal candidates would be proficient in teaching English as a second language, have a strong understanding of English grammar and vocabulary, and be able to engage me in speaking, listening, reading, and writing exercises. Experience with teaching to advanced levels (C1-C2) is preferred.
I am looking for a data extraction specialist to help me collect dealer contact details from a specific manufacturer's website. The information is presented in a list format on the site. Key Requirements: - Extract dealer contact details from the manufacturer's website for 2 specified products and its sub products. - Deliver the data in an organized manner in 1 day ie in a few hours - Respect the confidentiality and integrity of the data. Please contact only if you have time today and can deliver in a few hours Ideal Skills and Experience: - Proven experience in data scraping and extraction by using python. - Familiarity with working on websites data extraction is a plus. - Excellent attention to detail and ability to deliver high-quality work on time.
My website built on the Zend MVC framework has a malfunctioning password reset function. ...website built on the Zend MVC framework has a malfunctioning password reset function. I need an expert to investigate and rectify the issue. - Issue: The password reset function is not working. If I attempt to manually reset a password from the database, it causes the admin login to fail. This renders the admin section unusable. - Current Method: I am currently using a direct SQL query to reset passwords in the database. because admin is not sending password reset emails Ideal Skills and Experience: - Proficiency in Zend MVC framework - Strong understanding of SQL - Prior experience in troubleshooting and fixing website functionalities - Familiarity with admin panel function...
I am looking for a certified financial planner with expertise in Excel to assist me with financial analysis. The data will be sourced from CSV files or other external imports. Key Requirements: - Proficient in Excel with advanced financial analysis skills - Certified financial planner - Experience with handling and analyzing data from CSV or external files - Ability to present findings in a clear and concise manner The ideal candidate will have a strong background in financial analysis, specifically using Excel, and can help me gain insightful perspectives from my data.