tectudssr

4. November 2018

App updated 10.10.2020
(added word wrap function)

I’ve created an Android App, shortly after A.VCE+ dead.
tectudssr cannot show pictures and can’t doing a lot of other things, but it serves me faithfully for text quizes.

Download the latest APK – v. 2.36

How to use the Application?
1. Install SumatraPDF
2. Open the pdf-test from gratisExam (didn’t tested other pdf-s) using SumatraPDF, „Save as“ -> „Save as .txt“
3. Удаляю из этого текстового файла вопросы в которых нет вариантов ответа или правильного ответа (редко).
4. Rename this file to tect.txt and move it to the Download folder of tablets sd-card

Back – swipe left or Vol+
Forward – swipe right or Vol-

I’m choosing right answers (checkboxes or radiobuttons depends on answers)

now, tectudssr will show correct answers – click the bottom middle button (or swipe up):

In cases of segmentation faults, incorrect quiz parsing (and so on) leave a comment or write a mail (attach the pdf).
Android v6+ required.

Previous version: tectudssr-2.11.apk.

Android, VCE
1 comment

Parse XLS using openpyxl

15. Oktober 2014

#1. Entferne non SAP/AEB Services
#2. Lösche Übersicht Seite
#3. Speichern als xls
#4. Konvertieren xls to xlsx
#5. Speichern als \\SAP\SD

import openpyxl, win32com.client, calendar, pandas as pd, datetime as dt
from datetime import datetime
from datetime import date

xlapp = win32com.client.DispatchEx("Excel.Application")
print('Aktualisierung xlsx...')
wbr = xlapp.Workbooks.Open('C:\Documents\Statistik Loader.xlsx')
wbr.RefreshAll()
xlapp.CalculateUntilAsyncQueriesDone()
wbr.Save()
print('Aktualisierung ist fertig.')
xlapp.Quit()

print('Lesen die xlsx Datei...')

df = pd.read_excel('Statistik Loader.xlsx', 'Quelldaten', index_col=None, na_values=['NA'])

df = df.drop(df[(df['State'] == 'closed')].index)
df = df.drop(df[(df['Queue'] != '[1] Second Level::SAP') & (df['Queue'] != '[2] Third Level::SAP')].index)
print('Reinigung xlsx...')

writer = pd.ExcelWriter('Statistik.xlsx')
df.to_excel(writer, 'Quelldaten', index=False)
writer.save()

print('Reinigung ist fertig.')

Woerterbuch = { 
				'SD-EU': 0,
				'JIS': 0,
				'IAU240': 0,
				'JAVA-Entwicklung': 0,
				'Preisfindung': 0,
				'LO-Logistik': 0,
				'EDIFACT-Mapping': 0,
				'IDocs': 0,
				'EDI': 0,
				'ABAP': 0,
				'SAP-Basis': 0,
				'Vertrieb': 0  }
			
Dienste = { '[T000] SAP::JIT': 0 }			

for Wort in Woerterbuch:
	Wort = '[T000] SAP::' + Wort
	Dienste[Wort] = 0

class switch(object):
    value = None
    def __new__(class_, value):
        class_.value = value
        return True

def case(*args):
    return any((arg == switch.value for arg in args))

wb = openpyxl.load_workbook('Statistik.xlsx')

ws = wb['Quelldaten']

print('Kalkulation...')
  
for cell in ws['I']:
	if str(cell.value) in Dienste:
		Dienste [str(cell.value)] += 1

ws = wb.create_sheet('T000')

i = 0
for dienstName in Dienste:
	i += 1
	ws.cell(row=i, column=1).value = dienstName
	ws.cell(row=i, column=2).value = Dienste[dienstName]

currentdate = datetime.today().strftime('%d.%m.%Y')
wb.save('\\\\java.sap.sd\DFS-Abteilungen$\SAP\SD\\' + currentdate + '.xlsx')
print('File \\\\java.sap.sd\DFS-Abteilungen$\SAP\SD\\' + currentdate + '.xlsx ist gespeichert.')
d,m,y = currentdate.split('.')

woche = dt.date(int(y),int(m),int(d)).strftime("%V")
monat = calendar.month_name[int(m)]

outlook = win32com.client.Dispatch('outlook.application')
mail = outlook.CreateItem(0)
mail.To = 'uchla@feedback'
mail.Subject = 'Die Liste Woche #' + woche + ', ' + monat
mail.HtmlBody = 'Hallo, die Datei S:\SAP\SD\\' + currentdate + '.xlsx ist fertig. \r\n Viele Grüße \r\n'
mail.Display(True)

#1. Entferne non SAP/AEB Services

#2. Lösche Übersicht Seite

#3. Speichern als xls

#4. Konvertieren xls to xlsx

#5. Speichern als \\SAP\SD

import openpyxl, win32com.client, calendar, pandas as pd, datetime as dt

from datetime import datetime

from datetime import date

xlapp = win32com.client.DispatchEx("Excel.Application")

print('Aktualisierung xlsx...')

wbr = xlapp.Workbooks.Open('C:\Documents\Statistik Loader.xlsx')

wbr.RefreshAll()

xlapp.CalculateUntilAsyncQueriesDone()

wbr.Save()

print('Aktualisierung ist fertig.')

xlapp.Quit()

print('Lesen die xlsx Datei...')

df = pd.read_excel('Statistik Loader.xlsx', 'Quelldaten', index_col=None, na_values=['NA'])

df = df.drop(df[(df['State'] == 'closed')].index)

df = df.drop(df[(df['Queue'] != '[1] Second Level::SAP') & (df['Queue'] != '[2] Third Level::SAP')].index)

print('Reinigung xlsx...')

writer = pd.ExcelWriter('Statistik.xlsx')

df.to_excel(writer, 'Quelldaten', index=False)

writer.save()

print('Reinigung ist fertig.')

Woerterbuch = {

'SD-EU': 0,

'JIS': 0,

'IAU240': 0,

'JAVA-Entwicklung': 0,

'Preisfindung': 0,

'LO-Logistik': 0,

'EDIFACT-Mapping': 0,

'IDocs': 0,

'EDI': 0,

'ABAP': 0,

'SAP-Basis': 0,

'Vertrieb': 0 }

Dienste = { '[T000] SAP::JIT': 0 }

for Wort in Woerterbuch:

Wort = '[T000] SAP::' + Wort

Dienste[Wort] = 0

class switch(object):

value = None

def __new__(class_, value):

class_.value = value

return True

def case(*args):

return any((arg == switch.value for arg in args))

wb = openpyxl.load_workbook('Statistik.xlsx')

ws = wb['Quelldaten']

print('Kalkulation...')

for cell in ws['I']:

if str(cell.value) in Dienste:

Dienste [str(cell.value)] += 1

ws = wb.create_sheet('T000')

i = 0

for dienstName in Dienste:

i += 1

ws.cell(row=i, column=1).value = dienstName

ws.cell(row=i, column=2).value = Dienste[dienstName]

currentdate = datetime.today().strftime('%d.%m.%Y')

wb.save('\\\\java.sap.sd\DFS-Abteilungen$\SAP\SD\\' + currentdate + '.xlsx')

print('File \\\\java.sap.sd\DFS-Abteilungen$\SAP\SD\\' + currentdate + '.xlsx ist gespeichert.')

d,m,y = currentdate.split('.')

woche = dt.date(int(y),int(m),int(d)).strftime("%V")

monat = calendar.month_name[int(m)]

outlook = win32com.client.Dispatch('outlook.application')

mail = outlook.CreateItem(0)

mail.To = 'uchla@feedback'

mail.Subject = 'Die Liste Woche #' + woche + ', ' + monat

mail.HtmlBody = 'Hallo, die Datei S:\SAP\SD\\' + currentdate + '.xlsx ist fertig. \r\n Viele Grüße \r\n'

mail.Display(True)

openpyxl, Parsing, Parsing, Python, Python
No comments

Change date on Vanilla Forum

12. März 2014

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.*;
import java.sql.Statement;

public class vanied {

    Connection Verbindung;
    Statement stmt;

    vanied() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Verbindung = DriverManager.getConnection("jdbc:mysql://java.www:3306/db-name?serverTimezone=UTC","db-benutzer","db-kennwort");
            stmt = Verbindung.createStatement();
        } catch(SQLException | ClassNotFoundException e){ System.out.println(e); }
    }

    void updateTopic(String ID, String Author, String dt) throws SQLException {
        String query = "UPDATE GDN_Discussion set DateInserted=" + dt + " where DiscussionID=" + ID + ";";
            if ("" != Author) // das ist ein Kommentar
                query = "UPDATE GDN_Comment set InsertUserID=" + Author + ", DateInserted=" + dt + " where CommentID=" + ID + ";";
            stmt.executeUpdate(query);
    }

    String benutzerExist(String benutzerName){
        String benutzerID = "";
        try {
            ResultSet rs = stmt.executeQuery("SELECT UserID FROM GDN_User WHERE Name=\"" + benutzerName + "\";");
            while (rs.next()) {
                benutzerID = rs.getString("UserID");
            }
        } catch (SQLException e) { System.out.println(e); }
        return benutzerID;
    }

    int maxBenutzerID(){
        try {
            ResultSet rs = stmt.executeQuery("SELECT MAX(UserID) FROM GDN_User;");
            while (rs.next()) {
                return rs.getInt("UserID");
            }
        } catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); }
        return 0;
    }

    String regBenutzerName(String benutzerName) {
        String benutzer = benutzerExist(benutzerName);
        if (benutzer != "") return benutzer;
        String kennwort = "neues-kennwort";
        String query = "INSERT INTO GDN_User (UserID, Name, Password, HashMethod, Email, ShowEmail, Gender, CountVisits, " +
                "CountInvitations, Permissions, Attributes, HourOffset, Admin, Banned, Deleted) " + "VALUES(" +
                maxBenutzerID()+1 + ",\""  + benutzerName + "\", \"" + kennwort +
                "\", Vanilla, 'generiert@e-mail.www', 0, m, 0, 0, '', '', 2, 0, 0, 0);";
        try {
            stmt.executeUpdate(query);
            return String.valueOf(maxBenutzerID()+1);
        } catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); }
        return "";
    }
}

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.*;

import java.sql.Statement;

public class vanied {

Connection Verbindung;

Statement stmt;

vanied() {

try {

Class.forName("com.mysql.cj.jdbc.Driver");

Verbindung = DriverManager.getConnection("jdbc:mysql://java.www:3306/db-name?serverTimezone=UTC","db-benutzer","db-kennwort");

stmt = Verbindung.createStatement();

} catch(SQLException | ClassNotFoundException e){ System.out.println(e); }

}

void updateTopic(String ID, String Author, String dt) throws SQLException {

String query = "UPDATE GDN_Discussion set DateInserted=" + dt + " where DiscussionID=" + ID + ";";

if ("" != Author) // das ist ein Kommentar

query = "UPDATE GDN_Comment set InsertUserID=" + Author + ", DateInserted=" + dt + " where CommentID=" + ID + ";";

stmt.executeUpdate(query);

}

String benutzerExist(String benutzerName){

String benutzerID = "";

try {

ResultSet rs = stmt.executeQuery("SELECT UserID FROM GDN_User WHERE Name=\"" + benutzerName + "\";");

while (rs.next()) {

benutzerID = rs.getString("UserID");

}

} catch (SQLException e) { System.out.println(e); }

return benutzerID;

}

int maxBenutzerID(){

try {

ResultSet rs = stmt.executeQuery("SELECT MAX(UserID) FROM GDN_User;");

while (rs.next()) {

return rs.getInt("UserID");

}

} catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); }

return 0;

}

String regBenutzerName(String benutzerName) {

String benutzer = benutzerExist(benutzerName);

if (benutzer != "") return benutzer;

String kennwort = "neues-kennwort";

String query = "INSERT INTO GDN_User (UserID, Name, Password, HashMethod, Email, ShowEmail, Gender, CountVisits, " +

"CountInvitations, Permissions, Attributes, HourOffset, Admin, Banned, Deleted) " + "VALUES(" +

maxBenutzerID()+1 + ",\"" + benutzerName + "\", \"" + kennwort +

"\", Vanilla, 'generiert@e-mail.www', 0, m, 0, 0, '', '', 2, 0, 0, 0);";

try {

stmt.executeUpdate(query);

return String.valueOf(maxBenutzerID()+1);

} catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); }

return "";

}

To launch files from Chrome’s context menu, I’ve registered a simple new URI handler: https://docs.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/platform-apis/aa767914(v=vs.85) i.e. vanied:

Add to Windows registry:

HKEY_CLASSES_ROOT
   vanied
      (Default) = "URL:Vanied Protocol"
      URL Protocol = ""
      DefaultIcon
         (Default) = "java.exe,1"
      shell
         open
            command
               (Default) = "C:\java\java.exe vanied.jar" "%1"

HKEY_CLASSES_ROOT

vanied

(Default) = "URL:Vanied Protocol"

URL Protocol = ""

DefaultIcon

(Default) = "java.exe,1"

shell

open

command

(Default) = "C:\java\java.exe vanied.jar" "%1"

Context Menu Editor plugin for Chrome: cme3.4.0.cab
After installing right click on Options:

Add new item

Edit and apply. Except info.linkUrl there are number of different data: https://developer.chrome.com/extensions/contextMenus#property-onclick-info

javafx, mysql, sql
No comments

tectudssr

Parse XLS using openpyxl

Change date on Vanilla Forum

Neueste Beiträge

Neueste Kommentare

Archive

Kategorien