{"repo":"jwhulette/pipes","free":true,"listed":false,"github":"https://github.com/jwhulette/pipes","clone":"git clone https://github.com/jwhulette/pipes.git","description":"A PHP ETL solution for use with Laravel or Laravel-Zero","language":"PHP","stars":22,"topics":["php","etl","laravel","pipeline"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Pipes Pipes is a PHP Extract Transform Load [ETL] package for Laravel 11+ Installation Usage 1. Create a new EtlPipe object. 1. Add an extractor to the object to read the input file - You can create your own extractor by implementing the ExtractorInterface.php 1. Add transformers to transform the data - You can add as many transformers as you want. - You can create your own transformers by implementing the TransformerInterface.php - Data is passed to the transformers in the order they are defined 1. Add a loader to write out the transformed data. - You can create your own loader by implementing the LoaderInterface.php Notes: Built-in extractors: CsvExtractor XlsxExtractor SqlExtractor Built-in loaders: CsvLoader SqlLoader Built-in transformers: CaseTransformer - Change the case of a string DateTimeTransformer - Change the format of a date string PhoneTransformer - Transform a US phone, removing all non numeric characters, and limiting the length to the first 10 digits TrimTransformer - Trim a string ZipcodeTransformer - Transform a US zip code, removing all non numeric characters, and left pad zeros for zip codes less than 5 digits ConditionalTransformer - Transform a column, based on the values of another column Data is passed to the transformers in the order they are defined Changelog Please see CHANGELOG for more information on what has changed recently. Contributing Please see CONTRIBUTING for details. Security Vulnerabilities Please review our security policy on how to r","default_branch":null,"files":null,"tree":[],"storefront":"/r/jwhulette","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jwhulette/pipes/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}