B.O.M> spreadsheet> distributor>stock levels
Bookmark this page:
 Yahoo!
 Google
 Windows Live
 del.icio.us
 digg
 Netscape
|
|
||||||||||||||||||||||||||||||||||
|
Posted by Martin Griffith on July 12, 2008, 6:04 pm
Please log in for more thread options done hyperlinks to the component with the worst priced distributor (RS/Farnell) in the next column....no problems with that Now wouldn't it be nice if I could set up the next column with their stock levels? Just click refresh.........Fat chance They seem to be living in Web 0.1 Must be this lot http://www.theregister.co.uk/2008/07/10/levis_erp_costs/ martin | ||||||||||||||||||||||||||||||||||
|
Posted by Paul Hovnanian P.E. on July 12, 2008, 9:08 pm
Please log in for more thread options Most of these big ERP vendors have a vested interest in huge, monolithic systems rather than modular systems with good, open interfaces between modules. This keeps customers on track to buy their whole thing, rather than doing phased migrations which necessitate interfaces to legacy systems. A side effect of this is that their systems don't have decent interfaces available to the outside world that one can use for the stuff you are looking for. -- Paul Hovnanian mailto:Paul@Hovnanian.com ------------------------------------------------------------------ Broken pipe. Command flooded basement. | ||||||||||||||||||||||||||||||||||
|
Posted by Martin Riddle on July 12, 2008, 9:15 pm
Please log in for more thread options
| I've imported the CSV bom from my schematic program into open orifice, | done hyperlinks to the component with the worst priced distributor | (RS/Farnell) in the next column....no problems with that | | Now wouldn't it be nice if I could set up the next column with their | stock levels? Just click refresh.........Fat chance | | They seem to be living in Web 0.1 | | Must be this lot | http://www.theregister.co.uk/2008/07/10/levis_erp_costs/ | | | martin Here in the US I use www.partminer.com . I can get a good indication of who has what quantity. But I doubt it is always up to date. Cheers | ||||||||||||||||||||||||||||||||||
|
Posted by on July 12, 2008, 10:46 pm
Please log in for more thread options > I've imported the CSV bom from my schematic program into open orifice,
> done hyperlinks to the component with the worst priced distributor > (RS/Farnell) in the next column....no problems with that > > Now wouldn't it be nice if I could set up the next column with their > stock levels? Just click refresh.........Fat chance > > They seem to be living in Web 0.1 > > Must be this lothttp://www.theregister.co.uk/2008/07/10/levis_erp_costs/ > > martin Hmm, I also live in the Stone Age.I create an "order text file" for Digikey, I upload the text file as an order and I get to see it all in one shot: price and stock. Of course it's a manual process, but I suppose it could be done programmatically. I don't do it that often. | ||||||||||||||||||||||||||||||||||
|
Posted by James Morrison on July 13, 2008, 2:14 pm
Please log in for more thread options On 2008/Jul/12 6:04 PM, in article
pu8i74lh8961oaojgfuqteatpk93o2io3f@4ax.com, "Martin Griffith" > I've imported the CSV bom from my schematic program into open orifice,
> done hyperlinks to the component with the worst priced distributor > (RS/Farnell) in the next column....no problems with that > > Now wouldn't it be nice if I could set up the next column with their > stock levels? Just click refresh.........Fat chance Hello Martin, I've thought the same thing and so we did something about it. In about a month we'll be releasing a java program (so platform independent) that will do just that: take a csv, auto-detect a few columns (the distributor part number and quantity), access the distributors database, find the best price for the number of assemblies across a few derived part numbers (different packaging available), and then check to make sure there is enough stock for the number of items needed (num assemblies time board quantity). Finally add the unit price, line cost, etc to the BOM and output as a new .csv file. This will be released as an CadSoft EAGLE tool specifically, but the java program is tool independent: csv in and out. Any other schematic tool that can create the .csv input file with the few number of columns that are required will work just fine. This tool will add the new columns (pricing, quantity available and some extra verification columns like ROHS status, manufacturer and part number). It won't edit or change any other column so you can have your own custom columns (like the links) so you can have an unlimited number of these. I can't quite announce the distributor just yet as we are finalising details. But you will know who they are and we use them all the time. The price is TBD but it will be very reasonable. Check in at the website below for the announcement in the next few weeks. The tool is in beta testing right now. Cheers, James. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ ~ ~ James Morrison ~~~ Stratford Digital ~ ~ ~ ~ email: sales@eagletoolkit.com ~ ~ fax: 888.701.8097 ~ ~ web: http://www.eagletoolkit.com ~ ~ ~ ~ Online EAGLE Dealer for US and Canada ~ ~ EAGLE Design Experts ~ ~ EAGLE Enterprise Toolkit ~ ~ ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ** Posted from http://www.teranews.com ** | ||||||||||||||||||||||||||||||||||
| Similar Threads | Posted |
| B.O.M> spreadsheet> distributor>stock levels | July 12, 2008, 6:04 pm |
| global sea ice levels now same as levels in 1979 | January 1, 2009, 1:09 pm |
| distributing spreadsheet revisions | December 19, 2007, 7:52 am |
| Spreadsheet as realtime viewer? | May 30, 2007, 9:01 pm |
| interface miniLAB 1008 to Excel spreadsheet? | September 14, 2005, 12:25 am |
| RS-232 levels to computer | March 10, 2006, 1:29 pm |
| 802.3 signal levels | September 28, 2006, 3:28 pm |
| Four Logic Levels | April 30, 2008, 10:09 am |
| About various levels of spice models | December 5, 2006, 11:09 am |
| DDR2 Vdd and signal levels... | August 18, 2007, 8:05 pm |
| Re: PSpice Logic Levels | September 5, 2008, 3:32 pm |
| LM339 comparator input levels | February 27, 2007, 9:54 pm |
| How to set automatically unknow trigger levels? | May 10, 2007, 6:29 am |
| Re: PCB trace spacing for voltage levels | November 4, 2007, 5:07 am |
| Re: PCB trace spacing for voltage levels | November 4, 2007, 8:44 am |
> I've imported the CSV bom from my schematic program into open orifice,
> done hyperlinks to the component with the worst priced distributor
> (RS/Farnell) in the next column....no problems with that
>
> Now wouldn't it be nice if I could set up the next column with their
> stock levels? Just click refresh.........Fat chance
>
> They seem to be living in Web 0.1
>
> Must be this lot
> http://www.theregister.co.uk/2008/07/10/levis_erp_costs/