Laravel Import File with Artisan Command

Overview

This is a test project to import the data from a file into a mysql database with artisan command.

Task Definition

Using Laravel create an Artisan command called import_file that accepts two arguments - path_to_file and id. The command should parse the attached file PAYARC_DDF that has a fixed width text format and import the data into a mysql database. On each line of the file there is a Record, that has two symbol unique Record Type which starts from position 18, for example: "DT", "P1", "P2", etc. Each individual Record Type has its own fixed width scheme that determines the Start and End of each column. You can find the full scheme specification in the attached file import_file_specs.csv. The id parameter of the command uniquely identifies a file. Any consecutive import of a file with the same id should not result in duplicating the Records that have already been imported.

How To Run

• Clone the repository to your local machine and navigate to the project's root directory in a terminal.
• Copy the .env.example file and name it .env.
• Update the .env file with the appropriate database credentials and settings.
• Run composer install to install all the required dependencies.
• Generate an application key by running php artisan key:generate.
• Run database migrations by running php artisan migrate.
• Run database seeds by running php artisan db:seed.
• Run the Laravel server by running php artisan serve.
• To import a file, run php artisan import_file /path/to/file file_id. Replace /path/to/file with the actual path to the file you want to import and file_id with an integer value that uniquely identifies the file you're importing.
• To check if there are any pending jobs in the queue, run php artisan queue:work. This will start a worker process that will listen for jobs and execute them as they come in.

Note: Make sure you have a running Redis or database queue driver configured to process queued jobs. You can check your queue driver settings in the .env file.

About Laravel

Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as:

• Simple, fast routing engine.
• Powerful dependency injection container.
• Multiple back-ends for session and cache storage.
• Expressive, intuitive database ORM.
• Database agnostic schema migrations.
• Robust background job processing.
• Real-time event broadcasting.

Laravel is accessible, powerful, and provides tools required for large, robust applications.

---

License

This project is released under the MIT License.