text:
by kzuu907fm
on Mar 09, 2020 2020-03-22
Do you like music festivals? Obviously. Treefort has an awesome lineup this year. But if you need some persuation, check out some of our most recent Treefort posts:
https://kzuu.org/category/treefort/
And now for our third update of 'Treefort Hype'. Up until now, we've been focusing on the road-warriors artists that festival goers must see. But with 15 days until Treefort Music Fest begins, there are a couple spotlight artists that are going to have some 'must-see' performances. So here are some that should be on your radar curated by KZUU's finest:
Shane's Pick: Lauren Ruth Ward
I've always wanted to experience 'Jam In The Van' in person. And this video is just about as close as I've gotten. 'Make Love To Myself' along with many of Ward's tunes have vocal runs that last much longer that 4 bars. At times, Ward's voice becomes raspy without sounding like she's losing her breath. And her 'Srew you A**hole, I don't need you for s**t' attitude echos when she delivers the lyrics but with a touch of poetic justice. This performance is particularly special because its an acoustic set of the studio version. The band does a great job of complimenting her voice without being overbearing. You'll be able to see her @The Olympic for a 12:20AM showing on Thursday Evening into Friday Morning. She will be a great way to end the second night of the festival.
Jacob's Pick: Magna Carda
Whenever hip-hop artists can marry their sound with live music, the end result is almost always something more interesting and diverse than the sum of its parts. Think Badbadnotgood's performance with Denzel Curry, or El-P's "High Water" album, performed with a live jazz band. Magna Carda, an Austin-based duo, manages to capture the cohesion and fusion between their spoken track and the live band, especially in this performance of "They Watchin' Me." DJ Megz Kelli's strong vocals, reminiscent of Lauryn Hill, Wynne, and even Danny Brown at times, cut through the instrumental backing, and are able to stand on their own as powerful indictments of an unjust system. At one point in the song, there's a longer instrumental break, where the guitarist's technical skill almost creates a second voice in the song, complementing Kelli's original bars. Magna Carda will be playing Thursday the 26th at 7:10 PM in the Linen Building. Their music, suited to nighttime coffeehouses and smaller venues, will be a unique and original addition to the Treefort lineup, and I'm excited to see them play.
Derek's Pick: Lightning Bolt
These guys are absolutely insane, in the best way possible. This noise rock band is made up of just a drummer and a bassist, but it's some of the loudest music you'll ever hear. Punching through the chaotic drumming and crazy bass rhythms are the drummer's unintelligible vocals. When performing live, he uses a contact mic, which needs to be touching his mouth in order to work. So he keeps it strapped to his face underneath his mask.
This live performance at a Japanese festival, Taicoclub, was how I first heard of the Lightning Bolt. I was instantly hooked after just how nuts the video was. Yet another quirk of theirs is how they usually perform on the same level as the audience. Often their "stage" is just a gap in the crowd, as you can see in the video. The closest fans could reach out and touch the instruments, so earplugs are highly recommended. I hope that their set at Treefort comes close to the kind of energy shown in the video. They're performing late Friday night at 12:20 AM, at the El Korah Shine stage, and for me it's a can't-miss. I can't wait to hear how the songs from their last album, 2019's Sonic Citadel, turn out live.
Flint's Pick: Horse Jumper of Love
Horse Jumper of Love has been on my radar for a few months now, ever since I started working at KZUU. Over the past couple of months, I've managed to slip one of their songs into nearly every one of my shows. So, imagine how genuinely surprised and happy I was to find out that they'd be playing at Treefort this year. This live performance really showcases just how full their sound is, despite only having three members in the group. While it might not be particularly high-energy, they take their performance seriously by focusing on recreating the full sound that's present on the recorded track to the best of their ability. In some ways, they've managed to make the track seem even "warmer" during the live performance, so I'm curious to see how well that transitions to their performance at Treefort this year. I'm really looking forward to hearing their live set Saturday night (3/28) from 9-9:40pm at RamaPong, and you should be too.
There will be a bunch of great shows throughout this festival, but these are ones that are going to be perfect fits for these venues. So if you didn't have a reason to truck to the festival with us, here is your chance! Head to https://www.treefortmusicfest.com/ for tickets and the full schedule!
Previous: Dustbowl Revival – Is It You, Is It Me
Next: Anna Zak (אנה זק) – בלוק


text:
Q: Copy & Paste into next empty row & column respectively I asked a number of times on this question & all the while, I being given vague answer, which isn't much help. Thus I just research on my own and came up with the following code from my research. Which works but doesn't exactly give me the desired outcome stated in the image attached. Whereby the codes paste the data from its specified cells but paste in column A which isn't the outcome wanted, but rather to paste from column B onward for sheets DX,DY & DZ.
Is there also a way I can get column A to update the date by itself base on Date entered in cell S9 which tag along with the data for sheets DX,DY & DZ. Likewise for sheet RAW, that update row 6 with the date entered in S9 of sheet GP Data
Sub Prism2ndStep()
'
' Prism2ndStep Macro
'
    r = 1
Sheets("GP Data").Range("S12:S14").Copy
If Sheets("GP Data").Range("S12") = Sheets("DX").Range("A65536").End(xlUp) _
    Then r = 0
Sheets("DX").Range("A65536").End(xlUp).Offset(r, 0).PasteSpecial _
    Paste:=xlPasteValues, Transpose:=True
Application.CutCopyMode = False

j = 1
Sheets("GP Data").Range("T12:T14").Copy
If Sheets("GP Data").Range("T12") = Sheets("DX").Range("A65536").End(xlUp) _
    Then j = 0
Sheets("DX").Range("A65536").End(xlUp).Offset(j, 0).PasteSpecial _
    Paste:=xlPasteValues, Transpose:=True
Application.CutCopyMode = False

k = 1
Sheets("GP Data").Range("U12:U14").Copy
If Sheets("GP Data").Range("U12") = Sheets("DX").Range("A65536").End(xlUp) _
    Then k = 0
Sheets("DX").Range("A65536").End(xlUp).Offset(k, 0).PasteSpecial _
    Paste:=xlPasteValues, Transpose:=True
Application.CutCopyMode = False

Dim copySheet As Worksheet
Dim pasteSheet As Worksheet

Set copySheet = Worksheets("GP Data")
Set pasteSheet = Worksheets("RAW")

copySheet.Range("P12:R14").Copy
With pasteSheet
.Cells(7, .Columns.Count).End(xlToLeft).Offset(0, 7).PasteSpecial _
    Paste:=xlPasteValues, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False

End With

End Sub

A: Try this macro for copying data from "GP Data" S12:S14 and pasting it into column B:D in DX tab.
Edited
Sub prism2ndStep()
    'get date from cell p9
    strdate = Sheets("GP Data").Range("S9").Value
    arrData = Sheets("GP Data").Range("S12:S14").Value
    Set rngwrite = Nothing
    Set rngwrite = Sheets("DX").Range("A:A").Find(strdate, LookIn:=xlFormulas)
    Do While rngwrite Is Nothing
        With Sheets("DX").Range("A60000")
            .End(xlUp).AutoFill (.End(xlUp).Resize(2))
        End With
        Set rngwrite = Sheets("DX").Range("A:A").Find(CDate(strdate), LookIn:=xlFormulas)
    Loop
    rngwrite.Offset(, 1).Resize(, 3).Value = Application.Transpose(arrData)

End Sub

Sub prism2ndStep2()
    'get data
    arrData = Sheets("GP Data").Range("P12:R14").Value
    'find get the first non-blank column in row 7 from right to left
    Set rngwrite = Sheets("RAW").Range("IV7").End(xlToLeft).Offset(, 1)
    'paste data
    rngwrite.Resize(3, 3).Value = arrData
    'drag dates across row 7
    rngwrite.Offset(-1).Value = rngwrite.Offset(-1, -3).Value + 1
End Sub

redpajama_set_name: RedPajamaStackExchange


The US Open starts today and runs through September 9th.
Crazy Rich Asians tops box office again w/crazy second weekend; Ferrari race car sells at auction for record-making $48.4 million; World's first craft beer hotel opens today; Functioning Apple computer built in 1970s up for auction soon–could fetch $300,000 or more?; Uber gearing up for shift to electric bicycles, scooters on short trips; Instagram testing virtual communities for college students; Sheraton, Westin, and other Starwood Hotels finding their religion?; Most popular Labor Day Weekend destinations and what to do in each of them; America's favorite apple; Pot stock highs; Tinder U.
Global study says safest level of alcohol consumption is…drum roll, please…none?!; Aspirin disappoints for avoiding first heart attack, stroke; People are now taking placebo pills to deal w/their health problems–and it's working; You'll soon be able to get your prescription and a blowout at CVS??; A ranking of every type of cheese by how (un)healthy they are; The connection between sleep and loneliness; Ultimate guide to vegan meat substitutes.
Hugo Boss recreates Michael Jackson's white 'Thriller' suit in honor of King of Pop's birthday (would have turned 60 this coming Wednesday); Kelly Preston readies to launch natural beauty brand Breathe Organics; Target rolls out enhancements in beauty department – for men; Botched facial fillers and…blindness?; The $28 vitamin C serum developed by MIT scientists that keeps selling out; RealReal's new 12,000 square foot boutique in Los Angeles; Met's most popular fashion exhibit ever.
Major study finds new slimming pill could help millions fight middle-age spread? It's three times more effective than dieting alone?? And–safe??; J.Lo teams up w/activewear brand Niyama Sol, drops new line of workout pants and sports bras; Ireland Baldwin reveals past struggle w/anorexia; The simple science that explains why drinking diet soda makes you gain weight; A "floating" backpack that could ease the burden of travel; Halo Top competitor.


Pradha Villas Seminyak features 11 private villas comprising 3 units of 1 bedroom, 8 units of 2 bedrooms. Situated in the middle of the famous Seminyak area, in the heart of Bali's most fashionable shopping and night life, yet offering a very private retreat within earshot of the waves breaking on Seminyak Beach - only 3 minutes walking distance. Each private villa is enclosed in its own immaculate walled garden with its own private swimming pool, Jacuzzi and sun deck.
Pradha Villas complex offers only the best of everything, from the fully multitask staff to the level of privacy and the easy access to Bali's exciting facilities.
Pradha Villas Seminyak perfect for relaxing and romancing, truly your home from home in Seminyak.


text:
Q: htaccess: redirect old domain and all pages to a new domain I know that there is a lot of examples on Stackoverflow but I still miss something.
I'm trying to redirect http://old.domain.com/fr/ to http://brand.new-domain.com/fr/ with the following rules, but that doesn't work:
# Enable Rewrite Engine
RewriteEngine On
RewriteBase /

# Add a trailing slash to paths without an extension
RewriteCond %{REQUEST_METHOD} !=POST
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !(\.[a-zA-Z0-9]{1,5}|/)$
RewriteRule ^(.*)$ $1/ [L,R=301]

# Redirect domain
Options +FollowSymLinks
RewriteCond %{HTTP_HOST} ^old.domain.com [OR]
RewriteCond %{HTTP_HOST} ^other-old.domain.com [NC]
RewriteRule ^(.*)$ http://brand.new-domain.com/$1 [r=301,L]

# Remove index.php
# Uses the "exclude method"
# http://expressionengine.com/wiki/Remove_index.php_From_URLs/#Exclude_List_Method
# This method seems to work best for us, you might also use the include method.
# http://expressionengine.com/wiki/Remove_index.php_From_URLs/#Include_List_Method
# Exclude root files
RewriteCond $1 !^(index\.php) [NC]
# Exclude EE folders
RewriteCond $1 !^(assets|ee-admin|images|templates|themes|fr|nl)/ [NC]
# Exclude user created folders
RewriteCond $1 !^(assets|css|img|js|swf|uploads)/ [NC]
# Exlude favico, robots, ipad icon
RewriteCond $1 !^(favicon\.ico|robots\.txt|pple-touch-icon\.png) [NC]
# Remove index.php
RewriteCond %{QUERY_STRING} !^(ACT=.*)$ [NC]
RewriteCond %{QUERY_STRING} !^(URL=.*)$ [NC]
RewriteRule ^(.*)$ /index.php?/$1 [L]

It correctly redirect when I call the root URL, but not when I call a page. What am I doing wrong?
Thanks in advance!
Pv

A: Try to use the following ruke as the first one:
# Redirect domain
Options +FollowSymLinks
RewriteCond %{HTTP_HOST} ^old.domain.com [OR]
RewriteCond %{HTTP_HOST} ^other-old.domain.com [NC]
RewriteRule ^(.*)$ http://brand.new-domain.com/$1 [R=301,L]

Also mind the upper case R with is the short form for the lower case redirect.

A: When writing mod_rewrite rules, the rules get applied in the order that they appear.
To redirect an old domain to a new domain, you'll want that rule to be first in your .htaccess or httpd.conf file — all other rules should appear after it.
If you only want to redirect a certain directory, the following rule will do so, while allowing the rest of the site to function normally:
<IfModule mod_rewrite.c>
    RewriteEngine On

    # Redirect Only Matching Directories
    RewriteCond %{REQUEST_URI} ^/(fr|fr/.*)$
    RewriteRule ^(.*)$ http://brand.new-domain.com/fr/$1 [R=301,L]
</IfModule>

If you want to redirect the entire site, the following rule will do so:
<IfModule mod_rewrite.c>
    RewriteEngine On

    # Redirect Entire Site to New Domain
    RewriteCond %{HTTP_HOST} ^old.domain.com$ [OR]
    RewriteCond %{HTTP_HOST} ^other-old.domain.com$ [NC]
    RewriteRule ^(.*)$ http://brand.new-domain.com/$1 [R=301,L]
</IfModule>

If you care about letting crawlers know your content has moved and want to make the transition as seamless as possible, be sure to keep the 301 Redirect flag in the RewriteRule.
This will ensure that users and search engines are directed to the correct page.

While we're on the subject, as part of the EE 2.2 release, EllisLab now "officially" offers limited technical support for removing index.php from ExpressionEngine URLs.
Simply add or update your code to the following, making sure to consider any rules you may already have in place:
<IfModule mod_rewrite.c>
    RewriteEngine On

    # Removes index.php
    RewriteCond $1 !\.(gif|jpe?g|png)$ [NC]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ /index.php/$1 [L]

    # If 404s, "No Input File" or every URL returns the same thing
    # make it /index.php?/$1 above (add the question mark)
</IfModule>

A: Have you tried using mod_alias simple redirect instructions (a core module that you have), before trying the hacky-mod-rewrite thing?
I would do a VirtualHost with ServerName old.domain.com and in this VH I would add this rule:
Redirect /fr http://brand.new-domain.com/fr

from doc:

Then any request beginning with URL-Path will return a redirect request to the client at the location of the target URL. Additional path information beyond the matched URL-Path will be appended to the target URL.

So get a separate VirtualHost for brand.new-domain.com (with ServerName brand.new-domain.com) and in this one do not set the Redirect Rule.
If you still want to handle the 2 domains in the same VirtualHost then you'll have to use mod-rewrite as even RedirectMatch cannot check the request domain on the query.