Git Product home page Git Product logo

csv-importer's Introduction

Platform to import clients and find their geolocation

The main objective of this repository is to create a system where it is possible to register customers using a CSV file, and have their data updated with the google API, validating their address and searching for their Latitude and Longitude.

Installation

Para executar o sistema em modo de desenvolvimento:

  1. Copy the .env.example file to .env
  2. Edit the .env file to reflect your System Database configuration, Pusher Config and Gmaps Key
  3. Install composer dependencies: composer install
  4. Run the platform:
    1. Docker Mode
      1. Run docker-compose build
      2. Run docker-compose up
      3. Open your browser in http://localhost:8080
    2. Laravel Dev Mode
      1. Run php artisan Migrate
      2. Run php artisan serve
      3. Run php artisan queue:work
      4. Open your browser in http://localhost:8000

Features

  • Import CSV
  • GMaps Integration (GeoCoding)
  • Bootstrap Layout
  • Docker + Docker Compose
  • Tables with Relationship
  • GeoCoding Asynchronous processing(Queues)
  • Update Events with WebSocket
  • Upload with Axios
  • Export of clients compatible with import
  • Import Clients from Command Line: php artisan create:clients './FilePath'
  • Remove individual clients
  • 100% tests coverage

CSV structure:

nome email datanasc cpf endereco cep
Cliente 1 [email protected] 05/10/1993 123.456.789-01 "Av Paulista, 123 - Pinheiros – São Paulo" 01311-000
Cliente 2 [email protected] 05/10/1992 123.456.789-01 "Avenida Dr. Gastão Vidigal, 1132 Sala 123 - Vila Leopoldina – São Paulo" 05314-010

Example (included in root folder):

nome,email,datanasc,cpf,endereco,cep
Cliente 1,[email protected],05/10/1993,123.456.789-01,"Av Paulista, 123 - Pinheiros – São Paulo",01311-000
Cliente 2,[email protected],05/10/1992,123.456.789-09,"Avenida Dr. Gastão Vidigal, 1132 Sala 123 - Vila Leopoldina – São Paulo",05314-010
Cliente 3,[email protected],05/10/1991,123.456.789-17,"Rua Caçapava, 123 – Novo Riacho – Contagem",32285-030
Cliente 4,[email protected],05/10/1990,123.456.789-25,"Rua Rio Sacramento, 421 Bloco A, Apt 402 – Contagem",32280-470
Cliente 5,[email protected],05/10/1989,123.456.789-33,"R. Tubira, 88 - Novo Eldorado, Contagem",32340-460
Cliente 6,[email protected],05/10/1988,123.456.789-41,"Av. João César de Oliveira, 2859 - Eldorado, Contagem",32310-000
Cliente 7,[email protected],05/10/1987,123.456.789-49,"Av. Pres. Antônio Carlos, 3860 - Pampulha, Belo Horizonte",31270-000
Cliente 8,[email protected],05/10/1986,123.456.789-57,"Av. do Contorno, 9530 - Barro Preto, Belo Horizonte",30110-934
Cliente 9,[email protected],05/10/1985,123.456.789-65,"Av. Presidente Carlos Luz, 3001 - Pampulha, Belo Horizonte",31250-010

csv-importer's People

Contributors

herickc avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.