Re: gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
DJ, Wow, i *really* wish that I had known that earlier. No need for some script if you can just upload the file directly... indeed, i should have guessed that such functionality existed! I guess all is not lost, though, as now we have some way of programmatically interacting with the digikey website. maybe in the future I'll use it to sort available parts by *price*. (e.g. something to automate selection of surface mount resistors and capacitors, which i find tedious). Maybe even with a UI or something. thanks, Tim On Fri, Feb 13, 2009 at 6:05 PM, DJ Delorie wrote: > > You know, you can just upload a CSV spreadsheet to Digikey's master > ordering module. My BOM scripts export the .csv file, I just send it > to them and it orders everything on the list. > > I don't know how (or if) you'd do it without logging in, but when you > do log in, just use "Order File Upload". > > > ___ > geda-user mailing list > geda-user@moria.seul.org > http://www.seul.org/cgi-bin/mailman/listinfo/geda-user > ___ geda-user mailing list geda-user@moria.seul.org http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
Re: gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
On Feb 13, 2009, at 4:26 PM, evan foss wrote: > On Fri, Feb 13, 2009 at 7:14 PM, Steven Michalske > wrote: >> might add a delay to the add action make it like a human is entering >> them :-P > > I don't think Digikey cares how you are ordering. > >>> Digikey's >>> webserver occasionally balks under the torrent of POST and GETs The point i was making is that a delay may allow the system to not balk. >> >> hardkrash >> >> On Feb 13, 2009, at 1:59 PM, Tim Hanson wrote: >> >>> Hi All, >>> >>> I wrote this script yesterday as I needed to enter ~200 parts into >>> Digikey, and didn't want to make any mistakes. It reads in a CSV >>> file, establishes a TCP connection with the Digikey ordering web >>> server, and repeatedly POSTs the quantities in your spreadsheet onto >>> the active server pages. If the minimum quantities are not met for >>> any of your items, it will first guess the next multiple of 10, >>> and if >>> that does not work, it will ask you for the quantity. Digikey's >>> webserver occasionally balks under the torrent of POST and GETs, in >>> which case you'll have to kill the script, start a new web order, >>> and >>> try again. >>> >>> hope this is useful to someone other than myself. >>> >>> Tim >>> -- >>> source: >>> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/digikeyweborder.ml >>> makefile: >>> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/Makefile >>> readme: >>> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/README >>> >>> >>> ___ >>> geda-user mailing list >>> geda-user@moria.seul.org >>> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user >> >> >> >> ___ >> geda-user mailing list >> geda-user@moria.seul.org >> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user >> > > > > -- > http://www.coe.neu.edu/~efoss/ > http://evanfoss.googlepages.com/ > > > ___ > geda-user mailing list > geda-user@moria.seul.org > http://www.seul.org/cgi-bin/mailman/listinfo/geda-user ___ geda-user mailing list geda-user@moria.seul.org http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
Re: gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
On Fri, Feb 13, 2009 at 7:14 PM, Steven Michalske wrote: > might add a delay to the add action make it like a human is entering > them :-P I don't think Digikey cares how you are ordering. > > hardkrash > > On Feb 13, 2009, at 1:59 PM, Tim Hanson wrote: > >> Hi All, >> >> I wrote this script yesterday as I needed to enter ~200 parts into >> Digikey, and didn't want to make any mistakes. It reads in a CSV >> file, establishes a TCP connection with the Digikey ordering web >> server, and repeatedly POSTs the quantities in your spreadsheet onto >> the active server pages. If the minimum quantities are not met for >> any of your items, it will first guess the next multiple of 10, and if >> that does not work, it will ask you for the quantity. Digikey's >> webserver occasionally balks under the torrent of POST and GETs, in >> which case you'll have to kill the script, start a new web order, and >> try again. >> >> hope this is useful to someone other than myself. >> >> Tim >> -- >> source: >> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/digikeyweborder.ml >> makefile: >> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/Makefile >> readme: >> http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/README >> >> >> ___ >> geda-user mailing list >> geda-user@moria.seul.org >> http://www.seul.org/cgi-bin/mailman/listinfo/geda-user > > > > ___ > geda-user mailing list > geda-user@moria.seul.org > http://www.seul.org/cgi-bin/mailman/listinfo/geda-user > -- http://www.coe.neu.edu/~efoss/ http://evanfoss.googlepages.com/ ___ geda-user mailing list geda-user@moria.seul.org http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
Re: gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
might add a delay to the add action make it like a human is entering them :-P hardkrash On Feb 13, 2009, at 1:59 PM, Tim Hanson wrote: > Hi All, > > I wrote this script yesterday as I needed to enter ~200 parts into > Digikey, and didn't want to make any mistakes. It reads in a CSV > file, establishes a TCP connection with the Digikey ordering web > server, and repeatedly POSTs the quantities in your spreadsheet onto > the active server pages. If the minimum quantities are not met for > any of your items, it will first guess the next multiple of 10, and if > that does not work, it will ask you for the quantity. Digikey's > webserver occasionally balks under the torrent of POST and GETs, in > which case you'll have to kill the script, start a new web order, and > try again. > > hope this is useful to someone other than myself. > > Tim > -- > source: > http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/digikeyweborder.ml > makefile: > http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/Makefile > readme: > http://code.google.com/p/kicadocaml/source/browse/trunk/scripts/README > > > ___ > geda-user mailing list > geda-user@moria.seul.org > http://www.seul.org/cgi-bin/mailman/listinfo/geda-user ___ geda-user mailing list geda-user@moria.seul.org http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
Re: gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
You know, you can just upload a CSV spreadsheet to Digikey's master ordering module. My BOM scripts export the .csv file, I just send it to them and it orders everything on the list. I don't know how (or if) you'd do it without logging in, but when you do log in, just use "Order File Upload". ___ geda-user mailing list geda-user@moria.seul.org http://www.seul.org/cgi-bin/mailman/listinfo/geda-user
