Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into 1C: Small Business.
Current state:
In 1C, the processing for loading Nova Poshta specifications from an Excel file is used. During the import, some data from the file is not transferred to the system.
Problem:
When loading the specification, some rows and/or individual fields are not filled in the 1C document, despite the presence of data in the source Excel file.
It is necessary:
To analyze the existing processing of importing Excel files from Nova Poshta.
To determine the reason why individual data is not being loaded.
To check the correctness of the mapping of Excel columns to attributes in 1C.
To ensure the correct loading of all data from the specification file.
To test the processing on several current Nova Poshta specification files.
Applications 1
-
I will check and fix the processing of uploading specifications from Nova Poshta in 1C: Small Business: I will analyze reading Excel, matching columns, filling in attributes, and test the import on several relevant files.
Did your data start disappearing after changing the format of the Nova Poshta Excel file, updating 1C/Excel, or is the processing simply skipping some rows and fields without an error?
Budget and deadlines will be discussed in private correspondence after reviewing the processing, examples of Excel files, the 1C document where the data is uploaded, and the specific rows/fields that are currently not being transferred.
Similar completed project: В модулі OpenCart виправити 5 проблем повязаних з Facebook API
-
Hello! I am ready to take on your project and will complete it urgently. I have extensive experience with similar tasks, so there will be no difficulties. If I have piqued your interest, feel free to write; I am happy to collaborate!
-
976 4 0 Hello! I have experience working with 1C/BAS, Excel import processing, and Nova Poshta integrations. I am ready to analyze the current processing, find the reason for the incomplete data loading, and fix the issue. I will check the logic of reading Excel, the correspondence of columns to 1C attributes, the selection conditions for rows, and possible changes in the format of Nova Poshta files. As a result, I will ensure the correct loading of all data from the specifications and test the solution on several relevant files. After completion, I will provide a brief report on the cause of the problem and the changes made. I am ready to start soon.
-
320 2 0 Good day
I am ready to analyze the processing of the import of Nova Poshta specifications, find the reason for the incomplete data loading, and fix it.
I will also check the correspondence of the Excel columns to the 1C requisites and test it on current files.
Feel free to write, I would be happy to collaborate.
-
196 We already have almost ready logic for diagnosing such imports in 1C and Excel, it can be quickly adapted to your processing, run the check, and discuss on the marketplace now - I'm available ))
Regarding the timeline, I would estimate 2-3 days, and for the budget - starting from 6000 UAH, because it’s important not just to fix one field, but to find the reason for incomplete loading and check several files.
We can go through the processing step by step - reading Excel, determining columns, matching with 1C attributes, conditions for skipping rows, data types, and filling errors.
Look, there’s a nuance - often the problem is not in 1C itself, but in changes to the New Post specification template or in silently skipping rows due to an empty cell, date format, number, or renamed column.
To start, we need the processing itself, 2-3 Excel files where there is a problem, an example document in 1C showing what exactly did not load, and the version of the Small Business configuration.
…
Please clarify, is the processing external or built into the configuration?
And the second question - is part of the data not loading always from the same columns or randomly from different rows?
Relevant examples from Ingello
- https://business.ingello.com/forma-bpm - automation of business processes and accounting logic
- https://business.ingello.com/forma-wms - accounting, warehouses, documents, import, and operation control
- https://systems-fl.ingello.com - our profile on systems, integrations, and automation
Overall, it looks fine, the task seems compact, but it’s better to check the reason carefully so that after the next New Post file it doesn’t break again ))
-
788 16 0 Good day! I can take a look and correct it. Feel free to reach out, I will be happy to help :)
-
266 Good day, we will proceed immediately if you choose to be the executor. The task is 100% clear.
-
4602 28 0 Good day, we are ready to complete the tasks quickly and efficiently, we can discuss all the details in correspondence, after which we will form the final cost, but the specified budget should be sufficient.
-
477 Hello!
I am ready to take on the task. I have experience in refining 1C processing, importing data from Excel, and finding errors in matching columns, table parts, and document attributes.
I can perform:
• analysis of the current processing for loading specifications from Nova Poshta;
• investigation of the reason why some rows or fields do not get into 1C;
• verification of the matching of Excel columns with attributes in 1C;
• correction of the import logic;
… • testing on several relevant Excel files;
• delivery of the corrected processing with a brief description of the changes.
To start, I will need the processing itself, several specification files where the error occurs, and access to the test/production 1C database.
I am ready to begin and ensure the loading works correctly.
-
3008 73 4 2 Good day! I know what the problem is, so we will solve it quickly!!!!!
Feel free to reach out!!!!!
-
871 10 0 Good day. I can take on the task, but first, I need to analyze the cause of the problem. Please send:
the version of 1C;
a processing file (*.epf), if it is separate;
a sample Excel file that is being imported incorrectly;
After the analysis, I will be able to confirm the deadlines and the scope of the necessary adjustments.
-
1168 7 0 Good afternoon! We have experience working with data exchange between Excel and 1C:UNF. We will analyze the structure of the specification file and the processing logic to identify the cause of the failure during the parsing of the table part. We will implement this through code debugging and adjustment of the cell reading algorithm, ensuring the correct import of all items.
-
3355 11 0 Hello, Dmitry! This is Nina, the manager of the development team.
The task is completely clear. Judging by the screenshot of the interface, the processing successfully reads the header, document numbers, and dates, but completely ignores the final columns (amounts, service content, etc.). This often happens when Nova Poshta slightly changes the structure of the Excel file (shift of columns, appearance of empty hidden rows, change of cell format from text to numeric), and the 1C algorithm starts to silently skip them.
Our Middle+ developer Valentin is responsible for 1C automation and integrations. He has extensive experience working with parsing Excel files and modifying configurations (including Small Business / UNF).
What Valentin will do:
Algorithm analysis: He will check the processing code (.epf), specifically the logic of reading cells and the conditions under which a row may be skipped.
Data matching: He will compare the column indexes in the new Nova Poshta Excel file with the attributes of the table part in your 1C.
… Correction and testing: He will modify the processing to make it resilient to minor format changes and test it on 2-3 of your current files, achieving 100% import of all fields.
Working conditions:
Deadline: 1 day (we will do it promptly, understanding that accounting is ongoing right now).
Budget: 2000 UAH (we work through the Safe, the amount is fixed, your proposed budget is fully sufficient).
Dmitry, please send the processing file and one of the problematic Excel specification files in the chat. Valentin will immediately localize the error in the code, and we will return to you a fully functional tool.
-
Ask your question to the client
Current freelance projects in the category Databases & SQL
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 2 hours 58 minutes back ∙ 24 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 11 hours 33 minutes back ∙ 31 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 5 days 10 hours back ∙ 56 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 5 days 10 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 5 days 23 hours back ∙ 10 proposals |