| # |
Sep 13th 2019, 16:30 |
 admad |
Check the webserver aka Apache logs |
| # |
Sep 13th 2019, 16:30 |
alexis752 |
i'm using apache 2.4 + php-fpm 7 |
| # |
Sep 13th 2019, 16:30 |
slackebot |
<alexis752> |
| # |
Sep 13th 2019, 16:30 |
alexis752 |
I'm having a bit of trouble with the apache config, the custom errors of Cakephp doesn't work for me |
| # |
Sep 13th 2019, 16:29 |
alexis752 |
Hi guys |
| # |
Sep 13th 2019, 16:26 |
challgren |
And your not depending on the request to generate everything and deal with potential timeouts |
| # |
Sep 13th 2019, 16:25 |
challgren |
That way theres a bit of parallel processing going on |
| # |
Sep 13th 2019, 16:25 |
challgren |
I use it to generate my pdfs/zips |
| # |
Sep 13th 2019, 16:25 |
louis |
Wow that’s perfect |
| # |
Sep 13th 2019, 16:24 |
challgren |
https://sandbox.dereuromark.de/sandbox/queue-examples/scheduling |
| # |
Sep 13th 2019, 16:24 |
challgren |
Plus you can see whats been cleaned and what failed cleanup |
| # |
Sep 13th 2019, 16:23 |
louis |
I’m going to try this way ! I agree, never thought about it :expressionless: Thank you @challgren |
| # |
Sep 13th 2019, 16:22 |
challgren |
A little bit cleaner IMHO |
| # |
Sep 13th 2019, 16:22 |
challgren |
Yeah same idea except the queue handles it |
| # |
Sep 13th 2019, 16:21 |
louis |
Okay, in previous projects I was writing CakePHP shell planned with a cron task. this is why I’m looking for better solution :slightly_smiling_face: |
| # |
Sep 13th 2019, 16:20 |
challgren |
That way if the user wants to redownload it again, Im not hammering the server with another pdf creation/zip process and can quickly serve them the “cached” package |
| # |
Sep 13th 2019, 16:19 |
challgren |
Using https://github.com/dereuromark/cakephp-queue |
| # |
Sep 13th 2019, 16:19 |
challgren |
But what I do is create my pdfs/zips and then create a queue task to clean it up in an hour |
| # |
Sep 13th 2019, 16:18 |
challgren |
Nah Im just waking up so the mt dew hasnt kicked in yet |
| # |
Sep 13th 2019, 16:18 |
louis |
Should I explain in another way ? |
| # |
Sep 13th 2019, 16:18 |
challgren |
Oh probably do a queue task |
| # |
Sep 13th 2019, 16:18 |
louis |
@challgren Yeap I’m using it ;) . Sorry if my question is not well formulated |
| # |
Sep 13th 2019, 16:17 |
challgren |
@louis https://github.com/FriendsOfCake/CakePdf is awesome! |
| # |
Sep 13th 2019, 16:16 |
louis |
Hello everyone, I’m looking for advices for PDF generation. At the moment i’ve a method that saving multiple Pdf files into TMP directory (named with a uuid) adnd then I create an archive of theses Pdf. The problem is what is a good way to remove this directory after serving file to user using `response->withFile()` |
| # |
Sep 13th 2019, 16:15 |
ruano84 |
Hi guys |
| # |
Sep 13th 2019, 14:35 |
admad |
welcome |
| # |
Sep 13th 2019, 14:33 |
felipe.marinho |
Nice, thank you :pray: |
| # |
Sep 13th 2019, 14:29 |
admad |
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html |
| # |
Sep 13th 2019, 14:29 |
admad |
*storage engine |
| # |
Sep 13th 2019, 14:28 |
admad |
also if possible use 'MEMORY' engine for the temp table |
| # |
Sep 13th 2019, 14:27 |
felipe.marinho |
Awesome... a temp table and an action to match those 2 tables... I'll try this too... Thank you @admad |
| # |
Sep 13th 2019, 14:26 |
admad |
*if your |
| # |
Sep 13th 2019, 14:26 |
admad |
then do whatever processing you need |
| # |
Sep 13th 2019, 14:25 |
admad |
if you table columns don't directly match csv columns then first dump the csv in a temp table with matching columns |
| # |
Sep 13th 2019, 14:24 |
felipe.marinho |
the problem is to match the fields from the CSV and the table columns... |
| # |
Sep 13th 2019, 14:23 |
admad |
you should just upload file and use a shell / command to do the importing in background |
| # |
Sep 13th 2019, 14:23 |
admad |
ideally importing 500,000 lines of csv should be even done in a web request. |
| # |
Sep 13th 2019, 14:22 |
felipe.marinho |
Yes, his approach was to use the input type="hidden"... I'll try to upload the CSV, match the fields, and after use the uploaded CSV. |
| # |
Sep 13th 2019, 14:22 |
admad |
sorry but i am not going to bother reading that :slightly_smiling_face: |
| # |
Sep 13th 2019, 14:21 |
felipe.marinho |
I adapted this tutorial: https://quickadminpanel.com/blog/how-to-import-csv-in-laravel-and-choose-matching-fields/ |
| # |
Sep 13th 2019, 14:20 |
admad |
if not possible then query builder to do multi insert |