rt-assets-import-csv(1)

📦
version 2.3 · 2 versions
, in debian bookworm

💖 rt-assets-import-csv(1) 💖

okay bestie, so this is the manual for rt-assets-import, living in the Request Tracker Reference section of the manual pages. it's giving "one script, big job," and honestly? it ate. 🦋

✨ NAME ✨

rt-assets-import — import assets to rt 💅

🌸 SYNOPSIS 🌸

rt-assets-import /path/to/assets.csv
rt-assets-import --update /path/to/assets.csv

🎀 DESCRIPTION 🎀

okay so this script imports and updates assets from a CSV into rt. literally that's the whole vibe. ✨

for all the configuration deets, go peek at RT::Extension::Assets::Import::CSV — that's where the settings live, iykyk.

👑 OPTIONS 👑

  • --config file , -c file — hands you an explicit extra config file that gets loaded before any other configuration files. super useful when you're doing per-import AssetsImportUniqueCF and AssetsImportFieldMapping settings, like when you're importing from multiple sources and their columns do NOT match. 🌈
⚠️ bestie, listen: if you use this option, RT_SiteConfig.pm should not contain a setting for AssetsImportFieldMapping. if it does, the two hashes get merged and you get unexpected behavior. not the slay we're going for. 💀
  • --update — without this, existing assets (figured out by matching AssetsImportUniqueCF values) are left completely untouched, like, don't perceive them. 🙈 with this option, records get updated based on their values in the CSV. glow-up mode activated. ✨
  • --insert — by default, assets that don't have AssetsImportUniqueCF values will just throw a warning at you. with this flag, they get inserted instead (generating their own id as needed) after all the other operations. main character energy, they get their own id and everything. 👑
  • --mdy, --dmy — forces RT to parse dates as mm/dd/yy or dd/mm/yy respectively. and if you don't use either one? RT just defaults to the DateDayBeforeMonth setting, which itself defaults to dd/mm/yy. so like, day-before-month is the factory setting, periodt. 🎀
  • --debug — gives you verbose output on STDERR while the import is happening. very "tell me everything," very demure, very mindful. 🫶
💜 reminder: every one of these flags is doing something real, so don't just vibe-check your way through a production import. read them fr fr.

perl v5.34.0 🦋 2022-06-24 🎀 — that's the version and the date this page was last living its truth, bestie. go import something iconic. 💖✨

📦 where this page comes from