Android Example B4Xgoodies_from_walt61 Online

Discussion in 'Tutorials & Examples' started by AnandGupta, Sep 30, 2019.

  1. AnandGupta

    AnandGupta 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.

    Update:
    version 2019-11-05, total 4870 rows.
    version 2019-11-11, total 4885 rows.​

    Regards,

    Anand
     
    Last edited: Nov 12, 2019 at 9:46 AM
  2. walt61

    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 ;))
     
  3. AnandGupta

    AnandGupta Active Member Licensed User

    Hi walt61,

    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 likes this.
  4. walt61

    walt61 Active Member Licensed User

    :) It's on my list Anand, I'll be back ! :)
     
  5. AnandGupta

    AnandGupta Active 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
     
  6. walt61

    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
     

    Attached Files:

  7. AnandGupta

    AnandGupta Active 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
     
  8. walt61

    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?
     
  9. AnandGupta

    AnandGupta Active 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
     
  10. walt61

    walt61 Active Member Licensed User

  11. AnandGupta

    AnandGupta Active Member Licensed User

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

    Thanks for the download links.

    Regards,

    Anand
     
    walt61 likes this.
  12. AnandGupta

    AnandGupta Active 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
     
  13. walt61

    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)
     
  14. JamesGreaves

    JamesGreaves Active Member Licensed User

    Brilliant @AnandGupta , you are the man!!
     
  15. AnandGupta

    AnandGupta Active 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
     
    JamesGreaves likes this.
  16. AnandGupta

    AnandGupta Active 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
     
  17. AnandGupta

    AnandGupta Active Member Licensed User

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

    Regards,

    Anand
     
  18. AnandGupta

    AnandGupta Active Member Licensed User

    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
     
    Last edited: Nov 5, 2019
    José J. Aguilar and DonManfred like this.
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice