Update sql query logic hook sugarcrm jobs
I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.
... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system
I'm looking for a skilled Affinity Publisher designer to create a monthly newspaper for the catering and hospitality sector. Key Requirements: - The newspaper should have a modern and sleek design, appealing to a wide audience. - Your task will be to create a stunning layout, incorporating the latest trends in graphic design. - You should be able to work with a monthly update schedule, ensuring the newspaper is ready for distribution in a timely manner. Ideal Skills: - Strong proficiency in Affinity Publisher, with a strong portfolio of previous newspaper or editorial design. - Ability to understand and match the aesthetic required for an advertising publication. - Excellent communication skills to ensure the publication meets our advertising goals. We will discuss monthly b...
I'm looking for a CAD designer familiar with CATIA V5 to assist with a product design project. cable retracable mechanism is needed along with a stepper motor assembly to drop down 3 kg box from hook, design mechanism is identical to cord winder, dog leash etc Key Tasks: - 3D Modeling: The project involves creating a detailed 3D model of the product. - Assembly Design: You'll also be expected to work on the assembly design, ensuring all parts fit and function appropriately. Ideal Skills and Experience: - Proficiency in CATIA V5 is a must. - Extensive experience with 3D modeling and assembly design. - Previous work in product design is highly beneficial. Please submit your bid along with a portfolio showcasing similar projects you've worked on in the past.
...being displayed after each selection until we exit the program): 1. Admit a patient The program will ask if the PCR test result is negative or positive and that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a positive PCR test should be considered a covid19 patient from that moment. (Hint: copy old object data to the new object) a covid19 patient will be discharged if the PCR test result was negative. 4. Do rounds It will ask you to enter the current temperature for every Covid19 patient. It will treat all the pati...
I have a billboard design that needs a text update. While I do have the original design files, unfortunately, they're not in vector format. Key requirements: - Slight creative adjustment to the text to fit the design: The update will require minor modifications to maintain the overall design aesthetic and message of the billboard. - Non-vector file: As the original files are not in vector format, the freelancers will need to work with the available files and ensure the quality is maintained during the update. - Experience with billboards: Prior experience with billboard designing is preferred as the freelancer would need to understand the specific requirements and limitations of billboard designs. - Graphic design skills: Strong graphic design skills are crucial ...
I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...
We're on the lookout for a proficient Wordpress developer to assist with theme customization, plugin installation, and content update tasks. Experience is pivotal as we're not just looking for someone to get the job done but who can also advise us on better practices and improvements. Key tasks include: - Theme Customization: Help us modify our existing theme to better fit our brand and enhance user experience. It's vital that you have a solid grounding in PHP and CSS. - Plugin Installation: Evaluate, install, and set up necessary WordPress plugins that will add to our site's functionality. - Content Updates: Regularly update site content based on the needs of our evolving business. Given the nature of these tasks, we're not just looking for someo...
Adjustments to the Botanical Bliss render as discussed in PM. (adding 2" and adding a 2nd tape line).
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the ye...
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on...generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, M...
Hi Soumya Sekhar M.,can you provide me a support to update the faker app with a new
I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the system is currently not allowing the addition or update of database records, although deletion is possible. Key requirements and responsibilities: - The main issue is resolving the problem of not being able to add or update database records. - There are no error messages displayed, so a deep understanding of PHP and MySQL is needed to identify and solve the root problem. - Once the issue is resolved, the next step would be to optimize the application to prevent similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and debugging leg...
Looking for someone to help update my linkedin profile
I'm in need of legal research focusing on probate, trusts and trust administration within Colorado, to support a forthcoming filing. The research will require identification of the relevant probate laws and legal codes in Colorado, specifically in the area of some specific aspects I will share in private. This summary should encompass the most current laws - so an update on recent changes in laws is important. The goal is to provide me with supportive applicable laws to my filing Ideal candidates for this project should be well-versed in probate law, specifically related to trust administration. A background in legal research and a familiarity with the Colorado legal system will be highly advantageous. Accuracy, attention to detail, and the ability to convey complex legal i...
...solid understanding of API integration. User interaction is another key aspect of this project. I expect the grid to support the following interactions: - **Click on rows to view details**: Users should be able to click on a row to view more detailed information about that entry. - **Edit data directly in the grid**: The grid should allow users to modify the data directly within the grid and update the database accordingly. - **Select multiple rows for batch actions**: Users should be able to select multiple rows to perform batch actions, such as deleting or updating multiple entries at once. Ideal candidates should have prior experience working with ag-Grid and implementing similar functionalities. Your understanding of frontend technologies, API integration, and user experi...
I'm looking for a skilled graphic designer to help me update my current logo. The task involves incorporating an abstract style 'X' letter behind the existing logo. Add X to my logo, on a white, black and blue background. Provide files as requested in the attached document for various uses marketing, print uses. Key Requirements: - Add the 'X' letter to the current logo as shown in the attachement. - Position the 'X' behind the existing logo Ideal Skills and Experience: - Proficiency in graphic design - Experience in logo modification/embellishment - Strong understanding of abstract design - Ability to blend new elements seamlessly with existing design
I have a magento webstore running on magento 2.3.4. I want to update it to the latest version with all patches, while maintaining current customers/database/products. I also want usps first class mail parcel/usps ground advantage to show up again as a shipping method.
Please read the job listing below before creating something. I need a logo designer who could give my logo a sleek revamp. It currently contains a truck, which needs to be replaced with a car trailer. Here's what the job entails: - Remove the existing truck element from the logo - Replace it with a single car trailer - Modify the existing text to fit my new business - Update the phone number as required Nicely's Trailer rental LLC 304-673-7378 Do not change to colors, font, or layout. The ideal candidate will have a keen eye for design, experience in typography, and a knack for transforming an idea into a visual. Your ability to work with different colors, layouts and elements will be vital in this project. Understanding my brand and channeling it into the redesi...
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
Python refactor code, change logic for the investment strategy
I need an experienced web developer to adjust text and pictures on my website. - Update Text and Picture: The task involves replacing certain phrases within the existing text so it looks good when hovering over the text/picture of our existing provider. - Picture and Text Placement: I need a new provider's picture and text added to the 'Our Providers' section of the webpage. - Button Links: Additionally, the task includes changing a link so that it opens within the same window as the webpage, rather than a new tab. This will be required across several buttons on different parts of the website. Completion Deadline: This task needs to be completed as soon as possible. Ideal Freelancer: - Proficient in web development and website design. - Ability to work with...
I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability
I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This form will have a unique requirement of collecting data at multiple points in a user's session. Key Requirements: - The form needs to be integrated with Contact Form 7 plugin - Should support multipage logic for better user experience - Collect and store user-provided data including: - Name and contact information - User input and preferences - Additional comments and feedback - Implement a method to save all incomplete form data. This data should be: - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomp...
I'm looking for a skilled Web Application developer to update and maintain a web application with advanced user interaction features. Key Requirements: - Update the Application in the backend / front end with the latest features ( Will be provided) - Update application sign-in features and Splash images - Configure Firebase Cloud fully/ Google IAM with all features (Like push notifications ) - Upgrade & integrate PG - Editing existing content on the Laravel website Ideal Skills - Proficiency in web application technologies backend languages like PHP, Laravel, Andriod Studio, Vue.Js, Git and Github, Front end Flutter development.
I'm looking for a skilled professional who can help me in migrating my current website to WordPress. The website is to remain visually identical, with the same functionality and content. This is more about the back-end than the front-end. The ideal freelancer for this job should be: - Proficient in WordPress - Experience...in migrating my current website to WordPress. The website is to remain visually identical, with the same functionality and content. This is more about the back-end than the front-end. The ideal freelancer for this job should be: - Proficient in WordPress - Experienced in website migration - Able to ensure that my website remains fully operational post-migration Note: This is not a redesign or update project. It's about moving the existing website to a...
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
...enhance customer satisfaction. This project requires someone who can blend functionality with aesthetics to deliver an application that not only meets our operational needs but also enhances the overall customer experience. It is crucial that the app is designed with future growth in mind, ensuring scalability and ease of integration for new branches. Additionally, the ability to easily manage and update app content in-house is essential for maintaining operational flexibility and responsiveness. If you have the skills and experience we're looking for, please submit your portfolio and a brief proposal outlining your approach to this project....
... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...
I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. For the view/UI React/It's front-end Library Setting up server, Use , which we'll use it for serve our front-end to talk with our DB Which is MongoDB, the DataBase. To deploy MERN stack app for free, first build your React frontend. Choose Netlify or Vercel for frontend hosting. Connect your GitHub repository and deploy the React app. For the server, select Heroku. Prepare your backend, set environment variables, and follow Heroku's deployment guide. For the database, use MongoDB Atlas, their free tier suffices. Connect your backend to MongoDB Atlas using its URI. Ensure ...
As a restaurant owner, I am seeking an experienced graphic designer to update our existing logo. We're looking to streamline its design while retaining its fundamental style. Your challenge would be to modernize both the typography and imagery while ensuring it still feels familiar. The new logo should embody the following elements: - Modernized design with a nod to the existing logo - Bold and contemporary typography What you need to maintain from our existing logo: tie with existing color scheme (not line) Think "Friendly and inviting" as the emotion we want the logo to evoke. The new logo should echo our brand’s welcoming spirit. We will need the logo provided in the variety of file formats, etc. needed for various uses. I'm excited to see origina...
Update Wordpress Child theme to work with latest version of X-Pro theme and PHP 8.2 First I would like you to estimate the work using the WPEngine credentials I supplied. Environment is: volleyball2stg From the ticket: I have tried again to update the staging site with the latest copy of the production and update the plugins and theme as well as the PHP version and here is the result. Updating the Pro theme have broken the existing layout of the pages and will need an overhaul of the child theme to match the new parent theme version when it comes to the structure. Updating the PHP version to 8.2 have generated and error on the WooCommerce collapsing categories pro plugin. I am not sure if this plugin is still maintained for the only review that it had
I'm seeking a skilled developer who can perform specific updates to my Laravel website. Key tasks include: - Front-End Design Changes: Your main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowl...
I need someone expert in restoring a SUITE CRM (SugarCRM) system precedent installed on a different domain. i have done backup of files and db but expanding on new domain it give an error (maybe many files to configure or something else to do i don't know. Al system is under plesk so i give a plesk customer containing files zipped and db zipped
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like i...
...native PHP and JavaScript. As this app is now deprecated and outdated, we are looking to rebuild it entirely from the ground up while retaining its core functionalities. Project Overview: We are seeking to develop a modern web application using cutting-edge technologies: - Frontend: React.js for dynamic and responsive user interfaces. - Backend: Laravel for robust and scalable server-side logic and API development. To begin, we can provide you with access to a working instance of the current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If you are interested in this exciting project and would like to discuss further details, including access to the existing appl...
(**If you are not a US citizen, pls don't apply**) I'm in search of a skilled software engineer to help develop a new web application. The ideal candidate should have proficiency in Java, Python and C++, as well as experience in full-stack development. Key responsibilities include: - Developing a new web application from scratch - Integration of user-facing elements with server side logic - Building reusable code and libraries for future use - Ensuring the technical feasibility of UI/UX designs - Optimizing the application for maximum speed and scalability Skills and experience required: - Proficiency in Java, Python and C++ - Full-stack development experience - Strong understanding of web development technologies and concepts - Familiarity with Agile methodologies - Ex...
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
I have a website, , that I would like to copy for a new domain. However, I need this new site to have a similar structure, yet with a unique and bright and vibrant color scheme to avoid any SEO issues with Google. Key requirements for this project include: - Cloning the structure and layout of my current website , ensuring a similar user experience - Updating the design with a bright and vibrant color scheme - Ensuring the updated design is distinct enough from the original site to avoid any penalties from search engines Ideal skills and experiences for this job would include: - Proficiency in web design and development - Experience with creating SEO-friendly websites - Strong sense of aesthetics and understanding of color theory - Familiarity with cloning websites while maintaining uni...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
...importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run once a night to parse a large XML file provided by the content provider. It will update, add, or remove relevant data in the PrestaShop facet search database tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and...
I need a script to automate server updates. It should be able to handle operating system updates, software updates, and security patches. Key Requirements: - The script should be able to automate server updates - It needs to handle operating system updates, software updates, and security patches Ideal Skills: - Proficiency in scripting languages - Experience with server management and updates - Understanding of cybersecurity and best practices - Strong problem-solving skills and attention to detail.
Looking for a talented web designer and developer to greatly enhance our landing page and web application, with a deadline of this very day. I'm eager to find someone who can: - Update our landing page's layout: I want our page to be sleek, modern, and easy to navigate. - Add fresh, engaging content to our landing page: The new contents need to be captivating, relevant to our services, and add value to our website. - Implement new features and fix prevailing bugs in our web app: I want our web application to be free of errors and add new functions that make it more user-friendly and efficient. The main goal of the landing page and the web app updates is to cater to 'software customizing’. I'm striving to make the entire user experience on both platforms s...
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
I'm looking for a developer to help me create a WhatsApp join invite link for sharing events. Key Requirements: - Development of a join invite link for WhatsApp - The primary goal is to facilitate event sharing - The link should come with an automated update notification feature
...talented PHP full-stack developer for a project that lies in the moderate complexity category, featuring some customizations. Key Responsibilities: - Front-end development: You'll be expected to create a visually appealing and user-friendly interface using HTML/CSS and JavaScript. - Back-end development: You must be proficient in PHP, particularly Laravel, to successfully implement the back-end logic of the application. - Database management: Proficiency in database management is essential, as it's a crucial part of the project. The ideal candidate for this role should have: - Strong experience in front-end and back-end development - Proficiency in HTML/CSS, JavaScript, CodeIgniter and Laravel - A track record of successfully managing databases - The ability to wor...
