I think the option for both, as requested by jackg a year ago, would be the best solutions.
For my own personal scripts, the current format is ideal. But i see the reasoning behind ID's instead of usernames.
Topic: Request @theymos: Can you show userIDs instead of user names in trust.txt.xz? (Read 585 times)
June 03, 2020, 07:54:45 AM
June 03, 2020, 03:42:48 AM
Bump:
Bump: since more and more users change their username, I'd really like to have this request granted!
February 04, 2019, 04:46:32 AM
I checked 2 of the usernames that gave me a hard time:
https://bitcointalksearch.org/user/--131122
https://bitcointalksearch.org/user/sakura-249929
I think I pulled it off. I've converted trust.txt into trust.userIDs.txt. As far as I can tell, I covered all usernames it without any mistakes.https://bitcointalksearch.org/user/--131122
https://bitcointalksearch.org/user/sakura-249929
My request still stands, as it makes things much easier, but for now it works for me. I'll publish weekly updates through LoyceV's Trust list viewer.
February 03, 2019, 11:14:08 AM
<…> Peraphs is better to use this db in here https://bitcointalksearch.org/topic/m.47728970 even if it's not guaranteed either the will be all the id available.
That’s kind of what I do. I start try to retrieve the profile id from the merited profiles I download, and default to your December 2018 DB for those unmerited.This month I got something like 15 to 20 profiles I had to retrieve manually (using the search profile option), since they were created from December 2018 onwards. Retrieving a few manually is fine, but if many new profiles enter the scene, then retrieving the info for drawing the trust relations becomes a bit cumbersome. User Ids in the trust.txt file would improve retrieval options (better as a separate file as has been suggested on this thread).
February 03, 2019, 12:41:13 AM
ya it's strange, i checked those names and they are not there, i am not sure how piggy retrieve his data , does bpip has any database similar to piggy's format?
The users in there are only those which ever sent or received any merit, so for trust purposes is not complete.
Peraphs is better to use this db in here https://bitcointalksearch.org/topic/m.47728970 even if it's not guaranteed either the will be all the id available.
February 02, 2019, 04:30:17 PM
does bpip has any database similar to piggy's format?
No, I scraped the usernames one by one from BPIP. 
February 02, 2019, 04:10:58 PM
I checked 2 of the usernames that gave me a hard time:
https://bitcointalksearch.org/user/--131122
https://bitcointalksearch.org/user/sakura-249929
They're not in there. There are only a few that give me a hard time.
https://bitcointalksearch.org/user/--131122
https://bitcointalksearch.org/user/sakura-249929
They're not in there. There are only a few that give me a hard time.
ya it's strange, i checked those names and they are not there, i am not sure how piggy retrieve his data , does bpip has any database similar to piggy's format?
February 02, 2019, 01:56:13 PM
you can download the .txt file with complete list here > https://file.io/HIZ47N
I checked 2 of the usernames that gave me a hard time:https://bitcointalksearch.org/user/--131122
https://bitcointalksearch.org/user/sakura-249929
They're not in there. There are only a few that give me a hard time.
Quote
1- copy paste new users from piggys tools using "desc" order.( done once at every update you make)
2- copy paste the trust.txt data to the excel file.
Thanks for the work you put in, but I'm looking for a more permanent solution with less manual work. I'm trying a different approach now, if it works I'll post a weekly "trust_id.txt.xz" (thanks Coin-1 for the name). 2- copy paste the trust.txt data to the excel file.
February 02, 2019, 01:41:23 PM
just send me a an excel or text file with all usrename and ids
Getting the userIDs with the usernames is the problem.it's not, it's very simple, using piggy's tool > https://albertoit.github.io/Merit-Explorer-SQL/ ( last update according to piggy is last friday 1 feb 2019)
use this query
Code:
select username,userid from userdata
order by userid
if you wish to see the last userid first in case so that you will only copy the new users that you don't have , use this query
Code:
select username,userid from userdata
order by userid desc
hit execute.
copy all users and ids, paste them in an excel file( or wherever you want them to be) and you will get 2 rows , userid and username
to speed things up , i copied everything (ctrl + A) pasted it in a text file and simply removed everything above the tables. and i got something like this
Code:
UserId UserName
3 satoshi
4 sirius
11 madhatter
13 SmokeTooMuch
24 dwdollar
26 NewLibertyStandard
29 giik
30 BitcoinFX
33 m0mchil
35 theymos
40 xc
you can download the .txt file with complete list here > https://file.io/HIZ47N
last user id = 2528400
i'll upload an excel file a bit later which will parse the format to this
Code:
35t203
35t3420
35t4171
you will still have to do a bit of manual work every time you want to update it.
1- copy paste new users from piggys tools using "desc" order.( done once at every update you make)
2- copy paste the trust.txt data to the excel file.
not a perfect approach but something you can work with.
February 02, 2019, 11:20:17 AM
just send me a an excel or text file with all usrename and ids
Getting the userIDs with the usernames is the problem. February 02, 2019, 10:45:48 AM
this is pretty easy to parse using Excel.
you just need the 2 rows for username and id (M,N)
copy-paste the data frum trust.txt to (I,J)
use the function below on any 2 columns you want and it will parse the results for you
*you need to replace I with J for the trustee column.
of course i assume you know how to put these in a single column if needed and how to add whatever separators you want.
if you having a trouble with it, just send me a an excel or text file with all usrename and ids, i'l upload an excel file where you just need to import the trust.txt and everything else will be automated.
you just need the 2 rows for username and id (M,N)
copy-paste the data frum trust.txt to (I,J)
use the function below on any 2 columns you want and it will parse the results for you
Code:
=IF(ISERROR(INDEX($N$3:$N$100,MATCH(I3,$M$3:$M$100,0))),"",INDEX($N$3:$N$100,MATCH(I3,$M$3:$M$100,0)))
*you need to replace I with J for the trustee column.
of course i assume you know how to put these in a single column if needed and how to add whatever separators you want.
if you having a trouble with it, just send me a an excel or text file with all usrename and ids, i'l upload an excel file where you just need to import the trust.txt and everything else will be automated.
February 02, 2019, 12:30:02 AM
Your proposal is good as the current system makes it difficult to keep track of changes in the trust network when VIPs and mods change their display name.
On the other hand, only providing UIDs makes it very difficult for anyone to analyze the information without automated tools.
Maybe a good solution would be to map the name to the UID if the name appears on trust.txt.xz
On the other hand, only providing UIDs makes it very difficult for anyone to analyze the information without automated tools.
Maybe a good solution would be to map the name to the UID if the name appears on trust.txt.xz
February 01, 2019, 07:15:48 PM
My recent example, and the reason for creating this topic:
Your tool is useful. Since I regularly update TOP-200 the most trusted members DT1, DT2, DT3, I'm also voting for the requested suggestion. In this case, it will be much easier to parse the dump of the Marketplace Trust Network for machine processing.
But maybe some people will want to download the file "trust.txt.xz" and manually check the relationship in a human readable format, so there is no need to change the structure of this file. In my opinion, the Marketplace Trust Network should be published in two files: "trust.txt.xz" and, for example, "trust_id.txt.xz".
February 01, 2019, 04:24:16 PM
I'm not a big fan of LoyceV's format without separators
I used "t" and "d" as separators, but anything else is fine too.A csv file of
userid, username, userid, username
It's an improvement, but since usernames can have "weird characters", it's still not that easy to separate.userid, username, userid, username
Can we not just have an area dedicated to this whole file
That is the reason why I ask this 
Theymos' data dumps make it possible for users to create their own data analysis, which means less work for Admin.My recent example, and the reason for creating this topic:
February 01, 2019, 04:16:08 PM
Rather why not change the whole format of the file?
It needs to be easy to parse. JSON, XML, CSV...
I'm not a big fan of LoyceV's format without separators, it would require pre-processing or custom parsing to load into tools that I use.
Won't it make things easier? Im a dumbhead, ignore me if I am too stupid to understand things.
February 01, 2019, 03:20:21 PM
Rather why not change the whole format of the file?
It needs to be easy to parse. JSON, XML, CSV...
I'm not a big fan of LoyceV's format without separators, it would require pre-processing or custom parsing to load into tools that I use.
Pugman might be onto something though.
A csv file of
userid, username, userid, username,
Like what we have now but having both details in the one file...
January 31, 2019, 11:27:05 AM
Rather why not change the whole format of the file?
It needs to be easy to parse. JSON, XML, CSV...
I'm not a big fan of LoyceV's format without separators, it would require pre-processing or custom parsing to load into tools that I use.
January 31, 2019, 11:07:21 AM
Rather why not change the whole format of the file?
Maybe a proper constructed table like this maybe? .
Maybe a proper constructed table like this maybe? .
| | | User_ID
January 31, 2019, 10:53:45 AM
I think both is probably better than just using one... That would be even better indeed. January 31, 2019, 07:51:32 AM
I think both is probably better than just using one...
Theyre both quite hefty to have to keep using forum queries to work out the usernames. I think it's done like that for a reason but I wouldn't personally be against having both, I'd be against changing it to just be a userid entirely however... January 31, 2019, 06:26:18 AM
The forum has some very useful weekly data dumps:
https://bitcointalk.org/merit.txt.xz shows userIDs, and is easy to analyze. https://bitcointalk.org/trust.txt.xz shows usernames, which makes it a lot harder to process: It's a pain to get all userIDs from this data, especially the ones with weird or even invisible characters. Current format Code: theymos->HostFat Requested format Code: 35t203 This would make is much easier to create things like LoyceV's Trust list viewer, which I think makes it easier to view a user's custom trust list and can help users to create their own. Jump to:
|
