GUIDES

Guides

Practical answers, written from tests we ran ourselves. Each one says where Kionel fits and where it does not.

• Moving data off a standalone instrument PC without a USB stick
  Options for getting result files off an offline laboratory workstation — approved USB, data diode, scanning kiosk, printing and optical transfer — and what an auditor asks about each.
• Open-source QR file transfer tools compared with Kionel
  Free screen-to-camera file transfer tools exist, and some are faster than Kionel. What they do, what a regulated lab still needs around the transfer, and when to use which.
• Getting logs, recipes and reports out of an isolated plant network
  How to move small files off an air-gapped OT workstation or HMI host without USB sticks, with integrity checks and a signed record of every transfer — and where optical transfer does not fit.
• IEC 62443 and moving files across the air gap
  Which IEC 62443-3-3 system requirements a file transfer into or out of an isolated OT zone touches — portable media, integrity, audit, confidentiality — and what evidence answers them.
• Moving a file from an offline PC to a phone without USB or network
  How to get a small file off a computer that has no network, no USB access and no camera onto a phone or tablet — the realistic options and what each one leaves behind.
• Data diode, controlled USB or optical transfer for an isolated lab PC
  A practical comparison of three ways to move files off an isolated laboratory workstation: cost, installation, what the auditor sees, and which fits occasional small files.
• 21 CFR Part 11 and moving files between laboratory systems
  What Part 11 and EU Annex 11 expect when an electronic record moves between systems, where manual USB transfers fall short, and what a signed transfer record can and cannot cover.
• ALCOA+ when a result file moves off the instrument PC
  Applying the ALCOA+ data integrity principles to the moment a result file leaves an instrument workstation: which principles the transfer itself can break and how to keep them.
• Check a file's SHA-256 on Windows, Mac, Linux or a phone
  Get a file's SHA-256 in your browser without uploading it, or with one built-in command on Windows, macOS and Linux — and the five reasons two hashes of the same file differ.
• How much data fits in a QR code, and how many codes a file needs
  Exact QR code capacities by version, how many codes a 10 KB to 5 MB file needs, why screens use the lowest error correction, and what really limits screen-to-camera speed.
• Why a CSV changes when Excel opens it, and how to keep the raw result
  Excel drops leading zeros, cuts long IDs to 15 digits, turns gene names and well positions into dates and rewrites the file on save. What changes, how to switch it off, and how to prove the original is untouched.
• Getting results from an offline instrument PC into a LIMS
  Five ways to get a result file from an isolated instrument PC into a LIMS or data system: re-typing, a watched network folder, USB, middleware, and an optical route into a watched folder. What each costs and what the auditor sees.
• Why a screen recording of QR codes will not scan, and how to fix it
  Messaging apps shrink the video, 4K and 60 fps are often HEVC, codes change faster than the camera, the browser tab is in the background. Five causes with measured examples, and what to do about each.
• Our host changed our downloads: how a SHA-256 check caught it
  Cloudflare's free plan added its analytics script to every HTML response, including a downloadable app file, so its SHA-256 stopped matching. Why curl did not show it, how to detect it, and the one header that stops it.
• Send a file from a PC to a phone without internet, a cable or Bluetooth
  Move a file from a computer to a phone using only the screen and the phone's camera: no internet on the PC, no cable, no Bluetooth, no account. Step by step, with real timings and honest limits.
• An audit trail for file transfers between lab systems
  What an inspector expects to see when a file moves between laboratory systems, why USB transfers usually fail that test, and the practical options for producing a record.
• Second-person review on an offline workstation
  How to record who produced, reviewed and released a result when the workstation has no network, and what makes such a record hold up.

Türkçe rehberler

• Excel CSV dosyasını neden değiştirir? Sıfırlar, tarihler ve Türkçe ayarlar
  Excel baştaki sıfırları siler, uzun kimlikleri 15 haneye keser, 1.12 gibi değerleri tarihe çevirir ve kaydedince dosyayı yeniden yazar. Türkçe Excel'e özgü sorunlar ve ham sonucu koruma yolu.
• Ekran kaydındaki QR kodlar neden okunmaz, nasıl düzeltilir
  Mesajlaşma uygulaması videoyu küçültür, 4K ve 60 fps çoğu zaman HEVC'dir, kodlar kameradan hızlı değişir, sekme arka planda kalır. Ölçülmüş örneklerle beş neden ve her birinin çözümü.
• İnternetsiz, kablosuz ve Bluetooth'suz bilgisayardan telefona dosya aktarma
  Bir dosyayı yalnızca ekran ve telefon kamerasıyla bilgisayardan telefona aktarın: bilgisayarda internet, kablo, Bluetooth ve hesap gerekmez. Adım adım, gerçek sürelerle ve sınırlarıyla.