Hi Siniy-Kit, Thank you! This is incredible! Thanks for sharing!
Kind regards, Chun On Saturday, March 9, 2019 at 2:50:11 AM UTC+13, Siniy-Kit wrote: > > All my javascript I put to one tiddler > http://novye-podarki.ru/6_7_0/heeg.html#%24%3A%2Fboot%2Fbootprefix1.js I > know, that it is not correct, but my project heeg.ru is not professional. > it has only 30-40 unique users per day (both with shop users and their > shops). > I don't see transactions of shops on my site (this information is > private), but i think it is about 0 :) > > test project http://heeg.ru/shop_test29.html use gviz google api. so it > loads not whole table at start (as my standard shop), but only necessary > part of it. So this APi use google table as database all code is > > > var part=''; > > var dataURL = ' > https://docs.google.com/spreadsheets/d/1b3CFfclMbQEQyJXVAz4yrqOiUS3vL_5jt-85ku0E9Ck/gviz/tq?sheet=goods > '; > > function drawVisualization(dataURL,queryString,part) { > > var opts = { > sendMethod: 'auto' > }; > var query = new google.visualization.Query(dataURL, opts); > query.setQuery(queryString); > query.send(handleQueryResponse); > } > > function handleQueryResponse(response) { > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + > response.getDetailedMessage()); > return; > } > var data = JSON.parse(response.getDataTable().toJSON()); > > > > > for (var ik=0, lenk=data.rows.length; ik<lenk; ik++) { > var fields = Object.create(null); > for (var i=0, len=data.cols.length; i<len; i++) { > if(data.cols[i].label=='id'){new_keya='title'}else > if(data.cols[i].label=='name'){new_keya='caption'}else{ > new_keya=data.cols[i].label}; > > > > if(data.rows[ik].c[i] == null || data.rows[ik].c[i].v=="" || > data.rows[ik].c[i].v==undefined){}else if(new_keya=="tags"){ > fields[new_keya]=data.rows[ik].c[i].v+" $:/Note"+" > "+search_text;}else{fields[new_keya]=data.rows[ik].c[i].v+""}; > > }; > $tw.wiki.addTiddler(new > $tw.Tiddler($tw.wiki.getModificationFields(),fields,$tw.wiki.getCreationFields())); > > > }; > > if (part=="limit 1"){ > var story = new $tw.Story(); > story.navigateTiddler(search_text); > } > > > } > > > > > > function summaryVisualTitle(title, col, par){ > if(title.length>2){ > querySummary = 'select * Where ' +col +' like '+title+' ' +par; > part=par; > search_text=title; > drawVisualization(dataURL,querySummary,part); > > > > } > } > > > > пятница, 8 марта 2019 г., 14:59:57 UTC+3 пользователь Jeremy Ruston > написал: >> >> Hi Siniy-Kit >> >> What you've built is incredibly impressive. I would love to get the >> techniques you are using written up so that it's easier for others to >> follow. Do you have any idea of the traffic volumes you're seeing? Can you >> talk about the number of successfully completed transactions per day/week >> etc? >> >> here is google table shop demo with 14000+ ITEMS >> http://heeg.ru/shop_test29.htm >> >> >> This URL didn't work for me. >> >> Best wishes >> >> Jeremy. >> >> >> >> <http://heeg.ru/shop.html?id=1LJKSexFKRh6EpWeDTvgbYNBZhhf-TmV3E7c0PvVdS-s> >> среда, 20 февраля 2019 г., 12:38:37 UTC+3 пользователь CHUN LI написал: >>> >>> Hi Jeremy, >>> >>> Thanks for the guide and I will see how far I can go. >>> >>> May I ask a further question? Can a blank TW file also be created by >>> publishing a Google web app? I guess it is about the fundamental >>> requirements of creating a TW file vs. the limitation of GAS? >>> >>> (I read about Web app on GAS from >>> https://developers.google.com/apps-script/guides/web) >>> >>> So I am thinking, >>> >>> 1. Create a Google spreadsheet on my Google drive. >>> 2. Open Script Editor from the 'Tools' tab in the Google spreadsheet. >>> 3. Add (write) all the necessary .js, .html, .css code in my TW.html >>> file. Please see a screenshot attached below. GAS use .html file to >>> store >>> all these three types of files. >>> 4. Use a .gs file, e.g. getData.gs, to read all the data from the >>> Google spreadsheet. The data can be used to create a .json tiddler, and >>> create tiddlers. >>> 5. Publish as a web app. >>> 6. The Google spreadsheet can be updated using a Google form. The >>> form can also be a tiddler and be used to edit (add) tiddlers. >>> 7. Multiple users can work on the Google spreadsheet. Their Google >>> logins will be collected and used as tiddler authors. >>> >>> [image: Screen Shot 2019-02-20 at 10.12.53 PM.png] >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Thanks, >>> >>> Chun >>> >>> >>> On Wednesday, February 20, 2019 at 12:25:32 AM UTC+13, Jeremy Ruston >>> wrote: >>>> >>>> Hi Chun >>>> >>>> As I have been using Google Apps Scripts (GAS) and knowing TiddlyWiki >>>> for about 1 year, I am trying to find out the possibilities of (re) >>>> writing >>>> TiddlyWiki in GAS. The HTML services in GAS allows client side javascript, >>>> CSS and HTML (https://developers.google.com/apps-script/guides/html). >>>> Google Sheets might be a place to store (or keep a copy of) tiddlers, or >>>> be >>>> used to produce a data tiddler. Google also has this ( >>>> https://developers.google.com/apps-script/api/quickstart/nodejs) to >>>> make node.js commands to GAS API. >>>> >>>> >>>> Thanks! I think you are correct, there is a fascinating opportunity to >>>> make an adaptation of TW that is served by GAS and can save changes back >>>> to >>>> it. It would be a nice straightforward user experience too. >>>> >>>> I think the easiest way to get started would be to create a new >>>> syncadaptor that loads and saves tiddlers via the GAS APIs. Then one could >>>> serve a blank TW file that includes that plugin, and at startup it would >>>> load the required tiddlers from the server. The next step might be to bake >>>> tiddlers into the HTML file when it is first served. >>>> >>>> I'm not sure that I will personally have time to investigate this >>>> opportunity in the near future, but I'd be very happy to help guide other >>>> developers who might want to take up the challenge... >>>> >>>> Best wishes >>>> >>>> Jeremy >>>> >>>> >>>> >>>> >>>> >>>> Did I misunderstand anything? Or this sounds like a plan? Sorry if I >>>> overlooked the Copyright of Tiddlywiki as I don't intend to do so. >>>> >>>> Thanks! >>>> >>>> Chun >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "TiddlyWiki" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to tiddlywiki+...@googlegroups.com. >>>> To post to this group, send email to tiddl...@googlegroups.com. >>>> Visit this group at https://groups.google.com/group/tiddlywiki. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/tiddlywiki/97145418-d172-42b5-aaff-c6b170c7d4ca%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/tiddlywiki/97145418-d172-42b5-aaff-c6b170c7d4ca%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> -- >> You received this message because you are subscribed to the Google Groups >> "TiddlyWiki" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to tiddlywiki+...@googlegroups.com. >> To post to this group, send email to tiddl...@googlegroups.com. >> Visit this group at https://groups.google.com/group/tiddlywiki. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/tiddlywiki/c3e63bbb-3190-450a-9839-3be32ec6b82f%40googlegroups.com >> >> <https://groups.google.com/d/msgid/tiddlywiki/c3e63bbb-3190-450a-9839-3be32ec6b82f%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> >> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To post to this group, send email to tiddlywiki@googlegroups.com. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/de0e4286-7fb9-4aad-aad1-0d791c07db26%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
