Eagle to Mouser Bill of Materials script

I have been learning Perl scripting the last week and this is one of the first scripts I wrote. It takes the Bill of Materials output from Eagle and converts it to a format that you can import into Mousers BOM Import Tool. Very handy for setting up orders quickly. It will also scan your BOM for reference values like “100uF” and “4.7K”. It takes these reference values and converts them to an actual part number based on what you set in the reference.csv file.

Example:

“1″;”100″;”RESISTOR0805″;”0805″;”R10″;”Resistors”;”";

Becomes

“1″,”SG73S2ATTD101J”,”RESISTOR0805″,”0805″,”R10″,”Resistors”,”",

Add new references to the reference.csv file in the following format.

“Part Value”,”Package”,”Manufacture Part Number”,

Run the perl script by passing it the Bill Of Materials from Eagle as an argument. Only works with List type set as “Values” and Output format set as “CSV” in the Eagle BOM generator.

GitHub Repository

AD7999 I2C ADC Driver

The Propeller Development Stick Redux uses a AD7999 I2C ADC to add analog functionality to the Propeller. I used the Basic I2C Driver and then wrote two demo programs to demonstrate how to get data from the AD7999. The demos could be used with other devices from the AD799X series with proper changes to the defines.

Files



AD7999 Round Robin Channel
AD7999 Select Channel

The round robin style enables all 4 channels then pulls the data in sequence. This makes the sampling faster as you do not need to write to the AD7999 every sample. The select channel demo writes to the AD7999 and tells it which channel to sample then gets the data. This is slower then the round robin style but you can request a specific channel.

Tommy Update

The parts for REV 0 of Tommy arrived from Mouser today. Just finished soldering the Propeller portion and it worked first try. I also updated the page for Tommy.

Tommy Pinball System Specifications

CPU:        Parallax Propeller P8X32A-Q44 clocked at 96MHz.
 
I/O:        64 Optocoupled switch inputs.
            32 Mosfets for solenoid control.
            8 Servo Connectors. 
            72 8-bit PWM LEDs. Using WS2803 chips.
            Up to 64 8-bit PWM RGB LEDs for General Illumination. Using WS2801 chips.
            4 12-bit Analog to Digital Channels.
            Standard LED DMD connector. 

Power:      Molex connector for PC PSU.
            Separate connector for Solenoid and Servo Power.

Storage:    Micro SD card slot.
            2 Mbit of SPI SRAM.
            1 Mbit of I2C EEPROM.

Additional: PCB Size is 7"x5" - 4 Layer 
            3 7-Segment numerical LED digits for debugging. 
            USB Serial built in.
            2-channel audio.
            Selectable voltage for LEDs and Servos. 
            All I/O data lines brought out for expandability. 
            Hardware watchdog that will disable solenoid power on event of CPU failure. 

IEE Flip VFD Working! Test code coming soon.

Today I wrote some code to get the IEE Flip VFD working. It has a fairly simple protocol and only took a bit of tweaking to get it working. I wrote the demo code for my Prop Dev Stick and will be uploading the SPIN code later once I finish the feature set.

After this I will write some C code for the MSP430 LaunchPad and get that working. The screen supports a serial input mode which saves 8 I/O pins but requires more timing. I will try to get that working as well.

msPROBOT Ready for Maker Faire

I finished the first physical version of the msPROBOT just in time for Maker Faire. I have the majority of the demo code written and I will post it when I test the code. All the basic library functions are written. Just need to make a main program that strings it all together.

There is more information and PCB files you can download at the msPROBOT project page.