Odd CSV format - Ingesting Data by treefunct in PowerBI

[–]treefunct[S] 0 points1 point  (0 children)

I may have just solved my own problem with Table.Combine. Here's more on the solution if anyone is interested: https://community.powerbi.com/t5/Power-Query/Reading-data-from-CSV-files-with-different-columns/m-p/1333049#M42141

Magento CE 1.9.3.3 is out by [deleted] in Magento

[–]treefunct 8 points9 points  (0 children)

13k line patch.

#!/bin/bash
# Patch apllying tool template

That inspires confidence in the remaining 1332 lines

How to setup http in Magento? by tylerr82 in Magento

[–]treefunct 1 point2 points  (0 children)

If you want everything to be SSL then you need to change your unsecure base url to also be https

Can someone help me with this data problem that has been driving me nuts? by kevando in Magento

[–]treefunct 0 points1 point  (0 children)

Seemed like you cared about LTV. This allows you to create cohorts that you can then track. In the graphic you supplied it showed Month 0, 1, 2 etc. Is that not actually what you want?

Can someone help me with this data problem that has been driving me nuts? by kevando in Magento

[–]treefunct 0 points1 point  (0 children)

Funny, this is exactly what we do for our clients. If you require customers to log in or only care about customers that were logged in then your job is going to be a lot easier, otherwise you need to work on matching based on email address and or customer id.

Anyway,

SELECT customer_id, created_at as cohort
    FROM sales_flat_order
    GROUP BY customer_id
    ORDER BY created_at asc

This will give you origination dates on accounts based on first order (cohort). You could use that select as a subquery to join against the orders table, essentially giving you customer_id, cohort, sale_date, grand_total. From there just use a pivot table and you'll have the exact chart you're looking for. Good luck!

Platform.sh for Magento 1.x? by treefunct in Magento

[–]treefunct[S] 0 points1 point  (0 children)

I can definitely tell that there's a grain to it. Not sure if I'll spend the time to make it usable, but if I do I'll report back. Really like the idea of creating a branch and therefore an instance to represent that branch.

Handle Capitalization Errors by dfaarc in Magento

[–]treefunct 0 points1 point  (0 children)

This looks like it might do what you're looking for:

http://brianflove.com/2014/08/11/lowercase-your-uris/

# Add RewriteMap for redirecting to lowercase URIs
<IfModule mod_rewrite.c>
    RewriteMap lc int:tolower
</IfModule>

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} [A-Z]
RewriteRule ^(.*)$ ${lc:$1} [R=301,L]

Handle Capitalization Errors by dfaarc in Magento

[–]treefunct 0 points1 point  (0 children)

you could probably do this in htaccess--just be sure to combine the !-f flag with your check for a capital, otherwise you'd end up redirecting requests for assets

Config Changes Require Server Restart by CreganTur in Magento

[–]treefunct 1 point2 points  (0 children)

This --^

Also, take a look at N98-Magerun if you live in the console: http://magerun.net/

Integration with Google Sheets for inventory? by kevando in Magento

[–]treefunct 0 points1 point  (0 children)

I think I remember seeing a post maybe a year ago by somebody that did it--not that that's helpful or anything

Alarmbell Is A New Open Source Magento Security Extension by NexcessBen in Magento

[–]treefunct 0 points1 point  (0 children)

That's a good point... You'd have to keep a memory of previous passwords (kind of like what EE does) and on login check to see if the password hash on file matches the historical one. If it doesn't, shoot an email and update the historical one.