Auto Mouser Part Lookup

[mpm]

Anybody know a way to create a link to a Mouser part, by just using the part number?

For example, on Digikey, if my BOM has part "NCP785AH50T1GOSCT-ND", then
I can use Excel to concatenate the link: https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-ND

Is there a URL string for Mouser that does the same thing?

 

[Rich S]

On Monday, February 17, 2020 at 10:46:45 PM UTC-5, mpm wrote:

Anybody know a way to create a link to a Mouser part, by just using the part number?

For example, on Digikey, if my BOM has part "NCP785AH50T1GOSCT-ND", then
I can use Excel to concatenate the link: https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-ND

Is there a URL string for Mouser that does the same thing?

Hmm, best I can see with easy poking around is

https://www.mouser.com/ProductDetail/863-NCP785AH50T1G

or

https://www.mouser.com/QuickViewProdDetail.aspx?PartNum=863-NCP785AH50T1G

where the "863" seems to be Mouser's internal group code. If all you're
listing are just narrow range of types, then you could figure out
Mouser's coding without too much trouble. But if you're looking at
a lot of types of parts and time is short, well, ask them. It's not
like it should be all secret.

(800) 346-6873
sales@mouser.com
1000 North Main Street
Mansfield, TX 76063
USA


cheers, Rich S.

 

mpm <mpmillard@aol.com> wrote in
news:e4e6187f-ecba-4d10-b19f-f2f611684e58@googlegroups.com:

Anybody know a way to create a link to a Mouser part, by just
using the part number?

For example, on Digikey, if my BOM has part
"NCP785AH50T1GOSCT-ND", then I can use Excel to concatenate the
link:
https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-ND

Is there a URL string for Mouser that does the same thing?

I made a spreadsheet cell line (a few minutes ago) that takes the
query segment of your link and adds it to ANY part number you put in
and makes your completed search link from it...

 

mpm <mpmillard@aol.com> wrote in
news:e4e6187f-ecba-4d10-b19f-f2f611684e58@googlegroups.com:

Anybody know a way to create a link to a Mouser part, by just
using the part number?

For example, on Digikey, if my BOM has part
"NCP785AH50T1GOSCT-ND", then I can use Excel to concatenate the
link:
https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-ND

Is there a URL string for Mouser that does the same thing?

You can do it by hand (tiny URL), but the only link I saw you could
give was to the data sheet for the part.

 

[mpm]

On Tuesday, February 18, 2020 at 6:27:07 AM UTC-5, DecadentLinux...@decadence.org wrote:

mpm wrote in
news:e4e6187f-ecba-4d10-b19f-f2f611684e58@googlegroups.com:

Anybody know a way to create a link to a Mouser part, by just
using the part number?

For example, on Digikey, if my BOM has part
"NCP785AH50T1GOSCT-ND", then I can use Excel to concatenate the
link:
https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-ND

Is there a URL string for Mouser that does the same thing?



I made a spreadsheet cell line (a few minutes ago) that takes the
query segment of your link and adds it to ANY part number you put in
and makes your completed search link from it...

For Mouser or Digikey?
I already got the Digikey to work.

I may have to call Mouser today and ask if they have a URL or API that can do this.

 

[mpm]

On Tuesday, February 18, 2020 at 6:41:42 AM UTC-5, mpm wrote:

This seems to work, where MANUFACTURER'S Part # is everything after the equal sign: (and appears to also work using Mouser's Part #, but I need to test it further).


https://www.mouser.com/Search/Refine?Keyword=LM2575HVT-3.3/NOPB

 

mpm <mpmillard@aol.com> wrote in
news:201e927a-b339-4aac-9670-7187a4ff7b6d@googlegroups.com:

On Tuesday, February 18, 2020 at 6:41:42 AM UTC-5, mpm wrote:

This seems to work, where MANUFACTURER'S Part # is everything
after the equal sign: (and appears to also work using Mouser's
Part #, but I need to test it further).


https://www.mouser.com/Search/Refine?Keyword=LM2575HVT-3.3/NOPB

I may have to make it an older version for those not up to date on
Office yet.

<http://www.mediafire.com/file/qogxwbswyvw9tcw/PartBook.xlsx/file>

 

DecadentLinuxUserNumeroUno@decadence.org wrote in news:r2gp70$hpl$1
@gioia.aioe.org:

I may have to make it an older version for those not up to date on
Office yet.

http://www.mediafire.com/file/qogxwbswyvw9tcw/PartBook.xlsx/file

What? No critique on my workbook yet?

 

DecadentLinuxUserNumeroUno@decadence.org wrote in
news:r2i0u7$a1l$1@gioia.aioe.org:

DecadentLinuxUserNumeroUno@decadence.org wrote in
news:r2gp70$hpl$1 @gioia.aioe.org:


I may have to make it an older version for those not up to date
on
Office yet.

http://www.mediafire.com/file/qogxwbswyvw9tcw/PartBook.xlsx/file


What? No critique on my workbook yet?

OOps... here is the 2003 compatible version...

<http://www.mediafire.com/file/38lzbxd5heog0yq/PartBookCompatible.xls
/file>

 

[mpm]

On Tuesday, February 18, 2020 at 8:00:28 PM UTC-5,

Thanks for that excel file, but I'm not sure what it does.
It looks like it's just concatenating the URL prefix to the selection from a drop-down.

I already had a URL (for DK), but not for Mouser.
And a formula works better for our needs than a form.

Anyway, my apologies if I confused the ask.

 

mpm <mpmillard@aol.com> wrote in
news:67400ab7-0bb1-4d5c-9ac6-b708d3b61951@googlegroups.com:

On Tuesday, February 18, 2020 at 6:27:07 AM UTC-5,
DecadentLinux...@decadence.org wrote:
mpm wrote in
news:e4e6187f-ecba-4d10-b19f-f2f611684e58@googlegroups.com:

Anybody know a way to create a link to a Mouser part, by just
using the part number?

For example, on Digikey, if my BOM has part
"NCP785AH50T1GOSCT-ND", then I can use Excel to concatenate the
link:
https://www.digikey.com/products/en?keywords=NCP785AH50T1GOSCT-N
D

Is there a URL string for Mouser that does the same thing?



I made a spreadsheet cell line (a few minutes ago) that takes
the
query segment of your link and adds it to ANY part number you put
in and makes your completed search link from it...

For Mouser or Digikey?
I already got the Digikey to work.

I may have to call Mouser today and ask if they have a URL or API
that can do this.

Actually, it is for both mouser and digikey. The user puts in part
numbers in a list, then chooses whichever search he or she wants then
picks the part number from a drop down list, and the link is
generated and clickable instantly. The logos ensure that you are not
making the right search on the wrong site.

Voila'

 

mpm <mpmillard@aol.com> wrote in
news:6da4123a-b0ee-4c30-b76e-b118c8144ae1@googlegroups.com:

On Tuesday, February 18, 2020 at 8:00:28 PM UTC-5,

Thanks for that excel file, but I'm not sure what it does.
It looks like it's just concatenating the URL prefix to the
selection from a drop-down.

I already had a URL (for DK), but not for Mouser.
And a formula works better for our needs than a form.

Anyway, my apologies if I confused the ask.

Right. It allows you to put the PN you want to search for in the
drop down list. Then go to either search tab and select it from that
list and it will make the link for you, and then click the link and
it takes you to the site.

The list is so you can keep your searches. If that is not desired
simply only use the top line in the list for your search criteria.

I thought it was pretty obvious what it does.

I guess I need to put a better instructional on my shit... errr
sheet.

 

[mpm]

On Sunday, February 23, 2020 at 4:36:37 PM UTC-5, DecadentLinux...@decadence.org wrote:

The list is so you can keep your searches. If that is not desired
simply only use the top line in the list for your search criteria.

I thought it was pretty obvious what it does.

I guess I need to put a better instructional on my shit... errr
sheet.

Seriously.... thanks!!
However, what your solution does is very simple -- but overly complicated for my needs.

I can just as easily use Excel's CONCATENATE command to combine the BASE URL, and append that part # to the end of the string.

Like this: =CONCATENATE("base_URL" & CELL)
I don't really need the drop-downs, multiple tabs, graphics, etc...
Just the inline equation suffices.

That said, I'm sure some folks will find the solution you presented very worthwhile, just not a good fit for me. I do understand it - it is self-explanatory. This week's design involves over 700 different parts, just FYI.
(And by "week", I mean of course the "project that never ends".

Today, I played around with JSON and Digikey's API.
Between that, and the CONCATENATE command, I can do everything I need to regarding an automated BOM. Will try to find something similar for Mouser, but thankfully, we purchase a lot more Digikey than Mouser and the rest, so if that part still has to be done by hand, not a deal-breaker.

 

mpm <mpmillard@aol.com> wrote in
news:dbc68164-b4b2-415b-af77-61c5ac962185@googlegroups.com:

On Sunday, February 23, 2020 at 4:36:37 PM UTC-5,
DecadentLinux...@decadence.org wrote:


The list is so you can keep your searches. If that is not
desired
simply only use the top line in the list for your search
criteria.

I thought it was pretty obvious what it does.

I guess I need to put a better instructional on my shit...
errr
sheet.

Seriously.... thanks!!
However, what your solution does is very simple -- but overly
complicated for my needs.

I can just as easily use Excel's CONCATENATE command to combine
the BASE URL, and append that part # to the end of the string.

Like this: =CONCATENATE("base_URL" & CELL)
I don't really need the drop-downs, multiple tabs, graphics,
etc... Just the inline equation suffices.

That said, I'm sure some folks will find the solution you
presented very worthwhile, just not a good fit for me. I do
understand it - it is self-explanatory. This week's design
involves over 700 different parts, just FYI. (And by "week", I
mean of course the "project that never ends".

Today, I played around with JSON and Digikey's API.
Between that, and the CONCATENATE command, I can do everything I
need to regarding an automated BOM. Will try to find something
similar for Mouser, but thankfully, we purchase a lot more Digikey
than Mouser and the rest, so if that part still has to be done by
hand, not a deal-breaker.

Cocatenate is good, but if you are simply placing text strings
together, you can use cell contents and link texts together by simply
ading an ampersand character. as in (leave the quotes out)
"=A1&B1"

The ampersand turns off the excel math function usually associated
with making a cell a formula and treats it as text.

So whatever your front end prefix is in one cell (or even simply in
the formula itself) and you search part number in the other. I think
it will still fail on certain URL unfriendly characters, if any part
numbers have that in them. So:

=https://www.digikey.com/Search/Refine?keyword=&B1
Is all you need where B1 contains the search PN.

The ampersand is all you need. Mine converts the finished text into
a clickable link. Concatenate and the ampersand do not, so excel can
do that too. So

=HYPERLINK(A1&B1)

A1 has the string prefix for the search string and B1 contains the
desired Part Number. No concatenate needed.

Or for the mouser string directly in the formula would then be:

HYPERLINK((https://www.digikey.com/Search/Refine?keyword=)&B1))

 

[mpm]

On Monday, February 24, 2020 at 6:17:06 AM UTC-5,


I love Excel.
A neat trick I needed a couple weeks ago, but "forgot" about was the ability to sum a column of numbers that had been imported as, or converted to text.

For example...
All you have to do is SUMPRODUCT((A1:A50)*1)

That little "*1" at the end does all the type conversion magic!

 

[Rob]

mpm <mpmillard@aol.com> wrote:

On Monday, February 24, 2020 at 6:17:06 AM UTC-5,


I love Excel.
A neat trick I needed a couple weeks ago, but "forgot" about was the ability to sum a column of numbers that had been imported as, or converted to text.

For example...
All you have to do is SUMPRODUCT((A1:A50)*1)

That little "*1" at the end does all the type conversion magic!

I hate Excel. When importing a list of telephone numbers (which start
with 0 here when they are inter-area or 00 when international), Excel
decides that they are numbers and converts them, dropping the leading zeroes.

Because of that (and similar problems) I always indicate the proper data
type when importing data.

 

[Winfield Hill]

Rob wrote...

I hate Excel. When importing a list of telephone numbers (which start
with 0 here when they are inter-area or 00 when international), Excel
decides that they are numbers and converts them, dropping the leading zeroes.

Because of that (and similar problems) I always indicate the proper data
type when importing data.

How could Excel automatically make the correct choice for all kinds
of ASCII data? They do give a simple effective way to customize your
data input, which you can save in a macro if you do the process often.


--
Thanks,
- Win

 

[Rob]

Winfield Hill <winfieldhill@yahoo.com> wrote:

Rob wrote...

I hate Excel. When importing a list of telephone numbers (which start
with 0 here when they are inter-area or 00 when international), Excel
decides that they are numbers and converts them, dropping the leading zeroes.

Because of that (and similar problems) I always indicate the proper data
type when importing data.

How could Excel automatically make the correct choice for all kinds
of ASCII data? They do give a simple effective way to customize your
data input, which you can save in a macro if you do the process often.

Excel could know that when it reads data like 001 the user apparently
wants to preserve leading zeroes. I have no problem when it converts
it to numeric, when it keeps the precision, but it should keep the format
as well. When it cannot or does not want to do that, it should keep it
as a string so it will not be damages.

(there is another issue: when the telephone number is suffciently long,
it cannot be stored as an integer and Excel converts it to floating point)