Insert or update in a single query jobs

I require a skilful web developer to update and enhance our church's informational web page. The project will involve several tasks, brought to life with a bright and colourful design scheme to represent our vibrant community. Key Requirements: - Development of five main sections: 'About Us', 'Services', 'Events', 'Ministries', and 'Contact Us'. Each should be easily navigable and user-friendly. - The 'About Us' page should provide a detailed account of our church, our mission and beliefs. - 'Services' should outline the various services we offer, including schedules and descriptions. - 'Events' needs to showcase upcoming and recurring events, with an option to register intere...

I am in need of a professional that can help me compile a customer email list from a single business email address. The purpose of this email list is to support our marketing campaigns, allowing us to reach out to our customers and potential leads. The ideal candidate for this job will be able to gather this information solely from the incoming emails, as well as categorize them based on customer interest. Key responsibilities: - Compiling customer email list from a single business email address - Ensuring categorization of emails by customer interest Ideal skills for this project: - Proficiency in handling emails and email extraction - Experience in compiling and organizing customer data - Strong analytical skills to c...

I'm looking for an experienced developer to create a robust and user-friendly app and mobile website for a paid live stream service and profile advertising. The primary functions and features of this project include the following: - User Registration and Profile Creation: Users should be able to create accounts, access and update their profiles. The profile should include essential details like Name, Occupation, Location. They should be able to change their location and update their profiles every 60 days. - Paid Live Stream Service: The platform should have a paid live stream service where users can access and view streams. - Profile Listing: The app and website should also have a feature where users can view and rate profiles. - Facial Re...

I need to update my website contact information on Hostinger. This involves changing the WhatsApp number displayed on the site and optimization in the hosting. Key requirements: - Replace current WhatsApp contact with a new number - Ensure the update reflects on website in a timely manner Ideal Skills: - Proficiency in managing and updating contact information on hosting platforms - Previous experience with Hostinger is a plus - Attention to detail to make sure the update is correctly reflected on the website I'm looking for someone who can carry out this task quickly and accurately. Please ensure you have the necessary skills and experience before bidding.

Code a dynamic input field feature for quick data entry of an items data facts (options). The goal is to streamline the input process for users, making it intuitive and efficient. Requirements: 1. Dynamic Input Fields: • Initially, a single input field is displayed. • As the user starts typing, a new input field is automatically added below. 2. Autocomplete/Autosuggestion: • Input fields should support autocomplete/autosuggestion from a provided array. • When the user starts typing, suggestions should be displayed in a dropdown list. 3. Handling User Input: • If the user highlights a suggestion and presses Tab or Enter, the selected suggestion should be entered into the field. ...

...experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should be familiar with VBA, Excel and AutoCAD. Experience with similar projects will be ...

- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of ...

I have a JPEG format logo that I need to have a transparent background. I also require this logo to be provided in both multiple sizes and a single high resolution size. The logo will be used for both print and digital purposes. Ideal Skills and Experience: - Proficiency in graphic design and image editing software. - Experience in converting and manipulating images. - Understanding of different file formats and their appropriate uses. - Ability to create high resolution versions of images. - Familiarity with both print and digital design requirements.

I'm currently looking for a skilled photo editor who can assist with a unique project. My requirements are explicit and I require a specific set of edits to be made. The task is simple: - Remove one individual from one photo - Add that same individual to another photo Additional Details: - I already have both the photos that need to be edited - Only one person needs to be maneuvered between the two photos Ideal Skills: - High proficiency in image editing softwares - Experience in manipulating images and blending them seamlessly - Background in portrait retouching animations This project would perfectly suit those with a keen eye for detail, and who adhere to image realism. If this sounds like you, I can't wait to see your bi...

Please Update the Prestashop to the last Stabile Version. Take Care and do a Backup, also we do it.. try to keep the current theme and programming Make sure that at least the following modules are still running after the upgrade DHL, PPL shipping service provider, payment functions... just the important ones to rebuild a store operation. Complete Check for funktion and improvements - old Theme must Working fine inkl. ABO function - All Modules must working or update, grade - Design is in all sites ok - Currency and Payment function fine.

I have an urgent need for a skilled web designer. I need the login page of my website to be modified. I also need the CSS issues fixed and to be responsive also on all devices Key Requirements: - Update Color Scheme: The login page should have an updated, modern color scheme that aligns with the brand. - Improve Layout and Alignment: The current layout of the login pages is not as user-friendly as it should be. The design should be improved to make the login process smoother. - Fix Responsiveness Issues: The login pages must be fully responsive to ensure a seamless user experience across all devices. I have not provided examples of websites with designs that I like, so I'm open to your creative input. The most important thing for me is to get this project comple...

I'm seeking an expert in Windows Server licensing to clarify some key points. - I have a single Windows Server, specifically Windows Server 2019 or 2022. - 5000 user accounts will need to access this server concurrently and they will use web application on Blazor Server. - I need advice on the appropriate licensing model to accommodate this level of usage. Ideal candidates for this project are professionals with: - Profound knowledge of Windows Server licensing, preferably Windows Server 2019 or 2022 - Experience with large-scale user access scenarios and concurrent usage. - Ability to explain complex licensing models in simple, user-friendly terms. What is cheapest model for me to utilize. People will connect to app using Chrome browser ...

...and interface for the order page of our website. The page will feature a variety of products, each with an image, a description and an item list. Key Requirements: - Design a clean and intuitive user interface for a WordPress website - Create a coherent and engaging user experience for a single page consisting of numerous product listings - Ensure the design is conducive to high conversion rates - With Order Button The ideal freelancer for this project should have: - A proven track record in UI/UX design, particularly for WordPress - Experience in designing e-commerce product pages - A creative approach to user experience and interface design -Must share collaboration with us during the process. -Final work ...

I need help with a data entry task that involves extracting data from various websites and inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling ...

As the client, I have a collection of video clips that is under 10 minutes long, which I need to be skilfully compiled into a single music video. Your creativity and video editing skills will be put to the test in creating a coherent narrative that matches the vision of a small band. Here is what I am looking for: - Video Editing: Splicing together multiple short clips from a phone. - Text Adding: The text content will be provided by me which should be incorporated in a way to add context and style to the video. - Music Video Styling: The video should give off a music video feel rather than the traditional cinematic or documentary styles. The ideal freelancer for this job should have: - Professional proficiency...

...are an important data structure used in computer science. The task is to load graphs and determine the following parameters: the degree sequence; the number of components; bipartiteness; the eccentricity of vertices (within the components) planarity; vertices colours (consecutive natural numbers from 1) obtained using algorithms: greedy (the vertex order according to its number) LF method (ties are solved by the vertex number) SLF method (ties are solved by highest vertex degree, and if there is still a tie choose the vertex with the lowest number) the number of different C4 subgraphs the number of the graph complement's edges Input In the first line there's a number k of graphs. The following lines contain k graph data sets. A single...

I'm in need of a professional web creator to design a sleek, modern website for my business. It should have a user-friendly menu with six entries: 'Who are we', 'Portfolio', 'Services + Testimonials', '34 Reasons', and 'Contact us'. Here are some key details: - **Design Style**: Modern - **Functionalities**: I want a photo gallery included on the site, to showcase our work and products. - **Content Management**: I will be updating the website content myself using a Content Management System (CMS), so the design should be easy to maintain and update. The website should be interactive, minimalistic, and very easy to navigate. I'm not looking for an e-commerce platform or ...

I'm looking for a skilled website developer to create a 1-5 page portfolio website. Key Requirements: - Portfolio Website: The primary objective of this website is to showcase my work as a professional. - Custom Design: I would like a unique, clean and modern design that represents my work elegantly. - Mobile Responsiveness: The website should be fully responsive and optimized for all devices and screen sizes. - SEO-Friendly: The website should be optimized for search engines to drive organic traffic. - Easy to Update: I would prefer a content management system that allows me to easily update and manage the website in the future. Skills and Experience: - Proven experience in developing portfolio websites. - Proficiency...

I'm seeking a skilled website developer to create a new website for an upcoming independent business consulting company. The website should be simple, visually appealing, and easy to update/manage, potentially using WordPress. Visual Style: The website should have a modern and professional feel, in line with the nature of our services. The website will have about seven pages: - Home Page - Services Page - Industries Page - About Us Page - Leadership Page - Contact Us Page I'm looking for freelancers who take initiative and can transform basic instructions into a polished product. I will provide the wording and a general overview of the web pages but expect you to help with selecting relevant images and icons. The website must be...

I'm in search of a 3D printing service for investment casting using PLA or PMMA or a suitable sacrificial material. I need to produce custom parts of moderate complexity with fine details. The parts are about 1.5 inches x 2.5 inches x 28 inches. I need them printed as single parts. Key Requirements: - The parts are provided as STEP or STL files. - These parts should be created using a sacrificial material such as PLA or PMMA, suitable for investment casting. This 3D print project is centered around the production of a small batch of custom parts. If you have experience in similar projects, your bid is highly encouraged.

I'm in need of a seasoned WordPress developer with experience in affiliate marketing website development and customizations. I aim to have the Rehub theme fully utilized with necessary plugins and the following customizations: - Custom product grid and filter design: The product grid and filter are pivotal in the user experience of the website. I require a unique grid and filter design to make my website stand out and provide a seamless experience to users. - Advanced filtering options: I need advanced filtering options implemented on the website to simplify the shopping experience for my visitors. - Single product page customization: The position of product attributes information needs to be altered. I am not looking for a sim...

I'm seeking a Python expert to assist with small tasks to insert data & search data with the help of keywords

We are in need of a freelance California certified solar designer to review and certify our solar system design. The project is a 280 kW Rooftop PV System for an estate in Southern California. Our Helioscope model, single line diagrams, layout and cabling schematics are all ready for review. Your expertise will be crucial in ensuring the accuracy and compliance of our design. The ideal candidate will have extensive knowledge and experience in solar system design, as well as the ability to conduct thorough peer reviews. Attention to detail and adherence to local regulations are paramount.

I'm seeking an experienced app developer to create a mobile application for both iOS and Android platforms. This application's primary function will be inventory management for a single store. Key Features Required: - Inventory tracking and management - Easy addition of products - Ability to categorize products - Alert notification for low stock - Detailed and customizable reporting feature Ideal Freelancer: - Experience in developing inventory management apps - Proficiency in iOS and Android app development - Familiarity with up-to-date inventory management techniques - Good organizational skills to ensure product categorization functionality - Strong attention to detail for developing customizable reporting feature - Excellent communicati...

I am looking for a proficient data analyst who can access, clean, and analyze large volumes of customer data. Ideally, the freelancer should have a background in big data, business intelligence, and data visualization, and previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a m...

### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commerci...

I have a video section on the demo above that needs to be included in this template that I’m building. The section enables the viewer to press the dropdown buttons which would then display a slider where they can scroll through and watch different video content.

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

Hi Lalith K., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need an expert Unity developer to build a single-player game that will be deployed across iOS, Android, and Web. Key Requirements: - Familiarity with multiple platforms' development and deployment requirements - Proven experience in creating engaging single-player games - Ability to design intuitive controls and user interfaces - Attention to detail and a high standard for quality assurance Ideal skills and experience: - Extensive Unity game development - Cross-platform development in iOS, Android, and Web - Single-player game design - UI/UX design skills - QA testing experience

I'm on the lookout for a developer who can assist me in testing the roles and endpoints within my system. Specifics: - The system consists of three primary roles: Admin, User, Supervisor. You will be expected to engage with these roles and scrutinize the performance of the system. - While the system may have several endpoints, your primary focus will be on testing a single endpoint. This endpoint remains undisclosed here, but will be shared with you upon selection. The project has an urgent requirement. I'd appreciate it if the work could be completed ASAP. The ideal candidate for this project: - Should have a comprehensive understanding of role-based access control (RBAC) in web applications. - Proficiency in endpoint test...

Task 1: Comprehensive Five-Year Projection Model and DCF Analysis for Marico Objective: Construct a five-year financial projection model and perform a Discounted Cash Flow (DCF) analysis for Marico, leveraging historical data from their Investor Relations (IR) presentation and Annual Report. This will include a thorough examination of revenue and cost factors along with balance sheet and cash flow analysis. Task 2: Potential Acquisition or Investment in the 'Foods' Category by Dabur Objective: Draft two to three slides outlining the opportunity and rationale for Dabur's potential acquisition or investment in the 'Foods' category. Suggestive Approach for Task 1 1. Data Collection: - Gather historical financial...

I'm looking for a skilled developer to update our Android platform APK for NFC access control on a custom-made board. Now we need to make it Cross platform and utilize the NFC CARD EMULATION system on the mobile device The Application is already developed and i have the source codes so i would like to work on it and not created from the scratch. The android version is located in the Andorid Store under the name of "PELEKIS NFC access control" Key Requirements: - The APK should be compatible with both Android and iOS platforms. - The main purpose of this APK is to facilitate NFC access control on a custom board, made specifically for this purpose. - The specific functionality required for this project is read/write capabilities. Ideal ...

I need a skilled developer with Opencart experience to create an automatic updater for my Opencart version 2.x store. The task is quite urgent, so I need it done as soon as possible. Key Requirements: - The system must update the following fields: - Product name - Product description - Meta Tag Description - Meta Tag Keywords (same as Product Tags) - SEO Heading Title - Meta Tag Description (160 characters limit) - I need the product description to be: - Minimum 200 words - Taken from the supplier's website - Translated from English to Danish - SEO optimization for each product Ideal Skills: - Proficient in Opencart - Familiar with APIs for data extraction - Strong in SEO and content writing - Able to work promptly and efficiently This ...

Become a Business Catalyst: Business Consultant Do you thrive on helping businesses reach their full potential? We are seeking a highly skilled and experienced Business Consultant to join our team. The ideal candidate will have a strong background in business strategy, process improvement, and project management. Key Responsibilities: • Conduct thorough business analysis to identify opportunities for improvement. • Develop and implement strategic plans and initiatives to achieve our goals. • Provide expert advice on business process optimization and efficiency improvements. • Collaborate with cross-functional teams to ensure alignment and effective execution of business strategies. • Prepare detailed reports and presentations to commu...

I'm looking for a skilled Laravel developer to help me update an existing application. The primary task will be adding new features to enhance the functionality of the platform. Your key responsibilities and requirements: - Proficient in Laravel: You should have a strong understanding of Laravel and be able to leverage the frameworks' capabilities effectively. - Strong knowledge of PHP: Even though the focus is on Laravel, a good grasp of raw PHP is a must. - Experience with updating existing applications: You should be comfortable working with an existing codebase and understanding how to integrate new features seamlessly. - Good problem-solving skills: You should be able to identify potential issues and come up with creative solutions...

I'm in need of a Google Script expert to create a script for me. This script will primarily update a Google Slides presentation with data from a Google Spreadsheet. Here's what I need: - The script should update only specific slides within the presentation. - These specific slides will be identified by their slide numbers. - The data to be updated will vary, and may include both text and charts/graphs. Ideal skills and experience for this project include: - Proficiency in Google Apps Script, particularly with regards to Google Slides and Google Sheets integration. - Experience with updating specific slides in a Google Slides presentation. - A good understanding of how to handle and update differ...

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

(ALL INFO IN DESCRIPTION-SEND ACCURATE BID ELSE YOU WILL BE REPORTED)****** I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow my users admin to book dates. If a date is unavailable, the application should clearly indicate it. Calendar app **1. User Registration:** - Admin creates a new user by providing a username and password. - Store the user's credentials securely in a database, with password hashing and salting for security. -Allow user to make remember me so they don’t have to login each time. **2. User Login:** - User enters their username and password on the login page. - The system checks the provided credentials against the database records. - If...

We have different Brochures, but now search a new Layout in A4 Page and A5 Page. How can you help us, can you design our layout from now a little more professional and update the brochure. For future, we would like give self products in the pages - always more and bigger and need than every month a feedback and update from you. What is possible ? Language German References for Vehicle (Car/Truck) Brochures ? Send us layout samples from your works via message, after this we check and you get a feedback.

I am seeking a talented and creative designer to develop an iconic logo for my fitness app. The logo should be visually striking yet simple enough to be effectively used as an app icon. This logo will be a key component of our brand identity, representing our innovative fitness app that rewards users for their physical activity with in-app currency that can be spent on prizes, vouchers, and more. Project Objectives Create an Iconic Logo: The primary objective is to design a logo that is both eye-catching and iconic, easily recognizable and memorable. Simplicity and Versatility: The logo should not be overly detailed to ensure it looks great at various sizes, especially as a small app icon on mobile devices. Brand Representation: The logo shou...

I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.

I need a skilled web developer to create a single HTML page that will serve as an information display. The page will have a mix of images, text, and videos. It's crucial that the design can properly showcase these different types of content in a visually appealing way. Moreover, the page needs to be mobile responsive, so the layout should adapt well across various devices. Key requirements: - Develop a single HTML page that is focused on information display - Integrate a mix of images, text, and videos seamlessly - Implement a design that is visually appealing and user-friendly - Ensure the design is mobile responsive, adapting well to different screen sizes - Provide efficient coding and optimize the page for fast...

I'm in need of a seasoned professional who can manage and optimize my Google Business listing for my tissue paper business. The main goal of this listing is to increase foot traffic to my physical store. Key Responsibilities: - Ensure that the listing is fully optimized to drive local traffic and reach the target audience effectively. - Implement strategies to enhance the visibility of my business in Google search results. - Regularly update the listing with new information and promotions to attract more customers. Requirements: - Proven experience in managing and optimizing Google Business listings, preferably for retail or similar businesses. - A strong understanding of local SEO and how to use it to drive foot traffic. - Excellent...

I need a skilled developer to address a bug in my Electron app that is causing download and Install failures for a external app on Windows. This issue does not arise on macOS. Additionally, I need help with implementing auto-updates and addressing Code Signing and Notarization for Windows and macOS. Key Tasks: - Resolve the download failure issue on Windows - Implement an auto-update mechanism for my Electron app - Address Code Signing and Notarization protocols to remove warnings for both Windows and macOS Ideal Skills & Experience: - Proficiency in Electron app development, especially on Windows and macOS - Experience in debugging and resolving download failures in Electron apps (and Windows, in particular) - Prior expe...

I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculatio...

I'm looking for a highly skilled professional to develop a mobile application for managing a small inventory of less than 100 products. Key functions: - Inventory tracking: The application needs to monitor and update inventory levels dynamically as sales and restocks occur. - Comprehensive reporting: I require detailed inventory level reports to ensure steady product availability. Ideal Skills and Experience: - Proficiency in mobile app development: You should have a robust portfolio of mobile applications, particularly those with inventory management features. - Understanding of inventory systems: Experience with inventory control mechanisms and generating inventory level reports is critical for this project.

I have a to-do list currently in a word document that I'd like to have recreated in Google Sheets. This newly created spreadsheet should have an additional summary page. Key Requirements: - I require the spreadsheet to have automatic calculations. For example, I'd like the sheet to automatically sum up the tasks, highlight overdue tasks and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to ...

...Responsibilities: Translate visual designs from Figma into pixel-perfect, responsive HTML/CSS Develop single page applications using modern JavaScript frameworks Integrate APIs and backend services Build reusable UI components and libraries for future use Ensure cross-browser and cross-device compatibility Test, debug and polish interfaces to achieve flawless usability Collaborate with product and design team throughout the development process Maintain code quality, organization and documentation Requirements: 5+ years of professional frontend development experience Strong experience with HTML5, CSS3 and modern JavaScript Proven working experience with frameworks like React, Angular or Vue Experience developing for responsive and adaptive interfaces Strong understanding...