I wanted the information on the front screen, so as soon as you opened the app, you had a choice for which language you wanted to view it in and then you would be able to read about it in a specific language. <\/p>\n\n\n\n
General information, I had initially on the home screen but decided to relegate that to the 2nd screen of 2. I wanted to demonstrate the access to the translation and the exhibition rather than the Gallery, which is adequately managed on their site. <\/p>\n\n\n\n
Google Translate<\/h4>\n\n\n\n This I opened 3 tabs and went through cutting and pasting the English into a cell and then copy\/pasting the translation back into the spreadsheet. It was tedious. I looked for a better way.<\/p>\n\n\n\nIn fact, Google Translate will translate a document:<\/p>\n\n\n\nSo I just cut\/pasted the English part of the Google Sheet Tab that I wanted translated to LibreOffice Calc and saved that as as an .XLSX file. I then uploaded that to Google Translate :<\/p>\n\n\n\nIt displays the result in a web browser:<\/p>\n\n\n\nYou can Copy\/Paste this into your Google Sheet on the next row down under the English text and it puts the data in the appropriate cells. <\/p>\n\n\n\n
Aside: Excel\/word translator feature<\/em><\/h5>\n\n\n\nI’m using the LibreOffice process as its free. If you have Excel (a paid version, free online does not have it) under the Review Tab there is a translation button where you can select\/copy text and translate it. I saw a video for this but have not tested it, so do not know if it works over a range of cells. Handy tool if you have Excel. <\/em><\/p>\n\n\n\nI will definitely be using the document translate method as you get the translations and the data structure for the cells. Much quicker. There were a couple of small things I had to tidy up. Black Atom 2013<\/em> translated into German as Black Atom 2013<\/em> whereas Black Atom<\/em> translated to Schwarz Atom. <\/em>I noticed that when I was doing each cell block manually, so could change it, but some things do need checking. <\/p>\n\n\n\nEnd comment<\/h3>\n\n\n\n The process is still evolving. This is definitely an improvement on the HOHO app as it is self-contained within one app. <\/p>\n\n\n\n
I’m still not happy with the titles but I may find a solution to this later. As a 2nd attempt I’m pleased with the results. I’m also very happy with the faster Google Translate process. That would allow quite a few more languages to be quickly added. <\/p>\n\n\n\n
I will move onto the museum exercise next, that one may require a bit of OCR or a lot of typing. <\/p>\n","protected":false},"excerpt":{"rendered":"
Further to HopOnHopOff (HOHO) for bus tour I could see that this idea could be extended to other instances like Museums, Art Galleries and events. A way of extending the information about a specific subject by translating it into different languages, thereby allowing people to engage more with the subject at hand. So, my initial […]<\/p>\n","protected":false},"author":1,"featured_media":5536,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,441,265,417,42,29],"tags":[425,428,431,422,53,54,430,426,420,421,255,429,424],"class_list":["post-5519","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","category-glide-apps","category-google-docs","category-mobile","category-productivity","category-web","tag-adding-value","tag-am","tag-art-gallery-translation-app","tag-asset-management","tag-facility-management","tag-facility-operations","tag-fm","tag-fm-productivity","tag-free-mobile-app-creator-with-no-coding","tag-glideapps","tag-google-sheets","tag-simplifying-data","tag-visualise-assets"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_27_48-CityGallery1-made-with-Glide.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_27_48-CityGallery1-made-with-Glide.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5519"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/5519\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/5536"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_17_08-Glide-\u2013-amazing-apps-without-code-491x1024.jpg\"){kind=spacer}
<\/figure><\/li>![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_17_33-Glide-\u2013-amazing-apps-without-code-508x1024.jpg\")
<\/figure><\/li>![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_19_21-Glide-\u2013-amazing-apps-without-code-502x1024.jpg\")
<\/figure><\/li>![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-17_19_34-Glide-\u2013-amazing-apps-without-code-512x1024.jpg\")
<\/figure><\/li><\/ul>\n\n\n\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-16_54_59-CityGallery1-Google-Sheets-1024x599.jpg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-16_56_42-Google-Translate-1024x579.jpg\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-12_46_07-Google-Translate-1024x370.jpg\"){kind=spacer}
<\/figure>\n\n\n\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2019\/04\/2019-04-25-12_46_26-Photos-1024x459.jpg\")
<\/figure>\n\n\n\n