Stepan Stanchev
Winning proposal- Projects -
- Rating -
- Rating 155
Budget: 500 UAH Deadline: 1 day
Full automatic processing is possible with regular expressions and a list of colors. If you change the originals, you may need to add the missing colors to the list.
With respect Stephanie
Budget: 200 UAH Deadline: 2 days
Good Morning Andrei,
ready to help you with the task. I offer an option using only one formula, which will then remain with you :) I can describe more in the message.
Budget: 500 UAH Deadline: 2 days
Ready to perform. in the semi-automatic version. Unfortunately, it will be quite difficult to fully automatize.
Please, I can do within a day if the budget will be above the rate I specified.
If the 2nd day is set, the rate is relevant.
Budget: 450 UAH Deadline: 2 days
Ready to take your project. I have experience with Excel. We are working?
Budget: 300 UAH Deadline: 1 day
Ready to do with the help of Excel macros
The speed and speed of operation guaranteed
Budget: 500 UAH Deadline: 1 day
The need to do the operational analysis, there is knowledge, skills and understanding of what is needed.
Budget: 300 UAH Deadline: 1 day
Good day ! I can do the assigned task partially with the help of built-in settings + handmade.
I would like to read the document in advance.
Budget: 300 UAH Deadline: 1 day
Hello, please contact LS, I will divide the text by columns and I can write instructions how to do it myself.
Budget: 500 UAH Deadline: 1 day
Good day ! Experience is great. Write to Ls, I will discuss and do it.
– –
Always in connection
Budget: 500 UAH Deadline: 1 day
Shouldn’t it be done once? I write a macro for repeated use. It’s better to connect with Skype Sokolv555.
Budget: 2000 UAH Deadline: 2 days
Good day ! I will begin to perform the task immediately after the discussion of TZ in LS. Go to turn.
- Projects -
- Rating -
- Rating 51
Budget: 100 UAH Deadline: 7 days
Hello to you. Ready to do.
Post by: [email protected]
Budget: 1000 UAH Deadline: 2 days
Hello to you,
I can provide a list of products in the form of a table of 3 columns: name, color, size
Budget: 500 UAH Deadline: 1 day
Good day . It is possible to implement the project quickly (Macros, formulas, ...)
Proposals are currently absent
Proposals concealed
Proposals concealed
-
Kristina Lyan 17 January 2019Добрый день! можно попросить отправить файл для понимания объема работы и определения стоимости.
-
Andrey Reveko
17 January 2019
Высылаю более понятно
2 листа1 - то что есть
2 - то что нужно из этого сделать -
Yura Soobschuzakazchiku 17 January 2019Странно, заказчик поставил пометку "срочно", но уже более 2-х часов отсутствует на сайте (хотя никакого исполнителя из желающих не выбрал)... Интересно, задача не такая уж срочная или заказчик просто пытается скинуть цену.
1) Уважаемый, а вы понимаете, что за срочность люди обычно готовы переплачивать?
1) Скажите какие у вас реальные сроки?
2) Какой резервируете бюджет под эту задачу?
-
Andrey Reveko
18 January 2019
да, заказчик с 8к+ товаров решил сэкономить 200грн))))
99% не читают тз и хотят делать руками, а мне нужна обработка, а не руки -
Konstantin Aleksandrovich 18 January 2019Не руки - можно пробовать Sql c полнотекстом но и здесь думать надо.
-
Klavdiia K. 18 January 2019Прошу прощения , но разве для полной автоматизации не нужно , чтобы инфа в исходнике была записана в определенном порядке: название товара— цвет— объём?
-
Aleksandr Pomazun 18 January 2019или иметь полный перечень вариантов цветов. Сколько их на 10 т позиций - х.з, файла нету
-
Andrey Reveko
18 January 2019
бить на колонки - выводить через фильтр
с размерами то же самое.. я полагаю
Current freelance projects in the category Databases & SQL
Support for Samotur and its servers
Support is needed for the self-tour program, catalog database servers, and the online server. There are 5 database servers.
The client database has been collected over several years from various sources, so the phone numbers are recorded in different formats, one client exists under multiple IDs, cities are entered manually in different languages, and the region is almost never filled in. Because of this, it is impossible to properly segment the database. What needs to be done: 1. Database audit (paid separately, first stage). How many cards, how many phone numbers are out of format, how many duplicates, how many unique city entries. Based on the results — a refined estimate of the remaining work. 2. Standardization of phone numbers. All numbers should be brought to the format +380XXXXXXXXX. Numbers that cannot be unambiguously recognized should not be deleted or guessed, but listed separately. 3. Merging duplicates. Rule: one phone number = one client ID. At the same time, one client can have an unlimited number of numbers. Order history, emails, addresses, tags, and custom fields must be preserved. 4. Parsing cards that have many numbers "attached" to them. 5. Cities and regions. Names of settlements — from a single directory in Ukrainian (API of Nova Poshta or KATOHTG). The region must always be filled in so that all clients from Kyiv and the region can be exported with one filter, not separately for Brovary, separately for Irpin, etc. 6. Protection against re-contamination: normalization of phone and city at the input (website forms, integrations, manual entry) + regular background checks of new entries. Requirements: — practical experience with the SIMLA / RetailCRM (v5) API: exporting, updating, merging cards, request limits; — experience with data deduplication tasks; — understanding of Ukrainian address directories. Working conditions: full backup before any changes; initially a dry-run with a report on planned changes for approval, and only then launch on the live database; log of all operations with the possibility of rollback. No irreversible deletions without approval. In your response, please include: — timelines and cost
It is necessary to compile a large and up-to-date database of contacts of Ukrainian scientists, educators, researchers, doctoral candidates, and graduate students using only open sources. The result should be in Excel or CSV format and contain at least full name, email, place of work (university or research institution), position, and a link to the source from which the contact was obtained. It is essential to minimize duplicates and, if possible, verify the validity of email addresses. For data collection, official websites of universities and research institutions, faculty profiles, department pages, institutional repositories, journals on the OJS platform, ORCID, OpenAlex, Google Scholar, ResearchGate, Crossref, PDFs of scientific articles, as well as other open academic resources can be used. The use of automation (parsing, API, Python, etc.) is encouraged if it does not violate the rules of the respective services. The main goal is to gather the most complete database of contacts from open sources.
A centralized server system for collecting and storing data from Planfix, 1C, Meta Ads, and Google Ads is needed, as well as a web dashboard for displaying and analyzing this data. All data, change history, calculations, and aggregated metrics must be stored exclusively in the server database. The dashboard should not store or duplicate business data. It must retrieve the necessary information from the server database via API according to user requests and display it in the form of KPIs, charts, tables, and detailed reports.
We are looking for support for a project based on Yii , we need to make edits and improvements to the database, there is partially a connection with the previous contractor .....................