August 2015 - Pharo-users - lists.pharo.org

Re: [Pharo-users] Tabular: XLSX import

by Vincent BLONDEAU

Hi, I added the dependencies to PharoExtras/XMLWriter and XMLParser. I didn't add the dependencies before because I used Tabular with Moose, and Moose already loads these dependencies... Now it should work. I created the new 0.2 release with the required dependencies. By the way, I used Versionner to create the configuration. I don't know if there is a documentation but there is a video: https://www.youtube.com/watch?v=cFRJDuWL-Q0 It is a very fast tool to manage your projects! If your are using at least Pharo 4.0, you can use the catalog browser to load the ConfigurationOfTabular directly. Best, Vincent -----Message d'origine----- De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la part de H. Hirzel EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 Ã : Any question about pharo is welcome Objet : Re: [Pharo-users] Tabular: XLSX import If I do ConfigurationOfXMLWriter load then TabularExperimentalExport writeTestFile is fine generating an Excel file. http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz I am currently exploring the code and trying to figure out how it works. --Hannes On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his > ConfigurationOfTabular file > > http://ss3.gemtalksystems.com/ss/Tabular.html > > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing > Projects with Metacello > > > The Tabular project needs a XMLWriter class. I assume the regular > pharoExtras is fine. I do not know. > > I am just looking at the code to see how the reading and writing of > MSOffice files, Excel in this particular case, is done so far. > > For reading a TabularSAXParser is included in the package. Probably > not necessary. > > I moved it out here > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz > > Hannes > > > > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >> >> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>> What about >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>> >>> p. 163 depending on a project without Metacello description p. 164, >>> depending on a project with a Metacello configuration >>> >>> In the mean time just a note that Tabular needs XMLParser and >>> XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. >> >> are you implying that there is no expression of dependencies and that >> in addition it depend on a different XML Parser/Writer than >> pharoExtras ones? >> >> Stef >>> >>> Some class comments are welcome as well :-) >>> >>> I understand that I can read Excel files and that you just started >>> to check out how to write them? >>> >>> --Hannes >>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>> Thank you Vincent. >>>> Some things is much clearer for me now. >>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>> especially taking into account I was on the ESUG conference where >>>> it was presented. >>>> It >>>> was my only conference unfortunately.* >>>> >>>> I see that you already started this job: you added >>>> ConfigurationOfTabular. >>>> What I really want to do with this configuration: add dependencies >>>> to XMLParser and XMLWriter packages. Can you help with this, please? >>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>> <vincent.blondeau(a)worldline.com> >>>> : >>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>> configuration for your project. You can create it with the >>>>> versionner if needed. >>>>> >>>>> >>>>> >>>>> Second, you have to add some methods adding meta-description to >>>>> your project. The versionner do it for you: in the configuration >>>>> list, select your project, do a right click and select add catalog >>>>> methods. >>>>> >>>>> It creates all the mandatory methods for the catalog. You now have >>>>> to fill them (look at the class side of the configuration). >>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>> MetaRepoForPharo30/40/50 depending where your project is working. >>>>> >>>>> The link is here: >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>> >>>>> >>>>> >>>>> Once published, your project will be in the catalog in the image >>>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>>>> >>>>> >>>>> >>>>> Tell me if you need help to do it, >>>>> >>>>> >>>>> >>>>> Cheers, >>>>> >>>>> Vincent >>>>> >>>>> >>>>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >>>>> *De la part de* ???? ????????? >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX import >>>>> >>>>> >>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>> packaging/deployment/versioning system. I know it exists, but I >>>>> don't know details. Can you kick me in the right direction? Maybe >>>>> some link? >>>>> >>>>> >>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>>> >>>>> >>>>> >>>>> Esteban >>>>> >>>>> >>>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >>>>> wrote: >>>>> >>>>> >>>>> >>>>> Hello. >>>>> >>>>> Some time ago I announced Tabular >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>>>> make a tool for spreadsheets import/export. >>>>> >>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>> functionality! >>>>> It's also mostly proof-of-concept now, but even at this stage it's >>>>> quite usable. >>>>> >>>>> Thanks, Vincent! >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de le >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre recherchÃ©e >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>>> soient faits pour maintenir cette transmission exempte de tout >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>>>> rÃ©sultant d'un virus transmis. >>>>> >>>>> This e-mail and the documents attached are confidential and >>>>> intended solely for the addressee; it may also be privileged. If >>>>> you receive this e-mail in error, please notify the sender >>>>> immediately and destroy it. >>>>> As >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>> liability cannot be triggered for the message content. Although >>>>> the sender endeavours to maintain a computer virus-free network, >>>>> the sender does not warrant that this transmission is virus-free >>>>> and will not be liable for any damages resulting from any virus >>>>> transmitted. >>>>> >>> >> >> >> >

Aug. 8, 2015

Re: [Pharo-users] MongoDB: console commands? query embedded indexed fields?

by Sabine Manaa

Hi Norbert, lol, I had to google that: https://en.wikipedia.org/wiki/Heisenbug funny but that's it. It is always a good feeling when I know what the reason for a certain behavior is. Now I can proceed with the implementation of the search functionality. no, in Mongo I don't store the back references, they are created when the objects are instantiated in pharo. Wouldn't you do it like this? What is the background for your question? Regards Sabine 2015-08-07 15:06 GMT+02:00 NorbertHartl [via Smalltalk] < ml-node+s1294792n4841471h96(a)n4.nabble.com>: > > Am 07.08.2015 um 14:53 schrieb Sabine Manaa <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=4841471&i=0>>: > > Hi Norbert, Hi Phil, > > thanks for your help! Now I know what the problem is/was. :-))) > > The query was right, the index was used, all is fine. > > BUT: > I used an inspector to look at the query's result and opening the > inspector forced to load all the other objects which belong to the object > found. > Explanation: I have a person which has N trips with N receipts, all with > back pointers. Opening an Inspector with one trip loads its person and all > other trips of this person hahaha. The magritte description isLazy but the > inspector forced the loading of the objects in the VOMongoRepository at > first time after image starting. > > Time millisecondsToRun: [(RKATrip selectMany: { > 'receipts.receiptDescription' -> 'a' } asDictionary) size] 764 . > Time millisecondsToRun: [(RKATrip selectMany: { > 'receipts.receiptDescription' -> 'a' } asDictionary) inspect] 17234 > > So, I messed around with myself. > > Well, we call this an inversed Heisenbug, don't we? :) That is a problem > we should be aware when using proxy implementations and tools like gt > tools. It is very likely that a powerful tool will inquire special > information on a proxy that will trigger it. > > Currently I do not have so much data but I hope in future there will be a > lot and I want the application prepared for that. > > It depends on the tool and your model. Are you storing those > backreferences in mongo as well? > > Norbert > > BTW: I found this nice document: > https://ci.inria.fr/pharo-contribution/job/EnterprisePharoBook/ws/Voyage/Vo… > I was mentioned there, thanks! Esteban, if you want, you could change my > name, I married and changed my name to Manaa. > > have a nice weekend > Sabine > > 2015-08-06 15:36 GMT+02:00 NorbertHartl [via Smalltalk] <<a > href="x-msg://13/user/SendEmail.jtp?type=node&node=4841464&i=0" > target="_top" rel="nofollow" link="external" class="">[hidden email]>: > > Sabine, >> >> Am 06.08.2015 um 14:49 schrieb Sabine Manaa <[hidden email] >> <http://user/SendEmail.jtp?type=node&node=4841238&i=0>>: >> >> Norbert, >> >> I have to come back to your answer. >> >> With the .explain option, I can see, how performance is with and without >> index on the _mongo console_. >> As an example, I see: with index only 2 objects scanned, without: 200. >> Performance is perfect with index. >> >> But _from smalltalk_, it seems to iterate over all objects, also with the >> index set. Slow. >> >> You wrote: "The index will be selected automatically." It seems that it >> does not. >> >> >> >> Usually it does. >> >> My question: >> MongoQuery has an attribute named "where" which is filled with the >> mentioned "receipts.receiptDescription". >> Because of the name of this attribute "where" and the slow performance, I >> assume that the mongo classes use the $where command: >> >> http://docs.mongodb.org/manual/reference/operator/query/where/ >> >> Is this right? >> >> In this case with the statement >> Trip selectMany: { 'receipts.receiptDescription' -> 'Tankquittung' } >> asDictionary >> the index would not be set automatically. >> >> "The $where provides greater flexibility, but requires that the database >> processes the JavaScript expression or function for each document in the >> collection. " >> >> Then my question is if the mongo classes support database queries with >> index and if yes, how. >> >> I am very interested in your opinion and I think other users should have >> the same requirements (querying indexed variables) - how did they solve >> this? >> >> The handling of indexes needs to be automatic. The rule of thumb is that >> if you use where clause like b = , c = , a= than you need an compound index >> in the same order being index(b,c,a). This is handled by the database when >> it analyzes the query it tries to find an appropriate index. Or seeing it >> from the other side: If you issue a query with index and the index does not >> fit the query it is a problem anyway. Are you sure you have only this one >> thing in the where query? >> >> I use e.g. >> >> COInstalledApp selectOne: { >> 'device.id' -> aString. >> 'application.__id' -> anApplication voyageId } asDictionary >> >> on a collection that has approx. 1 Mio. entires and it is fast. I didn't >> check with explain but I'll do if I find time :) >> >> If I were you I would step in the debugger down to the Voyage part after >> serialization. Then you have the exact Dictionary that is used to send to >> mongo. You can then use this query to do an "explain" on it and that should >> show you something. Another thing you can try (although I don't think makes >> any difference) is to use the non-javascript query variant. That would be >> >> Trip selectMany: { >> 'receipts' -> { >> 'receiptDescription' -> 'Tankquittung' } asDictionary } asDictionary >> >> Norbert >> >> Regards >> Sabine >> >> >> 2015-08-04 14:47 GMT+02:00 Sabine Manaa <[hidden email] >> <http://user/SendEmail.jtp?type=node&node=4841238&i=1>>: >> >> > >> > Hi Norbert, >> > >> > I didn't want to use "use database" for queries but for defining the >> index from within smalltalk. But if creating indexes is not supported, I >> will set the indexes within the mongo console. >> > >> > The explain option is very helpful I did not know this. >> > >> > Your answer was very helpful for me, thanks a lot! >> > Sabine >> > >> > >> > >> > 2015-08-04 10:42 GMT+02:00 NorbertHartl [via Smalltalk] <[hidden >> email]>: >> >> >> >> Sabine, >> >> >> >> Am 04.08.2015 um 07:08 schrieb Sabine Manaa <[hidden email]>: >> >> >> >> Hi, >> >> >> >> I have 2 questions concerning use of mongoDB classes: >> >> 1) how can I send mongo console commands directly from smalltalk >> >> 2) how to query on an embedded collection with an index >> >> >> >> Model: >> >> I have trips and each trip has an embedded collection of N receipts >> like >> >> this: >> >> { "tripName" : "trip 1", >> >> {"receipts" : [ >> >> {"receiptDescription" : "receipt 1" } >> >> {"receiptDescription" : "receipt 2" } >> >> {"receiptDescription" : "receipt 3" } ], >> >> } >> >> >> >> Index: >> >> For quick search, I created an index on the embeded[1] receipts with >> this >> >> command at the mongoDB console in a terminal (NOT in smalltalk) >> >> (mongo console starts with mongo in the MongoDB/bin dir): >> >> >> >> db.Trips.createIndex({"receipts.receiptDescription":1}) >> >> >> >> with a command like this in the mongoDB console >> >> >> >> db.Trips.find({"receipts.receiptDescription":"receipt 1"}) >> >> >> >> I get the resulting receipt. >> >> >> >> Before, I have to set the database with "use {databasename}" in thr >> mongodb >> >> console >> >> >> >> My questions: >> >> 1) how can I send mongo console commands directly from smalltalk, e.g. >> use >> >> database, set index etc. >> >> >> >> >> >> I don't know why you want to use "use database". For queries you don't >> need this because you choose the database and collection by using the >> smalltalk classes. You can look there if something you need exists. >> >> Creating indexes is not yet supported. I want to do that myself. As >> always there seems to be to less people implementing stuff like that. >> >> >> >> Is this possible? >> >> I did not succeed with the mongo command: method, it always returns >> "no such >> >> cmd". >> >> >> >> 2) how can I search for a receipt which is indexed as described from >> >> smalltalk? >> >> >> >> >> >> A simple >> >> >> >> Trip selectMany: { 'receipts.receiptDescription' -> 'Tankquittung' } >> asDictionary >> >> >> >> should do. You can use just the nested properties form. The index will >> be selected automatically. If you are not sure about queries read about >> explain [1] to optimize that stuff. >> >> >> >> [1] >> http://docs.mongodb.org/manual/reference/method/cursor.explain/#cursor.expl… >> >> >> >> Norbert >> >> >> >> >> >> I did not succeed with the description [2] I am not sure if it is >> covered by >> >> it. >> >> >> >> Regards >> >> Sabine >> >> >> >> >> >> [1] >> >> >> http://docs.mongodb.org/manual/core/index-multikey/#index-arrays-with-embed… >> >> [2] http://smallworks.eu/web/blog/2013-07-18-Voyage-advanced-queries >> >> >> >> >> >> >> >> -- >> >> View this message in context: >> http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field… >> >> Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com >> <http://nabble.com/>. >> >> >> >> >> >> >> >> >> >> ________________________________ >> >> If you reply to this email, your message will be added to the >> discussion below: >> >> >> http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field… >> >> To start a new topic under Pharo Smalltalk Users, email [hidden email] >> >> To unsubscribe from MongoDB: console commands? query embedded indexed >> fields?, click here. >> >> NAML >> > >> > >> > >> > ________________________________ >> > View this message in context: Re: MongoDB: console commands? query >> embedded indexed fields? >> > >> > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com >> <http://nabble.com/>. >> >> ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field… > To start a new topic under Pharo Smalltalk Users, email <a > href="x-msg://13/user/SendEmail.jtp?type=node&node=4841464&i=1" > target="_top" rel="nofollow" link="external" class="">[hidden email] > To unsubscribe from MongoDB: console commands? query embedded indexed > fields?, click here. > NAML > <http://forum.world.st/template/NamlServlet.jtp?macro=macro_viewer&id=instan…> > > > ------------------------------ > View this message in context: Re: MongoDB: console commands? query > embedded indexed fields? > <http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field…> > Sent from the Pharo Smalltalk Users mailing list archive > <http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html> at Nabble.com > <http://nabble.com/>. > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field… > To start a new topic under Pharo Smalltalk Users, email > ml-node+s1294792n1310670h65(a)n4.nabble.com > To unsubscribe from MongoDB: console commands? query embedded indexed > fields?, click here > <http://forum.world.st/template/NamlServlet.jtp?macro=unsubscribe_by_code&no…> > . > NAML > <http://forum.world.st/template/NamlServlet.jtp?macro=macro_viewer&id=instan…> > -- View this message in context: http://forum.world.st/MongoDB-console-commands-query-embedded-indexed-field… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 8, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

If I do ConfigurationOfXMLWriter load then TabularExperimentalExport writeTestFile is fine generating an Excel file. http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz I am currently exploring the code and trying to figure out how it works. --Hannes On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his > ConfigurationOfTabular file > > http://ss3.gemtalksystems.com/ss/Tabular.html > > So I pointed him to the Pharo By Examples book 2 Chapter 9 > Managing Projects with Metacello > > > The Tabular project needs a XMLWriter class. I assume the regular > pharoExtras is fine. I do not know. > > I am just looking at the code to see how the reading and writing of > MSOffice files, Excel in this particular case, is done so far. > > For reading a TabularSAXParser is included in the package. Probably > not necessary. > > I moved it out here > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz > > Hannes > > > > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >> >> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>> What about >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>> >>> p. 163 depending on a project without Metacello description >>> p. 164, depending on a project with a Metacello configuration >>> >>> In the mean time just a note that Tabular needs XMLParser and >>> XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. >> >> are you implying that there is no expression of dependencies and >> that in addition it depend on a different XML Parser/Writer than >> pharoExtras ones? >> >> Stef >>> >>> Some class comments are welcome as well :-) >>> >>> I understand that I can read Excel files and that you just started to >>> check out how to write them? >>> >>> --Hannes >>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>> Thank you Vincent. >>>> Some things is much clearer for me now. >>>> >>>> *It's shame on me that I lost all this Metacello progress, especially >>>> taking into account I was on the ESUG conference where it was >>>> presented. >>>> It >>>> was my only conference unfortunately.* >>>> >>>> I see that you already started this job: you added >>>> ConfigurationOfTabular. >>>> What I really want to do with this configuration: add dependencies to >>>> XMLParser and XMLWriter packages. Can you help with this, please? >>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>> <vincent.blondeau(a)worldline.com> >>>> : >>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>> configuration for your project. You can create it with the versionner >>>>> if >>>>> needed. >>>>> >>>>> >>>>> >>>>> Second, you have to add some methods adding meta-description to your >>>>> project. The versionner do it for you: in the configuration list, >>>>> select >>>>> your project, do a right click and select add catalog methods. >>>>> >>>>> It creates all the mandatory methods for the catalog. You now have to >>>>> fill >>>>> them (look at the class side of the configuration). >>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>> MetaRepoForPharo30/40/50 depending where your project is working. >>>>> >>>>> The link is here: http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>> >>>>> >>>>> >>>>> Once published, your project will be in the catalog in the image >>>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>>>> >>>>> >>>>> >>>>> Tell me if you need help to do it, >>>>> >>>>> >>>>> >>>>> Cheers, >>>>> >>>>> Vincent >>>>> >>>>> >>>>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] *De la >>>>> part de* ???? ????????? >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 >>>>> *Ã :* Any question about pharo is welcome >>>>> *Objet :* Re: [Pharo-users] Tabular: XLSX import >>>>> >>>>> >>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>> packaging/deployment/versioning system. I know it exists, but I don't >>>>> know >>>>> details. Can you kick me in the right direction? Maybe some link? >>>>> >>>>> >>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>>> >>>>> >>>>> >>>>> Esteban >>>>> >>>>> >>>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >>>>> wrote: >>>>> >>>>> >>>>> >>>>> Hello. >>>>> >>>>> Some time ago I announced Tabular >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to make a >>>>> tool for spreadsheets import/export. >>>>> >>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>> functionality! >>>>> It's also mostly proof-of-concept now, but even at this stage it's >>>>> quite >>>>> usable. >>>>> >>>>> Thanks, Vincent! >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >>>>> l'usage >>>>> exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le >>>>> secret >>>>> professionnel. Si vous recevez ce message par erreur, merci d'en >>>>> avertir >>>>> immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message >>>>> ne >>>>> pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne >>>>> pourra >>>>> Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs >>>>> efforts soient faits pour maintenir cette transmission exempte de tout >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant >>>>> d'un >>>>> virus transmis. >>>>> >>>>> This e-mail and the documents attached are confidential and intended >>>>> solely for the addressee; it may also be privileged. If you receive >>>>> this >>>>> e-mail in error, please notify the sender immediately and destroy it. >>>>> As >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>> liability >>>>> cannot be triggered for the message content. Although the sender >>>>> endeavours >>>>> to maintain a computer virus-free network, the sender does not warrant >>>>> that >>>>> this transmission is virus-free and will not be liable for any damages >>>>> resulting from any virus transmitted. >>>>> >>> >> >> >> >

Aug. 8, 2015

pharoExtras XML Parser/Writer in Pharo 4.0?

by H. Hirzel

On 8/8/15, stepharo <stepharo(a)free.fr> wrote: ... it depend on a different XML Parser/Writer than > pharoExtras ones? > > Stef >> Stef, Question of confirmation With pharoExtras XML Parser/Writer you mean the ones I get in the Configuration browser? (see attachment) Or is there a package 'pharoExtras' where I can load everything in one go? If yes how to I load it? --Hannes

Aug. 8, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his ConfigurationOfTabular file http://ss3.gemtalksystems.com/ss/Tabular.html So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing Projects with Metacello The Tabular project needs a XMLWriter class. I assume the regular pharoExtras is fine. I do not know. I am just looking at the code to see how the reading and writing of MSOffice files, Excel in this particular case, is done so far. For reading a TabularSAXParser is included in the package. Probably not necessary. I moved it out here http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz Hannes On 8/8/15, stepharo <stepharo(a)free.fr> wrote: > > > Le 8/8/15 09:11, H. Hirzel a Ã©crit : >> What about >> http://rmod.lille.inria.fr/deepIntoPharo/index.html >> >> p. 163 depending on a project without Metacello description >> p. 164, depending on a project with a Metacello configuration >> >> In the mean time just a note that Tabular needs XMLParser and >> XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. > > are you implying that there is no expression of dependencies and > that in addition it depend on a different XML Parser/Writer than > pharoExtras ones? > > Stef >> >> Some class comments are welcome as well :-) >> >> I understand that I can read Excel files and that you just started to >> check out how to write them? >> >> --Hannes >> >> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>> Thank you Vincent. >>> Some things is much clearer for me now. >>> >>> *It's shame on me that I lost all this Metacello progress, especially >>> taking into account I was on the ESUG conference where it was presented. >>> It >>> was my only conference unfortunately.* >>> >>> I see that you already started this job: you added >>> ConfigurationOfTabular. >>> What I really want to do with this configuration: add dependencies to >>> XMLParser and XMLWriter packages. Can you help with this, please? >>> >>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>> <vincent.blondeau(a)worldline.com> >>> : >>> >>>> Hi, >>>> >>>> >>>> >>>> To add a configuration in the catalog, first you should have a >>>> configuration for your project. You can create it with the versionner >>>> if >>>> needed. >>>> >>>> >>>> >>>> Second, you have to add some methods adding meta-description to your >>>> project. The versionner do it for you: in the configuration list, >>>> select >>>> your project, do a right click and select add catalog methods. >>>> >>>> It creates all the mandatory methods for the catalog. You now have to >>>> fill >>>> them (look at the class side of the configuration). >>>> >>>> Finally, commit your configuration on your repo and on the >>>> MetaRepoForPharo30/40/50 depending where your project is working. >>>> >>>> The link is here: http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>> >>>> >>>> >>>> Once published, your project will be in the catalog in the image >>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>>> >>>> >>>> >>>> Tell me if you need help to do it, >>>> >>>> >>>> >>>> Cheers, >>>> >>>> Vincent >>>> >>>> >>>> >>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] *De la >>>> part de* ???? ????????? >>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 >>>> *Ã :* Any question about pharo is welcome >>>> *Objet :* Re: [Pharo-users] Tabular: XLSX import >>>> >>>> >>>> >>>> It looks like I need some guidance to understand contemporary >>>> packaging/deployment/versioning system. I know it exists, but I don't >>>> know >>>> details. Can you kick me in the right direction? Maybe some link? >>>> >>>> >>>> >>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >>>> >>>> Hi, >>>> >>>> >>>> >>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>> >>>> >>>> >>>> Esteban >>>> >>>> >>>> >>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>> >>>> >>>> >>>> Hello. >>>> >>>> Some time ago I announced Tabular >>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to make a >>>> tool for spreadsheets import/export. >>>> >>>> >>>> This is short notice: Vincent Blondeau have added XLSX import >>>> functionality! >>>> It's also mostly proof-of-concept now, but even at this stage it's >>>> quite >>>> usable. >>>> >>>> Thanks, Vincent! >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------ >>>> >>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >>>> l'usage >>>> exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le >>>> secret >>>> professionnel. Si vous recevez ce message par erreur, merci d'en >>>> avertir >>>> immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message ne >>>> pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne >>>> pourra >>>> Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs >>>> efforts soient faits pour maintenir cette transmission exempte de tout >>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant >>>> d'un >>>> virus transmis. >>>> >>>> This e-mail and the documents attached are confidential and intended >>>> solely for the addressee; it may also be privileged. If you receive >>>> this >>>> e-mail in error, please notify the sender immediately and destroy it. >>>> As >>>> its integrity cannot be secured on the Internet, the Worldline >>>> liability >>>> cannot be triggered for the message content. Although the sender >>>> endeavours >>>> to maintain a computer virus-free network, the sender does not warrant >>>> that >>>> this transmission is virus-free and will not be liable for any damages >>>> resulting from any virus transmitted. >>>> >> > > >

Aug. 8, 2015

Re: [Pharo-users] Tabular: XLSX import

by stepharo

Le 8/8/15 09:11, H. Hirzel a Ã©crit : > What about > http://rmod.lille.inria.fr/deepIntoPharo/index.html > > p. 163 depending on a project without Metacello description > p. 164, depending on a project with a Metacello configuration > > In the mean time just a note that Tabular needs XMLParser and > XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. are you implying that there is no expression of dependencies and that in addition it depend on a different XML Parser/Writer than pharoExtras ones? Stef > > Some class comments are welcome as well :-) > > I understand that I can read Excel files and that you just started to > check out how to write them? > > --Hannes > > On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >> Thank you Vincent. >> Some things is much clearer for me now. >> >> *It's shame on me that I lost all this Metacello progress, especially >> taking into account I was on the ESUG conference where it was presented. It >> was my only conference unfortunately.* >> >> I see that you already started this job: you added ConfigurationOfTabular. >> What I really want to do with this configuration: add dependencies to >> XMLParser and XMLWriter packages. Can you help with this, please? >> >> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >> <vincent.blondeau(a)worldline.com> >> : >> >>> Hi, >>> >>> >>> >>> To add a configuration in the catalog, first you should have a >>> configuration for your project. You can create it with the versionner if >>> needed. >>> >>> >>> >>> Second, you have to add some methods adding meta-description to your >>> project. The versionner do it for you: in the configuration list, select >>> your project, do a right click and select add catalog methods. >>> >>> It creates all the mandatory methods for the catalog. You now have to >>> fill >>> them (look at the class side of the configuration). >>> >>> Finally, commit your configuration on your repo and on the >>> MetaRepoForPharo30/40/50 depending where your project is working. >>> >>> The link is here: http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>> >>> >>> >>> Once published, your project will be in the catalog in the image >>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>> >>> >>> >>> Tell me if you need help to do it, >>> >>> >>> >>> Cheers, >>> >>> Vincent >>> >>> >>> >>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] *De la >>> part de* ???? ????????? >>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 >>> *Ã :* Any question about pharo is welcome >>> *Objet :* Re: [Pharo-users] Tabular: XLSX import >>> >>> >>> >>> It looks like I need some guidance to understand contemporary >>> packaging/deployment/versioning system. I know it exists, but I don't >>> know >>> details. Can you kick me in the right direction? Maybe some link? >>> >>> >>> >>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >>> >>> Hi, >>> >>> >>> >>> it would be sooo cool to have a configuration in the catalogâ¦ >>> >>> >>> >>> Esteban >>> >>> >>> >>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>> >>> >>> >>> Hello. >>> >>> Some time ago I announced Tabular >>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to make a >>> tool for spreadsheets import/export. >>> >>> >>> This is short notice: Vincent Blondeau have added XLSX import >>> functionality! >>> It's also mostly proof-of-concept now, but even at this stage it's quite >>> usable. >>> >>> Thanks, Vincent! >>> >>> >>> >>> >>> >>> ------------------------------ >>> >>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã l'usage >>> exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le >>> secret >>> professionnel. Si vous recevez ce message par erreur, merci d'en avertir >>> immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message ne >>> pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne >>> pourra >>> Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs >>> efforts soient faits pour maintenir cette transmission exempte de tout >>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant >>> d'un >>> virus transmis. >>> >>> This e-mail and the documents attached are confidential and intended >>> solely for the addressee; it may also be privileged. If you receive this >>> e-mail in error, please notify the sender immediately and destroy it. As >>> its integrity cannot be secured on the Internet, the Worldline liability >>> cannot be triggered for the message content. Although the sender >>> endeavours >>> to maintain a computer virus-free network, the sender does not warrant >>> that >>> this transmission is virus-free and will not be liable for any damages >>> resulting from any virus transmitted. >>> >

Aug. 8, 2015

Multi Line labels/texts [New-Line/Line-Feed help required]

by Jigyasa Grover

Hi I have made an accordion widget for my application *searchQuick* ( https://github.com/jig08/sQuick_new ), an offline text search application using Expander Morphs I was trying to insert a multi-line content in it , but in vain. The new-line methods don't seem to have the desired effect. *I have tried the following ways:* *1. dialog newExpander: (result title asString, Character cr asString , result content asString ) * *2. dialog newExpander: (result title asString, '\' withCRs, result content asString)* *3. dialog newExpander: (result title asString, String crlf , result content asString ) * *[ result is the array item representing a document having the search string ]* Could anyone pls point out the error in my approach ? It would be a great help. Thank You Jigyasa

Aug. 8, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

What about http://rmod.lille.inria.fr/deepIntoPharo/index.html p. 163 depending on a project without Metacello description p. 164, depending on a project with a Metacello configuration In the mean time just a note that Tabular needs XMLParser and XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. Some class comments are welcome as well :-) I understand that I can read Excel files and that you just started to check out how to write them? --Hannes On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: > Thank you Vincent. > Some things is much clearer for me now. > > *It's shame on me that I lost all this Metacello progress, especially > taking into account I was on the ESUG conference where it was presented. It > was my only conference unfortunately.* > > I see that you already started this job: you added ConfigurationOfTabular. > What I really want to do with this configuration: add dependencies to > XMLParser and XMLWriter packages. Can you help with this, please? > > 2015-08-04 17:19 GMT+03:00 Blondeau Vincent > <vincent.blondeau(a)worldline.com> > : > >> Hi, >> >> >> >> To add a configuration in the catalog, first you should have a >> configuration for your project. You can create it with the versionner if >> needed. >> >> >> >> Second, you have to add some methods adding meta-description to your >> project. The versionner do it for you: in the configuration list, select >> your project, do a right click and select add catalog methods. >> >> It creates all the mandatory methods for the catalog. You now have to >> fill >> them (look at the class side of the configuration). >> >> Finally, commit your configuration on your repo and on the >> MetaRepoForPharo30/40/50 depending where your project is working. >> >> The link is here: http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >> >> >> >> Once published, your project will be in the catalog in the image >> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >> >> >> >> Tell me if you need help to do it, >> >> >> >> Cheers, >> >> Vincent >> >> >> >> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] *De la >> part de* ???? ????????? >> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 >> *Ã :* Any question about pharo is welcome >> *Objet :* Re: [Pharo-users] Tabular: XLSX import >> >> >> >> It looks like I need some guidance to understand contemporary >> packaging/deployment/versioning system. I know it exists, but I don't >> know >> details. Can you kick me in the right direction? Maybe some link? >> >> >> >> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >> >> Hi, >> >> >> >> it would be sooo cool to have a configuration in the catalogâ¦ >> >> >> >> Esteban >> >> >> >> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >> >> >> >> Hello. >> >> Some time ago I announced Tabular >> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to make a >> tool for spreadsheets import/export. >> >> >> This is short notice: Vincent Blondeau have added XLSX import >> functionality! >> It's also mostly proof-of-concept now, but even at this stage it's quite >> usable. >> >> Thanks, Vincent! >> >> >> >> >> >> ------------------------------ >> >> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã l'usage >> exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le >> secret >> professionnel. Si vous recevez ce message par erreur, merci d'en avertir >> immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message ne >> pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne >> pourra >> Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs >> efforts soient faits pour maintenir cette transmission exempte de tout >> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant >> d'un >> virus transmis. >> >> This e-mail and the documents attached are confidential and intended >> solely for the addressee; it may also be privileged. If you receive this >> e-mail in error, please notify the sender immediately and destroy it. As >> its integrity cannot be secured on the Internet, the Worldline liability >> cannot be triggered for the message content. Although the sender >> endeavours >> to maintain a computer virus-free network, the sender does not warrant >> that >> this transmission is virus-free and will not be liable for any damages >> resulting from any virus transmitted. >> >

Aug. 8, 2015

Re: [Pharo-users] MSOffice DOCX generation?

by H. Hirzel

I found Tabular http://ss3.gemtalksystems.com/ss/Tabular.html which is for Spreadsheets files. It is useful as an example for creating something similar for DOCX files. On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > A similar library but for Java > > http://www.docx4java.org/trac/docx4j > > On 8/7/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> Hello >> >> Is there a library like for Pharo to generate DOCX files? >> >> Something like this >> https://docx.codeplex.com/ >> DocX is a .NET library that allows developers to manipulate Word >> 2007/2010/2013 files, in an easy and intuitive manor. DocX is fast, >> lightweight and best of all it does not require Microsoft Word or >> Office to be installed. >> >> Regards >> >> Hannes >> >

Aug. 8, 2015

Re: [Pharo-users] PharoJS

by Noury Bouraqadi

The only connection is that they share the same goal of converting Smalltalk code to JavaScript. Noury > On 07 Aug 2015, at 21:02, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > > Is PharoJS related to / based on > > http://www.squeaksource.com/@45sUWABDUdZM7Og0/Uycfg_AQ > > > ST2JS - Traductor de Smalltalk a JavaScript > http://diegogomezdeck.blogspot.com/2006/07/st2js-traductor-de-smalltalk.html > Las caracterÃsticas de JavaScript mencionadas anteriormente, usadas > con picardÃa, permiten hacer un traductor de Smalltalk a JavaScript > que respete toda la semÃ¡ntica del Smalltalk. > ? > > --Hannes > > On 7/16/15, Noury Bouraqadi <bouraqadi(a)gmail.com> wrote: >>> On 15 Jul 2015, at 15:37, Andy Burnett <andy.burnett(a)knowinnovation.com> >>> wrote: >>> >> >>> One question. When I execute 1+1 on the Pharo (pink) playground, I see the >>> code appearing in the web browser log, but it doesn't appear to execute. >>> Is it supposed to, or at this stage is it just showing that it made it >>> over to the web browser? >>> >> It does actually execute on the browser, but 1+1 has no side effect :-). >> >> You can try to call native javascript object to see stuff changing. >> For example, you can evaluate the following> >> >> console native_log: 'Hello from Smalltalk'. "Displays the string in the >> console of the browser" >> window native_alert: 'This is cool'. "Opens an alert window on the >> browser" >> >> >> Note: You need to load version 51 (just pushed it to SmalltalkHub) that >> fixes a bug in the PharoJS workspace. >> >> Noury >> >> >> >> >

Aug. 8, 2015