Today, I needed a quick count of all of the files in Magento in order to set the “apc.num_files hint=xxx” in APC. Since all of the source files were on my Windows machine already, I started with Powershell.
Powershell (Windows)
|
1 |
(gci .\magento -recurse | Where-Object {-not ($_.PSsContainer)}).Count |
After that, for accuracy sake, I checked on the server as well.
Linux Shell (Ran from inside the directory)
|
1 |
find . -type f | wc -l |
Ever had a bunch of rows in a text file that you would like to format as an html table, but don’t want to take as much time formatting all of the tr and td rows. You can do something like this:
Say you have a comma-delimited text file with some rows like:
|
1 |
foo1,foo2,foo3 |
And you want to output them as html or something, you can do something like this:
|
1 2 |
Get-Content .\thetext.txt | %{ $data = $_.split(","); Write-Output " $($data[0]) $($data[1]) $($data[2])" } > text-output.html |
You should get something like this:
|
1 |
foo1 foo2 foo3 |
It certainly speeds up some tedious formatting of some static or maybe dynamic data.
Quick way to change the schema name in all mysql dump files in a directory using Powershell. Or you could just use it to change a string in files of particular type in a directory
|
1 2 |
C:\Users\SloshDev> foreach($f in gci("*.sql")){ (Get-Content $f.fullname) | %{ $_ -replace "magento_1_9","magento_1_12" } | Set-Content $f.fullname } |
Here’s how I changed the default character set from latin1 to utf8. May not want to use if different columns use different character sets.
|
1 2 3 |
C:\Users\SloshDev> foreach($f in gci("*.sql")){ (Get-Content $f.fullname) | %{ $_ -replace "latin1","utf8" } | Set-Content $f.fullname } |
Steve Smith, Founder of NimblePros, Speaker, Author, and Software Craftsman. Microsoft MVP and Regional Director. Gives a great example on Recursively locating files with particular text strings and a given extension in PowerShell.
Find String in Files with Given Extension Using PowerShell
Here’s a quick one-liner to re-size photos if you have Imagick installed using PowerShell. It also renames the files with the dimensions specified:
|
1 2 |
PS C:\Users\SloshDev> gci("*.jpg") | %{convert $_.FullName -resize 500x500 $_.Name -replace '\.jpg$','-500x500.jpg'} |
Ultimately ended up with this to rename the file based on the actual dimensions of the file in the end:
|
1 2 |
PS C:\Users\SloshDev> gci("*.jpg") | %{convert $_.FullName -resize 500x500 -set filename:area '%wx%h' ($destination + ($_.Name.Trim("\.jpg") + "-%[filename:area].jpg"))} |
This is great if you want to do this within the file itself, however if you need to specify dimensions, source and destination directories, and specific image file extensions you could use a script like this:
|
1 2 3 4 5 6 7 |
$source = 'C:\User\SloshDev\My Pictures\' $destination = 'C:\User\SloshDev\My Pictures\500's\' $ext = "jpg" $size = "500x500" #Resize Images gci("$source*.$ext") | %{convert $_.FullName -resize $size -set filename:area '%wx%h' ($destination + ($_.Name.Trim("\.$ext") + "-%[filename:area]." + $ext))} |
IIS 6.0 did not save configuration files with “.xml” extension automatically. So I needed to add the .xml to the files. So this is what I did:
|
1 |
PS C:\_old-IIS-site-configurations> Get-ChildItem *.com | Rename-Item -NewName { $_.Name + ".xml"; } |
Nice, quick one-liner to quickly eliminate what would be a pain otherwise.
If you’ve ever wanted a tab delimited list of product attributes and prices to update pricing, here’s one way:
Export product attributes through ‘Utilities > Export Data > Export Attributes to XML File’
|
1 2 |
PS C:\>$a = Get-Content .\provide.xml PS C:\>Set-Content .\provide.xml -value "<products>",$a,"</products>" |
Now bring in file as xml:
|
1 |
PS C:\>$xml = [xml] (Get-Content .\provide.xml) |
Run this command to generate a tab delimited list of Product_Code, Code, & Price
|
1 2 |
PS C:\>$xml.Products.ProductAttributeOption_Add | foreach { $_.product_code + "`t" + $_.Price } > .\provide-list.txt |
For more information on Powershell’s xml capabilities and how easy it is to use XML with Powershell visit Powershell XML on Code Project
.