Import documents

"Import documents" loads the company's data in two ways, which are the tabs "Documents" and "Template". In "Documents" you upload the files you already have (Word, Excel, PDF, photos): the application classifies them, proposes the records, and you review them next to the original before anything is saved. "Template" loads a CSV or an Excel file with fixed columns and has its own guide ("Bulk import"). It opens at Administration › My Organisation › "Import data" and is used only by company administrators.

1. Uploading the files

In the "Documents" tab, drop the files onto "Drop your files or folders here" or use "Choose files" or "Choose a folder" (with its subfolders). Once files are chosen, "Clear the selection" and "Start the import" appear; nothing is sent until you press the latter.

Accepted formats are Word (.docx, plus .doc, .dot, .odt and .rtf, which are converted before being read), Excel (.xlsx and .xlsm, plus .xls and .ods, which are converted), PDF, images (JPG, PNG, WebP, HEIC), text (.txt, .csv, .md) and ZIP. Each file can be up to 100 MB and an import accepts up to 500 files; the contents of a ZIP count file by file (up to 200 per ZIP and 500 MB uncompressed). The conversion is done by LibreOffice on the server: if it is not installed, that file fails and the reason asks you to convert it and upload it again. A scanned PDF without text and a photo are read with the AI vision model (up to 60 scanned pages per file); if the model is not available, a local OCR, which is less accurate, is attempted.

Some installations limit what can be uploaded. In that case the screen shows, below the box, "Limits in this environment: N files and M pages per import" (the demo accepts 10 files and 60 pages per import, and each user 5 imports and 200 pages per day). When a limit is exceeded the notice states the maximum; the daily limits are renewed the next day. "Try with the sample folder" creates an import with documents from the fictitious company Muebles Robledal: it does not use AI, does not count towards the limits, and nothing is saved until you approve it.

2. What it does with each file

When you start, "Import N" opens with a progress bar ("N of M files"), its status and the "Files" table (File, Type, Pages, Status). The import goes through "Uploading", "Processing", "Ready for review", "Saving" and "Saved"; it can also end up as "Failed", "Cancelled" or "Undone". While it is processing or waiting for review, "Cancel the import" stops it; if it is ready for review and has not proposed any record, the button is "Discard".

Each file goes through the antivirus (if the server has it enabled), is read, is classified and its data is extracted. Its status is "Queued", "Scanning", "Processing", "Done", "Rejected", "Failed" or "Sent to occupational health". The type is one of 18: risk assessment, preventive planning, employee list, training records, training certificate, PPE deliveries, safety data sheet, equipment datasheet, equipment inventory, medical fitness, medical report, accident report, emergency plan, contractor document, inspection, committee minutes, annual report, or other document.

A file that the AI classifies as health data is not read any further: it stays as "Sent to occupational health", carries the "Health data" mark, no record is proposed from it, and its original is not shown in the review. A rejected file, a file with an error, or a file of type "Other document" shows the reason (the antivirus detected a threat, the ZIP is not valid or exceeds the limits, it does not look like a prevention document...). If no file yields data, the screen says "We did not find any prevention data to import in these files" and gives the reason for each one. When it is known, the "AI cost" is also shown.

3. Reviewing the proposed records

With the import "Ready for review", "Review" appears below the files: one tab per record type (work centres, departments, job positions, people, equipment...) with its number, in the order in which they will be saved, and at the top the summary "Pending · Approved · Rejected · Doubtful". In each tab the doubtful ones come first: those pending with a conflict or with confidence below 85 %.

Each proposal shows three labels: what it would do ("New", "Updates" an existing record, "Already exists" or "Conflict"), "Confidence N %" (green from 85 %, amber from 60 %, red below) and its status ("Pending", "Approved" or "Rejected"). The fields are edited on the card itself and are saved when you leave the field. For "Updates", "Changes to the existing record" lists each field with its previous and its new value.

"View source" opens "Where the data comes from" on the right: the PDF page or the original image, with the text the data came from; for a Word file, the text around it, and for an Excel file, its sheet row highlighted. There is a conflict when two files give different values for a field or when the record could be one of several existing ones: a button appears for each value, with the file and the page it comes from; you have to choose one in order to approve. If the same data appears in several files, it is merged into a single record.

4. Approving and saving

"Approve" accepts a proposal and "Reject" discards it. "Approve the safe ones in every tab (N)" approves at once the pending items with confidence of 85 % or more, without conflict and that are not "Already exists"; the rest are reviewed one by one. While files are being read, "Save the approved records" waits until all of them are done and says so under the button.

"Save the approved records (N)" asks for confirmation and saves in dependency order: work centres, departments, job positions, people and equipment; then contractors, chemical products, assessments and measures; then training, certificates, medical examinations, incidents, PPE, emergency plans, inspections and contractor documents. This way each record finds its work centre, its job position or its assessment. It also archives in Documents the originals of the files that were read (not the health ones). The result, "Import saved", counts what was created, updated, what already existed and the originals archived; if any record fails, "Could not be saved" gives the reason for each one and the rest stays saved.

Medical examinations can be reviewed, approved and saved only by someone with full medical access and medical write permission; for everyone else, the application replies that they cannot review that type of record.

5. History and undo

"Previous imports" lists the company's imports, most recent first: who made it, the date, "N of M files", the AI cost and, if it is saved, the records it created by type. "View" opens the import.

"Undo" (only on "Saved" imports) asks for confirmation and deletes the records the import created, in the reverse order of saving, except those that someone has modified since; the originals stay in Documents. It can only be done during the 30 days after saving: after that period the button is disabled with the notice "More than 30 days have passed since it was saved." If any record cannot be undone, the notice says how many were undone and how many were not. The import changes to "Undone".

6. After saving

The records an import created carry in their record the line "Imported from file, p. N", with the link to the original in Documents and "View the import". It appears in risks, preventive measures, people and job positions.

With the import "Saved", "What is missing" also appears. It is checked against the company's data and not against the imported documents: mandatory training not done, job positions without a validated assessment, required PPE not delivered, overdue preventive measures, chemical products without a valid safety data sheet, and expired training certificates. Each section shows up to 25 items with a link to the screen that fixes it ("and N more" if there are more); if everything is up to date it says "Nothing is missing from what is checked".

The initial setup assistant uses this same engine in its documents step: you upload the files there and the review is done on this screen. For several clients at once, the service-provider console has "Import portfolio" (guide "Import portfolio").