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 d...@delorie.com 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
gEDA-user: fyi: program to enter spreadsheet contents into a Digi-Key web-order
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
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
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
On Fri, Feb 13, 2009 at 7:14 PM, Steven Michalske smichal...@gmail.com 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
On Feb 13, 2009, at 4:26 PM, evan foss wrote: On Fri, Feb 13, 2009 at 7:14 PM, Steven Michalske smichal...@gmail.com 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