Mysql read excel fileроботи

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

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з 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, тип файлу)

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

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

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

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

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.

I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred

I recorded a podcast episode on my computer through Riverside, but the audio is distorted. I need a skilled audio engineer to help me fix it. Key details include: - The audio was recorded in WAV format. - The primary issue is distorted sounds rather than background noise or volume fluctuations. Ideally, you should have experience with: - Audio editing software. - Correcting distorted audio without losing quality. - Working with WAV files.

...download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability to work with various digital file formats. - Attentive to details, particularly regarding security and user privacy. ...

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

I'm in need of a developer who can compile a Windows Exe file for the Real-ESRGAN GitHub project. The Exe file should operate on CPU, and accept command-line. Currently, the GitHub project offers only a GPU exe file, hence the need for a CPU version. GitHub link for Real-ESRGAN:

CRM WebApp Project: We need CRM with Wordpress can be elementor and theme, please see the links, read well, before you bide, make your best offer, I will choose the best offer price and deadline Functionalities: Client page: If we enter email or a phone that already exists it show immediately the number of CRM and the lead us to the CRM number CRMxxx We have many Tasks by numbers: T1 …….. To T35 For each task we can set up date, hour and the way to be done, in main page and by email we will receive alert for task that need to be done with number of task, number of CRM (client number) and the way that need to be done (W, Emai, SMS, Tel, Phone call, …). When we set up the task we can see it as the task is SET UP Some of the task

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

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

I'm looking for a talented web developer to transform my Figma file into an interactive, grid layout webpage. This is a great opportunity for someone who is looking for a challenging project which will demonstrate their ability to implement effective, modern design principles. Here are the key deliverables of this project: - Perfectly replicate my Figma design and translate it into a fully interactive webpage. - Implement a grid layout to optimize content display and improve user experience. - Make the webpage fully responsive, providing optimal viewing and interaction experience across all devices. Skillset Requirement: - Strong understanding of HTML & CSS. - Experience in converting Figma designs into webpages. - Strong background in responsive design principles. - Clea...

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 need a professional to add dimensions to specific sections of my AutoCAD drawing. These added measurements will serve to enhance the amount of detail and provide more informative insights for the viewer. I will send the DWG file on the creation of milestone. Key tasks: - Add metric (meters) dimensions to the DWG file - Pay special attention to select objects and areas requiring measurements Ideal skills and experience: - Expertise in AutoCAD software - Deep understanding of technical drawing and dimensioning standards - Precise attention to detail - Engineering or technical drafting experience would be a plus Your task will be integral in enhancing the sense of scale and data detail for anyone viewing this drawing in the future.

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

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

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.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I am looking for app developers who can incorporate the ability to both read and write to a Mifare Desfire EV1 card. In detail, here are the key requirements: 1. Android App: - Design and build an Android app that can interact with the Mifare Desfire EV1 card - Capable of reading and writing Authentication data to and from the card 2. IOS App: - Create an IOS app that can read this Authentication data from the same card Our main goal is to use this Authentication data for user login/authentication for internal use. The successful freelancer should have skills and experience in Android development, IOS development, and working with Mifare Desfire EV1 cards, preferably with Taplinx. Knowledge in data security is a must. Ensuring privacy and security of the data is our pri...

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

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention t...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

...enthusiastic business, 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 colla...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

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.

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...

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.

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.

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

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.