Database Design - Laboratory Work 3

Hello, I need your help in implementing a task. Fix the bugs on the website page, the page displays a 404 error.

Synchronization of Microsoft Access and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program).

Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000 subscribersRequired Implementation Integration through an official Viber Business provider (TurboSMS, GMS Worldwide, or another agreed service). The button "Write to Viber" in the subscriber card. Sending messages directly from BAS. Receiving incoming messages via Webhook. Automatic linking of messages to the subscriber by phone number. Complete preservation of correspondence history in the subscriber card. Displaying the time, message status, and the manager who responded. Simultaneous work of multiple managers. Message templates for quick responses. Assistance with setting up the Viber provider, API keys, and Webhook. Transfer of all source code and settings after the work is completed.Acceptance Conditions The work is considered completed after successful testing of all functions on the working database and transfer of the source code.Guarantee 1 month warranty for fixing bugs related to the implemented functionality. Further modifications are carried out by separate agreement.Result After the project is completed, managers should be able to fully work with Viber directly in BAS: write to clients, receive responses, view correspondence history, and communicate without using third-party CRMs. All source code, modifications, API keys, and settings will be transferred to the client after the project is completed.

Looking for an experienced developer (or a small team) to create an MVP mobile application — a service for urgent calls to specialists similar to Uber, Uklon. Development needed: • mobile application for iOS and Android (Flutter); • server part (REST API); • admin panel; • database. Main functionality of the MVP: registration of clients and performers; authorization; map and geolocation; order creation; search for the nearest performer; push notifications; in-app chat; ratings and reviews; order history; admin panel. Requirements: experience in developing marketplaces, delivery services, taxi or similar projects; Flutter; Backend (Node.js / Laravel / Go / NestJS — ready to discuss); PostgreSQL; understanding of scalable architecture. In your response, please include: Links to applications in the App Store and Google Play. Similar projects you have developed. What architecture you propose. Approximate cost of the MVP. Development timeline. Important: looking for a specialist for long-term cooperation. Interested in the quality of architecture and the possibility of further scaling the project. Budget is negotiable with the suitable candidate.

It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for verification and correction: 1. Products subject to repair – assignment of a mark Result: Number of records discrepancies Correction script 2. List of Categories, Groups, Subgroups – comparison with the tmp table Result: Number of records discrepancies Correction script 3. Number of products in category. Groups, subgroups. (statistics) – Comparison by table, identification of discrepancies Result: Number of records discrepancies Correction script 4. List of spare parts in the system with category, group, subgroup - Comparison by table, identification of discrepancies, elimination of discrepancies Number of records discrepancies Correction script 5. Repair items related to spare parts - Comparison by table, identification of discrepancies, elimination of discrepancies Discrepancy table Correction script 6. Reconciliation of balances and SN Discrepancy table