# |
Jul 15th 2019, 18:17 |
ricksaccous |
manually set the type to "checkbox" |
# |
Jul 15th 2019, 18:17 |
ricksaccous |
but when i try to create a widget |
# |
Jul 15th 2019, 18:17 |
ricksaccous |
it's working fine when i attach the 'templates' to an input |
# |
Jul 15th 2019, 18:16 |
ricksaccous |
yeah, been messing around with those |
# |
Jul 15th 2019, 18:16 |
genellern |
Have you tried changing the templates? |
# |
Jul 15th 2019, 18:15 |
ricksaccous |
i'm building a widget and i can't figure out how to force the widget to use label of type nestingLabel |
# |
Jul 15th 2019, 18:15 |
ricksaccous |
for the life of me |
# |
Jul 15th 2019, 18:07 |
bird87_za |
Does anyone know of an API I can use to authenticate a user on his xbox profile and pull that data into my app? |
# |
Jul 15th 2019, 17:14 |
devito |
thank |
# |
Jul 15th 2019, 17:14 |
devito |
@kaliel yeah its mod rewrite |
# |
Jul 15th 2019, 16:50 |
hippo |
@rrd564 I think the easiest solution is to specify the columns you would like to export via the `$_extract` view variable. |
# |
Jul 15th 2019, 16:21 |
rrd564 |
I have to call toArray on a resultset. Is there any way to define the order of the array keys? I export to CSV using FirendsOfCake csvView plugin, but the order of the columns are mixed |
# |
Jul 15th 2019, 16:02 |
kaliel |
@devito nothing on logs ? mod_rewrite enable ? |
# |
Jul 15th 2019, 16:01 |
devito |
what would cause me to get a missing home controller error on a fresh stand up of cake3? default / route points to pages home and the route is named to /home |
# |
Jul 15th 2019, 15:57 |
ndm |
There's also `assertResponseEquals()` if you want to compare the whole content. |
# |
Jul 15th 2019, 15:55 |
neon1024 |
As it’s json, I’d rather do some more intrusive asserts :slightly_smiling_face: |
# |
Jul 15th 2019, 15:55 |
neon1024 |
I’d only found `$this->assertResponseContains()` |
# |
Jul 15th 2019, 15:55 |
neon1024 |
Ahh, thanks! |
# |
Jul 15th 2019, 15:55 |
ndm |
`$this->_response` |
# |
Jul 15th 2019, 15:50 |
neon1024 |
Using the IntegrationTestTrait, how do I get the response? |
# |
Jul 15th 2019, 15:24 |
kaliel |
your welcome :slightly_smiling_face: |
# |
Jul 15th 2019, 15:24 |
lubos |
I'll pick this in the morning with fresh head :slightly_smiling_face: thanks @kaliel for your input! :slightly_smiling_face: |
# |
Jul 15th 2019, 15:23 |
lubos |
@kaliel the memory issues are before creating any CSV (when trying to debug `orders` results - just count output) |
# |
Jul 15th 2019, 15:23 |
kaliel |
@lubos do you use a plugin or something to output csv ? I had memory issues too with some of them. Or do the allowed memory error is triggered before csv construction ? |
# |
Jul 15th 2019, 15:22 |
lubos |
to be even more specific, we have `orders` and `leads` data and client is requiring output of both combined in CSV file so they can process data on their side |
# |
Jul 15th 2019, 15:21 |
lubos |
@kaliel as you say, only the new collection is not third table but CSV output |
# |
Jul 15th 2019, 15:20 |
kaliel |
@lubos To be clear, you have to query 2 tables, merge the results, do some process, then save this new collection (to a third table) ? |
# |
Jul 15th 2019, 15:19 |
lubos |
I'll see, but for now it seems I stick with increasing memory limit, hopefully `512M` is just fine :slightly_smiling_face: |
# |
Jul 15th 2019, 15:18 |
lubos |
and sql union could be answer too, but who does like it? :slightly_smiling_face: |
# |
Jul 15th 2019, 15:17 |
lubos |
but still, i need to combine two collections (each has different table) that's why I picked post-processing at the first place |
# |
Jul 15th 2019, 15:17 |
lubos |
rather than do post-processing with collections |
# |
Jul 15th 2019, 15:16 |
lubos |
so using endless group and sql with `limit (number, from)` is the way to go I guess :slightly_smiling_face: |
# |
Jul 15th 2019, 15:15 |
lubos |
@kaliel but then 101 - 200 created date could be wrongly sorted with first 100 results, but I need to loop sql queries with short period at this case I think :slightly_smiling_face: |
# |
Jul 15th 2019, 15:14 |
kaliel |
@lubos you can sortBy('created') the first 100 results, then query for the 101th to 200th, etc... |
# |
Jul 15th 2019, 15:14 |
lubos |
is using `512MB` too much? :slightly_smiling_face: |
# |
Jul 15th 2019, 15:13 |
lubos |
but so much easier to increase memory limit |
# |
Jul 15th 2019, 15:13 |
lubos |
thanks both, i will do |
# |
Jul 15th 2019, 15:13 |
lubos |
but I guess I can make sets limited by short period, e.g. day or so |
# |
Jul 15th 2019, 15:12 |
lubos |
and output is one CSV file which would be OK I can append to the CSV, but neeed sort them first |
# |
Jul 15th 2019, 15:12 |
lubos |
well I can chunk them, but i need `sortBy('created')` for all items, then chunk does not work well |
# |
Jul 15th 2019, 15:11 |
ricksaccous |
like @kaliel is suggesting |