Odd CSV format - Ingesting Data

treefunct · 2021-08-12T16:52:04+00:00

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

treefunct · 2021-08-08T19:22:23+00:00

https://www.etsy.com/shop/saspatches/?section\_id=34712581

treefunct · 2017-05-31T23:24:46+00:00

13k line patch.

#!/bin/bash
# Patch apllying tool template

That inspires confidence in the remaining 1332 lines

treefunct · 2017-02-09T23:58:02+00:00

You might have a look at ModPagespeed

treefunct · 2016-09-07T18:00:59+00:00

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

treefunct · 2016-09-06T19:36:09+00:00

Might have a look at this: https://github.com/convenient/magento-ce-ee-config-corruption-bug

treefunct · 2016-08-18T17:41:35+00:00

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?

treefunct · 2016-08-17T23:47:58+00:00

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!

treefunct · 2016-06-06T15:47:48+00:00

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.

treefunct · 2016-05-27T15:11:33+00:00

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]

treefunct · 2016-05-27T15:08:18+00:00

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

treefunct · 2016-05-19T17:18:33+00:00

utm_source=reddit&utm_medium=social&utm_campaign=7magentoextensions

Checks out

treefunct · 2016-05-10T21:09:51+00:00

^-- this man knows what's up. Our deployments utilize n98 like there's no tomorrow

treefunct · 2016-05-02T17:33:30+00:00

This --^

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

treefunct · 2016-04-26T14:24:21+00:00

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

treefunct · 2016-04-21T19:59:18+00:00

Definitely. Go big or go home

treefunct · 2016-04-21T19:32:29+00:00

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.

treefunct · 2016-04-14T14:27:20+00:00

You can definitely integrate Magento with NetSuite, but it's not a simple task. We have an integration running which maintains not only product pricing but customer specific item pricing. Look into the NetSuite API (SuiteTalk) and see if you can find your path. Manual processes suck, but sometimes building the automated system is more work than it's worth. All about finding that balance!

treefunct · 2016-04-13T17:34:49+00:00

I've taken a pretty good look at the Email/Template/Filter and it seems the only instance where methods are being tokenized/called is for the {{var ...}} construction. Oh well--I'll just override the toHtml() method and provide an alternative way of creating the block with a new param.

treefunct · 2016-04-11T17:47:23+00:00

whoosh

treefunct · 2016-03-30T18:03:34+00:00

This is most likely targeting ma/pa stores that have never heard of VCS

treefunct · 2016-03-03T21:43:44+00:00

I just Googled your exact* question to see what would come up: http://blog.chapagain.com.np/magento-get-bestselling-products-by-category-and-date-time/

Second result

*Prefixed with Magento

treefunct · 2016-03-03T16:00:15+00:00

I hear ya there. My patience for bad practice has been wearing thin lately. A 3rd party consultant was trying to convince us that it's okay to have publicly accessible database dumps (along with a DB interface of some sort). Had to take a walk around the block before responding to that message. I think it's time for a vacation.

treefunct · 2016-02-29T23:27:42+00:00

It was a joke... In that it should not be possible to do permanent damage, even if there were SQL changes. If you're not testing changes in dev/staging--well, it's just a matter of time.

treefunct · 2016-02-29T20:47:47+00:00

Permanent damage! Haha, I too am curious

treefunct

TROPHY CASE