i am working with googledocs to do industry related calculations. to retrieve the data i am using mainly code by fuzzy. to be explicit, those three:
with these i am able to create endless lists of data with item or system IDs and things like prices or cost indexes, which is fine. but i dont know which ID belongs to which item or system name.
can i use an additional function to also retrieve the names? how would such one have to look like? i heard of SDE. how can i work with that? when i am able to just generyte two colums in my googledocs, one with system/item ID and the other with their names, i am good to go.
unfortunately i dont know how to programm/write the needed code for those json files myself. till now i was only able to do slight modifications to fuzzy´s code (which i posted above).
alright i did that. works out great.
now the function loadRegionAggregates( ) seems no longer to work. it says: Internal error while executing the user-defined function. (translated from german)
could you imagine what the problem is? what does this kind of error mean? what do i have to look for?
https://forums.eveonline.com/u/Blacksmoke16 you mean changing the cell, in which i am using this function? did that, but does not make a difference. loading for 30 sec => error
how can i load data from SDE? do i have to download it? do i need some code to retrieve the data from that link?
do yo mean with different worksheet just a new tab/page in my current sheet or a whole new document?
i fixed function loadRegionAggregates( ). the error was due to too much requested data. i forgot to delete some unnecessary itemIDs. SO thats it when fuzzysteve means: to much to handle for googledocs.
now i got a new error when using function =universe_names( ). it says:
{âbodyâ:{âerrorâ:âfailed to coerce value âidâ into type integer (format: int32), âidsâ is requiredâ},âcodeâ:400,âcharacterâ:âBjoern Panzerâ,âsheet_idâ:â1d0yLrIS4B4LC6rPpgT1vyuev7K7xp78GwK3_QAKxjCIâ,âpathâ:âhttps://esi.evetech.net/v2/universe/names/â} (Zeile 308).