Posts Tagged with: php -> mysql

A parser needs to be created to collect competitor prices, with a catalog of over 40,000 products. Access to the prices is only available under authorization.

Hello! It is necessary to compile a list of Telegram chats suitable for advertising, the theme is gray, Russian. Let's start with 100 chats. The breakdown should be in the following format: chat link, number of participants. It is preferable that the chats are active with a real audience. Please provide the deadlines and cost for completion. Thank you.

Hello I previously posted a project (description below) and received the following result https://docs.google.com/spreadsheets/d/1-abSBtjRZeD_ZGriquW0YUZdbmC4eXcr/edit?usp=sharing&ouid=113724943543706943348&rtpof=true&sd=true as it turned out, unfortunately, later - it is very incomplete... for example, in the table, there is a filter for the city of Neperville - where only 4 dealers are listed. But I manually found 25 such dealers on the maps, and these are not duplicates but unique. Some cities are completely missing. So I am interested in the city of Chicago and the surrounding towns (suburbs), I will provide a list if needed. ---- List of categories from Google Maps from which all companies need to be extracted Car Dealer Used Car Dealer New Car Dealer I also provide a list of categories used by branded dealerships: Toyota Dealer Ford Dealer BMW Dealer Honda Dealer I will provide a list of car brands separately. Generally, within the city, there are several dealerships for each car brand The result in the form of a table. Deduplication through Place ID Price for the work. This is a one-time job. I do not require any script that I will work with further. You can do parsing through your developments or third-party ready services.

Development of automation for Google Sheets + weekly reporting in TelegramProject type: Automation of spreadsheets, data parsing, Google Apps Script / alternatives.Project descriptionThere is an EXCEL spreadsheet (about 45 tabs, some light formulas, historical data). The spreadsheet significantly lags during online work, so it has to be worked on offline. The tasks are: Automate the weekly addition of data from a specific website. Resolve the performance issue. Set up automatic data aggregation and weekly report sending to Telegram.Stage 1. Solving the performance issue + automating data loadingTasks: Analyze the current Google spreadsheet (template will be provided) and propose an optimal solution to the lag issue (large number of tabs and rows). Possible solutions (choose and justify the best one): Optimization within Google Sheets (splitting spreadsheets, using caching, IMPORTRANGE with a smart approach, Google Apps Script). Alternative: migration to Airtable / Notion / Make.com + Power Automate / Python + Google Sheets API. Hybrid solution (main work offline + synchronization). Implement automatic weekly parsing/importing of data from the specified website into the required tabs of the spreadsheet. Set up a schedule (preferably automatic, without manual triggering).Expected result of the stage: A working spreadsheet (or system of spreadsheets) that does not lag during operation. Automatic addition of new data every week.Stage 2. Data aggregation and report sending to TelegramTasks: Set up data collection from specific cells/tabs. Create a pivot table with historical data and percentage ratios (dynamics, % change, etc.). Organize automatic weekly report generation. Set up sending the finished report (spreadsheet + key indicators) to a Telegram bot or a specific chat/channel/group.Expected result of the stage: Automatic weekly report sending to Telegram. Clear, understandable report format.Candidate requirements Excellent knowledge of Google Sheets + Google Apps Script. Experience with website parsing. Experience in optimizing large spreadsheets. Knowledge of Telegram Bot API — mandatory.Implementation details, exact data requirements, deadlines, and costs will be discussed in private messages.

It is necessary to set up the parser remotely (via Anydesk or TeamViewer), something is broken and not working correctly. Mainly replacing the starting links and configuring the parser. Website https://dveri-pol.com/