Minor issue with the Number column

Bug #1053036 reported by Keith Davies
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Griffith
New
Undecided
Unassigned

Bug Description

Minor issue with the Number column. My collection of dvd's include region 0,1,2 and blue ray

disc's therefore in order to keep them separate on the database I have numbered them as

follows:-
Region 1 numbered from 1
Region 2 numbered from 1000
Region 0 numbered from 10000
Blue Ray numbered from 19000
However when I view the database the order is not in a numerically correct sequence.
The examples below of the error

10009,1001,10010
10019,1002,10020
10029,1003,10030
etc.
I suspect the column is a aplha-numeric field and hence the incorrect sequence.
Any suggestions on how to fix this issue most welcome.
ps Griffith version 13 on windows 7 and xp

Revision history for this message
Michael (mikej06) wrote :

I think the following change can help you:
* make a backup of the file main_treeview.py
* open the file main_treeview.py with an editor
* look for the following line:
treemodel.set_value(iter, 0, '%004d' % int(movie.number))
* change it to
treemodel.set_value(iter, 0, '%005d' % int(movie.number))

Revision history for this message
Keith Davies (arkdavies) wrote : Re: [Bug 1053036] Re: Minor issue with the Number column

Michael

Many thanks, the fix worked a treat.

Regards Keith

________________________________
From: Michael <email address hidden>
To: <email address hidden>
Sent: Saturday, 1 December 2012, 19:45
Subject: [Bug 1053036] Re: Minor issue with the Number column

I think the following change can help you:
* make a backup of the file main_treeview.py
* open the file main_treeview.py with an editor
* look for the following line:
treemodel.set_value(iter, 0, '%004d' % int(movie.number))
* change it to
treemodel.set_value(iter, 0, '%005d' % int(movie.number))

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1053036

Title:
  Minor issue with the Number column

Status in film collection manager:
  New

Bug description:
  Minor issue with the Number column. My collection of dvd's include
  region 0,1,2 and blue ray

  disc's therefore in order to keep them separate on the database I have
  numbered them as

  follows:-
  Region 1 numbered from 1
  Region 2 numbered from 1000
  Region 0 numbered from 10000
  Blue Ray numbered from 19000
  However when I view the database the order is not in a numerically correct sequence.
  The examples below of the error

  10009,1001,10010
  10019,1002,10020
  10029,1003,10030
  etc.
  I suspect the column is a aplha-numeric field and hence the incorrect sequence.
  Any suggestions on how to fix this issue most welcome.
  ps Griffith version 13 on windows 7 and xp

To manage notifications about this bug go to:
https://bugs.launchpad.net/griffith/+bug/1053036/+subscriptions

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.