MySQL and Excel
8 USD From this, remove a new mysql table with organizations, and the columns "Status" and "Exist in the list" are added to them. If an organization is at least in one of the lists above, the status is written "Unfunctional" and the column of the list is written in which list the organization was located. Otherwise, the status is written "Active" and, in the presence of the list, "No".
MySQL base on the host.
Client's review of cooperation with Natalya Kvitka
MySQL and ExcelGreat work! She quickly fulfilled the task, which she was grateful for.
Freelancer's review of cooperation with client
MySQL and ExcelOK, thank you for your collaboration!
-
Winning proposal2 days8 USD
458 27 0 Winning proposal2 days8 USDGood day .
I would like to see the structure of the table.
Compare by the EDRPOU code (if there is such a field in the tables) or by other records?
The price is conditional.
-------
Explanation of the budget of the project - after clarification of the TZ.
-
1 day11 USD
6340 144 6 4 1 day11 USD
Ready to implement during the day in the form of a script on the piton if necessary will periodically update the information or in the form of a ready mysql base if necessary once. You need an example of the Excel file and the mysql database.
-
2 days16 USD
8283 381 0 1 2 days16 USD
Good day . Interested in your tasks. Ready to discuss and perform.
-
4 days34 USD
798 15 0 4 days34 USD
I welcome.
I can help with the task.
I’ve already worked with data parsing from Excel to MySQL.
Example of the site: http://marketmetal.com.ua/
Here we had to make a parsing price from the .xls file to the BD.
Realized the task using this library: https://github.com/PHPOffice/PhpSpreadsheet
-
mysql таблицы -- все в одной базе? Или несколько баз?
Сравнивать только по названию организаций?
-
сколько предлагаете денег ?
-
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 1 day 10 hours back ∙ 4 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 1 day 13 hours back ∙ 17 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 3 days 4 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 4 days 9 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 4 days 13 hours back ∙ 13 proposals |