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 !

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.​
version 2020-02-17, total 4979 rows.​
version 2020-02-24, total 4995 rows.​
version 2020-03-02, total 5006 rows. Crossed 5K !​
version 2020-03-09, total 5014 rows. Happy Holi From India.​
version 2020-03-16, total 5027 rows.​
version 2020-03-23, total 5038 rows. World Lock-down due to Covid 19.​
version 2020-03-30, total 5051 rows. World Lock-down continue.​
version 2020-04-06, total 5066 rows. and World Lock-down continue.​
version 2020-04-14, total 5086 rows. India extended Lock-down till May 3, 2020.​
version 2020-04-20, total 5091 rows. Kinda getting used to working from Home.​
version 2020-04-27, total 5109 rows. Hope the lock down eases by next week.​
version 2020-05-05, total 5122 rows. Non teetotalers get in line, shops opened now.​
version 2020-05-11, total 5129 rows. Our locality in red zone now. Movement restricted.​
version 2020-05-18, total 5143 rows. Summer temperatures soaring and Covid too !!​
version 2020-05-26, total 5163 rows. Cyclone Ampham destroyed trees, electricity and our life line internet :(
version 2020-06-02, total 5178 rows. Life is limping back to whatever is left.​
version 2020-06-08, total 5198 rows. Covid, Ampham, Summer Heat ! What Next ?​
version 2020-06-15, total 5217 rows. If you living in peace now then you are gifted.​
version 2020-06-22, total 5225 rows. Still working from Home. Getting Office-sick​
version 2020-06-29, total 5234 rows. WOW ! Number of rows are now sequential ! Nearly !!​
version 2020-07-06, total 5243 rows. It is routine now.​
version 2020-07-14, total 5265 rows. B4A is version 10 ! now and have Cross Platform B4XPages !!​
version 2020-07-20, total 5276 rows. Everybody is going about their jobs now, with Mask on.​
version 2020-07-27, total 5290 rows. On / Off / On / Off i.e. Lock Down.​
version 2020-08-03, total 5307 rows. Today is Raksha Bandhan (India). Bonding Sister and Brother relationship.​
version 2020-08-10, total 5322 rows. Everything going on-line now. From Education to Shopping.​
version 2020-08-17, total 5335 rows. Celebrations are also now on-line !​
version 2020-08-24, total 5348 rows. WHO says COVID19 will not last long now. Phew !​
version 2020-08-31, total 5357 rows. Covid recovery rate is more than death rate now Thanks.​
version 2020-09-07, total 5373 rows. Not getting time to develop in B4X and it is frustrating than Covid lock down !!​
version 2020-09-14, total 5377 rows. Metro (Kolkata, India) starts at last, but with e-Pass !​
version 2020-09-21, total 5392 rows. Covid Pandemic still not over !!​
version 2020-09-28, total 5408 rows. Most people are going about there works, normally. Many without masks.​
version 2020-10-05, total 5416 rows. Political clashes everywhere in India. People forgot Covid !!​


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

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
 

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
 

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