Automate mysql queryроботи

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain

...following issues: - **MySQL Configuration**: I'm encountering error messages related to MySQL. The freelancer must be able to diagnose the issue and provide an effective solution. - **SSH Troubleshooting**: There are connection issues with SSH. The hired professional should be able to identify the root cause and resolve it promptly. - **cPanel Account Missing**: Currently, some cPanel accounts are not showing. The task involves investigating and rectifying the issue. - **Service Stoppage**: Some important services have stopped working. The ideal candidate should have experience with Linux administration and be able to troubleshoot and restart these services effectively. Ideal skills and experience include: - Proficient in Linux server administration, particularl...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-free output is imperat...

I'm seeking a skilled freelancer to integrate and customize the Bitrix24 CRM platform for my business. Your task would encompass three main areas: 1. Contact Management: Streamline and automate how we track, manage, and interact with our contacts. 2. Sales Pipeline Tracking: Develop an efficient tracking system to provide clear visibility into the movement of deals through the sales pipeline. 3. Task Management: A system where tasks can be created, allocated, monitored, and completed efficiently should be put in the system. This would aid in team coordination and ensure accountability. Additionally, a customized calendar that syncs with these functionalities is crucial for our business operation. The CRM will be used by 11-50 users, so it should be user-friendly and scal...

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 yellow co...

I'm in search of a MailWizz expert Key responsibilities: - Customizing the user interface design to improve the overall user experience and branding. - Devising a mechanism to manage debits of email credits efficiently. We simply want to add emailing credits to our customers mailbox account and we will ad...credits the account based upon the amount paid. We then simply like to debit the credits for each email sent. Very simple. If we give the mailbox user 10,000 credits and they emails 3,000 emails the 3,000 is debited from the 10,000 balance and 7,000 credits are left. We have already configured Mail Wizz with Postfix MTA We own our servers and we wish to integrate the emailing server with our MySQL database. This is the first of many jobs that we will require cus...

This is an APP just for GitHub: Stressing over shipping bugs to prod? Automate your code-freeze periods and prevent merges during critical times We only have 56 installs on GitHub, not any paid plan yet. We are looking for affordable SEO services Thank you

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 different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote ...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, MySQL, O...

I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current demo code lacks a user-friendly interface. ...

...message templates to facilitate the sending of common messages, such as order confirmations, appointment reminders, promotions, etc. Activity Logging: Implement an activity logging system that records all interactions performed through the application, including message sending, delivery status, etc. Technologies Used: PHP: Primary programming language for backend development of the application. MySQL: Database for storing user information, contacts, and activity logs. WhatsApp Business API: Official API provided by WhatsApp for sending messages from business applications. HTML/CSS/JavaScript: For frontend development of the administration and configuration web application. Deliverables: Complete source code of the PHP application. Detailed documentation on installation, config...

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 debugg...

As a real estate professional, I am seeking assistance to implement a more systematic and effective way to generate leads from Facebook, Instagram, and ManyChat. My current method employs organic posting and engagement but I am keen on maximizing these platforms. Specifically: - I need help in setting up Zapier to build workflows. - I'd like to automate comment responses, particularly when specified keywords are used such as "guide" or "136 North Avenue". Upon detection of these keywords in comments, I want details to be sent out automatically. Ideal skills and experience: - Expertise in social media lead generation (Facebook, Instagram, ManyChat) - Experienced in using Zapier for workflow creation - Knowledge of automated chatbot interactions for lead ge...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

...appropriate tagging and categorization. - Report Generation: I require the freelancer to set up automated report generation which provides insights on sales performance, lead progress, and any other relevant metrics. The reports should be easy to interpret and visually appealing. In addition to this, I need assistance in setting up workflow automation in Fresh Sales. Specifically, I would like to automate follow-up reminders and email sequences. The freelancer should have a clear understanding of sales processes and be able to suggest and implement efficient automation strategies. Lastly, I am looking for a consultant who can recommend a program that supports multi-currency transactions and integrates smoothly with Fresh Sales. The program should be capable of: - Providing real...

I'm in need of a skilled professional to set up a multi-node GitLab environment on my Linux system. Key Points: - The project requires comprehensive experience with GitLab configuration and deployment on Linux. - The setup should be able to handle Continuous Integration/Continuous Deployment (CI/CD) and Source Code Mana...able to handle Continuous Integration/Continuous Deployment (CI/CD) and Source Code Management (SCM) efficiently. Ideal Skills: - Proven expertise in GitLab setup, particularly in multi-node scenarios. - Strong understanding of Linux systems and their configuration. Your successful completion of this project will enable me to streamline my development processes, manage code efficiently, and automate deployment pipelines. Please share your relevant experienc...

...ensuring proper data flow and interaction between the two. 6. Collaborate with the frontend developer to ensure smooth integration of custom designs. 7. Optimize the website for performance, security, and scalability. **Skills Required:** 1. Strong experience with Laravel 10.x framework, including MVC architecture, routing, middleware, and blade templating. 2. Proficiency in database management with MySQL or other relational databases. 3. Deep understanding of backend development principles and best practices. 4. Proven track record with API integration, particularly with payment gateways and shipping partners. 5. Familiarity with frontend technologies (HTML, CSS, JavaScript) to connect frontend to backend. 6. Familiarity with version control systems, such as Git, for collaborat...

Power Automate Flow Which send multiple attachments based on SharePoint list

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

...necessitates manual setup of form fields and checkboxes on a PDF. To streamline this task, I'm looking for an expert who can automate the conversion of PDFs or image files into HTML, using the image/PDF as a background. If able to populate the fields with datalabels corresponding to program (OscarEMR) is a bonus. documentation eform generator being used, I would like to automate the process to not have to use the manual generator: Key Requirements: - Automation: The primary goal of this project is to automate part or all of the the form creation process - even if there is a way to automate the location of top left pixel of each checkbox. - Simplicity: The forms that need automating are relatively straightforward

...Power Automate freelancer to help in automating several workflows in my organization. With the current setup, we are facing challenges with our corporate devices. They don't conform to the naming convention and we also have issues with the logged-in user not matching UPN in Azure. This is causing problems with device identification, user verification, and Azure AD integration. To address these issues, I need a full workflow setup. Your responsibilities for this project would include: - Understanding the current device and user identification issues - Designing and implementing a comprehensive Power Automate workflow - Ensuring that the workflow addresses the issues with the corporate devices and Azure AD The ideal candidate must have: - Extensive experience with...

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 y...

I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.

Please bid based on the actual price you believe it will cost, not just to get in our inbox. We are a hosting company looking to automate our services through our WordPress site. This project involves two main tasks: creating a custom WordPress hosting management plugin and integrating Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, e...

...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...

We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.

...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 its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and existing PrestaShop MySQL tables. As we have large amount of products and the feature data. We dont want the filter to read all the data while loading. for example TV category filter should only load and read filter data where products belongs to TV categoeiry. This will speed up filter load. Adding Filter Button for Mobile Display: This task involves modifying the mobile layout to include a filter ...

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.

...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...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and bdomain

I'm looking for an experienced freelancer to create a Postman script that will automate the login process for without requiring any manual intervention. Here are the key details of the project: - You should be able to simulate entering the email and password, clicking the login button, and retrieving headers for subsequent actions on the front. - Upon successful login, the output data format should be in JSON. Ideal Skills and Experience: - Proficiency in working with Postman and creating scripts for automation. - Strong knowledge of HTTP methods. - Experience with handling and parsing JSON data. - Familiarity with cookies and headers in HTTP requests is a plus. Please note that the successful delivery of this project requires meticulous attention to detail and a solid unde...

I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free ...

I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...

I am ...view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to im...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I will share my screen through te...

We are looking for a proficient developer who...specifically we require: - Product names - Prices - Descriptions These products are variable with different dropdown options. This data needs to be imported into Woocommerce on a weekly basis. The ideal candidate for this position would have previous experience in similar projects and an understanding of ecommerce platforms, particularly Woocommerce and Radix. A familiarity with scripting languages to automate the scraping and updating process would be a major advantage. The ability to ensure that every weekly update is accurate and timely is a must. If you have the skills and can guarantee a meticulous approach to this task, please place your bid. You will be asked to provide evidence of previous similar work. Please apply using ...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Prod...- Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...

I'm in need of a seasoned .NET developer who possesses the following expertise: - Skilled in developing Web API - Knowledgeable in MySQL as a database system - Need 5+ Years Experience This is a personal project and I'm seeking someone reliable, efficient, and with a firm grasp on these skills to ensure successful implementation. If you have the experience and are keen on a unique personal project, I encourage you to bid.