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

2017 Sansui Serial Number Database

LBPete said:
You guys are making my head hurt. How does that text file fit in? Does it have the serial numbers been previously posted and this is a revision with the T-tags called out?
Click to expand...

Hi Pete, The .txt file has both new finds and existing serials from my last Aleado run with T-tags called out. With the T-tags always in the 5th field there should be a way of parsing out the fields 1-4 and adding the 5th or creating a script to match the serials and adding T-tag where there is one?

If you need me to present "added" T-tag data differently just let me know but once you get a method it will be useful, as time goes on with us 'looking', serial duplicates with the added T-tag info will come up for sure. AKers back checking their own back plates for one.

As for "You guys are making my head hurt."...well that's a Database Administrators normal state of mind is it not !!...sorry 'bout that :(

Take care, don't stress and enjoy the music, that's why we are here :music::)
 
AU-101,832120538,carousell.my

Carousell.hk> hong kong
A-909,582120607,Carousell.hk
AU-X111 mos,215120359,Carousell.hk
AU-517,228103477,Carousell.hk
AU-D707,821080218,Carousell.hk
AU-D607,826090657,Carousell.hk
AU-D607GExtra,813060625,Carousell.hk
AU-a607MR,605120937,Carousell.hk
RA-500,215020059,Carousell.hk
RA-500,917091211,Carousell.hk
TU-217,848090400,Carousell.hk
QS-500,831120888,Carousell.hk

Peter
 
@sx1010JBL, got them, thanks.
@ Peter lye, welcome to the club, looks like you are tapping into auction sites most of us never see. I appreciate your help. One request though, rather than posting a few at a time, can you save them up and post them once towards the end of the month? I upload to the database once a month, usually on the last day of the month.

Reidy12 said:
Hi Pete, The .txt file has both new finds and existing serials from my last Aleado run with T-tags called out.
Click to expand...
So can I just delete one whole post from my January file and add in the text file? If so, please indicate what needs to be deleted.

If you need me to present "added" T-tag data differently just let me know but once you get a method it will be useful, as time goes on with us 'looking', serial duplicates with the added T-tag info will come up for sure. AKers back checking their own back plates for one.
Click to expand...
When you create your list, put the T-tag in the 5th field. I tried to clarify my thinking in a response to your post in the contractor thread.

As for "You guys are making my head hurt."...well that's a Database Administrators normal state of mind is it not !!...sorry 'bout that :(
Click to expand...
Roger that!

- Pete
 
Hi Pete,

Yep, saw your contractor thread, all good.

LBPete said:
So can I just delete one whole post from my January file and add in the text file? If so, please indicate what needs to be deleted.
Click to expand...

No worries, in a few days I'll send a new file for January to replace both the original and the T-tag txt file.

Peter Iye has a local site Carousell.hk that HiFishark has never picked up...good one :king:

- Cheers Bruce.
 
Replacement text file Pete.
Delete: 100volt_AleadoJapan_315dec2020.txt & Aleado Serials T-tag.txt entries
Add: Replacement100VandT-tag.txt. [attached]

There are 182 T-tag entries of which 39 existing serials [100volt file] had T-tag info added and 143 new ones [T-tag file]. Hope it goes smoothly. Cheers
 

Attachments

OK, the text file has 39 duplicate serial numbers. Are those serial numbers already in the database (posted prior to January 2021) or were they in posts since January 1, 2021?

- Pete
 
LBPete said:
OK, the text file has 39 duplicate serial numbers. Are those serial numbers already in the database (posted prior to January 2021) or were they in posts since January 1, 2021?

- Pete
Click to expand...

1. There were actually 37 serials from the Dec 18 100volt post [see attached 'Duplicated from original...." file] that got T-tag amended. So I guess there are two ways to update these records. Find those 37 originals and delete them then add the Aleado Serials T-tag.txt file
OR
2. As I have adjusted the Replacement file to fix those errors you highlighted in that December 18 file [See our conversation thread], Delete 2 lists: '100volt_AleadoJapan_315dec2020.txt' and 'Aleado Serials T-tag.txt' entries and then add 'Replacement100VandT-tag adjusted.txt'. [attached].

It's getting complicated but once done you'll have a big smile in reward!!!!...and maybe no hair ;)

Cheers & good luck, Bruce
 

Attachments

The serial numbers that are in the database already are not a problem. I can find them with a simple query as part of the upload process.. If all of the duplicates are in that December file, no problem. Any duplicates in the new upload file for January I have to find manually.

- Pete
 
Thanks! That 771 has a T-tag. It also may be the earliest one on file, 4th unit built on line 01 in March of '74. The database has one built in January but it's the only one with an 8 digit serial number and the only one built on line line 2 so it may not be a valid serial number.

- Pete
 
LBPete said:
Got it, thanks!
- Pete
Click to expand...
This one was wired for 220 volts (with the 220 sticker) and has a USA style plug.
It still has the blue plastic wrap on the bright work.
I’m guessing someone brought it back from a foreign assignment decades ago and it sat in a box.
I got it from the recycle pile at the town dump :dunno:.
It has the USA AM/FM bands though.
What market would it have been for?
 
A lot of Sansui gear was sold through the Military PX system. It's likely it was originally purchased in Europe through the PX system. I'm guessing they had US plugs because they would return with the servicemen to the US. In Europe it would just need an adapter plug. That's a very nice find but it's likely to have the early driver boards.

- Pete
 
LBPete said:
A lot of Sansui gear was sold through the Military PX system. It's likely it was originally purchased in Europe through the PX system. I'm guessing they had US plugs because they would return with the servicemen to the US. In Europe it would just need an adapter plug. That's a very nice find but it's likely to have the early driver boards.
- Pete
Click to expand...
Yes - it has the F1040 driver boards.
 
LBPete said:
@ Peter lye, welcome to the club, looks like you are tapping into auction sites most of us never see. I appreciate your help. One request though, rather than posting a few at a time, can you save them up and post them once towards the end of the month? I upload to the database once a month, usually on the last day of the month.



- Pete
Click to expand...

That's it for this site Catawiki. Dig up pass auction from 2018 to present.
3900Z,850112811,Catawiki
3900Z,821010178,Catawiki
441,024111303,Catawiki
551,026101930,Catawiki
5050,026083053,Catawiki
661,024051781,Catawiki
6060,816101921,Catawiki

A-5,430124483,Catawiki
A-500,645088006,Catawiki
A-6,860011476,Catawiki
A-7,441071400,Catawiki
A-80,860010637,Catawiki
A-9,442010870,Catawiki
A-9,431070905,Catawiki
AU-101,514100950,Catawiki
AU-101,514051395,Catawiki+
AU-101,224070622,Catawiki
AU-101,832111557,Catawiki+
AU-101,821030073,Catawiki
AU-117,832100646,Catawiki
AU-117,848091553,Catawiki
AU-117,037110423,Catawiki
AU-217,517100693,Catawiki
AU-217.838113781,Catawiki
AU-217,848081076,Catawiki
AU-217,857100105,Catawiki
AU-217,837082465,Catawiki
AU-20000,237040157,Catawiki+
AU-217,018020187,Catawiki
AU-217II,830071081,Catawiki
AU-222,119100038,Catawiki
AU-2200,215120302,Catawiki
AU-2900,517021953,Catawiki
AU-2900,836070284,Catawiki
AU-2900,517034496,Catawiki
AU-317,218110225,Catawiki
AU-317,837100484,Catawiki
AU-417,830050455,Catawiki
AU-3900,815091280,Catawiki
AU-3900,517044743,Catawiki
AU-4400,835060764, Catawiki+
AU-4900,836101496,Catawiki
AU-555A,832030605,Catawiki
AU-555A,522120077,Catawiki
AU-555A,832080514,Catawiki
AU-555A,822120759,Catawiki
AU-505,834030559,Catawiki+
AU-666,831080569,Catawiki
AU-777A,519110390,Catawiki
AU-717,227110424,Catawiki
AU-7500,833120233,Catawiki
AU-7700,835080309,Catawiki
AU-999,222110361,Catawiki
AU-D101,573060125,Catawiki
AU-D22,634050702,Catawiki
AU-D33,414051280,Catawiki
AU-D33,574080974,Catawiki
AU-D5,830102550,Catawiki
AU-D5,211031802,Catawiki
AU-D5,822110329,Catawiki
AU-D77X,434082396,Catawiki
AU-X201i,508070756,Catawiki
AU-X417R,603032926,Catawiki

B-77,860081274,Catawiki
B-1000,507111382,Catawiki

C-1000,507100161,Catawiki
C-1000,508061325,Catawiki
C-1000,508051055,Catawiki
C-77,860032520,Catawiki

D-X117HX,2236002891,Catawiki
1610378742163blob.png
FR-D25,331020326,Catawiki

G-301,828070779,Catawiki

P-D30,512124502,Catawiki


QRX9001,237070877,Catawiki

R-7,851030781,Catawiki
RA-500,224070023,Catawiki+
RA-700,216020295,Catawiki
RG-707,222120731,Catawiki
RD-707,833054366,Catawiki
RZ-1000,519070714,Catawiki

SC-1110,248051538,Catawiki
SC-1330,249100608,Catawiki
SE-3000,600062059,Catawiki
SE-8,443024876,Catawiki
SP-2,92002454,Catawiki
SRS-232,428061770,Catawiki
SRS-525,362071926,Catawiki
SR-626,326090174,Catawiki


T-60,849096209,Catawiki
T-80,859100002,Catawiki
TA-300,039031735,Catawiki
TU-217,848064635,Catawiki
TU-217,848100918,Catawiki
TU-217,028072756,Catawiki
TU-217,848100799,Catawiki
TU-217,847090931,Catawiki
TU-217,847110292,Catawiki
TU-217,848110631,Catawiki
TU-317,028102005,Catawiki
TU-3900,026100767,Catawiki+
TU-4400,014100530,Catawiki
TU-555XL,434083321,Catawiki
TU-719,819010044,Catawiki
TU-7500,824060150,Catawiki
TU-X111,60911054,Catawiki
TU-X501L,607123892,Catawiki

BTW the + @THE end mean T-tag

Peter
 
You must log in or register to reply here.
Back
Top Bottom