Insert or update in a single query jobs

...am seeking an flutter developer to make a single modification: switch it from dark mode to light mode. Here are the details: - I have purchased flutter app code from Codecanyon. I just want someone to build ios app with that purchased code & publish to app store by changing app name, app icon, package name, splash screen animation etc... - Color Adjustment: The color scheme should be shifted to neutrals and pastels to suit the light-mode aesthetic. Specifically, I want to change colors, not fonts or icons. - Publishing to the App Store: It's crucial that you have experience in this area, as I will need you to guide the app from final code to publication. Rest assured, I possess the necessary files and credentials. Ideal Skills: - Expertise ...

Description: We are looking for a skilled WordPress integrator to convert our web designs into a pixel-perfect, high-performance, SEO-friendly bilingual website with a mobile-first approach. The project scope includes integrating 24 pages across both desktop and mobile versions (48 page designs total). The ideal candidate will have a proven track record of integrating responsive designs into fast, secure and search engine optimized WordPress sites. Key requirements: Integrate our provided desktop and mobile designs for 24 pages into a fully responsive, mobile-first WordPress theme Implement bilingual functionality in French and English (with possible future languages) Integrate custom designs for product category and product detail pages Integrat...

I am in need of a skilled web application developer with strong proficiency in JavaScript. The social network I envision needs to include: - User Profiles: Users should be able to create, update, and interact with their personal profiles. Your main tasks will include: - Developing the social networking platform in a way that ensures a delightful user experience. - Writing clean, maintainable, and scalable code. - Collaborating with team members to achieve project goals. Ideal skills and experience for this job include: - Proficiency in JavaScript is a must. - Proven experience in developing social networking platforms or similar web applications. - Understanding of good design principles and experience in...

I'm in need of a skilled Flutter developer to create a mobile application. It will mainly focus on auto send bulk SMS using mobile sim and will operate on both Android and iOS platforms. Key requirements and responsibilities include: - Developing the app for both Android and iOS - Creating a user-friendly interface for bulk SMS sending - Ensuring the app efficiently sends SMS to multiple contacts - Implementing a feature that allows users to manage their SMS lists - Testing and debugging the application In mobile application there will be a configuration page For setting config values 1) base URL 2) get messages API URL 3) update message status API URL 4) time interval field (in seconds) 5) choose sim card through wh...

I need a PHP developer to update a single word in my script. Specifically, I want to add the country Montenegro to a pre-existing list, and have it inserted in the middle. The ideal candidate for this task should be proficient in PHP and have a good understanding of basic coding principles. Experience in handling string manipulation within PHP scripts is important, as you'll be required to ensure the country name is inserted accurately and efficiently. Your responsibilities will include: - Identifying the appropriate place to insert the word 'Montenegro' in the PHP script - Making the necessary changes to the script to reflect the updated country list Your bid should reflect the size and ...

I'm in immediate need of an experienced professional with a strong background in Webmin / Virtualmin on LAMP server, Postfix 3.3 and Ubuntu 18.04 for a swift and effective system update. Major Requirements: - install and place letsencrypt certs at right places - make sure sudo can upgrade again - Updating Postfix 3.3 on my Ubuntu 18.04 system to the latest, most secure version available. - Enhancing the performance and resolving any bugs or issues in the current system. - Customizing mail server settings for an improved mail delivery. Ideal Skills and Experience: - Proficiency in Postfix 3.3 and Ubuntu 18.04. - Track record of doing similar system updates and enhancements. - Understanding of custom mail server configuration....

I need a proficient web developer to design and build a website revolving around financial products, specifically cryptocurrency investments. The website will include both front-end and back-end elements and needs to support USDT payment. Front-end Functionalities: - Live price updates - A section showing a user's transaction history - Cryptocurrency purchase options The website needs to be user-friendly, visually attractive, and secure. Ideal Skills and Experience: - Proven track record in web design, especially with sites related to financial products or cryptocurrency - Understanding of and experience with USDT payment systems - Ability to integrate live update modules for cryptocurrency prices - Proficiency in back-end ...

I am currently in need of an experienced PHP developer for an upcoming project. The specific tasks and objectives have yet to be defined, so I am looking for someone who is adaptable and skilled in all areas of PHP, from front-end development to back-end development and database management. Skills/Experience Required: - Proven experience in front-end and back-end PHP development - Knowledge and experience in database management - Ability to work in different frameworks and technologies such as Laravel, CodeIgniter The qualified candidate should be ready to use different frameworks and technologies as per the project's needs. If you are skilled, adaptable, and up for the challenge, let's get in touch.

I'm seeking a skilled developer to create a NinjaTrader trading bot/backtester with functionalities catering to Forex and Futures markets. Key Requirements: - I need the bot to support NinjaTrader, as this is the platform I intend to use. - The bot should have automated trading capabilities, facilitating transactions based on predefined strategies. - I require historical data analysis. The bot should assess past price behaviors and generate insights to aid decision making. - The bot should also be optimized to assess strategy effectiveness and make necessary adjustments while trading. Strategy uses pivot points - the pivot points highlight a certain candle, specifically the high and low of that candle.

 A box is then drawn from that high and low of the ...

I am looking for a skilled WordPress website developer to design and build an e-commerce site for a fully managed Wordpress hosting company. This project budget is a total of $150 AUD. Key Needs: - Live Chat - Ticketing support and the ability to track tickets based on when created, how old and total time of resolution - Ability to pay/subscribe online. There will likely be three core offerings - Additional offerings will include the below. I them broken into a single price or monthly option - Website Speed Audit and Optimisation - Plugin Audit - Security Audit - Content plans The website will initially host less than 10 different products. Candidates with past experience in developing and managing Wordpress e-commerce sites with similar...

I have a WordPress site where I'm encountering a problem with content loading across the whole site. There is text content and images that aren't properly displaying and this is happening on various pages, not a single specific one. Interestingly, there are no specific error messages being displayed when this occurs. Ideal Skills and Experience: - Proficiency in WordPress troubleshooting - Solid understanding of site loading mechanics - Prior experience with similar issues Please note: Given the lack of error messages, a thorough initial analysis will be required to identify the root cause of the problem. You should be prepared to explain your process and findings, and offer the best possible solution to correct this issue.

As a small business owner, I'm seeking a Photoshop expert with skills in photo retouching and image manipulation to edit the name on a single-layered image file. Specifically, your task will be to cleanly replace text in a photograph of a document. This project requires a keen eye for detail along with a patient, meticulous approach. Experience editing text in photographs is strongly preferred.

I'm urgently connecting with a proficient Flutter developer to configure a CI/CD pipeline in a single-hour session, utilising Codemagic. Your scope includes: - Creating a structured CI/CD pipeline on Codemagic To make a success of this opportunity, your background should entail: - In-depth understanding of Codemagic operations and implementation - Well-versed with CI/CD principles and best practices - Expert in Flutter development - Previous experience related to pipeline setup I'm looking forward to accomplishing this assignment ASAP; please approach if you're capable of swiftly tuning in.

...targeting young adults. This project demands a firm understanding of several unique features: - Social Media Integration: The app should connect readily with major social platforms, enhancing its social nature. - Push Notifications: A robust system for update alerts and reminders needs to be implemented, enhancing user engagement. - In-app Purchase: A system to facilitate in-app purchases should be built, driving revenue growth. - Live Streaming & Video Calling: Incorporation of real-time streaming and face-to-face communication capabilities are crucial for the app's entertainment component. - Private Room: An exclusive space in-app for private chats or activities is required. Candidates with relevant experience in...

We are in need of a skilled software designer who understands the game of baseball and can create a fairly basic but somewhat complicated baseball data software. This software will work on both Microsoft and Apple platforms, focusing on tracking and recording baseball data for users of our baseball board (non-computer) game. After our game is played the user will enter in which team won and lost. Then the user will enter the name of each player by team and what he did during the game. For example, Babe Ruth came to bat 5 times, struck out once, walked once, hit 2 homers and 1 single. He had 3 RBIs. Statistics will be retained that will show cumulative data of an ongoing season so once a player is entered into the data base he can then be pulled ...

...looking for a talented developer to create a single product landing page for me. The primary goal of this page is to generate leads for my product. Key Elements: - The landing page should have a contact form to capture visitor information. - It should be designed in a bright and vibrant color scheme, to grab visitors' attention and make the page appealing. Ideal Skills: - Proficient in creating engaging and converting landing pages - Experience with user-friendly contact form integration - Strong understanding of color psychology and design aesthetics I will provide all the necessary information about the product. I am open to creative suggestions, but the landing page should be aligned with the theme of 'bright and vibran...

We are searching for a mobile developer to join the team to finalise a project for MVP. We need a single developer with both Android (react/java) and iOs (swift) to finalise the app already well underway but requiring changes in UI and functionality. You will also use WhatsApp for comms and JIRA for ticket management and be a strong communicator. Experience a must. Looking for a price per week, and 4 milestones are created and based on sprints achieved.

...engineer who can help me design and plan a house on a 2.76-acre land in Mountain City, TN. The land has a 30-40 degree slope from top to bottom, so the design should take this into account. - A deed restriction is that the house, excluding the garage, must be at least 1700 square feet. We also would like two extra bedrooms. - We will be bringing in city water and electricity from about 250 feet from the house, buried electric. We will need to install a septic tank. We want to go with a Horizontal ground closed loop for the geothermal heat and AC. - We are thinking more of removing dirt on the high side to make a more level area for the house but are good with supports for the down hill side of the house - I need floor plan...

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from Italian and Romanian to English. - Aggregating financial statements from various group companies to form a single consolidated financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regul...

We are seeking a skilled WordPress website designer to quickly create a professional and visually appealing website for our energy storage company. We will provide all text content and images. The ideal candidate will have proven experience in WordPress and a portfolio demonstrating business websites, preferably in the technology and energy sectors. This fast-paced project requires completion within one week, so immediate availability is essential. Responsibilities Design a WordPress business website that showcases our energy storage technologies through interactive and dynamic elements. Update and optimize existing materials on the website. Integrate essential functionalities such as contact forms into the design. Ensure the website is mob...

...for a skilled developer to update an existing capacitorjs plugin to version 5 and introduce Android compatibility. I am looking for a Geofence plugin. I have a good starting point with a public plugin, but it needs updating. Here is the source repository: Please reference it, and add updates to it for capacitor version 5, update any of the swift or Objective C code that may be out of date, add corresponding support for Android. Key Requirements: - The main focus of this project is to enhance the plugin's compatibility with various platforms, particularly iOS and Android. - The plugin should be updated to Capacitorjs v5 to ensure it's leveraging the latest features and security patches.. Ideal Skills and Experience: - Prof...

Looking for an innovative thinker to solve the challenge of automatically filling a single-page form on a local host, where .exe files cannot be run. The database to work with can be either online or local (not the local host of the form), and the database type may vary (MySQL, SQLite, PostgreSQL, etc). Key Responsibilities: - Conceptualize and suggest potential solutions for the auto-fill issue - Design and implement a solution that does not require .exe or batch files Ideal Skills & Experience: - Expertise in form automation - Understanding of various database types - Experience with local and online database handling - Problem-solving and innovative thinking capabilities are crucial. Write strawberry in your response so...

I'm looking for a talented designer to help me refresh my current logo by incorporating new lettering. Change 1) Paasulntt Hill to Pleasant Hill, CA 2)Cub Sclt to CUB SCOUT 3) Jeap to 405 Ideal candidates should have: - Proven experience in logo design - Strong graphic design skills - Ability to create modern and appealing lettering - A portfolio that showcases previous logo design work - Experience with designing for print and digital platforms

I'm in need of an advanced photo editing tool that allows for image cropping and Photoshop level editing. The primary requirement though is the ability to insert objects into images. Key Requirements: - Compatibility: The editor should run on Windows, MacOS, and Linux. - Features: Image cropping and a level of editing akin to Photoshop are essential. - Object Insertion: The ability to add objects to images is a key requirement for this project. Ideal Skills and Experience: - Proven experience in creating or customizing advanced photo editing tools. - Strong understanding of Photoshop level editing features. - Familiarity with object insertion tools. - Cross-platform development experience would be a plus.

I'm looking to hire a skilled architect to design a single-family home with modern architecture. Here are my key requirements: - Knowledge and experience with modern architecture for residential properties. - Ability to design a home with an open floor plan. - Strong communication and understanding of client's vision. Having a portfolio of previously designed modern single-family homes would be a considerable advantage. The end result should be a design that portrays a fresh, spacious outlook with an open floor plan. The ability to multifunctionally use the space is key.

I am seeking an experienced professional who can resolve challenges that occurred after my website was affected by malware and a WordPress update. The issues I need addressed are: - Broken links and images - Distorted website layout - Install SSL These complications are experienced on Google Chrome, Mozilla Firefox, and Safari browsers. Despite clearing the cache, these issues persist. Therefore, prospective freelancers need to be proficient in WordPress and have in-depth knowledge in troubleshooting browser and malware-related issues. Your expertise will be well-appreciated.

...site's dropdown menus are malfunctioning. This has been a problematic issue that's affecting all the pages on my website. I've been utilizing the WordPress default menu manager to handle the menus. This problem is hindering my ability to update and manage the content effectively. I am seeking a proficient Wordpress developer who can: - Diagnose why the dropdown menus aren't functioning properly. I believe it is has something to do with the theme I'm using (Roosevelt) because when I switch themes the dropdowns start working. This started when I updated to the newest version of Wordpress. - Use their extensive knowledge of Wordpress and its default menu manager to rectify this issue swiftly. - Provide a guideline on how to avoid this...

We need a Wordpress site built out to match our Photoshop design. A PDF of the design is attached, the Photoshop file and resources will be provided after we start the project. Looking for someone to start on this ASAP. Project details are below. * We want someone to work on this over this weekend so we can have something on Monday. Does not need to be completed, but need to have progress. 1. We have already setup the site and installed a theme here: 2. We are using the Avada theme and page builder. We've installed demo content. This content should all be replaced. 3. This is a single page website, but has quite a bit of content on it. 4. Style this page to match the attached design. 5. Menu: the design does not have a menu, but we ...

I'm in search of a competent individual or team to manage my multiple websites - a mix of e-commerce, blogging, and corporate sites. We need a web manager to manage our 5 websites for a month milestone of 35 USD. Must be a wordpress expert Must be dedicated and have to make sure all websites are live Must be available to update the websites at all times when needed Must protect the websites from malware and virus Must frequently take backup of all files.

Hello, Thank you for your interested. I'm in need of a proficient InDesign user to update business cards for multiple staff members. The business card has already been designed. This is only updating cards for other staff members. The task includes: - Updating each card with the new staff member's name, title, and contact details. - Implementing minor design tweaks to update staff member's photo on the card There are more than 6-8 business cards that require updating. Upon completion, I will need print-ready PDFs for each business card. Ideal candidates for this job should have a strong command of InDesign, as well as a good eye for design details. Previous experience with business card design and print-ready file preparation ...

...dealing with a persistent virus and malware issue on my WordPress website. Despite running a security plugin, some issues still linger. To clarify, the tasks I need assistance with are: - Detect and eliminate the remaining virus/malware threats - Ensure the removal is comprehensive, with no residual issues - Update the outdated newspaper theme of the website () Help reinstalling/updating plugins - Sabai Business Directory (keeping existing categories and businesses in the directory) - The ideal freelancer for this job would have a solid

I'm looking for a video editor to collaborate on a YouTube series, where we would conduct weekly interviews with everyday people. Each week, we uncover the unique stories and experiences of different individuals, bringing their perspectives into the public eye and bring 3,4,5 or 6 3 minute interviews together into one show called HOT LINE. The show is filmed like a chat show one interviewer interviewing someone for 3/6 mins, then the next, next interview. The interviewer will have a research assistant that has control of a giant tv screen behing the interview. The research assistant will take calls from people, pop up zoom meetings, show social media feeds and pop up relevent content about the interview to make the interview exciting and st...

I'm in need of an expert to design a site plan for a Level 2 EV chargers. Key Requirements: - Analyze existing property blueprints and create ev charger plan with load balancing for 20 chargers. - Ev charger plan must include: Cover Sheet, site plan, electrical site plan, parking layout and details, single line diagram, schedules and Notes and T24 compliance forms. Experience: - Experience in EV charging station design. - Experience in load balancing for multiple chargers

...Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') I...

I am currently seeking a professional ballet dancer for my next photoshoot in Kolkata. This project will take place in an indoor studio for a more controlled environment and to highlight the elegance of ballet. Key requirements and details include: • Single ballet dancer: I'm in search of one proficient dancer who can bring grace and finesse to my project. • Ballet poses: While I didn't specify the type of ballet poses, I am open to the artist's creativity. • Experience: Ideally, the freelancer will have previous experience posing for photoshoots. Familiarity with working in a studio is a plus. Note: Please include a portfolio of your work (preferably in a studio setting) ...

We are looking for a front-end developer to assist in building a reservation system for a trampoline park, which consists of: - POS system - Website - Website displayed on tablets for customer registration The project is based on the following technologies: - Single Page Application - The backend is written in Django (DRF) and PostgreSQL - Microservices architecture based on Docker and Docker Compose - GIT - CI/CD Requirements: - Good command of English - Ability to write clean, bug-free, and scalable code - Minimum 5 years of experience in building web applications - Very good knowledge of and React - Excellent communication skills Nice to have: - Knowledge of Polish or Spanish language - Knowledge of Python / Django The project...

I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are yo...

I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skills and Experience: - Strong proficiency with Frontend JavaScript, and Backend Node.js. - Proficient understanding of databases particularly MySQL. - Comprehensive experience in building authentication and authorization systems. - Knowledge of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastNam...

I am currently in need of a professional with deep expertise in website maintenance. My website requires not just routine maintenance but also significant improvements which include: - Content Updates: It is necessary to keep the website content fresh and relevant. - Security Updates: I have security measures in place relying on regular backups. However, a security update by an expert to further safeguard the website is needed. - Bug Fixes: The website has been experiencing loading error issues which urgently need to be addressed. - SEO Optimization: The visibility of my website on search engines needs to be improved. The professional I need should have ample experience in website maintenance, cybersecurity, and SEO optimization. Furthe...

...need a professional and engaging website that will effectively promote my brand to home owners looking to renovate or update their spaces. The purpose is not primarily commercial but to create awareness, build brand image and provide relevant information to the potential customer base. The website should be designed in such a way as to encourage the visitor to request for more information. -Skills and Experience Ideally, the freelancer should possess excellent skills in: * Web Design and Development * Information Architecture * Effective Brand Promotion techniques * User Experience design * Everything Squarespace An understanding of what appeals to the public and the ability to creatively conceptualize that into the website layout design will...

I'm in need of a skilled henna artist who can create a traditional, yet simple and minimalistic design for my hands. I need multiple designs in sets of 10 made. I need circle palm designs and then single line design as well. The work requires: - Proficiency in traditional henna art. - Ability to create elegant yet minimalist designs that are even and symmetrical. - Experience in working on designs like this before. Looking forward to your proposals. Thank you.

I need help with my Google Chrome extension. I developed a JavaScript script that retrieves the content of a post and intends to insert . However, I am having difficulty with the process. The feature should apply to platforms like Facebook, Instagram, Twitter and LinkedIn. This should be a simple task.

I'm looking for a skilled professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) working and/or residing in foreign countries like USA, UK, SIngapore, Canada, Australia, Dubai. Their age group may be between 22 years to 42 database will be used for marketing and promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant...

...looking for a skilled professional in GCP DevOps Kubernetes to assist me in deploying and managing applications on a Kubernetes cluster. Key project details: - **Deployment & Management**: Your main focus will be on assisting with deploying applications on Kubernetes and ensuring smooth management of these applications. - **Scalability**: Although the scale of the project is relatively small, it's crucial that the setup is scalable to accommodate future growth. - **Update Handling**: The applications will require manual updates with specific scheduling. You'll need to ensure that the process is seamless and can be executed efficiently. Ideal skills and experience: - Proficiency in Google Cloud Platform (GCP) DevOps - Deep under...

Run tasks repeatedly to upload products file to Amazon.

I am looking for a full stack web developer to create a Network Management System (NMS) website that can be deployed on any cloud or local hosting. Main Functionalities: 1. Loginpage login (create user/password in the backend) 2. Dashbord one - prints rows of a table (buttons to add/delete/update table rows) 3. Dashboard two will have 6 tables, each of the table entries will have few configurable(will be configured through pop up window) , stats, logs , status 4. One of the table could have a flow table just for read only 5. THere should be back end persistent DB which saves all the data 6. THere should be method to bring down this and powered back any time Acceptance criteria 1. NDA signing 2. Web page working conditio...

I require a skilled and experienced web developer to create a custom HTML emailer for me. The emailer should be compatible with both Outlook and Gmail. Here are the specifics of the project: - You will be provided with a JPG image that will form the basis of the emailer. Your task will be to incorporate a single line of hyperlinked text in the middle of this image. The hyperlink should lead to a designated URL. - The emailer should be designed to display correctly across different email clients, especially Outlook and Gmail. The ideal candidate for this project would have: - Proven experience with creating custom HTML emailers. - Proficiency in working with JPG images and integrating hyperlinks into them. - A good understa...

All the requirements that are mentioned with red indications update logos and other minor issues. If any issue comes up based on these requirements I will take the responsibility.

I'm looking for a skilled Webflow developer to make strategic improvements to my website. The project involves a mix of SEO tweaks and backend work to enhance user experience. Key Deliverables: SEO work will include (PDF can be provided): changing hreflang, changing url page names, adding meta descriptions, changing headings, replacing text, creating breadcrumbs, Schema Mark Up, adding image alt text, reviewing and removing excess code, update sitemap. Adding additoinal pages: Updating the main menu to add additional pages Creating additional pages Uploading text and images, which will be provided Ensure consistent layout across all pages Ideal Skills: - Proven experience with Webflow - Strong understanding of SEO best practices - Ability to implement and opti...

...developing a new measurement device intended for checking machinery during transportation in the transport industry. I need a talented designer who can create a concept for the device and produce high-quality, promotional 3D images from multiple angles. Key requirements: - Concept design: The device needs to be suitable for the transport industry, with a focus on checking perishable goods during transportation. It should be practical, user-friendly, and able to withstand the rigors of the transport environment. - 3D mock-up: This project requires a detailed 3D mock-up of the device. The images should be of promotional quality, showcasing the device's key features. I expect to see the branding added to the device and mocked-up images on th...