NTAK(T) filler tool for Pálköve's camp

This tool is used to fill the NTAK site from Csaba with data from Pálköve's camp. For installation, see the section Installation. For usage and possible caveats, see the section Usage.

Installation

Make sure you have node.js and pnpm installed on your system.

1. Clone the repository:

   git clone

2. Navigate to the cloned directory:

    cd ntakt

3. Install pnpm, if it's not installed yet:

   npm install -g pnpm

4. Install the required dependencies:

   pnpm install

5. Copy the example configuration:

   cp .env.example .env.local

   Then set TARGET_URL and SHEET_PATH in .env.local. SHEET_PATH may be relative to the directory where you run the command (for example, ./workbook.xlsx) or an absolute path. This local file is ignored by Git and must not be committed.

6. Validate the workbook without opening the browser:

   pnpm check:data

7. Run the filler:

   pnpm start

Usage

The tool will read the Excel file specified in .env.local, extract the necessary data, and fill the NTAK site with it. The script takes a few minutes to run (about 10), in this timespan, please do not interact with the device (i.e. don't hide the browser window, don't switch to another tab, etc.).

Requirements

The tool automatically finds the worksheet containing the required columns. It accepts either the original English headers:

• name
• participant_birthday in Excel's date format
• gender: 1 if male, 0 if female
• participant_zip
• participant_birth_place
• id_card_number

or the Hungarian CampRegistration export headers:

• Diák neve
• Születésnap
• Diák neme (Fiú or Lány)
• Irányítószám
• Születési hely
• Okmány száma

Caveats, limitations

• The tool currently does not fill nationality, as it would be an overkill, and is defaulted to Hungarian. If you need to fill it, you can do so manually on the NTAK site.
• The site is slow as heck, so it might be required to manually check the filled data.
• In some cases, the gender gets misfilled
• The tool doesn't handle room numbers, as in our experience, the camp's owner doesn't care about it too much either.