Android Example B4Xgoodies_from_walt61 Online

AnandGupta · Sep 30, 2019

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

walt61 · Sep 30, 2019

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 · Sep 30, 2019

Hi walt61,

walt61 said:
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

walt61 · Oct 1, 2019

It's on my list Anand, I'll be back !

AnandGupta · Oct 1, 2019

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 · Oct 2, 2019

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

AnandGupta · Oct 2, 2019

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 · Oct 3, 2019

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

AnandGupta · Oct 3, 2019

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

walt61 · Oct 3, 2019

Exactly what I had in mind The links are:
- html file: https://www.dropbox.com/s/31w3ksayw80n6b8/b4xgoodies.html?dl=1
- version.txt: https://www.dropbox.com/s/ards6k5w3wuzy5n/version.txt?dl=1

AnandGupta · Oct 4, 2019

walt61 said:
Exactly what I had in mind

Ahh..so the saying is true,
"Great minds think alike"

Thanks for the download links.

Regards,

Anand

AnandGupta · Oct 5, 2019

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 · Oct 5, 2019

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 · Oct 10, 2019

AnandGupta said:
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 · Oct 22, 2019

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 · Oct 23, 2019

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

AnandGupta · Oct 28, 2019

Updated to version 2019-10-28
Total 4856 rows now

Regards,

Anand

AnandGupta · Nov 5, 2019

From now on, I will update the first post. As my number of post is increasing unnecessarily from this

Please check the Update: in first post.

Regards,

Anand

AnandGupta · Feb 10, 2020

WOW !!

In this new Forum upgrade the sheet is now visible in the first message itself ?
Thank you @Erel

Regards,

Anand

Jorge M A · Feb 10, 2020

AnandGupta said:
is now visible in the first message

It is cool.... but.... but... I cannot open the sheet to find o filter...
I Can't remember the original link.... Can you write it as "text", please?

Android Example B4Xgoodies_from_walt61 Online

Active Member

Expert

Active Member

Expert

Active Member

Attachments

Expert

Active Member

Expert

Active Member

Expert

Expert

Active Member

Active Member

Expert

Expert

Expert

Expert

Expert

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency