• Check out the Annual AK Secret Santa exchange Program, signup before November 23rd in the AK Charities & Christmas forum!

2017 Sansui Serial Number Database

Got 'um, thanks!

Cheers Pete, with so many pairs of eyes on screens now you must get duplicates.....using the AK search panel often fails to find my test searches on my own entries. Is there a better way to 'test' the water so to speak to see if another AKer has been there?
new find;

Don't sweat it Bruce. There are duplicates in almost every batch. There is really no easy way for you to know if someone else has posted a internet serial number at some other time. Just keep your own submissions clean and leave the rest to me.

In most cases the dupes fall out when I paste the processed file into the main database table. When dupes occur at that point, they wind up in a "paste error" table and I can compare that to the main table to see why they fell out. What happened with last month's file is the duplicates were in the file that I compile from these posts. When I process the serial numbers, that file appends to a table. Dupes or other "key violations" are just deleted by Access and there is no trail, they are just gone and I have to figure out why they were rejected.

- Pete
 
Don't sweat it Bruce. There are duplicates in almost every batch. There is really no easy way for you to know if someone else has posted a internet serial number at some other time. Just keep your own submissions clean and leave the rest to me.
You do a great service to the group Pete, I'll keep 'em clean....Cheers Bruce.
 
mmmm...... haven't worked out how to get that clever looking pinked up 'included from previous pos't banner up top of my reply, any clues?
 
Click on 'quote' ---- over here---------->>>>-------------------------------------------------------------------------------------------------------------------------------------------------v

:)

Maybe this time....new add to dbase;

TU-217,027092725,Reidy12,internet FB
AU-alpha707KX,603035639,Reidy12,internet FB
G-971,819070060,Reidy12,internet FB
 
Thanks guys, Got 'um!

RG-710,654023361,Reidy12
SE-7.582071513,Reidy12
Bruce, do me a favor, I upload the serial numbers into the database at the end of the month. Rather than posting yours a few at a time several days apart, can you compile them and post them as a group once or twice a month? Thanks!

- Pete
 
No worries, will do Pete. I thought with many eyes looking it might reduce duplicates if others could see recent adds but you're right do reduce the collating of all the posts.
 
Hi Pete,

I haven’t had a chance to listen to it, but it is
beautiful. This must be an early one. It apparently had some Sansui glue issues and was partly recapped.

C-2301V,214070005,mjs1

Cheers.

Marc​
 
CA-F1,259060459,Internet
AV-77,614112607,Internet
AV-77,615067469,Internet
AV-77,644117236,Internet
T-M800V,664109850,Internet
A-M800V,624118166,Internet
T-919,613101332,Internet
TU-S607G Extra,833090138,Internet
TU-5500,025040241,Internet
TU-666,240080949,Internet
TU-666,240080953,Internet
TU-777,218051310,Internet
TU-777,218061730,Internet
TU-777,238100986,Internet
TU-777,028070581,Internet
TU-999,230050006,Internet
BA-5000,235100043,Internet
BA-2000,246120352,Internet
QS-1,221020261,Internet
AU-9900,215070751,Internet
AU-999,210060401,Internet
P-E302,347053085,Internet
P-E302,347071248,Internet
P-E302,426123329,Internet
P-E700,926033743,Internet
P-D31,514024372,Internet
SAX-200,SH1813,Internet
P-E701,347011633,Internet
P-E701,347071901,Internet
D-E100,645116411,Internet
P-E300,425104883,Internet
 
Last edited:
200,829100531,Reidy12,eBay
8080,26021860,Reidy12,Facebook
990,826070436,Reidy12,eBay
AU-101,514020412,Reidy12,Facebook
AU-217,838090417,Reidy12,internet
AU-217,838092737,Reidy12,internet
AU-217,838113575,Reidy12,internet
AU-2200,834060306,Reidy12,Facebook
AU-317,238102152,Reidy12,Allegro Poland
AU-517,228111638,Reidy12,Facebook
AU-5500,834101706,Reidy12,eBay
AU-555A,834010021,Reidy12,Facebook
AU-6500,834020106,Reidy12,Facebook
AU-X11,221020499,Reidy12,Facebook
AU-X701,438090583,Reidy12,Facebook
CA-3000,225090249,Reidy12,Facebook
G-8700DB,810030313,Reidy12,Facebook
MA-7,228032161,Reidy12,eBay USA
QRX-3000,23030765,Reidy12,Facebook
QSD-1,226030218,Reidy12,eBay
S-55C,62059,Reidy12,Facebook
SC-1110,248041694,Reidy12,Allegro Poland
SEVEN,812070861,Reidy12,Facebook
SP-3500,93012762,Reidy12,Facebook
TU-217,027080619,Reidy12,eBay
TU-217,847090496,Reidy12,internet
TU-217,848020468,Reidy12,internet
TU-217,848064466,Reidy12,internet
TU-217,848064721,Reidy12,internet
TU-217,848064723,Reidy12,Allegro Poland
TU-217,848065005,Reidy12,eBay Italy
TU-217,848091008,Reidy12,internet
TU-217,848100634,Reidy12,internet
TU-217,848101659,Reidy12,internet
TU-217,849070348,Reidy12,internet
TU-317,028100736,Reidy12,internet
TU-317,840060055,Reidy12,eBay
TU-5500,025040055,Reidy12,Facebook
TU-7700,025030108,Reidy12,eBay
TU-X701,617098045,Reidy12,Facebook
XL-300,925100253,Reidy12,Facebook
 
Back
Top Bottom