Android Example B4Xgoodies_from_walt61 Online

AnandGupta

Well-Known Member
Licensed User
Well,

As JamesGreaves requested,
"So do you not think it would be of value to have even something like @walt61 has created but online?"
https://www.b4x.com/android/forum/threads/complete-library-repository-click-here.109921/#post-686347

I got thinking about it. How hard it is to convert walt61's such a good hard work into online.
Converting the given xlsm to Google Sheet gave reload error.
Xls without macro also gave same reload error.
I made csv and tried to open in sheet, still same error.

Finally I opted for csv to html, http://www.convertcsv.com/csv-to-html.htm and then pasted the html text in a new gsheet. Voila it works !


The direct link of the sheet is given in Post#21

Please note that the information is (c) walt61 and I will remove the link if not authorised to upload a online version of the same.

I just wanted to help fellow members here with an online option of the same.

Update:
version 2019-11-05, total 4870 rows.​
version 2019-11-11, total 4885 rows.​
version 2019-11-18, total 4894 rows.​
version 2019-11-26, total 4904 rows.​
version 2019-12-02, total 4907 rows.​
version 2019-12-09, total 4913 rows.​
version 2019-12-16, total 4923 rows.​
version 2019-12-23, total 4925 rows. Merry Christmas.​
version 2019-12-30, total 4933 rows. Happy New Year.​
version 2020-01-13, total 4945 rows.​
version 2020-01-20, total 4945 rows. No Change.​
version 2020-01-27, total 4953 rows.​
version 2020-02-03, total 4953 rows. No Change.​
version 2020-02-10, total 4969 rows.​

Regards,

Anand
 
Last edited:

walt61

Active Member
Licensed User
Nice one, @AnandGupta ! Of course I don't object (on the contrary) and the goodies are, just like all the free stuff on the forums, licensed as 'Free - Creative Commons CC BY 3.0' (and after all I'm merely collecting the information from the forums - ok perhaps a little more than just collecting but still :)).

By the way, would it help if I would publish an html version in addition to the xlsm one? Happy to look into it if that might eliminate manual work for you (I assume that like me you too are the good kind of lazy and want to eliminate manual actions as much as possible ;))
 

AnandGupta

Well-Known Member
Licensed User
Hi walt61,

Nice one, @AnandGupta ! Of course I don't object (on the contrary) and the goodies are, just like all the free stuff on the forums, licensed as 'Free - Creative Commons CC BY 3.0' (and after all I'm merely collecting the information from the forums - ok perhaps a little more than just collecting but still :)).

By the way, would it help if I would publish an html version in addition to the xlsm one? Happy to look into it if that might eliminate manual work for you (I assume that like me you too are the good kind of lazy and want to eliminate manual actions as much as possible ;))
I am happy that you appreciated my help on your hard work.
Yes a html will help as I will directly paste the content then without any conversion.

Ahh...the lazy am I.
I am lazy to move the mouse with my hand when it blocks my view on a clicked input box, I made Park Cursor Aside
I am lazy to press ALT+F4 to close a program and I made Esc Close
All my freeware creation are due to my laziness.
An excerpt from my most famous Overlap Wallpaper is,
"Well as a developer, somewhere inside me I was not feeling good. I wanted the benefit of both worlds and in automated manner."

So it is and I may make the pasting auto from your html in future :)

Regards,

Anand
 

AnandGupta

Well-Known Member
Licensed User
Adjusted the online table column width, so that they are visible properly in normal computer screen.
Also mentioned walt61's original link. He deserve it.

Regards,

Anand
 

walt61

Active Member
Licensed User
Hi @AnandGupta ,

Attached you'll find the zipped html table version. Please give it a go and see if it works fine, as I didn't escape/encode any characters (and am therefore not certain if there would be issues with it - if so, I'll refine it) and didn't put tags around the hyperlinks (more or less counting on Google Sheets to do that, but if it doesn't, I will).

If/when all works well, what would your preferred delivery method be? I thought of a Dropbox link like the one that already exists for the workbook, but if another way is more convenient, shout!

Cheers,

walt61
 

Attachments

AnandGupta

Well-Known Member
Licensed User
Hi @walt61 ,

This will do as only copy-paste works fine. Google Sheet does rest. You can check the link now.

Thanks for it.

Regards,

Anand
 

walt61

Active Member
Licensed User
Great ! Shall I setup a Dropbox link so that you can always pick up the latest version from the same place?
 

AnandGupta

Well-Known Member
Licensed User
Dropbox link will do, but post a message here that you have uploaded a new file, so that I know to download it.
Either you keep a "version.txt" with latest date in dropbox and its give link too, which I may download and check before downloading the html file. This will also help me in making an auto app for it :)

Regards,

Anand
 

AnandGupta

Well-Known Member
Licensed User
Hi @walt61,

I checked your last html and the latest from dropbox. The file size is same but the contents seem to be sorted in different order.
Is there any different / new in the latest html ? So that I update it to google sheet.

Regards,

Anand
 

walt61

Active Member
Licensed User
Ah you're right, @AnandGupta, I hadn't sorted the data by name - that's done (and published to Dropbox) now ! (And will be done in all future versions too)
 

JamesGreaves

Active Member
Licensed User
Well,

As JamesGreaves requested,
"So do you not think it would be of value to have even something like @walt61 has created but online?"
https://www.b4x.com/android/forum/threads/complete-library-repository-click-here.109921/#post-686347

I got thinking about it. How hard it is to convert walt61's such a good hard work into online.
Converting the given xlsm to Google Sheet gave reload error.
Xls without macro also gave same reload error.
I made csv and tried to open in sheet, still same error.

Finally I opted for csv to html, http://www.convertcsv.com/csv-to-html.htm and then pasted the html text in a new gsheet. Voila it works !

https://docs.google.com/spreadsheets/d/1Tu4yPNJQj8uqXi1oXqtc0bdbMMst6tsoAPQ1W48rraA/edit?usp=sharing

Please note that the information is (c) walt61 and I will remove the link if not authorised to upload a online version of the same.

I just wanted to help fellow members here with an online option of the same.

Regards,

Anand
Brilliant @AnandGupta , you are the man!!
 

AnandGupta

Well-Known Member
Licensed User
Online version updated to 2019-10-15.
Also inserted one row showing "Last updated on 2019-10-15" so that user can be aware of the it.

Regards,

Anand
 

AnandGupta

Well-Known Member
Licensed User
Online version updated to 2019-10-22.
Now the sheet is sorted on "Latest version's date" descending order, thanks to Walt61.
This will help members to see the latest library on top. And also helps me when I get 'memory error' in updating the sheet :)

Regards,

Anand
 
Top