It is necessary to check the scripts and update the data in the Postgres database.

Feel free to contact me, I will do it.

Show original

Translate

Hello!

The task is clear — SQL scripts for comparing data between two PostgreSQL databases and Excel, identifying discrepancies and correction scripts for each of the 6 points.

I work with PostgreSQL, and the submission format matches yours: discrepancy script → discrepancy table → correction script → correctness check in both databases.

Running via AnyDesk and Navicat — no problem.

We will discuss the details and exact price privately after you share the table structure and an example of the Excel file.
…
I look forward to collaborating!

Show original

Translate

Hello.

I can take on the task involving PostgreSQL and Excel spreadsheets. For such adjustments, it is important to first obtain a control picture of the discrepancies, and only after that run the UPDATE scripts.

I suggest performing the work as follows:
1. Loading Excel data into temporary / staging tables
2. SQL queries for reconciliation for each block
3. A discrepancies table and the number of records for each item
4. Agreement on the correction logic
… 5. Separate SQL correction scripts
6. Rechecking after the update

In the scripts, I will include:
- Transactions before changes
- Checking the number of records before/after
- The ability to rerun without corrupting data
- Separate queries for diagnostics and separate ones for corrections
- Minimization of manual edits directly in the production database

Before starting the work, I need to clarify:
- Is there a test database or dump?
- What fields are the keys for comparison?
- Are the Excel spreadsheets the benchmark or do they also need to be verified?
- Is there direct access between the two PostgreSQL servers?
- What current scripts already exist?

I can work via AnyDesk / Navicat, but before making changes, it is advisable to have a backup or a test run.
We can discuss the details in private messages.

Show original

Translate

Good day, Ekaterina!

Understood: we need to verify and organize the data in Postgres, reconcile between Excel spreadsheets and two databases on different servers, search for discrepancies, and create SQL scripts for corrections. For each block (items for repair, categories/groups/subgroups, quantity statistics, spare parts), provide the total number of discrepancies plus a fix script. Execution via AnyDesk in Navicat, I work this way.

How I will ensure reliability:
- For each point, first DIAGNOSIS: an SQL query showing discrepancies (count plus the actual records), so you can see the volume before corrections;
- then a FIX script, idempotent (re-running does not break) and in a transaction (rollback if something goes wrong);
- reconciliation of Excel and Postgres and between the two databases through temporary staging tables, to avoid touching production data directly until confirmed;
- for each block, a report showing discrepancies N became 0.
…
Safe: first in a transaction with verification, then confirmation. No blind corrections on the production database.

Clarification: two databases on different servers, do we connect them through export/import (dump/staging) or is there direct access (dblink/FDW)? This affects the approach to reconciliation.

We work through Safe step by step: Stage 1, diagnosis scripts for all blocks (you see all discrepancies), then correction scripts. Zero risk.

Estimate: 3500 UAH, 4 days. Examples of work: Freelancehunt https://guardlabs.online

Show original

Translate

Good day! I did an Excel ↔ Postgres reconciliation as a reproducible scenario, not manual editing: first a read-only reconciliation on staging, I calculate discrepancies by keys (product, category, group, balance, serial number), then separate idempotent SQL scripts for corrections and a report for each item. I upload to the production database only after running on the test one and your OK — to avoid surprises on both servers. Is there a test database available, or should we run the reconciliation on a dump of the production one? Ready in 5 days.

Show original

Translate

Hello!

The task is standard, I will complete it without any problems. I hold the 38th place in the SQL ranking on the relevant site, so I have good practical experience working with databases.

I look forward to collaborating!

Show original

Translate

Good day. I will do it within 1 day! Ready to start now. Huge experience. Write to discuss.

Show original

Translate

Good day, Ekaterina.

In brief:

Your data in PostgreSQL will be fully verified and synchronized with Excel spreadsheets and between servers. Each of the six verification points will receive a clear report on discrepancies and SQL scripts for their resolution. Using a direct connection through Navicat will allow for safe updates without the risk of data loss. I will use the excelize library to work with Excel files, which guarantees accurate reading and matching of data. As a result, you will have a consistent database where all products, categories, spare parts, and stocks will be fully aligned.

In detail:

Discrepancies between two PostgreSQL servers and external Excel spreadsheets often arise due to desynchronization of key fields—especially when spare parts are linked to repair items through complex category and subgroup relationships. Your six verification points cover exactly those areas where typical discrepancies accumulate, and each of them requires a separate report with a record count, as well as a separate script for their correction.
…
Your database will be fully verified through Navicat: for each point, you will receive a discrepancy table, a discrepancy script, and a data correction script for synchronizing both databases. Excel files are matched using the excelize library—this is more reliable than manual import, as type and encoding checks eliminate missed rows without notification. Before executing any UPDATE or DELETE, a backup will be created—this will protect against data corruption if the matching reveals unexpected matches. Your scripts will be adapted to the acceptance format: reconciliation script, discrepancy table, correction script, correct data in both databases.

To avoid scope creep, it is advisable to finalize the exact list of tables and fields for comparison for each of the six points before starting—this way, the correction scripts will cover exactly what is needed, without surprises.

Later, automated verification triggers and constraints can be created. This will eliminate the recurrence of discrepancies in categories and stocks, as the system will automatically reject incorrect data at the PostgreSQL architecture level.

SQL views can also be developed for monitoring product and spare part statistics. This will allow you to instantly see current discrepancies in Navicat without the need to run manual verification scripts each time.

Show original

Translate

Good day, I will gladly help with the review and correction of SQL scripts for PostgreSQL, as well as updating data from external Excel tables. I have over 5 years of experience with databases, particularly PostgreSQL. Feel free to reach out!

Show original

Translate

Good afternoon, Ekaterina. I am ready to take on the review of scripts and update the data in your Postgres database.

I have experience working with PostgreSQL and writing SQL scripts for finding discrepancies, matching tables, and updating attributes. The specifics of working with external Excel tables and cross-server comparisons are clear to me.

I am ready to work according to your requirements:
— I will connect via AnyDesk.
— All runs and adjustments of scripts will be conducted directly in Navicat.
— I will strictly follow all 6 points (from checking repair attributes to reconciling balances and serial numbers).

… Regarding the price and deadlines, I have oriented myself with the rate (1500 UAH, I will complete it in 1 day). Please let me know if the scripts for correction have already been written and only need adjustments, or if part of the matching logic needs to be written from scratch? I am ready to discuss the details and get started.

Show original

Translate

Hello! I am ready to help with your project. I have extensive experience in development and can implement all the necessary components according to your documentation. I guarantee quality execution within the agreed deadlines.

Show original

Translate

Good day!

I have extensive experience working with PostgreSQL, optimizing SQL scripts, and integrating data from Excel. I am ready to professionally review and update your databases, including cross-server synchronizations and working through Navicat.

Message me privately, and we will clarify the details.

Show original

Translate

Good afternoon! We have experience in data migration and synchronization between remote Postgres instances. We implement the task by writing optimized SQL procedures for processing external files and cross-server queries, ensuring data integrity during updates.

Show original

Translate