Forums
Clan List Logger
Quick find code: 86-87-226-65189098
Hmm, using the typical space, letters and numbers I had no problems using vlookup or hlookup on the data. What does the formula look like that doesn't return as expected?
ImportData("[clan api url]"
imports the clan data as a table into the sheet.
ImportData("[clan api url]"
imports the clan data as a table into the sheet.
.:
Blasty
the Blue
:.
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
04-Dec-2014 01:48:51
The problem with importdata is that you have one cell filled with valuable information, but I have no idea how to extract the valuble information.
Take a look at this link:
https://docs.google.com/spreadsheets/d/1yOC4qlQBTANhuJaB5eK24BkEEQPNz1_umiIEZqVSF7A/edit?usp=sharing
Sheet A => Weirdest glitch ever!
Type in different names in C1 and C2. If the name has space in it, it wont find it. If the name has no space in it, it will find it just fine. I tried concatenating spaces into the edges, then trimming it out, and so many other weird stuff to find my way around, but no avail. Also, sorting them all and making the Vlookup function look in "True" in sorting makes it work, but it's not applicable to what I want to use it. It has to work on "False". Tell me if you have any way around this.
Sheet B => I'd appreciate it if you could show me how to extract the information. Or it could be that I am using the wrong link :S.
Link input is A19
The rank and name information is at CS517
Thanks!
Founder of
Ebram 72
Take a look at this link:
https://docs.google.com/spreadsheets/d/1yOC4qlQBTANhuJaB5eK24BkEEQPNz1_umiIEZqVSF7A/edit?usp=sharing
Sheet A => Weirdest glitch ever!
Type in different names in C1 and C2. If the name has space in it, it wont find it. If the name has no space in it, it will find it just fine. I tried concatenating spaces into the edges, then trimming it out, and so many other weird stuff to find my way around, but no avail. Also, sorting them all and making the Vlookup function look in "True" in sorting makes it work, but it's not applicable to what I want to use it. It has to work on "False". Tell me if you have any way around this.
Sheet B => I'd appreciate it if you could show me how to extract the information. Or it could be that I am using the wrong link :S.
Link input is A19
The rank and name information is at CS517
Thanks!
Founder of
¤'•,¸
72
¸,•'¤
Ebram 72
04-Dec-2014 02:12:22
The clan member list page is only potentially useful for getting membership status, is that what you're trying to find out?
It'd be much better to use apps script to extract that data than spreadsheet functions. I'll have a look anyway.
Edit: I've made a custom function in apps script that returns a table of the data based on the results of importing the clan member list.
Original message details are unavailable.
function getMembership(obj){
return [["Name","Rank","Member","Total XP","Kills","Online"]].concat(obj.map(function(a){return a.join(""
}).join(""
.split("membersListRow"
.slice(1).map(function(row){var col=function(cls){return row.match(RegExp('"'+cls+'">([^<]*)'))},name=col("name"
,member=/pro\.png/.test(row),rank=col("clanRank"
,totalxp=col("totalXP"
,kills=col("kills"
,world=col("world"
;return [name[1],rank[1],member?"Member":"",parseInt(totalxp[1].replace(",",""
),parseInt(kills[1]),world[1].replace(/\n/g,""
]}))
}
It'd be much better to use apps script to extract that data than spreadsheet functions. I'll have a look anyway.
Edit: I've made a custom function in apps script that returns a table of the data based on the results of importing the clan member list.
Original message details are unavailable.
function getMembership(obj){
return [["Name","Rank","Member","Total XP","Kills","Online"]].concat(obj.map(function(a){return a.join(""
}).join(""
.split("membersListRow"
.slice(1).map(function(row){var col=function(cls){return row.match(RegExp('"'+cls+'">([^<]*)'))},name=col("name"
,member=/pro\.png/.test(row),rank=col("clanRank"
,totalxp=col("totalXP"
,kills=col("kills"
,world=col("world"
;return [name[1],rank[1],member?"Member":"",parseInt(totalxp[1].replace(",",""
),parseInt(kills[1]),world[1].replace(/\n/g,""
]}))
}
.:
Blasty
the Blue
:.
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
04-Dec-2014 07:48:08 - Last edited on 04-Dec-2014 10:56:52 by Blasty
Hey,
Day 385 using the clan logger
Something I found out awhile ago with the new google sheets, is that with all the scripts that you made, you can't actually convert it directly to the new google sheets and there are several other sheets that my clan have added to the spreadsheet that could use some of the new functions. I was wondering if you weren't too busy, could you make a new version on the new google spreadsheets?
Thanks again!
~Dash Dash - Founder of the NomNom Family | T7 + 3 Avatars | Recruiting Social and mature members |
Day 385 using the clan logger
Something I found out awhile ago with the new google sheets, is that with all the scripts that you made, you can't actually convert it directly to the new google sheets and there are several other sheets that my clan have added to the spreadsheet that could use some of the new functions. I was wondering if you weren't too busy, could you make a new version on the new google spreadsheets?
Thanks again!
~Dash Dash - Founder of the NomNom Family | T7 + 3 Avatars | Recruiting Social and mature members |
04-Dec-2014 09:54:09
Could you share the sheet with [email protected]
.:
Blasty
the Blue
:.
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of
Mine Nation
06-Dec-2014 01:25:59
Quick find code: 86-87-226-65189098 Back to Top