Ruby Contact Importer

This application allow users to upload contact files in CSV format and process them in order to generate a unified contact file. The contacts are associated to the user who imported them into the platform. And the application validate some fields of the .csv file. The test .csv file used in tests test.csv

Recomendations

• SQLite3
• Ruby .2.5.8+
• Redis 5.0.7+
• NodeJS 12.22.6+
• Yarn 1.22.5
• Ruby on rails ver. 6.1.4.1+ (running on port 3000)
• Tested in Ubuntu 20.04

Installation and Deploy

Clone the repository:

git clone https://github.com/gbhgit/ruby-app.git

Go inside folder app:

cd app

Installing dependecies:

yarn install

bundle install

Delete the test db, only in case you want to get a blank new db:

rm -rf db/development.sqlite3
rails db:migrate

Run the worker job:

bundle exec sidekiq

Open another console and run the server:

rails s

Case you want to run the test db open the browser for login http://127.0.0.1:3000:

• Login: [email protected] and Password: [email protected]

Considerations

Completed all Mandatory Features

✔️ As a user, I must be able to log into the system using an email and a password.
✔️ As a user, I must be able to register on the platform. For this, it will only be necessary to enter a username and password.
✔️ As a user, I must be able to upload a CSV file for processing. At the time of uploading the file, the user must choose which column belongs to which specific contact information, i.e. the user must match the columns of the file with the information to be processed and then save it into the database. This means that in the CSVs the columns with information will not be standard and may arrive in a different order or with different names than the ones that will be used in the database.
✔️ The following values must be saved in the database: Name, Date of Birth, Phone, Address, Credit Card, Franchise, Email.
✔️ As a system, I must process the content of the CSV file. And some validations must have the elements in the CSV file.
✔️ As a user, I should be able to see a summary of the contacts I have imported. All contacts that I have imported and that were successfully created should be displayed in a list that is paginated.
✔️ As a user, I should be able to see a log of the contacts that could not be imported and the error associated with it.
✔️ As a user, I should be able to see a list of imported files with their respective status. Valid statuses include: On Hold, Processing, Failed, Terminated

Bonus (Optional) Features

✔️ Process the CSV file in a background job. I used the gem 'sidekiq'.

My Personal Bonus Features

• All project was developed using the kanban of github as shown in page https://github.com/gbhgit/ruby-app/projects/1