IT Gurus - Help please !!

patsy_mccabe

Data from ICBF.com
Maybe some of you IT guys could help me on this? I'm trying to make my own cow/bull matcher using MS Excel. I want to compare ICBF data for my own cows and match them to bulls available and see how the offspring would look.

I've most of it done, but I have a problem with reading the Linear Data. Is there any way to automatically read these values in the pop-up windows?
Attached for example is a pic showing the linear data for ZGM. The height at the withers is 34 percentile. The data doesn't seem to be available anywhere else to download.

Click on 'Linear Type' tab;
https://webapp.icbf.com/v2/app/bull-search/view/1019715459

Thanks

Try the computer forums. You might have better luck. But you might need to explain to them what a cow is

I'm sure they think they know what a cow is but you might have to explain the difference between a cow and a bull and why that is important.

_Brian

Unless the raw data is available to download I don’t beleive the information in the pop up can automatically be downloaded. There is probably some fancy script like a screen scraper that might do it but for mere mortals like ourselves I don’t think so.

Duke of Url

Need the Raw data for this.

Seth Brundle

patsy_mccabe wrote: »

I've most of it done, but I have a problem with reading the Linear Data. Is there any way to automatically read these values in the pop-up windows?
Attached for example is a pic showing the linear data for ZGM. The height at the withers is 34 percentile. The data doesn't seem to be available anywhere else to download.

Click on 'Linear Type' tab;
https://webapp.icbf.com/v2/app/bull-search/view/1019715459

Am i correct in thinking that you wish to read the alt text that appears when you hover over the chart on the ICF website?
Even the basic HTML source code doesn't contain the term withers but it's using javaScript to collect that data from a server based on choices - this would make it more difficult to scrape the data you're looking for.
Does the ICF supply raw data?

Deleted User wrote: »

I'm sure they think they know what a cow is but you might have to explain the difference between a cow and a bull and why that is important.

Having a degree in Ag and a MSc in IT is actually a thing!

OP What version of Excel have you got? there are several , 2010, 2013, 2016 , 2019. and Excel 365. Maybe pop that in here.

patsy_mccabe

Seth Brundle wrote: »

Am i correct in thinking that you wish to read the alt text that appears when you hover over the chart on the ICF website? Yes, that's right.
Even the basic HTML source code doesn't contain the term withers but it's using javaScript to collect that data from a server based on choices - this would make it more difficult to scrape the data you're looking for.

Does the ICF supply raw data?
Yes, but ICBF combines all those pop-up figures into composite values known as 'Functionality', Muscle & Skeletal. Composite data is avilable here (the first Excel File linked)
https://www.icbf.com/wp/?page_id=200

Lime Tree Farm

Would a vertical or horizontal lookup table solve it for you. That is if I am reading yyour request properly. If this is the case you could edit out all the unwanted information in the ICBF file, just retain the SIRES and FUNCTIONALITY data that your are only interested in.

patsy_mccabe

Lime Tree Farm wrote: »

Would a vertical or horizontal lookup table solve it for you. That is if I am reading yyour request properly. If this is the case you could edit out all the unwanted information in the ICBF file, just retain the SIRES and FUNCTIONALITY data that your are only interested in.

I've done all that. I used the VLOOKUP function. The problem is all the other values that make up the finctionality figure are not in the Excel file. They are only available visually on the webpage.

I suppose it would lead to information overload, if ICBF put them in the file. Maybe that's their reason for not doing it.

Lime Tree Farm

I did a trial run of converting the ICBF data to excel.

I have Adobe Acrobat Professional software.

The steps I took were:

I right clicked on the ICBF linear tab page, selected print option , and saved the page as PDF.
I then opened the file in Acrobat, and saved the acrobat file under the Excel spreadsheet option.
I have opened this in Excel, and it is editable.

ganmo

Lime Tree Farm wrote: »

I did a trial run of converting the ICBF data to excel.

I have Adobe Acrobat Professional software.

The steps I took were:

I right clicked on the ICBF linear tab page, selected print option , and saved the page as PDF.
I then opened the file in Acrobat, and saved the acrobat file under the Excel spreadsheet option.
I have opened this in Excel, and it is editable.

There are websites that will convert pdf to excel format too.
Small pdf is the one I tend to use