diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-06-02 14:00:59 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-06-02 14:00:59 +0100 |
| commit | d1d1eef768e58c14635f3cd4078167c5009c2a8c (patch) | |
| tree | 413aa147ad0df11e27a7de1be2e016e77e8d26de | |
| parent | ce4dc08e96c18dd88ffbc1ad641b1f18d4baf3bd (diff) | |
| download | stock-d1d1eef768e58c14635f3cd4078167c5009c2a8c.tar.gz stock-d1d1eef768e58c14635f3cd4078167c5009c2a8c.tar.bz2 stock-d1d1eef768e58c14635f3cd4078167c5009c2a8c.zip | |
Untrack import/data CSV files; add .gitignore and .gitkeep
CSV data files are site-specific and should not be distributed.
import/data/ is now gitignored with a .gitkeep to preserve the
empty directory for deployments.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
| -rw-r--r-- | .gitignore | 2 | ||||
| -rw-r--r-- | import/data/.gitkeep | 0 | ||||
| -rw-r--r-- | import/data/CANPANStockList.csv | 33 | ||||
| -rw-r--r-- | import/data/CANSOLStockList.csv | 41 | ||||
| -rw-r--r-- | import/data/KitlockerAssemblies.csv | 272 | ||||
| -rw-r--r-- | import/data/KitlockerGroups.csv | 29 | ||||
| -rw-r--r-- | import/data/assembly_components.csv | 59 | ||||
| -rw-r--r-- | import/data/simple_assemblies.csv | 7 | ||||
| -rw-r--r-- | import/data/simple_components.csv | 82 | ||||
| -rw-r--r-- | import/data/simple_components_2.csv | 82 | ||||
| -rw-r--r-- | import/data/stock.csv | 57 |
11 files changed, 2 insertions, 662 deletions
diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..6dbdd18 --- /dev/null +++ b/.gitignore @@ -0,0 +1,2 @@ +import/data/* +!import/data/.gitkeep diff --git a/import/data/.gitkeep b/import/data/.gitkeep new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/import/data/.gitkeep diff --git a/import/data/CANPANStockList.csv b/import/data/CANPANStockList.csv deleted file mode 100644 index cd11a75..0000000 --- a/import/data/CANPANStockList.csv +++ /dev/null @@ -1,33 +0,0 @@ -"ITEM","XORDER","XREF","XKEY","XKET_EXT","DATA" -"SGL",1001,"ResCF-10kRQW",2,"R2, R5", -"SGL",1002,"ResCF-1k8RQW",3,"R3, R4, R6", -"SGL",1003,"ResCF-100kRQW",1,"R1", -"SGL",1004,"ResNet-10k4+C",1,"RR1", -"SGL",2001,"1N4001",1,"D1", -"SGL",2002,"1N4148",32,"For switch isolation", -"SGL",2003,"LED-3mmYLC",1,"LD1", -"SGL",2004,"LED-3mmGLC",1,"LD2", -"SGL",3001,"CapRE-100u/25V",1,"C1", -"SGL",3002,"CapTB-10u/16V",1,"C4", -"SGL",3003,"CapTB-4.7u/16V",1,"C2", -"SGL",3004,"CapRC-100n/50V2.5",4,"C3, C5, C6, C7", -"SGL",4001,"FDV304P",4,"Q1 - Q4", -"SGL",4002,"MCP2551-I/P",1,"U1", -"SGL",4003,"PIC18F26K80-I/SP",1,"U4", -"SGL",4003,"CD74HC238E",1,"U2", -"SGL",4005,"TLC5917N",1,"U5", -"SGL",5001,"R-78E5.0-0.5",1,"U3", -"SGL",5002,"RzPC-4M",1,"X1", -"SGL",5003,"SWTact-4.3mm",1,"S1", -"PCK",5004,"SRH-p1-36",6,"J2", -"SGL",5005,"TB-3.5-2",2,"J1", -"SGL",5006,"Sock-SPCB-D25",1,"J3", -"SGL",5007,"Plug-SL-D25",1,"(J3)", -"SGL",5008,"BoxH-p1-2x13",1,"J4", -"SGL",6001,"SocDIL-28",1,"(U4)", -"SGL",6002,"SocDIL-16",2,"(U2), (U5)", -"SGL",6003,"SocDIL-8",1,"(U1)", -"SGL",7001,"CANPAN PCB",1,, -"SGL",8001,"BagSS-75x85",3,, -"SGL",8002,"BagSS-140x140",1,, -"SHT",8003,"ASFoam","65x35",, diff --git a/import/data/CANSOLStockList.csv b/import/data/CANSOLStockList.csv deleted file mode 100644 index c879b5b..0000000 --- a/import/data/CANSOLStockList.csv +++ /dev/null @@ -1,41 +0,0 @@ -"ITEM","XORDER","XREF","XKEY","XKET_EXT","DATA" -"SGL",1001,"ResCF-10kRQW",4,"R1, R2, R3, R7", -"SGL",1002,"ResCF-1k8RQW",3,"R4, R5, R12", -"SGL",1003,"ResCF-2k2RQW",1,"R9", -"SGL",1004,"ResWW-4R7/0.5W",1,"R6", -"SGL",1005,"ResWW-1R2/0.5W",1,"R8", -"SGL",1006,"ResWW-0R1/3W",1,"R11", -"SGL",3007,"1N4002",10,"D1 - D10", -"SGL",1007,"UF4002",2,"D11, D12", -"SGL",1008,"1N4148",2,"D13, D14", -"SGL",3004,"LED-3mmYLC",1,"LD1", -"SGL",3005,"LED-3mmGLC",1,"LD2", -"SGL",3006,"LED-3mmRLC",1,"LD3", -"SGL",3001,"CapRE-2200u/35V",1,"C3", -"SGL",3002,"CapRE-470u/35V",1,"C6", -"SGL",3003,"CapRE-220u/25V",1,"C1", -"SGL",1009,"CapTB-10u/16V",1,"C8", -"SGL",1011,"CapTB-4.7u/16V",3,"C2, C4, C5", -"SGL",1012,"CapRC-100n/50V2.5",1,"C7", -"SGL",1013,"CapRC-22p/100V2.5",2,"C9, C10", -"SGL",2001,"STP55NF06L",8,"Q1 - Q8", -"SGL",1014,"ZTX1149A",1,"Q9", -"SGL",1015,"2N4401",1,"Q10", -"SGL",4001,"MCP2562-I/P",1,"U1", -"SGL",3016,"L7805CV",1,"U2", -"SGL",4002,"PIC18F26K80-I/SP",1,"U3", -"SGL",4003,"MIC4426",1,"U4", -"SGL",3008,"SWTact-4.3mm",1,"S1", -"SGL",4004,"SWDIL-6w",1,"DIP1", -"PCK",3009,"SRH-p1-36",6,"J2", -"SGL",3011,"TBSE-10A-3.5-4",1,"J1", -"SGL",3012,"TBPL-10A-3.5-4",1,"J1", -"SGL",3013,"TBSE-10A-3.5-3",4,"J3-J6", -"SGL",3014,"TBPL-10A-3.5-3",4,"J3-J6", -"SGL",3015,"Xyl-4MLP",1,"X1", -"SGL",5001,"CANSOL PCB",1,, -"SGL",6001,"BagSS-55x75",2,, -"SGL",6002,"BagSS-100x140",1,, -"SHT",4007,"ASFoam","65x35",, -"SGL",4005,"SocDIL-28",1,"(U3)", -"SGL",4006,"SocDIL-8",2,"(U1), (U4)", diff --git a/import/data/KitlockerAssemblies.csv b/import/data/KitlockerAssemblies.csv deleted file mode 100644 index 395e736..0000000 --- a/import/data/KitlockerAssemblies.csv +++ /dev/null @@ -1,272 +0,0 @@ -"Title","Description","SGL","KL3M","Group" -"36A","SD3 - Colour Light Signal Driver",0,0,1 -"37a","PD3-1000 Dual Capacitor-assisted Turnout Motor Driver",6,2,1 -"37b","PD3-2200 Dual Capacitor-assisted Turnout Motor Driver",7,6,1 -49,"12VDC CDU Solenoid Driver",8,9,1 -60,"5V DC Adaptor Kit",25,8,1 -61,"Gas Lamp Twinkler",16,12,1 -68,"2ch DC or DCC diode drop Block Detector (Train-on-Track-Indicator, ToTi-2)",15,14,1 -69,"±5V Dual Power Supply Regulator kit for ToTI Kits",14,11,1 -"72A","Dual Hector, Infra-red train detector kit ",24,11,1 -"72B","Hector Double Sensor Head kit",13,0,1 -"75A","Servo4-G",45,66,1 -"76B","ServoSet2, Setting box for kit 75, Servo4",0,9,1 -77,"Servo1 Single Servo Driver",17,24,1 -"77R","Servo1R Single Servo Driver with Relay",37,12,1 -"77RM","Servo1R Servo Driver 5 Multipack",11,2,1 -"77S","Setting Box for kits 77 & 77R",21,7,1 -79,"Turntable Controller (Stepper Motor)",2,6,1 -"79C","Turntable Control Pack",9,5,1 -470,"Dapol Signal Conversion Kit",17,8,1 -"59A","DCC Booster Kit NB2",3,24,2 -57,"DCC District Cutout",42,43,2 -52,"DCC Accessory Decoder (pulsed outputs)",16,2,2 -"53A","DCC Accessory Decoder (steady state output for constant drive turnouts, eg Tortoises) 4-channel Bipolar",16,20,2 -50,"2ch DCC only Current Transformer Block Detector, DTC2",42,119,2 -"56A","8ch DCC only Current Transformer Block Detector, DTC8",30,65,2 -175,"Frog Polarity Switch (FPS)",28,152,2 -177,"DCC Single Servo Decoder",0,0,2 -110,"Arduino CAN Shield",3,13,3 -793,"26SWG Solder",48,30,4 -794,"Bending Jig",47,17,4 -795,"Track/PCB Cleaner block",19,10,4 -799,"Measure of Patience",0,0,4 -"7921E","CANCAB2 Rotary Encoder for Kit 92E",5,5,5 -673,"CAB Holder",24,18,5 -721,"BT 47W/6H PCB Relay (12v 960 ohms)",0,0,5 -"472A","Telescope Ferrule for Dual Hector",29,4,5 -676,"Uses CBUS Label",170,4,5 -677,"CBUS Free Zone Label",41,0,5 -"678A","RJ22 Twin Faceplate",234,18,5 -"679A","MERG Publicity Label",110,11,5 -"93AH","CAB Plug-in Point with horizontal RJ22 sockets",21,25,5 -"93AV","CAB Plug-in Point with vertical RJ22 sockets",17,32,5 -498,"Voltage Detector Dongle Kit for CBUS",85,47,5 -"498F","Voltage Detector Dongle Kit inc with K80 CBUS PIC",66,97,5 -625,"4-way Pluggable Connectors : 5 Pack",65,25,5 -"764A","Label fascia for CANCAB2 Handset Kit 92P/E",9,0,5 -7919,"Spacer/Bracket sprue for CANCAB2",7,3,5 -6920,"Tactile Switch for CANCAB",1,55,5 -6921,"Button Cap for CANCAB - Ivory",31,21,5 -6922,"Button Cap for CANCAB - Black",20,7,5 -6923,"Button Cap for CANCAB - Yellow",44,2,5 -6924,"Button Cap for CANCAB - Red",27,2,5 -6925,"Button Cap for CANCAB - Green",48,0,5 -6926,"Button Cap for CANCAB - Blue",45,1,5 -7921,"100k Speed Pot for CANCAB",6,4,5 -7999,"Warranty Spares",19,2,5 -758,"FDV304P SMD CBUS Transistors (4)",11,0,5 -788,"MCP23017 Expander IC for EzyBus Input Module",0,8,6 -781,"TBD62083APG MOSFET Driver",18,4,6 -783,"L6388E Half Bridge MOSFET Driver",7,0,6 -784,"CD74HC238 Decoder/Multiplexer",22,32,6 -785,"TLC5917N LED Driver",15,25,6 -786,"MCP2561FD CAN Transceiver",14,3,6 -787,"MIC4426YN MOSFET Driver",1,4,6 -"775P-OUT","ATMEGA328P-PU",9,13,6 -"724P","EzyBus Controller Microprocessor",10,5,6 -755,"MCP2551-I/P CAN Transceiver",29,7,6 -756,"MCP2562-E/P CAN Transceiver",25,31,6 -759,"MCP2515-I/P",0,5,6 -798,"MCP111",0,0,6 -9152,"Layout Power Distribution PCB",17,13,7 -960,"PCB for Unversal PSU",4,3,7 -150,"RJ45 4-way Interconnector",0,0,7 -9461,"PCB for SMD Gas Lamp Twinkler",4,0,7 -9151,"LCB Connector Board PCB",18,14,7 -9470,"PCB for Dapol Signal Conversion",6,0,7 -921,"U-RLY Universal Relay Mounting PCB",80,77,7 -"922a","EzyBus Output PCB rev2",4,5,7 -923,"EzyBus Input PCB rev 3",7,0,7 -924,"EzyBus Controller PCB",4,0,7 -936,"SD2 Signal Driver PCB",4,5,7 -"936A","SD3 Signal Driver PCB",8,0,7 -937,"PD3 Point Driver PCB",0,0,7 -9145,"ATC2-CORE PCB",4,0,7 -"9145P","ATC2-CORE-PANEL PCB",5,0,7 -9146,"ATC2-ENDS and PROFILES PCB",7,0,7 -"9147P","ATC2-PROFILES-PANEL PCB",3,0,7 -9148,"ATC2-MPS PCB",4,0,7 -949,"12V CDU PCB",5,0,7 -961,"Gas Lamp Twinkler PCB (TH)",2,2,7 -968,"PCB for 2Ch ToTI Kit 68",4,5,7 -969,"PCB for Split PSU Kit 69",2,0,7 -"972A","Dual Hector PCB",16,0,7 -"975G","Servo4G Rev1 PCB",10,0,7 -"976B","ServoSet2 PCB",4,0,7 -977,"Servo1 PCB",25,0,7 -"977R","Servo1R PCB",21,0,7 -979,"Stepper Motor Turntable Controller PCB",0,0,7 -9436,"PCB for SD2-SMD",10,0,7 -"750SMP","Programmed PIC12F683 for Servo1",30,0,8 -404,"PTP-Lite HV Backplane Kit - SMD",0,0,8 -409,"PTP-Lite Address Setter Kit - SMD",0,0,8 -901.4,"TM4 CANLED Test Module PCB",31,1,8 -980,"CANUSB USB I/F PCB",6,0,8 -771,"5V 5A DC Power Supply",5,1,9 -772,"12V 5A DC Power Supply",35,39,9 -773,"15V 3A DC Power Supply",34,19,9 -774,"15V 6A DC Power Supply",12,6,9 -"774P","C5 (Clover Leaf) Power Lead",2,9,9 -776,"18V 3.6A DC Power Supply",2,0,9 -779,"DC Socket CLB-JL53",1483,18,9 -780,"C7 PSU Power Cable",10,36,9 -911,"PCB CAN.FLIM.IO-E",3,11,10 -912,"PCB CAN.FLIM.IO-O",6,5,10 -914,"PCB CAN.FLIM.IO-F",14,0,10 -928,"CANOUT PCB",8,5,10 -929,"CANINP PCB",10,0,10 -"980A","CANUSB4 I/F PCB",4,2,10 -"993A","CANCAB Plug Point Dual PCB",7,3,10 -"993S","CANCAB Plug Point Single PCB",30,4,10 -"994A","CANSOL 94A Rev 5 PCB",0,5,10 -997,"CANPAN Mimic Panel Interface PCB",6,0,10 -"998B","CANMIO Rev K PCB",11,6,10 -9110,"PCB for Arduino CAN Shield",4,1,10 -9111,"CAN-Pico02_2515 PCB",0,5,10 -9112,"Pico MEZZ01 PCB",12,1,10 -"9193A","CANACTOUT RJ22 PCB RevC",5,1,10 -9391,"MioADD PCB",12,13,10 -9392,"MioADDSVO PCB",8,2,10 -436,"SD2 Colour Light Signal Driver SMD",14,8,11 -461,"Gas Lamp Twinkler SMD",15,12,11 -681,"Point Motor - Micro-Servo Mount",60,66,12 -682,"Point Motor - Horizontal Kit",41,17,12 -683,"Microswitch Pack",41,28,12 -684,"Single Arm Semaphore Mount",0,33,12 -685,"Double Arm Semaphore Mount",14,6,12 -686,"Quad Arm Semaphore Mount",13,0,12 -687,"Removable Mount for Semaphore Mounts",10,0,12 -688,"Magnet Pack for Demountable Kit",15,10,12 -689,"Colour Light Signal Mount Kit",8,4,12 -690,"Level Crossing Gate Servo Mount",16,0,12 -"690A","Level Crossing Gate Servo Mount",9,23,12 -802,"PMP2 - LDR Train Detector",66,41,13 -803,"PMP3 - Servo Tester/Controller",21,14,13 -805,"PMP5 - Logic Probe",11,1,13 -806,"PMP6 - 12V Supply",18,3,13 -808,"PMP8 - Multi Purpose Flasher V2",48,22,13 -809,"PMP9 - 4-way Traffic Lights",26,9,13 -811,"PMP11 - LED Dimmer",17,2,13 -812,"PMP12 - Random Lights",44,29,13 -813,"PMP13 - Lighthouse Simulator",23,2,13 -814,"PMP14 - Decoder Test Rig",3,10,13 -816,"PMP16 - Turnout Position Sensor",20,7,13 -817,"PMP17 - Automatic Signals",35,32,13 -819,"PMP19 - Automatic Coach Lighting",14,4,13 -820,"PMP20 - Versatile Timer",30,19,13 -821,"PMP21 - Dual LED Flasher",41,21,13 -823,"PMP23 - DCC Reverse Loop Controller",38,1,13 -824,"PMP24 - Arc Flash Generator",43,17,13 -825,"PMP25 - Steam Sound Emulator",32,2,13 -826,"PMP26 - Event Sequencer",12,10,13 -827,"PMP27 - Button Operated Servos",34,1,13 -899,"PMP99 - Hall Effect Sensor Pack",19,5,13 -950,"DTC2 DCC Block Detector PCB",10,10,14 -952,"DCC Accessory Decoder (P) PCB",0,0,14 -"953A","DCC Accessory Decoder (S/S) PCB",5,4,14 -"956A","DTC8 DCC Block Detector PCB",1,8,14 -957,"DCO DCC District Cutout PCB",28,0,14 -"959A","NB2 DCC Booster PCB",7,0,14 -"991B","CANCMDB Command Station PCB",7,2,14 -"992P","CANCAB2 DCC Handset PCB",11,2,14 -9175,"Frog Polarity Switch (FPS) PCB",0,12,14 -741,"PIC12F675-I/P Microcontroller",3,0,15 -"741P","Programmed PIC12F675 Microcontroller",0,6,15 -760,"PIC16F1847",0,0,15 -"742P","PIC12F1840-I/SP Preprogrammed For Kit 77",22,3,15 -743,"PIC16F18313-I/P",11,9,15 -"743P","PIC16F18313-I/P Preprogrammed For Kit 77R",10,0,15 -540,"PIC16F628A Microcontroller",3,0,15 -"540P","Programmed PIC16F628A Microcontroller",20,8,15 -751,"PIC16F630 Microcontroller Blank",28,0,15 -"751P","PIC16F630 Microcontroller Programmed",20,6,15 -752,"PIC16F676 Microcontroller",6,0,15 -"752P","Programmed PIC16F676 Microcontroller",0,0,15 -753,"Blank 16F1503 Microcontroller",27,0,15 -"753P","Programmed 16F1503 Microcontroller for Dual Hector",27,3,15 -745,"Programmed 16F883 Microcontroller for ATC1 ",14,0,15 -754,"PIC18F2480 Microcontroller",5,0,15 -"754P","Programmed PIC18F2480 Microcontroller",20,2,15 -"756P","Programmed 18F2580 Microcontroller for CANCMD",18,2,15 -767,"Preprogrammed PIC18F14K50 for CANUSB4",3,4,15 -761,"PIC18F2420 Microcontroller",4,0,15 -"761P","Programmed PIC18F2420 Microcontroller for TTSM",7,1,15 -766,"PIC18F25K80 Microcontroller",0,0,15 -"766P","Programmed PIC18F25K80 Microcontroller",0,0,15 -768,"PIC18F26K80 Microcontroller",8,16,15 -"768P","Programmed PIC18F26K80 Microcontroller",0,9,15 -769,"PIC18F27Q83 MIcrocontroller",5,11,15 -"769P","PIC18F27Q83",4,6,15 -775,"ATMEGAGA328P-PU Microcontroller",0,0,15 -757,"PIC18F13K22-I/P",8,1,15 -11,"CANVOUT",18,22,16 -12,"CANVINP",25,11,16 -13,"CANVSERVO",35,47,16 -14,"CANV4BIP",18,6,16 -15,"CANV8BIP",0,0,16 -16,"CANV4SOL",0,0,16 -97,"CANPAN Mimic Panel Interface",19,28,16 -"98A","CANMIO Multi-Input-Output Module",0,0,16 -"98B","CANMIO-UNIVERSAL",27,32,16 -391,"MioADD",21,16,16 -392,"MioADDSVO",8,3,16 -193,"CANACTOUT RJ22 connector and CBUS Monitor",20,14,17 -90,"CBUS Message Activity Monitor (CANACT)",23,11,17 -492,"CANGIZMO. (CBUS Test Module.)",19,12,17 -491,"LCB Switch and LED test Boards",21,11,17 -493,"Bipolar pluggable LCB test Board",5,1,17 -497,"CANTM7 Test Module Kit",17,8,17 -990,"CANACT PCB",10,0,18 -"9491a","Pluggable Switch LCB test Board PCB",7,5,18 -"9491b","Pluggable LED LCB test Board PCB",7,5,18 -9492,"CANGIZMO PCB",8,0,18 -9493,"Bipolar pluggable LCB test Board PCB",3,0,18 -9497,"TM7 CANPAN Test Module PCB",5,2,18 -9801,"PCB for PMK1",24,13,19 -9804,"PCB for PMK4",16,5,19 -"9804A","PCB for PMK4A",5,3,19 -9807,"PCB for PMK7",19,10,19 -9810,"PCB for PMK10",26,2,19 -9815,"PCB for PMK15",26,0,19 -9818,"PCB for PMK18",19,0,19 -9822,"PCB for PMK22",3,0,19 -"101A","Beginners Kit 101A",8,7,20 -"102B","Beginners Kit 102B",4,9,20 -"101S","CBUS Beginner Pack A Subkit",12,0,20 -"102S","CBUS Beginner Pack B Subkit",9,0,20 -4801,"PMK1 - Track Tester",45,33,21 -4804,"PMK4 - Simple Shuttle",36,26,21 -"4804A","PMK4a - Shuttle Add-on",9,9,21 -4807,"PMK7 - DCC Train Detector",23,111,21 -4810,"PMK10 - Speed Controller",7,21,21 -4815,"PMK15 - Train AutoStop",25,7,21 -4818,"PMK18 - EzyPoints",80,32,21 -4822,"PMK22 - Laser Train Detector",58,51,21 -22,"EzyBus Output Module",5,22,22 -23,"EzyBus Input Module",0,19,22 -24,"AVR/EzyBus Controller Module",9,4,22 -"91B","DCC Command Station and Mini-Booster with CBUS Interface (CANCMDB)",30,39,23 -"92P","Handset with pot for MERG DCC Command Station - CANCAB2P",20,15,23 -"92E","Handset with encoder for MERG DCC Command Station - CANCAB2E",10,23,23 -144,"CANCAB2 RJ22 Curly Lead",16,16,23 -"7920P","Metal Knob and Washer for CAB2 Pot Version",14,1,23 -"7920E","Metal Knob for CAB2 Encoder Version",7,0,23 -777,"LCD Back lit Display for CANCAB2",10,4,23 -6720,"1.27mm Header for CANCAB2",13,2,23 -"44c","Mk1 DCC Handset cable, 2 metres",1,0,23 -236,"SD2A Colour Light Signal Driver kit",22,11,24 -25,"LCB Node Connector",0,0,25 -151,"LCB Connector Board",39,40,25 -152,"Power Distribution Board",29,47,25 -"779A","DC Male Socket CLB-JL52 DC 2.1 x 5.5",30,11,25 -28,"CANOUT",21,11,26 -29,"CANINP",19,7,26 -"80A","USB Interface (CANUSB4)",37,38,26 -"94A","CANSOL 94A",5,31,26 -145,"Automatic Train Controller 2 (ATC2) - Core Module Kit",2,4,27 -146,"ATC2 Ends",7,4,27 -147,"ATC2 Profiles Panel",5,1,27 -148,"ATC2 MPS",11,1,27 -666,"1st Class Postage in Addition to the Standard 2nd Class",791,24,28 -" ",,,, diff --git a/import/data/KitlockerGroups.csv b/import/data/KitlockerGroups.csv deleted file mode 100644 index 38c3afd..0000000 --- a/import/data/KitlockerGroups.csv +++ /dev/null @@ -1,29 +0,0 @@ -"KLID","Title" -"G1","General Kits" -"G2","DCC Kits" -"G3","CBUS Explorer" -"G4","Tools" -"G5","Miscellaneous" -"G6","ICs" -"G7","General Kit PCBs" -"G8","Clearance" -"G9","Power Supplies" -"G10","CBUS PCBs" -"G11","SMD Starter Kits" -"G12","Servo Mounts" -"G13","Pocket Money Projects" -"G14","DCC PCBs" -"G15","PICs" -"G16","CBUS Advanced" -"G17","Test Modules" -"G18","Test Module PCBs" -"G19","PMK PCBs" -"G20","CBUS Beginner's Packs" -"G21","Pocket Money Kits" -"G22","EzyBus" -"G23","DCC Traction" -"G24","Bitz-in-Bag kits" -"G25","Connector Boards" -"G26","CBUS Basic" -"G27","ATC" -"G28","POSTAGE" diff --git a/import/data/assembly_components.csv b/import/data/assembly_components.csv deleted file mode 100644 index 213002d..0000000 --- a/import/data/assembly_components.csv +++ /dev/null @@ -1,59 +0,0 @@ -,,,,"CANSOL","CANPAN" -"ResCF-10kRQW","10K 0.25W",150,,,2 -"ResCF-1k8RQW","1K8 0.25W",59,,,3 -"ResCF-2k2RQW","2K2 0.25W",25,,, -"ResCF-100kRQW","100K 0.25W",22,,,1 -"ResWW-4R7/0.5W","4R7 0.5W",89,,, -"ResWW-1R2/0.5W","1R2 0.5W",95,,, -"ResWW-0R1/3W","0R1 3W",45,,, -"ResNet-10k4+C","10K 5-pin commoned resistor network",2,,,1 -"1N4002","1N4002",2472,,, -"1N4001","1N4001",17,,,1 -"UF4002","UF4002",11,,, -"1N4148","1N4148",3482,,,32 -"LED-3mmYLC","yellow LED low current 3mm",8,,,1 -"LED-3mmGLC","green LED low current 3mm",7,,,1 -"LED-3mmRLC","red LED low current 3mm",22,,, -"CapRE-470u/35V","470uF/35V electrolytic",4,,, -"CapRE-220u/25V","220uF 25V Radial Electrolytic Capacitor",37,,, -"CapRE-100u/25V","100uF/25V electrolytic",63,,,1 -"CapTB-10u/16V","10uF tantalum 2.5mm",44,,,1 -"CapTB-4.7u/16V","4.7uF/16V tantalum 2.5mm",31,,,1 -"CapRC-100n/50V2.5","100nF/0.1uF ceramic 2.5mm",12,,,4 -"CapRC-22p/100V2.5","22pF 100V 2.5mm Radial Ceramic capacitor",68,,, -"FDV304P","FDV304P/XP221P0501TR-G XML CBUS Transistor",248,"farnell",,4 -"STP55NF06L","STP55NF06L MOSFET",24,,, -"ZTX1149A","ZTX1149A PNP Transistor",87,"farnell",, -"2N4401","2N4401 NPN Transistor",14,,, -"MCP2551-I/P","MCP2551 CAN Xceiver",0,"kitlocker",,1 -"L7805CV","L7805 5v 1A Regulator",8,,, -"PIC18F26K80-I/SP","PIC18F26K80",0,"kitlocker",1,1 -"MIC4426","MIC4426YN Driver",0,"mouser",, -"CD74HC238E","CD74HC238E Mux/Demux",0,"mouser",, -"TLC5917N","TLC5917IN LED Driver",0,"mouser",, -"R-78E5.0-0.5","R-78E5.0-0.5 5V 0.5A",2,"farnell",,1 -"RzPC-4M","4MHz 3 pin Resonator",54,,, -"SWTact-4.3mm","Tactile Switch 4.3mm Miniature Rectangular SPST",16,,, -"SWDIL-6w","DIL switch 6 Way 12 Pin",7,,, -"SRH-p1-36","Header 36 Way Single Row Plug 2.54mm",127,,, -"TB-3.5-2","Terminal Block 2 Way 10A 3.5mm Camden Type",52,,, -"Sock-SPCB-D25","D Type 25 Way Socket Straight PCB",3,,, -"Plug-SL-D25","D Type 25 Way Plug Solder Lug",4,,, -"BoxH-p1-2x13","Header 26 Way IDC Straight Boxed 2.54mm",7,,, -"TBSE-10A-3.5-4","4 way 10A 3.5mm Pitch Side Entry Header",11,"farnell",, -"TBPL-10A-3.5-4","4 Way 10A 3.5mm Pitch Free Plug",4,"farnell",, -"TBSE-10A-3.5-3","3 way 10A 3.5mm Pitch Side Entry Header",131,,, -"TBPL-10A-3.5-3","3 Way 10A 3.5mm Pitch Free Plug",212,,, -"Xyl-4MLP","4MHz Crystal",53,,, -"MCP2562-I/P","MCP2562-I/P CAN Transceiver",87,,, -"CANPAN PCB","CANPAN Printed Circuit Board",54,"kitlocker",, -"CANSOL PCB","CANSOL Rev D Solenoid Driver PCB",0,"kitlocker",, -"BagSS-75x85","Bag (M) 75x85",119,,, -"BagSS-140x140","Bag (L) 140x140",99,,, -"ASFoam","Antistatic Foam (whole sheets) 305x305x6mm",19,,, -,"CANPAN",1,,, -,"CANPAN Test Module",1,,, -"CapRE-2200u/35V","2200uF/35V electrolytic",0,,, -"SocDIL-28","28 way DIL socket 7.62mm",0,,, -"SocDIL-16","16 way DIL socket 7.62mm",0,,, -"SocDIL-8","8 way DIL socket 7.62mm",0,,, diff --git a/import/data/simple_assemblies.csv b/import/data/simple_assemblies.csv deleted file mode 100644 index 595bba5..0000000 --- a/import/data/simple_assemblies.csv +++ /dev/null @@ -1,7 +0,0 @@ -"PMP2","LDR Detector, works with DC and DCC.",0.5,"https://merg.org.uk/merg_wiki/doku.php?id=kits:pmplist" -"PMK4A","Add-on for PMK4 Simple Shuttle to operate a turnout. Replaces Kit 804A",4.01,"https://merg.org.uk/merg_wiki/doku.php?id=kits:pmklist" -"PMK15","A simple module that stops a train at any chosen point, controlled by the output of one or more train detectors. ",5.53,"https://merg.org.uk/merg_wiki/doku.php?id=kits:pmklist" -"PMP19","An automatic lighting system where the coach lights only come on when the train is moving.",3.14,"https://merg.org.uk/merg_wiki/doku.php?id=kits:pmplist" -"PMP27","Panel push buttons for servos. As described in the June 2019 Journal.",3.28,"https://merg.org.uk/merg_wiki/doku.php?id=kits:pmplist" -"CANPAN97","CBUS Modular Mimic Panel interface allowing up to 32 LEDs and 32 Switches/Pushbuttons. v1y Firmware",16.87,"https://merg.org.uk/merg_wiki/doku.php?id=kits:97" -"CANSOL94a","A revised version of the CANSOL solenoid driver kit",21.44,"https://merg.org.uk/merg_wiki/doku.php?id=kits:94a" diff --git a/import/data/simple_components.csv b/import/data/simple_components.csv deleted file mode 100644 index b2c5967..0000000 --- a/import/data/simple_components.csv +++ /dev/null @@ -1,82 +0,0 @@ -"Title","Description","supplier","supplier PN","Supplier price" -"ResWW-0R1/3W","0R1 3W Wire Wound Resistor","farnell",1735066, -"R-78E5.0-0.5","DC/DC Converter R-78E5.0-0.5 5V 0.5A","farnell",2078564, -"ResWW-1R2/0.5W","1R2 0.5W Wire Wound Resistor","farnell",2329749, -"FDV304P","FDV304P SMD CBUS Transistor","farnell",2438464, -"TBSE-10A-3.5-4","4 way 10A 3.5mm Pitch Side Entry Header","farnell",2517860, -"TBPL-10A-3.5-4","4 Way 10A 3.5mm Pitch Free Plug","farnell",2575217, -"ZTX1149A","ZTX1149A PNP Bipolar Transistor","farnell",9526781, -"PIC12F675-I/P","PIC12F675-I/P Microcontroller 8-bit DIP8","kitlocker","PIC12F675-I/P", -"CANSOL PCB","CANSOL Rev D Solenoid Driver PCB","kitlocker","CANSOL PCB", -"MCP2551-I/P","MCP2551-I/P CAN Transceiver","kitlocker","MCP2551-I/P", -"PIC18F26K80-I/SP","PIC18F26K80-I/SP Microcontroller","kitlocker","PIC18F26K80-I/SP", -"PMK4a PCB","PMK4a rev2 PCB","kitlocker","PMK4a PCB", -"PMK15 PCB","PMK15 rev 2 PCB","kitlocker","PMK15 PCB", -"CANPAN PCB","CANPAN Mimic Panel Interface PCB","kitlocker","CANPAN PCB", -"MCP2562-I/P","MCP2562-I/P CAN Transceiver","kitlocker","MCP2562-I/P", -"PIC18F26K80-I/SP","PIC18F26K80-I/SP Microcontroller Preprogrammed","kitlocker","PIC18F26K80-I/SP", -"TLC5917N","TLC5917N LED Driver","mouser",1755252, -"CD74HC238E","CD74HC238E Decoder / Demultiplexer DIL16","mouser","595-CD74HC238E", -"MIC4426","MIC4426 Dual 1.5A Peak MOSFET Drive","mouser","998-MIC4426YN", -"CapRE-470u/35V","470uF 35V Radial Electrolytic Capacitor","rapid","11-0244", -"CapTB-4.7u/16V","4.7uF 16V 2.5mm Tantalum Bead Capacitor","rapid","11-1018", -"CapTB-10u/16V","10uF 16V 2.5mm Tantalum Bead Capacitor","rapid","11-1022", -"CapTB-330n/35V","330nF 35V 2.5mm Tantalum bead","rapid","11-1060", -"CapRC-470n/50V2.5","470nF 50V 2.5mm Ceramic Capacitor","rapid","11-3424", -"CapRC-22p/100V2.5","22pF 100V 2.5mm Radial Ceramic capacitor","rapid","11-3427", -"CapRC-100n/100V2.5","100nF 100V 2.5mm Ceramic Capacitor","rapid","11-3442",13.68 -"CapRC-100n/50V2.5","100nF 50V 2.5mm Radial Ceramic Capacitor","rapid","11-3455",0.01 -"CapRE-100u/25V","100uF 25V Radial Electrolytic Capacitor","rapid","11-3509",0.06 -"CapRE-220u/25V","220uF 25V Radial Electrolytic Capacitor","rapid","11-3512",0.03 -"CapRE-2200u/35V","2200uF 35v Radial Electrolytic Capacitor","rapid","11-3533",13 -"BagSS-140x140","Self Seal Polythene Bag 140 x 140mm 160 gauge","rapid","14-0909",0.95 -"Plug-SL-D25","25 Way D-Type Solder Lug Plug","rapid","15-0110",277 -"Sock-SPCB-D25","25 Way Straight PCB D Type Socket","rapid","15-0750",3.03 -"BH-2032","CR2032 Coin Cell Battery Holder","rapid","18-0498",38 -"BoxH-p1-2x13","26 Way Straight Boxed Header 2.54mm Pitch","rapid","19-0037",135 -"TBLP-16A-5-2","2 Way 16A Low Profile Terminal Block 5mm Pitch","rapid","21-0461",0.11 -"TB-3.5-2","2 way 3.5mm Terminal Block","rapid","21-1500",0.08 -"TBSE-10A-3.5-3","3 way 10A 3.5mm Pitch Side Entry Header","rapid","21-3028",0.14 -"TBPL-10A-3.5-3","3 Way 10A 3.5mm Pitch Free Plug","rapid","21-3035",0.11 -"SocDIL-8","8 Pin DIL Socket 7.62 mm","rapid","22-0107",0.56 -"SocDIL-14","14 Pin DIL Socket 7.62 mm","rapid","22-0108",0.82 -"SocDIL-16","16 Pin DIL socket 7.62mm","rapid","22-0109",0.81 -"SocDIL-28","28 Pin DIL Socket 7.62mm","rapid","22-0114",0.84 -"SRH-p1-36","36 Way 2.54mm Single Row Header","rapid","22-0545",2.73 -"JL2pC","2 Pin Closed Jumper Link","rapid","22-0690", -"SB-25x64","Stripboard 25 x 64mm","rapid","34-0500", -"STP55NF06L","STP55NF06L MOSFET Logic N 60V 55A","rapid","47-0550", -"UF4002","UF4002 1A 100V Ultrafast Rectifier Diode","rapid","47-3156", -"L7805CV","L7805CV TO220 5V 1A Voltage Regulator","rapid","47-3290", -"1N4148","1N4148 75V 150mA Signal Diode","rapid","47-3416", -"1N4001","1N4001 Rectifier Diode","rapid","47-3420", -"78L05-100mA","78L05 -100mA Voltage Regulator","rapid","47-3612", -"1N4002","1N4002 Silicon Rectifier Diode 100V","rapid","47-3802", -"BC557B","BC557B Transistor PNP TO92 45V","rapid","50-3119", -"LED-3mmR","3mm LED - Red","rapid","55-0150", -"LED-3mmRLC","3mm LED - Red Low Current","rapid","56-0400", -"LED-3mmGLC","3mm LED - Green Low Current","rapid","56-0405", -"LED-3mmYLC","3mm LED - Yellow Low Current","rapid","56-0410", -"GL5528","GL5528 Light Dependent Photoresistor","rapid","58-0134", -"RlyDPDT-12V1A","12V DPDT relay 1A","rapid","60-4692", -"TCRT5000","TCRT5000 Optical sensor","rapid","60-8260", -"ResCF-470RQW","470R 0.25W Carbon Film Resistor","rapid","62-0362", -"ResCF-1k0RQW","1K0 0.25W Carbon Film Resistor","rapid","62-0370", -"ResCF-1k8RQW","1K8 0.25W Carbon Film Resistor","rapid","62-0376", -"ResCF-2k2RQW","2K2 0.25W Carbon Film Resistor","rapid","62-0378", -"ResCF-10kRQW","10K 0.25W Carbon Film Resistor","rapid","62-0394", -"ResCF-100kRQW","100K 0.25W Carbon Film Resistor","rapid","62-0418", -"ResCF-4k7RHW","4R7 0.5W Carbon Film Resistor","rapid","62-0510", -"ResNet-10k4+C","10K 5 Pin Commoned Resistor Network","rapid","63-0265", -"ResTrim-10kSM","10K 0.1W 30% Linear Trimpot","rapid","68-1575", -"PIC16F676-I/P","PIC16F676-I/P Microcontroller 8-bit DIP8","rapid","73-3692", -"SWTact-4.3mm","4.3mm Miniature Rectangular SPST Tactile Switch","rapid","78-1120", -"SWDIL-6w","DIL Switch 6-way 12-pin","rapid","80-0024", -"BC547B","BC547B Transistor NPN TO92 45V","rapid","81-0468", -"2N4401","2N4401 Transistor NPN TO92 40V","rapid","81-0487", -"BagSS-75x85","Self Seal Polythene Bags 75 x 85 x 0.05mm","rapid","87-0590", -"ASFoam","Conductive Foam","rapid","87-1528", -"Xyl-4MLP","4MHz Crystal","rapid","90-1074", -"RzPC-4M","4MHz 3-Pin Piezo-Ceramic Resonator","rapid","90-3565", -"BagSS-100x140","Self Seal Polythene Bag 100 x 140mm 160 Gauge","rapid","14-0926", -"BagSS-55x75","Self Seal Polythene Bag 55 x 75mm 160 gauge","rapid","14-0937", diff --git a/import/data/simple_components_2.csv b/import/data/simple_components_2.csv deleted file mode 100644 index 962e27f..0000000 --- a/import/data/simple_components_2.csv +++ /dev/null @@ -1,82 +0,0 @@ -"Title","Description","supplier","supplier PN","Supplier price","Supplier URL" -"ResWW-0R1/3W","0R1 3W Wire Wound Resistor","farnell",1735066,0.7476,"https://uk.farnell.com/vishay/ac03000001007jac00/res-0r1-5-3w-axial-wirewound/dp/1735066" -"R-78E5.0-0.5","DC/DC Converter R-78E5.0-0.5 5V 0.5A","farnell",2078564,3.48,"https://uk.farnell.com/recom-power/r-78e5-0-0-5/dc-dc-converter-5v-0-5a/dp/2078564" -"ResWW-1R2/0.5W","1R2 0.5W Wire Wound Resistor","farnell",2329749,0.072,"https://uk.farnell.com/te-connectivity/cfr50j1r2/res-1r2-5-500mw-axial-carbon-film/dp/2329749" -"FDV304P","FDV304P SMD CBUS Transistor","farnell",2438464,0.4536,"https://uk.farnell.com/on-semiconductor/fdv304p/mosfet-p-25v-0-46-sot-23-full/dp/2438464" -"TBSE-10A-3.5-4","4 way 10A 3.5mm Pitch Side Entry Header","farnell",2517860,0.4872,"https://uk.farnell.com/imo-precision-controls/20-155mh-4-e/terminal-block-header-4pos-th/dp/2517860" -"TBPL-10A-3.5-4","4 Way 10A 3.5mm Pitch Free Plug","farnell",2575217,1.284,"https://uk.farnell.com/imo-precision-controls/20-1550m-4-e/tb-pluggable-4pos-28-16awg/dp/2575217" -"ZTX1149A","ZTX1149A PNP Bipolar Transistor","farnell",9526781,1.680,"https://uk.farnell.com/diodes-inc/ztx1149a/transistor-pnp-e-line/dp/9526781" -"PIC12F675-I/P","PIC12F675-I/P Microcontroller 8-bit DIP8","kitlocker","PIC12F675-I/P",, -"CANSOL PCB","CANSOL Rev D Solenoid Driver PCB","kitlocker","CANSOL PCB",, -"MCP2551-I/P","MCP2551-I/P CAN Transceiver","kitlocker","MCP2551-I/P",, -"PIC18F26K80-I/SP","PIC18F26K80-I/SP Microcontroller","kitlocker","PIC18F26K80-I/SP",, -"PMK4a PCB","PMK4a rev2 PCB","kitlocker","PMK4a PCB",, -"PMK15 PCB","PMK15 rev 2 PCB","kitlocker","PMK15 PCB",, -"CANPAN PCB","CANPAN Mimic Panel Interface PCB","kitlocker","CANPAN PCB",, -"MCP2562-I/P","MCP2562-I/P CAN Transceiver","kitlocker","MCP2562-I/P",, -"TLC5917N","TLC5917N LED Driver","mouser",1755252,, -"CD74HC238E","CD74HC238E Decoder / Demultiplexer DIL16","mouser","595-CD74HC238E",, -"MIC4426","MIC4426 Dual 1.5A Peak MOSFET Drive","mouser","998-MIC4426YN",, -"CapRE-470u/35V","470uF 35V Radial Electrolytic Capacitor","rapid","11-0244",0.090,"https://www.rapidonline.com/suntan-ts13de1v471msb0b0r-470uf-35v-20-10-17mm-p-5mm-radial-alum-elec-cap-11-0244" -"CapTB-4.7u/16V","4.7uF 16V 2.5mm Tantalum Bead Capacitor","rapid","11-1018",0.075,"https://www.rapidonline.com/suntan-ts19001c4r7msb0a0r-4-7uf-16v-2-5mm-tantalum-bead-capacitor-11-1018" -"CapTB-10u/16V","10uF 16V 2.5mm Tantalum Bead Capacitor","rapid","11-1022",0.110,"https://www.rapidonline.com/suntan-ts19001c100msb0a0r-10uf-16v-2-5mm-tantalum-bead-capacitor-11-1022" -"CapTB-330n/35V","330nF 35V 2.5mm Tantalum bead","rapid","11-1060",0.100,"https://www.rapidonline.com/suntan-ts19001vr33msb0a0r-0-33uf-35v-2-5mm-tantalum-bead-capacitor-11-1060" -"CapRC-470n/50V2.5","470nF 50V 2.5mm Ceramic Capacitor","rapid","11-3424",0.057,"https://www.rapidonline.com/suntan-ts170r1h474msbfa0r-0-47uf-20-50v-y5v-2-54mm-radial-ceramic-capacitor-11-3424" -"CapRC-22p/100V2.5","22pF 100V 2.5mm Radial Ceramic capacitor","rapid","11-3427",0.040,"https://www.rapidonline.com/suntan-ts170r2a220jsbna0r-22pf-5-100v-npo-p-2-54mm-radial-ceramic-capacitor-11-3427" -"CapRC-100n/100V2.5","100nF 100V 2.5mm Ceramic Capacitor","rapid","11-3442",0.050,"https://www.rapidonline.com/suntan-ts170r2a104ksbba0r-0-1uf-10-100v-x7r-2-54mm-radial-ceramic-capacitor-11-3442" -"CapRC-100n/50V2.5","100nF 50V 2.5mm Radial Ceramic Capacitor","rapid","11-3455",0.010, -"CapRE-100u/25V","100uF 25V Radial Electrolytic Capacitor","rapid","11-3509",0.060, -"CapRE-220u/25V","220uF 25V Radial Electrolytic Capacitor","rapid","11-3512",0.030, -"CapRE-2200u/35V","2200uF 35v Radial Electrolytic Capacitor","rapid","11-3533",13.000, -"BagSS-140x140","Self Seal Polythene Bag 140 x 140mm 160 gauge","rapid","14-0909",0.950, -"Plug-SL-D25","25 Way D-Type Solder Lug Plug","rapid","15-0110",277.000, -"Sock-SPCB-D25","25 Way Straight PCB D Type Socket","rapid","15-0750",3.030, -"BH-2032","CR2032 Coin Cell Battery Holder","rapid","18-0498",38.000, -"BoxH-p1-2x13","26 Way Straight Boxed Header 2.54mm Pitch","rapid","19-0037",135.000, -"TBLP-16A-5-2","2 Way 16A Low Profile Terminal Block 5mm Pitch","rapid","21-0461",0.110, -"TB-3.5-2","2 way 3.5mm Terminal Block","rapid","21-1500",0.080, -"TBSE-10A-3.5-3","3 way 10A 3.5mm Pitch Side Entry Header","rapid","21-3028",0.140, -"TBPL-10A-3.5-3","3 Way 10A 3.5mm Pitch Free Plug","rapid","21-3035",0.110, -"SocDIL-8","8 Pin DIL Socket 7.62 mm","rapid","22-0107",0.560, -"SocDIL-14","14 Pin DIL Socket 7.62 mm","rapid","22-0108",0.820, -"SocDIL-16","16 Pin DIL socket 7.62mm","rapid","22-0109",0.810, -"SocDIL-28","28 Pin DIL Socket 7.62mm","rapid","22-0114",0.840, -"SRH-p1-36","36 Way 2.54mm Single Row Header","rapid","22-0545",2.730, -"JL2pC","2 Pin Closed Jumper Link","rapid","22-0690",, -"SB-25x64","Stripboard 25 x 64mm","rapid","34-0500",, -"STP55NF06L","STP55NF06L MOSFET Logic N 60V 55A","rapid","47-0550",, -"UF4002","UF4002 1A 100V Ultrafast Rectifier Diode","rapid","47-3156",, -"L7805CV","L7805CV TO220 5V 1A Voltage Regulator","rapid","47-3290",, -"1N4148","1N4148 75V 150mA Signal Diode","rapid","47-3416",, -"1N4001","1N4001 Rectifier Diode","rapid","47-3420",, -"1N4002","1N4002 Rectifier Diode","rapid","47-3422",, -"78L05-100mA","78L05 -100mA Voltage Regulator","rapid","47-3612",, -"1N4002","1N4002 Silicon Rectifier Diode 100V","rapid","47-3802",, -"BC557B","BC557B Transistor PNP TO92 45V","rapid","50-3119",, -"LED-3mmR","3mm LED - Red","rapid","55-0150",, -"LED-3mmRLC","3mm LED - Red Low Current","rapid","56-0400",, -"LED-3mmGLC","3mm LED - Green Low Current","rapid","56-0405",, -"LED-3mmYLC","3mm LED - Yellow Low Current","rapid","56-0410",, -"GL5528","GL5528 Light Dependent Photoresistor","rapid","58-0134",, -"RlyDPDT-12V1A","12V DPDT relay 1A","rapid","60-4692",, -"TCRT5000","TCRT5000 Optical sensor","rapid","60-8260",, -"ResCF-470RQW","470R 0.25W Carbon Film Resistor","rapid","62-0362",, -"ResCF-1k0RQW","1K0 0.25W Carbon Film Resistor","rapid","62-0370",, -"ResCF-1k8RQW","1K8 0.25W Carbon Film Resistor","rapid","62-0376",, -"ResCF-2k2RQW","2K2 0.25W Carbon Film Resistor","rapid","62-0378",, -"ResCF-10kRQW","10K 0.25W Carbon Film Resistor","rapid","62-0394",, -"ResCF-100kRQW","100K 0.25W Carbon Film Resistor","rapid","62-0418",, -"ResCF-4k7RHW","4R7 0.5W Carbon Film Resistor","rapid","62-0510",, -"ResNet-10k4+C","10K 5 Pin Commoned Resistor Network","rapid","63-0265",, -"ResTrim-10kSM","10K 0.1W 30% Linear Trimpot","rapid","68-1575",, -"PIC16F676-I/P","PIC16F676-I/P Microcontroller 8-bit DIP8","rapid","73-3692",, -"SWTact-4.3mm","4.3mm Miniature Rectangular SPST Tactile Switch","rapid","78-1120",, -"SWDIL-6w","DIL Switch 6-way 12-pin","rapid","80-0024",, -"BC547B","BC547B Transistor NPN TO92 45V","rapid","81-0468",, -"2N4401","2N4401 Transistor NPN TO92 40V","rapid","81-0487",, -"BagSS-75x85","Self Seal Polythene Bags 75 x 85 x 0.05mm","rapid","87-0590",, -"ASFoam","Conductive Foam","rapid","87-1528",, -"Xyl-4MLP","4MHz Crystal","rapid","90-1074",, -"RzPC-4M","4MHz 3-Pin Piezo-Ceramic Resonator","rapid","90-3565",, -"BagSS-100x140","Self Seal Polythene Bag 100 x 140mm 160 Gauge","rapid","14-0926",, -"BagSS-55x75","Self Seal Polythene Bag 55 x 75mm 160 gauge","rapid","14-0937",, diff --git a/import/data/stock.csv b/import/data/stock.csv deleted file mode 100644 index 8f0ad2b..0000000 --- a/import/data/stock.csv +++ /dev/null @@ -1,57 +0,0 @@ -"ResCF-10kRQW","10K 0.25W",150 -"ResCF-1k8RQW","1K8 0.25W",59 -"ResCF-2k2RQW","2K2 0.25W",25 -"ResCF-100kRQW","100K 0.25W",22 -"ResWW-4R7/0.5W","4R7 0.5W",89 -"ResWW-1R2/0.5W","1R2 0.5W",95 -"ResWW-0R1/3W","0R1 3W",45 -"ResNet-10k4+C","10K 5-pin commoned resistor network",2 -"1N4002","1N4002",2472 -"1N4001","1N4001",17 -"UF4002","UF4002",11 -"1N4148","1N4148",3482 -"LED-3mmYLC","yellow LED low current 3mm",8 -"LED-3mmGLC","green LED low current 3mm",7 -"LED-3mmRLC","red LED low current 3mm",22 -"CapRE-470u/35V","470uF/35V electrolytic",4 -"CapRE-220u/25V","220uF 25V Radial Electrolytic Capacitor",37 -"CapRE-100u/25V","100uF/25V electrolytic",63 -"CapTB-10u/16V","10uF tantalum 2.5mm",44 -"CapTB-4.7u/16V","4.7uF/16V tantalum 2.5mm",31 -"CapRC-100n/50V2.5","100nF/0.1uF ceramic 2.5mm",12 -"CapRC-22p/100V2.5","22pF 100V 2.5mm Radial Ceramic capacitor",68 -"FDV304P","FDV304P/XP221P0501TR-G XML CBUS Transistor",248 -"STP55NF06L","STP55NF06L MOSFET",24 -"ZTX1149A","ZTX1149A PNP Transistor",87 -"2N4401","2N4401 NPN Transistor",14 -"MCP2562-I/P","MCP2551 CAN Xceiver",43 -"L7805CV","L7805 5v 1A Regulator",8 -"PIC18F26K80-I/SP","PIC18F26K80",104 -"MIC4426","MIC4426YN Driver",60 -"CD74HC238E","CD74HC238E Mux/Demux",43 -"TLC5917N","TLC5917IN LED Driver",49 -"R-78E5.0-0.5","R-78E5.0-0.5 5V 0.5A",2 -"RzPC-4M","4MHz 3 pin Resonator",54 -"SWTact-4.3mm","Tactile Switch 4.3mm Miniature Rectangular SPST",16 -"SWDIL-6w","DIL switch 6 Way 12 Pin",7 -"SRH-p1-36","Header 36 Way Single Row Plug 2.54mm",127 -"TB-3.5-2","Terminal Block 2 Way 10A 3.5mm Camden Type",52 -"Sock-SPCB-D25","D Type 25 Way Socket Straight PCB",3 -"Plug-SL-D25","D Type 25 Way Plug Solder Lug",4 -"BoxH-p1-2x13","Header 26 Way IDC Straight Boxed 2.54mm",7 -"TBSE-10A-3.5-4","4 way 10A 3.5mm Pitch Side Entry Header",11 -"TBPL-10A-3.5-4","4 Way 10A 3.5mm Pitch Free Plug",4 -"TBSE-10A-3.5-3","3 way 10A 3.5mm Pitch Side Entry Header",131 -"TBPL-10A-3.5-3","3 Way 10A 3.5mm Pitch Free Plug",212 -"Xyl-4MLP","4MHz Crystal",53 -"MCP2562-I/P","MCP2562-I/P CAN Transceiver",87 -"CANPAN PCB","CANPAN Printed Circuit Board",54 -"BagSS-75x85","Bag (M) 75x85",119 -"BagSS-140x140","Bag (L) 140x140",99 -"ASFoam","Antistatic Foam (whole sheets) 305x305x6mm",19 -,"CANPAN",1 -,"CANPAN Test Module",1 -"CapRE-2200u/35V","2200uF/35V electrolytic",0 -"SocDIL-28","28 way DIL socket 7.62mm",0 -"SocDIL-16","16 way DIL socket 7.62mm",0 -"SocDIL-8","8 way DIL socket 7.62mm",0 |
