As most of you I've downloaded the cvs file containing the note information.
The first line is obviously the version information, though that info being stuck there gives
some tools a hard time to parse the file correctly. Anyway, for the rest of the lines,
containing the actual note information, we have
<denomination>;<year>;<serial>;<comment>;<timestamp of submission>;<city>;<country>;<zipcode>;<shortcode>;<?A>;<?B>;<?C>;<latitude>;<longitude>
can anyone help me with A, B and C? A looks like a primary key, e.g. the id of the note in the database.
B seems to be always 1 and C always 0. Do they somehow correlate to hits?
What's the cvs file schema?
Moderators: Fons, avij, Phaseolus
- Jes
- Euro-Master

- Posts: 4933
- Joined: Thu May 24, 2007 9:38 pm
- Location: Away from home (once again)
- Contact:
Re: What's the cvs file schema?
I think that some of them (A,B or C, cannot remeber which one of them), indicates the number of times that the note has been entered into the database.
ie:
If the note has been entered once
"1"
if the note has been entered twice
"2" (this is a Hit)
if the note has been entered 3 times
"3" (this is triple Hit)
and so on...
ie:
If the note has been entered once
if the note has been entered twice
if the note has been entered 3 times
and so on...
Jes Speaks English, French, Spanish, Tokpisin and Esperanto. (Currently learning Swahili).
Don't fear perfection, you'll never reach it! (by Salvador Dali)
my EBT: http://es.eurobilltracker.com/profile/?user=121292" coins and banknote collector.
Don't fear perfection, you'll never reach it! (by Salvador Dali)
my EBT: http://es.eurobilltracker.com/profile/?user=121292" coins and banknote collector.
- R/J
- Euro-Master

- Posts: 2300
- Joined: Fri May 16, 2008 12:04 pm
- Location: Eindhoven & omgeving, Nederland
Re: What's the cvs file schema?
I have two notes with a 1 in column L and found out that 0=normal and 1=moderated hit.
So:
A: note-id
B: number of times entered (i.e. note is a hit if B>1)
C: type of hit (0=normal or no hit 1=moderated)
So:
A: note-id
B: number of times entered (i.e. note is a hit if B>1)
C: type of hit (0=normal or no hit 1=moderated)
My NIG stats have finally disappeared. My EBTST stats are still available.
Re: What's the cvs file schema?
Thanks for the replies. A general accessible EBT CSV schema would be nice as well
But your replies have been sufficient.
Re: What's the cvs file schema?
From a similar topic on the Dutch forum:
Denominantion/Year/Serialnr/Comment/Date+time/City/Country/Postal Code/Shortcode/EBT's note-id nr/Number of times entered/Moderation status/Geographical coordinates
Denominantion/Year/Serialnr/Comment/Date+time/City/Country/Postal Code/Shortcode/EBT's note-id nr/Number of times entered/Moderation status/Geographical coordinates
"of all wars, religious wars are the most detestable, since they are waged for no tangible gain, but only to impose a set of arbitrary credos on another."
--- Unspiek baron Bodissey.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--- Unspiek baron Bodissey.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
