What's the cvs file schema?

Euro tracking discussion in English

Moderators: Fons, avij, Phaseolus

Post Reply
kKeks
Euro-Newbie
Euro-Newbie
Posts: 17
Joined: Fri Nov 19, 2010 3:19 pm

What's the cvs file schema?

Post by kKeks »

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?
User avatar
Jes
Euro-Master
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?

Post by Jes »

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 :arrow: "1"
if the note has been entered twice :arrow: "2" (this is a Hit)
if the note has been entered 3 times :arrow: "3" (this is triple Hit)

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. :)
User avatar
R/J
Euro-Master
Euro-Master
Posts: 2300
Joined: Fri May 16, 2008 12:04 pm
Location: Eindhoven & omgeving, Nederland

Re: What's the cvs file schema?

Post by R/J »

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)
My NIG stats have finally disappeared. My EBTST stats are still available.
kKeks
Euro-Newbie
Euro-Newbie
Posts: 17
Joined: Fri Nov 19, 2010 3:19 pm

Re: What's the cvs file schema?

Post by kKeks »

Thanks for the replies. A general accessible EBT CSV schema would be nice as well :D But your replies have been sufficient.
jrnsndrs
Euro-Master
Euro-Master
Posts: 2118
Joined: Wed Feb 13, 2008 8:27 pm
Location: Tilburg
Contact:

Re: What's the cvs file schema?

Post by jrnsndrs »

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
"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.

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Post Reply

Return to “Site and Euro-tracking Discussion (English)”