This Node.js script allows you to read, compare, and export differences from multiple CSV files containing data related to visa processing. The script reads data from CSV files organized by date and performs comparisons between consecutive dates to identify changes in the data. It specifically focuses on cases where a visa application has been refused under section 221(g) of the Immigration and Nationality Act. The script outputs the differences in both JSON and CSV formats.
The CSV files used in this project are provided by Xarthisius, and we sincerely appreciate their efforts in collecting and sharing this data.
Before using the script, ensure you have Node.js and npm (Node Package Manager) installed on your system. You can download them from nodejs.org.
- Clone this repository to your local machine.
git clone git@github.com:lawyer-omer/dv-221g-ap-tracker.git- Navigate to the repository folder using the command line.
cd dv-221g-ap-tracker- Install the required dependencies by running:
npm install csv-parser fs-
Place the CSV files you want to compare in the appropriate folders and update the
csvFilesarray in the script with the relevant paths and dates. -
Run the script using the following command:
node compare.js- The script will process the data, compare it across dates, and generate JSON and CSV files containing the identified differences. The exported files will be named
differences.jsonanddifferences.csv.
- Reads and organizes data from multiple CSV files by date.
- Compares data across dates to identify changes in visa processing status.
- Tracks and calculates the duration for cases affected by 221(g) refusals.
- Exports differences in both JSON and CSV formats.
Contributions to this script are welcome! If you find any issues or have suggestions for improvements, feel free to open an issue or submit a pull request.
This script is licensed under the MIT License. You are free to modify and use it according to the terms of the license.