Posts you have Liked #2

[AnandGupta]

Refer https://www.b4x.com/android/forum/threads/posts-you-have-liked.101884/post-639962

@Erel can we have this feature now ? As I have a big list of "liked" which are my bookmarks, done from mobile.

BTW I have started a new thread as the original post says so.


Regards,

Anand

 

[DonManfred]

BTW I have started a new thread as the original post says so.

the mesage is timebased... x days after threadcreation the message appears.

As you are still requesting the same wish you could have answered there.
Nothing bad will happen.

Anyway you get an Like here too

 

[Erel]

There is no such built-in feature or add-on that implements it.

 

[AnandGupta]

There is no such built-in feature or add-on that implements it.

Ok.
Can you do this now, as Forum upgrade did not helped ?

Post I liked but not bookmarked via query

Hi Erel (yes, only he can solve it :) ) Since you have access to the forum database and can run select statement, https://www.b4x.com/android/forum/threads/ive-just-crossed-100-000-posts-today.105743/#post-662858 can you run a statement for like below, SELECT FROM `xf_post` WHERE `user_name` =...

www.b4x.com

Once I get them I will book mark them for future.

Regards,

Anand

 

[Erel]

A list of the thread ids is attached. You will need to do some work to organize it. For some reason the numbers are repeated many times.

Thread id to url: https://www.b4x.com/android/forum/threads/<thread id number>

 

[AnandGupta]

For some reason the numbers are repeated many times.

Thanks Erel for the hardwork.
Yes looks repeated, as total lines show 14,243 which looks daunting to manually open and bookmark
Any app to do it auto ?

Regards,

Anand

 

[fixit30]

Yes looks repeated, as total lines show 14,243 which looks daunting to manually open and bookmark
Any app to do it auto ?

Im feeling generous, here is your de-duplicated list...

 

[AnandGupta]

Thanks a lot @fixit30

Regards,

Anand

 

[fixit30]

Thanks a lot @fixit30

It was a simple Excel formula, I used to be a Senior data analyst in my previous job, and spent most of my day doing this sort of thing! Hope it helped.

 

[Erel]

Dim ids As B4XSet = B4XCollections.CreateSet
For Each line As String In File.ReadList("C:\Users\H\Downloads\xf_post.csv", "")
    ids.Add(line.Replace($"""$, ""))
Next
For Each id In ids.AsList
    Log(id)
Next

 

[AnandGupta]

WOW ! each one is master in his own field ?

I am more or less a text manipulator guy. So I may have sorted the csv list as text lines unique.
Anyway thanks both of you to give me the sorted unique list of thread ids.

Now I used Merge CSV and Text to get the html file with all ids as urls, like below

https://www.b4x.com/android/forum/threads/6589
https://www.b4x.com/android/forum/threads/7327
https://www.b4x.com/android/forum/threads/7561
https://www.b4x.com/android/forum/threads/8416
https://www.b4x.com/android/forum/threads/8832
https://www.b4x.com/android/forum/threads/9777

Then I used FireFox Extension URLs List to open 10 urls at a time (cut and paste)
BookMark them with suitable tags.

I keep the urls as notes in ResophNotes which syncs with SimpleNotes, so that I can perform cut - paste - open - bookmark both from home and office computers, as and when I get free time.

Thanks all for the help.

Regards,

Anand