XML Import Error

[Will Beatts]

I am using a sheet a friend made, which stopped working properly.

Whenever I try to update the connections from eve central it gives a "No elements mapped" & "No data was imported or only some of the data was imported"

One of the connections I have is: http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&usesystem=30000142

Re-creating the connections makes the doc work again, but when I close the doc and reopen it, the errors return.

Any ideas? I've already tried reinstalling excel (several times) and a clean windows reinstall.

[Will Beatts]

The following connection works when initially created

http://api.eve-central.com/api/marketstat?typeid=2869&typeid=2870&typeid=2868&typeid=2871&typeid=2872&typeid=2875&typeid=2867&typeid=2876&typeid=3810&typeid=13267&usesystem=30002187

However, when I refresh it, it only imports the first couple of id's

[Gary Hartl]

I have similar problems in google sheets.  I use similar links with IMPORTXML funcion and when i make changes it populates the data, however after a few minutes, i get unable to resolve URL, i've tried using direct URL's vs builing ones from cells, i'm tried shortening the lenght to just one item type, no different.

I have zero solutions to this problem, and it really causes grief.

[Scott Barnes]

I suspect its the redirect that occurs on the eve-central page that makes Google sh**t itself.

[Yann Ramin]

Hmm, which redirect? Using https://api.eve-central.com is free from any redirects. 

--
You received this message because you are subscribed to the Google Groups "EVE-Central" group.
To unsubscribe from this group and stop receiving emails from it, send an email to eve-central...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.