Opened 5 years ago

Closed 5 years ago

#2037 closed bug (fixed)

delete from database words that are not used in the code

Reported by: pablobd Owned by: Tsjoek
Priority: major Milestone: 2.3
Component: BW Internationalization Keywords:
Cc:

Description

in order to get real stats about the languages and not confuse the translation volunteers we need to to delete from the system all the unused words (from former code or outdated content) that do not really need translations

Attachments (4)

2037_CandidatesForDNT.txt (2.0 KB) - added by Tsjoek 5 years ago.
2037_CandidatesForIsDelete.txt (11.1 KB) - added by Tsjoek 5 years ago.
2037_CandidatesForIsDelete2.txt (886 bytes) - added by Tsjoek 5 years ago.
Another 42 serious candidates for cleanup
2037_CandidatesForIsArchived.sql (17.0 KB) - added by Tsjoek 5 years ago.
final list in sql format

Download all attachments as: .zip

Change History (12)

Changed 5 years ago by Tsjoek

Changed 5 years ago by Tsjoek

comment:1 Changed 5 years ago by Tsjoek

  • Owner set to Tsjoek
  • Status changed from new to assigned

Total deletion is maybe a bit too harsh, especially because it's not easy to define 100% sure what is outdated and what is not.

I've over time collected a list of almost 600 wordcodes that do not seem to be used anymore. Partly based on a list of wordcodes that don't appear in the code anywhere (corrected for faq etc. that are dynamically pulled from the db) and partly based on experience. The broadcasts will be set to donottranslate='yes', the others to a to be created status isDeleted.

That should do for a first serious cleanup.

Changed 5 years ago by Tsjoek

Another 42 serious candidates for cleanup

comment:2 Changed 5 years ago by Tsjoek

As we are not going to delete anything but archive stuff, the columname has changed into: isarchived. See #2107 for db updates.

comment:3 Changed 5 years ago by Tsjoek

Update of the sql file: found some more stuff that could be archived.

comment:4 Changed 5 years ago by shevek

  • Milestone changed from unassigned to 2.3
  • Status changed from assigned to to_alpha

comment:5 Changed 5 years ago by shevek

  • Status changed from to_alpha to testing

Deployed to alpha. (SQL execution pending.)

Changed 5 years ago by Tsjoek

final list in sql format

comment:6 Changed 5 years ago by Tsjoek

We'll keep the languages in the lists for now.

comment:7 Changed 5 years ago by Tsjoek

I suggest to keep this ticket open a bit longer. I've found already some more candidates that might be (re)moved or need some adjustments otherwise.

comment:8 Changed 5 years ago by crumbking

  • Resolution set to fixed
  • Status changed from testing to closed

guess this is done!

Note: See TracTickets for help on using tickets.