Trouble With Internet Open As Data (JMP12)<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />Hi,
I am having trouble reading an internet table. The table is internal to our company, so I am not able to share the link. I am using JMP12.
- If I use File --> Internet Open --> Open As Data, then JMP can import the table headers, but not the table data.
- If I use File --> Internet Open --> Open As Web page --> File --> Import Table as Data Table, then JMP will encounter two script errors (below). If I bypass these errors, then JMP can import both headers and data, as I would expect.
An example of the table source code and error messages are attached. Any ideas about how to resolve this? Or even better: is it possible to script around this?
Thanks!
Re: Trouble With Internet Open As Data (JMP12)Thanks again Eric.
Re: Trouble With Internet Open As Data (JMP12)While you're at it, if "run", "context", "reads (100/250K)", "readlength (2K)", etc., are supposed to be headers, you'd be better off if they were in tags rather than tags. If they are in tags, they will automatically be set as column names. In tags, they are going to be assumed to be the first row of data. Here is an example:
|
| MyCol1 |
|---|
| MyCol2 |
|---|
| MyCol3 |
|---|
| MyCol4 |
|---|
|
| 1 |
| 2 |
| 3 |
| 4 |
Re: Trouble With Internet Open As Data (JMP12)Thanks Eric. I will pass this on to the website admin.
Re: Trouble With Internet Open As Data (JMP12)Hey, robot,
I'm not the expert on Internet Open, but, looking at your HTML snippet, you've got tags appearing outside the context of tags. I dummied up a quick example, and data that was present in tags that were not enclosed in tags shows up in the browser, but JMP Internet Open does not find that data. My understanding is that tags *must* be nested inside of tags in correct HTML.
Also, I don't see a closing tag, although I might have missed it. JMP definitely does not like a missing closing tag.
HTH,
Eric
