Bitcoin Forum
March 19, 2024, 10:41:08 AM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Automatically get post count from bitcointalk to Google Spreadsheet  (Read 513 times)
Zeroxal (OP)
Hero Member
*****
Offline Offline

Activity: 896
Merit: 508



View Profile
February 06, 2016, 02:15:20 PM
 #1

Is there any function that allows me to automatically import the post count as data into a Google spreadsheet? I've tried using the "importhtml" function, which only allows me to import all the data at once (username, activity, postcount etc...).

I only need to get the post count. Not the whole profile page.

Another problem with "importhtml" is that it does not update and only gives you the data once. You need to update that manually.

Any help is appreciated.

Thanks!
1710844868
Hero Member
*
Offline Offline

Posts: 1710844868

View Profile Personal Message (Offline)

Ignore
1710844868
Reply with quote  #2

1710844868
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1710844868
Hero Member
*
Offline Offline

Posts: 1710844868

View Profile Personal Message (Offline)

Ignore
1710844868
Reply with quote  #2

1710844868
Report to moderator
1710844868
Hero Member
*
Offline Offline

Posts: 1710844868

View Profile Personal Message (Offline)

Ignore
1710844868
Reply with quote  #2

1710844868
Report to moderator
Monnt
Legendary
*
Offline Offline

Activity: 938
Merit: 1000


View Profile
February 06, 2016, 09:22:16 PM
 #2

It doesn't seem that hard of a task to code, I could do an "importhtml" type program that isolates the post count from the text, after you put in the user id of your choice. I'll look into this, because it'll be a really good tool for signature campaign managing.
grue
Legendary
*
Offline Offline

Activity: 2058
Merit: 1431



View Profile
February 06, 2016, 09:37:00 PM
 #3

Another problem with "importhtml" is that it does not update and only gives you the data once. You need to update that manually.
or you can use excel with vb.net macros or data sources, which doesn't have this limitation.

It is pitch black. You are likely to be eaten by a grue.

Adblock for annoying signature ads | Enhanced Merit UI
Monnt
Legendary
*
Offline Offline

Activity: 938
Merit: 1000


View Profile
February 06, 2016, 09:57:58 PM
 #4

Another problem with "importhtml" is that it does not update and only gives you the data once. You need to update that manually.
or you can use excel with vb.net macros or data sources, which doesn't have this limitation.
Oh. Never use excel that much, how does this macro work? Does it retrieve the data and save it as an excel, or do we have to modify it?
Zeroxal (OP)
Hero Member
*****
Offline Offline

Activity: 896
Merit: 508



View Profile
February 06, 2016, 10:10:08 PM
 #5

It doesn't seem that hard of a task to code, I could do an "importhtml" type program that isolates the post count from the text, after you put in the user id of your choice. I'll look into this, because it'll be a really good tool for signature campaign managing.
If you have coded it, may you send it to me too Grin
I have no idea with Google spreadsheet coding or anything like that, but I do have some excel macro skill.

I'd  be eternally grateful if you could provide me with that code Wink
grue
Legendary
*
Offline Offline

Activity: 2058
Merit: 1431



View Profile
February 06, 2016, 10:36:32 PM
 #6

http://www.excel-easy.com/vba/range-object.html
https://github.com/VBA-tools/VBA-Web


or just use a real programming language to generate a csv file which you can import

It is pitch black. You are likely to be eaten by a grue.

Adblock for annoying signature ads | Enhanced Merit UI
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!