Re: A Look-up for Coins

On Tuesday 29 May 2007, Thomas Ronayne wrote:
> Is there a look-up site available for coins?

No. I'm pretty sure there's no web-service APIs for coins, and I've just not 
written any scripts for websites. Do you have a suggestion for one?

Robby

HTML export and editing...

_______________________________________________
tellico-users mailing list
tellico-users@...
http://forge.novell.com/mailman/listinfo/tellico-users

RE: HTML export and editing...

_______________________________________________
tellico-users mailing list
tellico-users@...
http://forge.novell.com/mailman/listinfo/tellico-users

Re: HTML export and editing...

On Saturday 02 June 2007, christhi wrote:
> The HTML export engine seems to be very basic. Visually, I like the HTML
> output file it generates, but my to problems are that the search function
> in the page does not work at all,

It requires Javascript. That's the only way to do a search without depending 
on PHP or something else on the server side. When you transfer to the 
server, make sure to copy the ,js file.

> and that there's no way to change the 
> parameters of the collection from "Title" to something else (all I see is
> a huge list of clickable titles).

The HTML exports the same columns that are visible in the Tellico window. 
Turn on the other columns and re-order them however you like.

> Is there a way to improve the search function, at least? How can I add,
> as an instance, a search engine, for doing searches through many fields
> in the database (author, title, subject, keywords, etc)?

It will search whatever fields get exported.

Robby

Re: HTML export and editing...

On Sunday 03 June 2007, King, Darren wrote:
> I agree with your comments though, I'd like more options when exporting
> to html, especially more layout options.

It's all in the XSLT file. :) The HTML is fairly basic, I think, at least, 
if you speak HTML.  What other kinds of layouts would you suggest?

Robby

Re: stamps size in a printed collection

cool thank you very much !

Nicolas

On Saturday 26 May 2007 19:48:03 Robby Stephenson wrote:
> On Wednesday 23 May 2007, humufr@... wrote:
> > I still have the same problem than before with the image if I want to
> > print the collection (a dvd one). Some image are very big some does have
> > a small size.
>
> Thanks for the email. I just fixed this bug in SVN, so it'll be in the next
> release. I'm not sure why it ever worked before, if it ever did. :)
>
> Robby
> _______________________________________________
> tellico-users mailing list
> tellico-users@...
> http://forge.novell.com/mailman/listinfo/tellico-users

Feature request(s)

Hi,

First of all let me say that Tellico is the best collection manager available 
for Linux. I have been using the collectorz.com program Book Collector, and 
Tellico offers most of its functionality and more in some cases. But Book 
Collector has a couple things I would like to see implemented at some point if 
possible. (Maybe they already exist and I can't find them?)

First, some editing mode, possibly a child of the field editor, that lists all 
of the values that occur in a given field, for the whole collection. For 
example, a window listing all of the authors (entries in the author field) in 
the whole collection, and allowing selected ones to be merged into one. When 
importing books from Amazon, for instance, the same author (or publisher or 
whatever) is often named slightly differently (J. Brown vs. Joseph Brown, for 
example). Sometimes this can make it difficult to search for all books with a 
given author. So it would be nice to be able to instantly convert, for example, 
all field entries such as "J. Brown" and "Joe Brown" to "Joseph Brown." I hope 
that makes some sense.

Second, and less important, is there some way, or would it not be too difficult 
to implement a way, to use a source like Barnes & Noble or Powell's for 
automatic importing? Sometimes these places have books that Amazon doesn't for 
whatever reason.

Anyway, thanks for writing Tellico. It's a great program.

date bugs

I've been using Tellico for some time to keep track of my movie
collection, and it works really well. At some point I added a "date
added" field so friends could easily sort and see which movies are new
since the last time they checked my list.

So I have a collection with a date field, but not all entries have that
field populated. One bug I found is that if I update an entry that
doesn't have the date field populated, a date of 2007-1-1 gets added.

Looking at the code, it seems there's a reasonable feature whereby the
year defaults to the current year, and month and day default to 1.
datewidget_empty_date_fix.patch assumes the user wants a null date if
year, month, and day are all missing. I thought the date widget would be
the proper place for this fix (as opposed to, say Field::formatDate())
because Tellico keeps year, month, and day as null internally, so the
"current_year-1-1" representation doesn't get exported. This also means
that as a workaround, the user could save and reload the collection.

The other bug (or two depending on how you count them) is in date
sorting. I like how ISO dates are used to facilitate sorting, but it's
broken for two reasons. One, single-digit days and months aren't
zero-padded internally or when exported, and two, string sorting doesn't
account for the "current_year-1-1" defaulting feature.
isodate_sort_fix.patch implements a date comparison that constructs two
QDates with the same algorithm Field::formatDate() uses and compares
them with QDate's overloaded comparison operators. Perhaps it would be
desirable to rework this so the defaulting algorithm is only in one
place.

I made both patches against tellico-1.3.x because trunk gives a warning
about everything being broken.

I'm not subscribed to the list, so please CC me with replies.

-- 
Jake Maciejewski <maciejej@...>

--- tellico-1.3.x_orig/src/gui/datewidget.cpp	2007-06-06 23:49:23.000000000 -0500
+++ tellico-1.3.x/src/gui/datewidget.cpp	2007-06-08 23:55:40.000000000 -0500
@@ -123,20 +123,26 @@
 }

 QString DateWidget::text() const {
-  // possible for either day, month, or year to be empty
+  // possible for any (but not all) of day, month, or year to be empty
   // format is "year-month-day"
+  int y = m_yearSpin->value();
+  int m = m_monthCombo->currentItem();
+  int d = m_daySpin->value();
+  if((y <= m_yearSpin->minValue()) && (m <= 0) && (d <= m_daySpin->minValue()) ) {
+    return QString(); // all items empty
+  }
+
   QString s;
-  if(m_yearSpin->value() > m_yearSpin->minValue()) {
-    s += QString::number(m_yearSpin->value());
+  if(y > m_yearSpin->minValue()) {
+    s += QString::number(y); // first item is empty
   }
   s += '-';
-  // first item is empty
-  if(m_monthCombo->currentItem() > 0) {
-    s += QString::number(m_monthCombo->currentItem());
+  if(m > 0) {
+    s += QString::number(m);
   }
   s += '-';
-  if(m_daySpin->value() > m_daySpin->minValue()) {
-    s += QString::number(m_daySpin->value());
+  if(d > m_daySpin->minValue()) {
+    s += QString::number(d);
   }
   return s;
 }

diff -ur tellico-1.3.x_orig/src/listviewcomparison.cpp tellico-1.3.x/src/listviewcomparison.cpp
--- tellico-1.3.x_orig/src/listviewcomparison.cpp	2007-06-06 23:49:23.000000000 -0500
+++ tellico-1.3.x/src/listviewcomparison.cpp	2007-06-09 02:45:51.000000000 -0500
@@ -20,6 +20,7 @@

 #include <qlistview.h>
 #include <qpixmap.h>
+#include <qdatetime.h>

 namespace {
   int compareFloat(const QString& s1, const QString& s2) {
@@ -44,6 +45,8 @@
     return new PixmapComparison(field_);
   } else if(field_->type() == Data::Field::Dependent) {
     return new DependentComparison(field_);
+  } else if(field_->type() == Data::Field::Date) {
+    return new ISODateComparison(field_);
   } else if(field_->formatFlag() == Data::Field::FormatTitle) {
     // Dependent could be title, so put this test after
     return new TitleComparison(field_);
@@ -193,3 +196,47 @@
   return ListViewComparison::compare(col_, item1_, item2_, asc_);
 }

+Tellico::ISODateComparison::ISODateComparison(Data::ConstFieldPtr field) :
ListViewComparison(field) {
+}
+
+int Tellico::ISODateComparison::compare(const QString& str1, const QString& str2) {
+  // modelled after Field::formatDate()
+  // so dates would sort as expected without padding month and day with zero
+  // and accounting for "current year - 1 - 1" default scheme
+  QStringList dlist1 = QStringList::split('-', str1, true);
+  bool ok = true;
+  int y1 = dlist1.count() > 0 ? dlist1[0].toInt(&ok) : QDate::currentDate().year();
+  if(!ok) {
+    y1 = QDate::currentDate().year();
+  }
+  int m1 = dlist1.count() > 1 ? dlist1[1].toInt(&ok) : 1;
+  if(!ok) {
+    m1 = 1;
+  }
+  int d1 = dlist1.count() > 2 ? dlist1[2].toInt(&ok) : 1;
+  if(!ok) {
+    d1 = 1;
+  }
+  QDate date1(y1, m1, d1);
+
+  QStringList dlist2 = QStringList::split('-', str2, true);
+  int y2 = dlist2.count() > 0 ? dlist2[0].toInt(&ok) : QDate::currentDate().year();
+  if(!ok) {
+    y2 = QDate::currentDate().year();
+  }
+  int m2 = dlist2.count() > 1 ? dlist2[1].toInt(&ok) : 1;
+  if(!ok) {
+    m2 = 1;
+  }
+  int d2 = dlist2.count() > 2 ? dlist2[2].toInt(&ok) : 1;
+  if(!ok) {
+    d2 = 1;
+  }
+  QDate date2(y2, m2, d2);
+
+  if(date1 < date2) {
+    return -1;
+  } else if(date1 > date2) {
+    return 1;
+  } else return 0;
+}
diff -ur tellico-1.3.x_orig/src/listviewcomparison.h tellico-1.3.x/src/listviewcomparison.h
--- tellico-1.3.x_orig/src/listviewcomparison.h	2007-06-06 23:49:23.000000000 -0500
+++ tellico-1.3.x/src/listviewcomparison.h	2007-06-09 00:46:21.000000000 -0500
@@ -99,5 +99,13 @@
   QPtrList<ListViewComparison> m_comparisons;
 };

+class ISODateComparison : public ListViewComparison {
+public:
+  ISODateComparison(Data::ConstFieldPtr field);
+
+protected:
+  virtual int compare(const QString& str1, const QString& str2);
+};
+
 }
 #endif

_______________________________________________
tellico-users mailing list
tellico-users@...
http://forge.novell.com/mailman/listinfo/tellico-users

Feature request: Time stamp of creation and modification of records

Hi there,

using tellico on an everyday basis to handly my huge bibliography 
database, I'm noticing over and over again how extremely helpful it 
would be to have an two automatic time stamp fields in each record: one 
for the record creation time and one for the last modification time.

As it is, I handle a field for the creation date manually (which demands 
for more discipline than I can provide...) and it is near impossible to 
track down changes that I have recently made.

Greetings,
Norbert

RE: Feature request: Time stamp of creation and modification of records

Hear, hear.  Being that 99% of the time, I add a book/movie/cd/whatever
to it's collection the day I buy it, then I'd love the purchase date to
be automatically entered as the current date when you add a record.

Darren 

-----Original Message-----
From: tellico-users-bounces@...
[mailto:tellico-users-bounces@...] On Behalf Of Norbert
Nemec
Sent: Monday, 11 June 2007 7:02 PM
To: tellico-users@...
Subject: Feature request: Time stamp of creation and modification of
records

Hi there,

using tellico on an everyday basis to handly my huge bibliography
database, I'm noticing over and over again how extremely helpful it
would be to have an two automatic time stamp fields in each record: one
for the record creation time and one for the last modification time.

As it is, I handle a field for the creation date manually (which demands
for more discipline than I can provide...) and it is near impossible to
track down changes that I have recently made.

Greetings,
Norbert
_______________________________________________
tellico-users mailing list
tellico-users@...
http://forge.novell.com/mailman/listinfo/tellico-users