#leagueCSV

5 months ago

You load a CSV written in french iso-8895-15 and using the ";" as delimiter You first load the CSV document. Then using the stream feature you convert on the fly the document into UTF-8 using mb_string extension. You convert and store the CSV document as a NDJson file using a list with a header. Last but not least you convert the strings into integer where it makes sense using the JsonConverter formatter capabilities.

Coming in the next minor version of #LeagueCSV the JsonConverter #ndjson support is improved you can now do the following #php #csv #oss

0 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

The Buffer class loads the first 1000 rows of the CSV Reader object. Delete records where the rating is equal to 0. Update records without tags and a the book and the sci-fi tags And insert a new record that was not present Finally, the buffer is stored in a new CSV document with the update made to it.

League/csv 9.22.0 is out with a new class the Buffer which enable buffering and performing CRUD operation on your data. Please read the documentation csv.thephpleague.com/9.0/writer/b... and the release notes for more github.com/thephpleague... #php #csv #leagueCSV

0 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

$The picture illustrate how you can user League\CSV package to directly interact with popular RDBMS system in PHP to turn any query result into a object processable by the package.$

The picture illustrate how you can user League\CSV package to directly interact with popular RDBMS system in PHP to turn any query result into a object processable by the package.

OK this still need some ironing but... in #LeagueCSV 9.22.0 a new interface is added `TabularData` which enables the following magic 😍 #PHP #interoperability #extension #tabulardata for more information and limitations check the documentation csv.thephpleague.com/9.0/reader/r...

2 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

Would anyone be interested in a talk around #LeagueCSV I promise it won't be boring. I have never done a talk on it so if you have a #PHP group not too far away from Brussels I'll be more than happy to present to your group the package and some hidden gems inside it!!

0 1 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

$The new stream filter API using the League\Csv\Writer object. You can register any callback and attach it to the object in a read or write mode depending on the situation$

The new stream filter API using the League\Csv\Writer object. You can register any callback and attach it to the object in a read or write mode depending on the situation

The API can be use with native PHP stream resource too register, append or remove the stream filter

#LeagueCSV 9.21.0 is out with a full rewrite of the exposed #PHP stream filter API to improve its usage. github.com/thephpleague...

0 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

Enabling parsing a file using the carriage return character as end of line character using PHP stream filter via the new CallbackStreamFilter class in League/CSV in the upcoming release 9.21.0

One of the most underrated, under-used, unknown feature of #PHP is the powerful PHP stream filter API with the weirdest class of them all

www.php.net/php_user_fil...

I use them heavily in #LeagueCSV 😈 and they are getting a clean fresh API in the next minor version to improve their usages

1 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

Release version 9.20.0 · thephpleague/csv Added XMLConverter::formatter HTMLConverter::formatter Writer::encloseNone Writer::encloseNecessary Writer::noEnclosure Deprecated None Fixed JsonConverter::formatter now accepts callable befo...

OK I might have forgotten to say it but #leagueCSV 9.20 is out with full control in the Writer for the presence of enclosure in your generated CSV. github.com/thephpleague... #csv #php #enclodure

3 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

query a CSV document using league/csv query builder

Did you know you could do the following with #leagueCSV ? The result is a Iterator containing the records which match the query. #php #csv #query-builder

15 3 0 3

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago

A script that shows how to generate a CSV document without enclosure character using League/csv

Coming in the next minor version of #LeagueCSV generating #CSV without enclosure. Like Uncle Ben used to say ... with great power comes great responsability. This should be used wisely with a lot of precaution. #php

1 0 0 0

Ignace Nyamagana Butera

@nyamsprod.com

1 year ago