WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

Hej.
W jednym z procesów użytkownik ma możliwość zaimportowania danych do listy pozycji z pliku Excel. Niestety często są to pliki zawierające minimum 100 pozycji, co powoduje problemy w imporcie. Wtedy, jakimś cudem import udaje się mi z poziomu admina (nie rozumiem w czym jest różnica).
Lista pozycji ma obecnie 40 kolumn w tym kilka pól wyboru gdzie uzupełniają się inne pola czy pola wyliczalne (zmiennoprzecinkowe).

Jak sobie radzicie z importem pliku na ponad 100 pozycji, dla takich kolosalnych list pozycji?


Hi.
In one of our processes, a user can import data into an item list from an Excel file. Unfortunately, these files often contain at least 100 items, which causes import problems. In such cases, somehow, the import is successful from the admin level (I don't understand the difference).
The item list currently has 40 columns, including several selectable fields that also populate other fields or calculated fields.

How do you manage importing files with over 100 items for such colossal item lists?

Hi, in this report, does a user need to have read privileges to view the data? Not to open the document itself, but just to view a specific item within the report. A couple of days ago, this worked without issue(without read rights), but now, without any changes, it no longer does — a user only see rows in the report for elements that have some assigned rights (such as read).

MVP

Hi Jaroslav

I did some tests with the AI Prompt business rule.
Turns out to do quite a nice job. Uploaded two documents and used ""Check the similarity between these documents and rate it between 0 and 100.
Only return the similarity as an integer value" as instruction. The highest rate was 95 with two identical documents.
Maybe this is good enough to try?

The application was initially developed in the dev-environment and later exported to the prod-environment. However, changes have since been made directly in the prod-environment that are not reflected in development—and unfortunately, these changes were not documented.

Now the question is: Is it safe to overwrite the development version with the production version, considering potential issues such as differing IDs, configurations, or other environment-specific data?

If it's not safe, what would be your suggestions for how to approach it otherwise?

MVP

Hi Jarosław,
I think there won't be a fit-all solution here, this would have to be developed per use-case.

Is the PDF 1 page, 10 pages, 100 pages, 1k pages?
Those pages are text, graphics, screenshots, scans, if there are images, how would you decide if those are reasonable?

You might wanna check the tools below, but it's far from a put in action and forget :)
* https://techcommunity.microsoft.com/blog/azure-ai-services-blog/extract-data-from-pdfs-using-form-recognizer-with-code-or-without/2214299 -
* https://github.com/invoice-x/invoice2data - it's not only for invoices, my attempt would be to parse pdf with this tool, and then check if output structure matches your template structure.

Those below would require coding a solution and expose it via API, so it's more advanced:
* https://github.com/Layout-Parser/layout-parser
* https://docs.opencv.org/4.x/d4/dc6/tutorial_py_template_matching.html

Business case: due to organization regulation it is required to fill in a specific form and attach it as PDF to a WEBCON case. The problem is how to assure that such PDF file matches prefedined format and that is is filled with reasonable contect
Expectation: dedicated action that will take two attachments: template in PDF or WORD and actual document in PDF or WORD and will calculate similarity score from 0 - documents differ completely to 1.00 - documents match perfectly. Alternatively TRUE (document matches template and has reasonable content) or FALSE (document doesn't match)
I look for WEBCON integrated solution
Any ideas?

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.