Update German translation #2193

horst-p-w-neubauer · 2020-04-18T11:35:02Z

update German translation

this is done

'record' to 'Datensatz'
'Constraint' to 'Beschränkungen' in different ways.
'clause' to 'Anweisung'
strict case-issue 'Rowid'
'unmittelbar' in stead of 'inline' (context sensitive)
'vacuum' to 'Komprimierung'
'commit' to 'abschließen'
don't translate 'Concordance' as it is a trademark
tried to correct or clearify some missunderstandings

update German translatiion this is done * 'record' to 'Datensatz' * 'Constraint' to 'Beschränkungen' in different ways. * 'clause' to 'Anweisung' * strict case-issue 'Rowid' * 'unmittelbar' in stead of 'inline' (context sensitive) * 'vacuum' to 'Komprimierung' * 'commit' to 'abschließen' * don't translate 'Concordance' as it is a trademark * tried to correct or clearify some missunderstandings

horst-p-w-neubauer · 2020-04-18T11:38:30Z

Please, take this pullrequest as a draft for an open discussion.
I' have some concerns with some of my suggestions as well.
e.g. 'Prüfbechräunkung' for 'check constraint'

src/translations/sqlb_de.ts

FriedrichFroebel

I am not sure whether not translating some of the strings would be the preferred way. Examples:

I would tend to rather use "UNIQUE-Beschränkung" instead of translating "unique" into German, as "UNIQUE" is SQL syntax.
The same for "CHECK-Beschränkung".
The same for "WITHOUT ROWID".
I am not sure about whether "Rowid", "rowid" or "ROWID" would be the best choice.

I commented some of the specific findings directly as well.

src/translations/sqlb_de.ts

horst-p-w-neubauer · 2020-04-18T12:24:25Z

I am not sure whether not translating some of the strings would be the preferred way. Examples:

* I would tend to rather use "UNIQUE-Beschränkung" instead of translating "unique" into German, as "UNIQUE" is SQL syntax.

* The same for "CHECK-Beschränkung".

* The same for "WITHOUT ROWID".

* I am not sure about whether "Rowid", "rowid" or "ROWID" would be the best choice.

I agree with "UNIQUE-Beschränkung" and "CHECK-Beschränkung" - great solution!
I disagree with "WITHOUT Rowid" as it is also a dialog checkbox label where it might look like a not translated foreign part.

upate German translation done: * 'UNIQUE-' and 'CHECK-Beschränkung' * typo * 'collation' to 'Sortierung' * all variaties of 'Message from database [engine]|DB says' to 'DB meldet:'

update German translation done: * 'pattern' to 'Suchmuster' * 'Zu findendes Textpattern unter Einbeziehung der Prüfungen in diesem Fenster' replaced with 'Suchmuster unter Einbeziehung der aktivierten Optionen in diesem Fenster' as I think that is the meaning of 'considering the checks in this frame' but that might be wrong, need help.

update German translation done: * 'Query' to 'Abfrage' * 'Der Syntax' to 'Die Syntax'

update German translation done: * 'stop' to 'abbrechen'

update German translation done: * div. Beugungen * 'Toolbar' to 'Werkzeugleiste'

update German translation done: * 'bar' (context:bar plots) to 'Säule' * bar (context:toolbar) to 'Werkzeugleiste'

update German translation done: * 'log' to 'Protokoll' according to https://community.kde.org/KDE_Localization/de/StandardUebersetzungen

horst-p-w-neubauer · 2020-04-18T16:38:14Z

Allright. No more commits for today.

justinclift · 2020-04-19T04:07:23Z

Looks like good progress @horst-p-w-neubauer. 😄

update German translation done: * 'Statement' to 'Anweisung' * 'Plot' to 'Diagramm' * 'Pane' to 'Fensterbereich' * 'Unterstrichen' instead of 'Unterstreichung' as its siblings are adjectives as well * 'Plain[ ]text' to 'Nur-Text'

horst-p-w-neubauer · 2020-04-19T10:23:27Z

Now I've checked all items on my todo list.
I suggest to add a manualy updated dictionary as design-document for the translation-process.
I've attached mine as a draft. I don't know how you use to handle design-documents.
Maybe Excel isn't first choice for erveryone.
dictionary_de.xlsx

mgrojo · 2020-04-19T13:36:20Z

You have also the possibility of using issues or discussions in our Translators team (which you can join if you want). It's easy to write tables or even paste them from spreadsheets. You lose filtering capabilities, but maybe it is easier to share and edit in group. The wiki would be another option for this kind of coordination, but strangely I could not copy the table there. The syntax is the same, though, so an unsaved issue comment can be used as intermediary for the conversion from spreadsheets to wiki. Another option is using https://dbhub.io/ for storing the dictionary as a DB file. It is then easy to edit it using DB Browser.

Here an example:

Quelle	Kontext	Übersetzung	Bemerkungen
bar	Diagramme	Säulen	Säulendiagramme ordnen die Werte von oben nach unten, Balkendiagramme von rechts nach links
bar	toolbar	Werkzeugleiste	siehe: https://community.kde.org/KDE_Localization/de/StandardUebersetzungen
Check-Constraint		CHECK-Beschränkung	siehe: #2193
clause	SQL	Anweisung
Collation		Sortierung
commit		abschließen
Constraint		Beschränkung	siehe: #2193
Log		Protokoll	siehe: https://community.kde.org/KDE_Localization/de/StandardUebersetzungen
Message from database [engine]DB says		DB meldet	Vorschlag: horst-p-w-neubauer
pattern	regulärer Ausdruck	Suchmuster
Query		Abfrage
Record		Datensatz
Row		Zeile oder Datenbankzeile
Statement		Anweisung
stop		abbrechen
Toolbar		Werkzeugleiste	siehe: https://community.kde.org/KDE_Localization/de/StandardUebersetzungen
Unique-Constraint		UNIQUE-Beschränkung	siehe: #2193
Vacuum		Komprimierung

FriedrichFroebel · 2020-04-19T14:30:08Z

I have added a new wiki page at https://github.com/sqlitebrowser/sqlitebrowser/wiki/Translations to maintain the dictionary there. We might want to add a general explanation for the translation workflow as well - if I remember correctly, there have been some discussions regarding the required steps some time ago inside an issue.

horst-p-w-neubauer · 2020-04-19T14:33:06Z

Great idea. I love wikis!

horst-p-w-neubauer · 2020-04-19T14:55:43Z

Before this pull-request might get merged I wonder, are there any german documentations that rely on the former translations. As this merge is going to change a lot, I don't want to break anything.

mgrojo · 2020-04-19T14:58:40Z

Awesome!

I've updated the wiki page with the information Martin wrote in #182 (comment)

Before this pull-request might get merged I wonder, are there any german documentations that rely on the former translations. As this merge is going to change a lot, I don't want to break anything.

The only documentation that we have is the wiki (which is currently only English, but it could be translated as well) and the "What's This" information, whose strings are already present in the translation files.

horst-p-w-neubauer · 2020-04-20T09:04:00Z

I'm not sure what is the process that comes up with this message:
<location filename="../sqlitedb.cpp" line="1816"/>
'... Here's the SQL statement which you might want to fix and execute manually:'

Does it present an artificial produced SQL statement, that might fix the problem or is it the SQL statement that produced the problem and you offer the possibility to fix it and run it manually?

update German translation * all translated shortcut-Keys set back to root * 'Anzeige des übergenen SQL' to 'Anzeige der übergebenen SQL' as it reffers to 'SQL-Anweisung' (feminin)

horst-p-w-neubauer · 2020-04-22T19:40:38Z

If there are no more hints I would ask You to commit this request so we can see the translation-result ot the reset shortcuts with the next 3.12 build. BTW - when can we expect to see this?

horst-p-w-neubauer · 2020-04-22T19:42:42Z

If we find this working for german - we should do it for the other langs too.

FriedrichFroebel · 2020-04-23T08:36:26Z

You should probably remove .project, .settings/org.eclipse.core.resources.prefs and src/MainWindow.ui.autosave introduced during your last commit from the PR. Maybe we should add these files/directories/file extensions to the .gitignore as well to avoid pushing them again.

scottfurry · 2020-04-23T08:41:29Z

definitely remove IDE-specific files

update German translation done: * single SQL as feminin form * 'Panel' to 'Fenster' some clarifications, one typo

This reverts commit ff7f023.

update German translation done: * 'String' to 'Zeichenkette' * 'Modifier' to 'Modifizierer' * 'Timestring' to 'Zeit-Zeichenkette'

justinclift · 2020-04-28T23:37:06Z

What's the state of this now? Is it ready to merge? 😄

.gitignore

justinclift · 2020-04-29T06:15:46Z

I'd like to merge this now, if people feel this is ready?

horst-p-w-neubauer · 2020-05-01T19:56:34Z

the conflicted line allready vanished with #2224
Is there anything, I can do?

justinclift · 2020-05-02T11:51:45Z

I'm ok to merge this, if you feel it's ready?

horst-p-w-neubauer · 2020-05-02T13:22:10Z

I'd say: ready enough to merge.

justinclift · 2020-05-02T18:24:32Z

Awesome, thanks heaps for this too @horst-p-w-neubauer. 😄

mgrojo reviewed Apr 18, 2020

View reviewed changes

src/translations/sqlb_de.ts Outdated Show resolved Hide resolved

FriedrichFroebel reviewed Apr 18, 2020

View reviewed changes

src/translations/sqlb_de.ts Outdated Show resolved Hide resolved

src/translations/sqlb_de.ts Outdated Show resolved Hide resolved

src/translations/sqlb_de.ts Outdated Show resolved Hide resolved

horst-p-w-neubauer added 7 commits April 18, 2020 14:42

upate German translation

337ecd6

upate German translation done: * 'UNIQUE-' and 'CHECK-Beschränkung' * typo * 'collation' to 'Sortierung' * all variaties of 'Message from database [engine]|DB says' to 'DB meldet:'

update German translation

42cc8c5

update German translation done: * 'Query' to 'Abfrage' * 'Der Syntax' to 'Die Syntax'

update German translation

1501418

update German translation done: * 'stop' to 'abbrechen'

update German translation

ebdcbda

update German translation done: * div. Beugungen * 'Toolbar' to 'Werkzeugleiste'

update German translation

9bb669f

update German translation done: * 'bar' (context:bar plots) to 'Säule' * bar (context:toolbar) to 'Werkzeugleiste'

update German translation

13828f6

update German translation done: * 'log' to 'Protokoll' according to https://community.kde.org/KDE_Localization/de/StandardUebersetzungen

update German translation

1bd516d

update German translation done: * 'Statement' to 'Anweisung' * 'Plot' to 'Diagramm' * 'Pane' to 'Fensterbereich' * 'Unterstrichen' instead of 'Unterstreichung' as its siblings are adjectives as well * 'Plain[ ]text' to 'Nur-Text'

update German translation

ff7f023

update German translation * all translated shortcut-Keys set back to root * 'Anzeige des übergenen SQL' to 'Anzeige der übergebenen SQL' as it reffers to 'SQL-Anweisung' (feminin)

horst-p-w-neubauer added 3 commits April 23, 2020 17:28

update German translation

3851f6a

update German translation done: * single SQL as feminin form * 'Panel' to 'Fenster' some clarifications, one typo

Revert "update German translation"

1250ed3

This reverts commit ff7f023.

update German translation

3b1c94a

update German translation done: * 'String' to 'Zeichenkette' * 'Modifier' to 'Modifizierer' * 'Timestring' to 'Zeit-Zeichenkette'

justinclift reviewed Apr 28, 2020

View reviewed changes

.gitignore Show resolved Hide resolved

resolved conflict

23fe33b

justinclift merged commit 912abd1 into sqlitebrowser:v3.12.x May 2, 2020

horst-p-w-neubauer deleted the v3.12.x branch May 2, 2020 18:47

justinclift changed the title ~~update German translation~~ Update German translation Jun 7, 2020

Uh oh!

Update German translation #2193

Update German translation #2193

Uh oh!

Conversation

horst-p-w-neubauer commented Apr 18, 2020

Uh oh!

horst-p-w-neubauer commented Apr 18, 2020

Uh oh!

Uh oh!

FriedrichFroebel left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

Uh oh!

Uh oh!

horst-p-w-neubauer commented Apr 18, 2020

Uh oh!

horst-p-w-neubauer commented Apr 18, 2020

Uh oh!

justinclift commented Apr 19, 2020

Uh oh!

horst-p-w-neubauer commented Apr 19, 2020

Uh oh!

mgrojo commented Apr 19, 2020 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

FriedrichFroebel commented Apr 19, 2020

Uh oh!

horst-p-w-neubauer commented Apr 19, 2020

Uh oh!

horst-p-w-neubauer commented Apr 19, 2020

Uh oh!

mgrojo commented Apr 19, 2020

Uh oh!

horst-p-w-neubauer commented Apr 20, 2020 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

horst-p-w-neubauer commented Apr 22, 2020

Uh oh!

horst-p-w-neubauer commented Apr 22, 2020

Uh oh!

FriedrichFroebel commented Apr 23, 2020

Uh oh!

scottfurry commented Apr 23, 2020

Uh oh!

justinclift commented Apr 28, 2020

Uh oh!

Uh oh!

justinclift commented Apr 29, 2020

Uh oh!

horst-p-w-neubauer commented May 1, 2020

Uh oh!

justinclift commented May 2, 2020

Uh oh!

horst-p-w-neubauer commented May 2, 2020

Uh oh!

justinclift commented May 2, 2020

Uh oh!

Uh oh!

mgrojo commented Apr 19, 2020 •

edited

Loading

horst-p-w-neubauer commented Apr 20, 2020 •

edited

Loading