Posts tagged ‘Reporting’

Reports erzeugen mit Powershell

Heute bekam ich von einer Leserin meines Blogs folgendes Powershell Skript zugesandt, das alle Bilder größer 1MB sucht in in einer HTML Datei auflistet, die dann verschickt wird.

Vielen Dank an Andrea!

"
$a = $a + "BODY{background-color:#ffffff;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:grey}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:#ffffff}"
$a = $a + ""

gci "C:\Users\Uwe\" -recurse -include *.jpg,*.bmp,*.png | Where-Object {$_.Length -gt 1000KB} |
? { $_.PSisContainer -eq $false} |
Sort-Object length -descending | Select-Object Name, @{Name="Kbytes";Expression={ "{0:N0}" -f ($_.Length / 1Kb) }}, DirectoryName, CreationTime | ConvertTo-HTML -head $a -body "

Grosse Bilder

" | out-file "C:\report.htm" #Send Email $msg = $null $smtpServer = "0.0.0.0" $workpath = “\\Server\Share\Verzeichnis” $file = “$workpath\report.htm” $msg = new-object Net.Mail.MailMessage $att = new-object Net.Mail.Attachment($file) $smtp = new-object Net.Mail.SmtpClient($smtpServer) $msg.From = "sender@domain.com" $msg.To.Add("empfaenger@domain.com") #$msg.To.Add("empfaenger2@domain.com") $msg.Subject = "Bilder Report" $msg.IsBodyHTML = $true $html = "Report der Bilder" $msg.Body = $html $msg.Attachments.Add($att) $smtp.Send($msg)

Uwe

Uwe Ziegenhagen likes LaTeX and Python, sometimes even combined. Do you like my content and would like to thank me for it? Consider making a small donation to my local fablab, the Dingfabrik Köln. Details on how to donate can be found here Spenden für die Dingfabrik.

More Posts - Website

Schicke A5 Reports mit LaTeX erstellen

Hier ein „Proof of Concept“, wie man mit LaTeX schicke Din A5 Reports erstellen kann. Das Beispiel muss mit xeLaTeX übersetzt werden, da es die Microsoft OpenType Fonts nutzt. Das Layout der Fonts gefällt mir persönlich noch nicht, hier kann man sicher durch andere Schrifte noch einen besseren Eindruck schaffen.

Muster (PDF)

\documentclass[10pt]{scrartcl}
\usepackage{xltxtra}
\usepackage[]{xkeyval,polyglossia}
\setmainlanguage[spelling=new]{german}
\usepackage[a5paper,top=2cm, bottom=2cm, left = 2.5cm, right=2cm]{geometry}
\usepackage[]{csquotes}
\usepackage[]{titlesec}
\usepackage[]{url}
\usepackage[]{paralist}
\usepackage[absolute]{textpos}
\usepackage[]{rotating}
 
\usepackage[]{scrpage2}
\usepackage[]{blindtext}
 
\pagestyle{scrheadings}
\setheadsepline[\textwidth]{0.25pt}{}
 
\ohead{\headmark}
\ofoot[\pagemark]{\pagemark}
\cfoot{}
\chead{}
\ihead{Foobar}
 
\usepackage{xcolor}
\definecolor{msdarkblue}{RGB}{54,95,145}
\definecolor{msblue}{RGB}{79,129,189}
 
%\titleformat{\section}[form]{layout}{labellayout}{abstand}{davorcode}[danachcode]
\titleformat{\section}[hang]{\color{msdarkblue}\Large\sffamily\bfseries}{}{0pt}{\vspace*{-6pt}}
\titleformat{\subsection}[hang]{\color{msblue}\large\sffamily\bfseries}{}{0pt}{\vspace*{-4pt}}
\titleformat{\subsubsection}[hang]{\color{msblue}\normalsize\sffamily\bfseries}{}{0pt}{}
 
\setsansfont[ItalicFont={Cambria Italic},BoldFont={Cambria Bold},BoldItalicFont={Cambria Bold Italic}]{Cambria}
\setmainfont[ItalicFont={Calibri Italic},BoldFont={Calibri Bold},BoldItalicFont={Calibri Bold Italic}]{Calibri}
\setmonofont[ItalicFont={Consolas Italic},BoldFont={Consolas Bold},BoldItalicFont={Consolas Bold Italic}]{Consolas}
 
\setlength{\parindent}{0pt}
\setlength{\parskip}{1em}
 
\usepackage{unicode-math}
\setmathfont{Cambria Math}
\begin{document}
 
\setlength{\TPHorizModule}{1mm}
\setlength{\TPVertModule}{1mm}
 
\begin{titlepage}
~
\begin{textblock}{50}(-10,-10)
  \begin{color}{msdarkblue}
    \rule{3cm}{25cm}    
  \end{color}
\end{textblock}
 
% Logo white
\begin{textblock}{130}(30,30)
\rule{2cm}{2cm}\\[2em]   %\includegraphics[height=20mm]{Logo.jpg}
 
{\noindent\Huge\bfseries Title }
 
{\noindent\huge\bfseries Subtitle }\\[5em]
 
{\noindent\Large\bfseries Firstname Lastname}
 
\end{textblock}
 
 
\begin{textblock}{20}(12,200)
\begin{rotate}{90}
{\huge\bfseries \textcolor{white}{rotierter Text}}
\end{rotate}
\end{textblock}
 
\end{titlepage}
 
 
\tableofcontents
 
\clearpage
 
\begin{abstract}
\noindent \blindtext
\end{abstract}
 
\section{Einführung}
 
\blindtext[2]
 
\section{Hauptteil}
\subsection{Hallo}
 
\blindtext
 
\subsection{Welt}
 
\blindtext
 
\section{Fazit}
 
\subsection{Foo}
 
\blindtext
 
\subsection{Bar}
 
\blindtext
 
\end{document}

Uwe

Uwe Ziegenhagen likes LaTeX and Python, sometimes even combined. Do you like my content and would like to thank me for it? Consider making a small donation to my local fablab, the Dingfabrik Köln. Details on how to donate can be found here Spenden für die Dingfabrik.

More Posts - Website