CSV2YAPET(1)

📦 version 2.6, in debian bookworm, debian trixie, epel 9, fedora 43, fedora 44, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ CSV2YAPET(1) ✨

okay bestie, gather round, because csv2yapet is about to turn your boring lil CSV into a whole encrypted YAPET file and honestly?? iconic. 💖

🌸 NAME 🌸

csv2yapet — convert a CSV file to a YAPET file. that's it, that's the girl. 🎀

🦋 SYNOPSIS 🦋

csv2yapet [[-c] | [-h] | [-V]] | [[-p password] [-q] [-s separator]] src
dst

💅 DESCRIPTION 💅

So the whole vibe is: you hand over a CSV file src, and csv2yapet hands you back a YAPET file dst. glow-up complete. ✨

The default character for delimiting the fields is , (comma), unless you say otherwise on the command line by passing -s. speak now or forever hold your commas. 😌

Fields that contain the field separator character have to be wrapped in double quotes ("). it's giving "please contain yourself". 🙈

And to convert an actual double quote character, you have to precede it with another double quote character. double the quote, double the drama. 💀

Here's the tea on what csv2yapet expects each field of the source CSV file to be — literally, column by column, no cap:

Table 1. Source File Format

  • Column # 1 → YAPET Record Field: Record Name → Maximum size in bytes: 127
  • Column # 2 → YAPET Record Field: Host Name → Maximum size in bytes: 255
  • Column # 3 → YAPET Record Field: User Name → Maximum size in bytes: 255
  • Column # 4 → YAPET Record Field: Password → Maximum size in bytes: 255
  • Column # 5 → YAPET Record Field: Comment → Maximum size in bytes: 511

so five columns, in that order, periodt. 👑

🔥 OPTIONS 🔥

The following options are supported — and yes, we're doing all of them, because nobody gets left behind in this group chat:

  • -c — Show copyright. gotta credit the queen. 👑
  • -h — Show help. when in doubt, ask for help, that's literally what it's for bestie. 🫶
  • -V — Show version. version check, vibe check. ✅
  • -p password — The password to be used to encrypt the YAPET file. If csv2yapet is invoked without this option, it will prompt for the password on the standard input. no password on the command line? she'll just ask you, gently. 💜
  • -q — Enable the quiet mode. No details about errors are reported. she's not gonna tell you what went wrong. silence. 🤫
  • -s separator — Change the default field separator , (comma) to the single character separator. one character only, don't get greedy. 🌈
  • src — The source CSV file to be converted. the before picture. 📸
  • dst — The resulting YAPET file holding the content of src encrypted. This file must not exist prior to the conversion process, else csv2yapet will not start the conversion and abort.
⚠️ okay this one matters: dst has to NOT already exist. if it does, csv2yapet will not start the conversion and will just abort. no merge, no overwrite, no second chances. she's a one-file-only kind of girl. 💀

🎀 EXAMPLES 🎀

AN EXAMPLE OF A CSV FILE ACCEPTED BY CSV2YAPET. 🍓

The following example shows an excerpt of a CSV file as accepted for conversion by csv2yapet.

As the second line shows, fields can be blank but the separator may not be omitted. blank is fine, skipping the comma is NOT. 😤

ssh host,host.example.org,johndoe,secret,Linux machine
mail account,imap.email.org,john_doe,secret,

An example of a CSV file accepted by csv2yapet using double quotes. ✨

The following example shows an excerpt of a CSV file as accepted for conversion by csv2yapet.

The first line demonstrates how to double quote fields containing the separator character. The second line shows how to literally convert double quote characters. she said "quote me, but correctly." 💅

"ssh, ftp, and http server",server.example.org,johndoe,secret,Linux machine
mail account,imap.email.org,john_doe,secret,"John ""the Unknown"" Doe"

⭐ EXIT STATUS ⭐

  • 0 — No error. we ate and left no crumbs. 🔥
  • 1 — Error while parsing command line argument. the args said no. 😭
  • 2 — The passwords provided on the standard input do not match. bestie. they have to MATCH. 🫠
  • 3 — The destination file dst already exists. told you. 🙈
  • 4 — An unexpected error occurred. the plot twist nobody asked for. 💀

💀 BUGS 💀

Please report bugs to https://github.com/RafaelOstertag/yapet/issues. found a glitch? tell on it, respectfully. 📣

🫶 AUTHORS 🫶

Rafael Ostertag rafi@guengel.ch. the main character who made all of this happen. 👑

🌈 SEE ALSO 🌈

iykyk — the round trip is real, go convert both ways. 🔁

okay that's the whole page, you're officially a csv2yapet girlie now. this was YAPET 2.6, dated 2022-03-12 — thanks for coming to my TED talk, ily, bye 💖🦋🎀

📦 where this page comes from