|
Title: Automatically get post count from bitcointalk to Google Spreadsheet Post by: Zeroxal on February 06, 2016, 02:15:20 PM 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! Title: Re: Automatically get post count from bitcointalk to Google Spreadsheet Post by: Monnt on February 06, 2016, 09:22:16 PM 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.
Title: Re: Automatically get post count from bitcointalk to Google Spreadsheet Post by: grue on February 06, 2016, 09:37:00 PM 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.Title: Re: Automatically get post count from bitcointalk to Google Spreadsheet Post by: Monnt on February 06, 2016, 09:57:58 PM 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.Title: Re: Automatically get post count from bitcointalk to Google Spreadsheet Post by: Zeroxal on February 06, 2016, 10:10:08 PM 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 ;DI 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 ;) Title: Re: Automatically get post count from bitcointalk to Google Spreadsheet Post by: grue on February 06, 2016, 10:36:32 PM 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 |