Thursday, September 24, 2015

Splitting Word document into separate files

#Author: Matt Bungard / bungard at g-mail d com
#
#Pull bits from various sources, if you've been exluded let me know and I'll cite accordingly
#http://stackoverflow.com/questions/26737239/powershell-add-a-new-document-to-exisitng-word-file-with-page-number-of-2
## -- Settings --
#$fileNamePattern = "ID #:\s+(\d+)"
$fileNamePattern = "Student ID #:\s+# (\d+)"
$pageLength = 1
$inputFile = "inputDoc.docx"
$outputPath = "outputDir\" #End the path with a slash
## -- End Settings
[ref]$SaveFormat = "microsoft.office.interop.word.WdSaveFormat" -as [type]
$word = New-Object -ComObject word.application
$word.Visible = $true
$doc = $word.Documents.Open($inputFile)
$pages = $doc.ComputeStatistics([Microsoft.Office.Interop.Word.WdStatistic]::wdStatisticPages)
$rngPage = $doc.Range()
for($i=1;$i -le $pages; $i+=$pageLength)
{
[Void]$word.Selection.GoTo([Microsoft.Office.Interop.Word.WdGoToItem]::wdGoToPage,
[Microsoft.Office.Interop.Word.WdGoToDirection]::wdGoToAbsolute,
$i #Starting Page
)
$rngPage.Start = $word.Selection.Start
[Void]$word.Selection.GoTo([Microsoft.Office.Interop.Word.WdGoToItem]::wdGoToPage,
[Microsoft.Office.Interop.Word.WdGoToDirection]::wdGoToAbsolute,
$i+$pageLength #Next page Number
)
$rngPage.End = $word.Selection.Start
$marginTop = $word.Selection.PageSetup.TopMargin
$marginBottom = $word.Selection.PageSetup.BottomMargin
$marginLeft = $word.Selection.PageSetup.LeftMargin
$marginRight = $word.Selection.PageSetup.RightMargin
$rngPage.Copy()
$newDoc = $word.Documents.Add()
$word.Selection.PageSetup.TopMargin = $marginTop
$word.Selection.PageSetup.BottomMargin = $marginBottom
$word.Selection.PageSetup.LeftMargin = $marginLeft
$word.Selection.PageSetup.RightMargin = $marginRight
$word.Selection.Paste() # Now we have our new page on a new doc
$word.Selection.EndKey(6,0) #Move to the end of the file
$word.Selection.TypeBackspace() #Seems to grab an extra section/page break
$word.Selection.Delete() #Now we have our doc down to size
#Get Name
$regex = [Regex]::Match($rngPage.Text, $fileNamePattern)
if($regex.Success)
{
$id = $regex.Groups[1].Value
}
else
{
$id = "patternNotFound_" + $i
}
$path = $outputPath + $id + ".docx"
$newDoc.saveas([ref] $path, [ref]$SaveFormat::wdFormatDocumentDefault)
$newDoc.close()
Remove-Variable(regex)
Remove-Variable(id)
}
[gc]::collect()
[gc]::WaitForPendingFinalizers()

Tuesday, September 22, 2015

Rails - Apache - "Web Application could not be started"

When deploying a new rails application to a local Apache install, i seem to run into this error:
Web application could not be started It looks like Bundler could not find a gem. Maybe you didn't install all the gems that this application needs. To install your gems, please run: bundle install If that didn't work, then the problem is probably caused by your application being run under a different environment than it's supposed to. Please check the following:
A quick fix, appears to be:

Run: bundle install --path vendor/bundle

Source: http://stackoverflow.com/a/5589346/3084542