XB_IMPORT(1)

📦 version 4.2.6, in fedora 44

💖 XB_IMPORT(1) — bestie's guide to yeeting delimited data into a DBF 💖

okay so this is xb_import, and it lives in the General Commands Manual (section 1, the section for the actual runnable commands, iykyk). it's a little program whose whole entire personality is: take a delimited text file, dump those records into a version 3 or 4 DBF data file. that's it. that's the girl. 🎀

✨ NAME ✨

xb_import — a program to import records in delimited format to a version 3 or 4 DBF data file.

🌸 SYNOPSIS 🌸

xb_import -t MyFile.DBF -i InputFile.txt -d |

xb_import -h

xb_import -v

🦋 DESCRIPTION 🦋

so like. xb_import imports data records from a delimited input file into an existing .DBF file. existing!! it does not make you a new one, it fills up the one you already have. 💅

the first record in the input file is required to be a list of field names, and they have to be in the same order as the data in the delimited input data file. no cap. also those field names need to correspond to field names in the DBF table, otherwise they're just not getting imported, periodt.

here's the slay part: the fields in the input data file do not need to be in the same order as they are in the table. the field names just have to match. order? flexible. names? non-negotiable. 💖

  • fields that exist in the DBF table but are not in your input data → left blank. enjoy the void, babes. 🕳️
  • fields that are in your input data but don't exist in the DBF table → ignored. not invited to the party. 🙈

🌈 OVERVIEW 🌈

the Xbase64 library is the whole ecosystem here — it provides various utility programs and a set of C++ classes for application programming, for reading, writing and updating DBF database files, NDX and MDX index files and DBT memo files. it's giving infrastructure. it's giving main character library. 👑

version 4.x.x has been tested for compatability with dBASE III (TM), dBASE IV (TM) and dBASE 5 (TM) version data files and indices:

  • *.DBF — data
  • *.NDX — single tag index
  • *.MDX — multi tag index
  • *.DBT — memo

and in RDBMS parlance, each *.DBF file would be a table. okay?? now you get it. 🧚

💅 OPTIONS 💅

  • -h, -?, --help — display help information. she's helpful, she's polite.
  • -v, --version — display version information. tell me who you are bestie.
  • -t MyFile.DBF — DBF file to import data to. this is the destination, the target, the final girl.
  • -i InputFile.csv — input file of delimited text where the first line is a list of field names corresponding to fields in the DBF file to import. first line = the roster. 📋
  • -d | — optional delimeter. the default delimiter is a comma ",".
  • -q, --quiet — quiet mode. she said 🤫
ngl the synopsis spells it Otional and we love her for it, but yes, it's optional — if you don't pass it, you get the comma ",".

🎀 FILES 🎀

  • *.DBF

👑 AUTHORS 👑

Gary Kunkel <xdb-devel@lists.sourceforge.net>

🔥 SEE ALSO 🔥

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_pack(1), xb_reindex(1), xb_tblinfo(1), xb_undelall(1)

the whole friend group fr fr 💜

😭 REPORTING BUGS 😭

<xdb-devel@lists.sourceforge.net>

and that's the page!! this cutie is brought to you by <strong>GNU</strong>, dated <strong>2023-11-18</strong>, and she answers to <strong>XB_IMPORT(1)</strong>. go import something, bestie 🫶✨

📦 where this page comes from