- Pharo-users - lists.pharo.org

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

Hello Jurij and Vincent I am working on extending the export function (export of several worksheets). For this I am adding some more tests currently and I'd like to have your feedback on some of the basic functions regarding initial values. http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz (41 tests run, 32 passes) in particular on class TabularWorksheetTest (3 tests) We have for example Test which passes testCellsReadingEmptyCell0 "accessing a cell without data" ws col: 1 row: 1 putData: 11. ws col: 2 row: 1 putData: 21. self assert: (ws col: 1 row: 1) data equals: 11. self assert: (ws col: 2 row: 1) data equals: 21. self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have nil returned?" Test which does not pass testCellsReadingEmptyCell self assert: ((ws col: 100 row: 100) data =''). "probably should return an empty string" Comments of others are invited as well. -- Hannes On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: > If your are using at least Pharo 4.0, you can use the catalog browser to > load the ConfigurationOfTabular directly. > > You have only publish it for MetaRepoForPharo50, so it didn't work for > Pharo 4. > BUt, thanks to your explanations, I just have published in > MetaRepoForPharo40 as well - works like charm! > > 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < > vincent.blondeau(a)polytech-lille.net>: > >> 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. 13, 2015

Spec TreeModel

by Thomas Heniart

Hi, I'm using TreeModel>>beCheckList and I wanted to know if it is possible to dissociate the checkbox and label. More precisely, what I want is changing state by clicking on the checkbox only Is it possible ? Cheers, Thomas

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Ben Coman

On Wed, Aug 12, 2015 at 6:38 PM, Sean P. DeNigris <sean(a)clipperadams.com> wrote: > Ben Coman wrote >> Unless your requirements *specifically* need identical files to be >> maintained as duplicates, I would strongly consider using something >> content based like MD5 or SHA > > Interesting... There should not be any duplicates. What's the advantage over > UUID? > This... "move to another OS and continue generating [file-ids] with another VM? " An sha-hash intrinsically represents THE content (it is *always* the same no matter who/where/how its calculated), whereas a UUID is a randomly generated label assigned to the content. also, depending on use-case, it may facilitate... * easy to verify whether the file contents have changed. * periodic checking of backups/restores for file corruption (including by external tools without reference to indexes maintained by your Application Image. * facilitate revision control, if you come across a file whose filename doesn't match its contents-sha-hash, then you know its ancestor content by its current file-id. And for my own use case "some day".... I know have many duplicate files scattered amongst many adhoc backups. For example, over ten years several cycles of upgrading to a new PC where the quick-safe path taken was to copy the old PC hard drive to a subfolder on the new PC hard drive, but the old hard went into a box now with a dozen friends, plus duplication of many old small backups media (floppy, ZIP-Media, tape) that it wold help to consolidate onto several of todays large media. cheers -ben

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Sean P. DeNigris

Ben Coman wrote > Unless your requirements *specifically* need identical files to be > maintained as duplicates, I would strongly consider using something > content based like MD5 or SHA Interesting... There should not be any duplicates. What's the advantage over UUID? ----- Cheers, Sean -- View this message in context: http://forum.world.st/UUIDs-tp4842189p4842284.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Peter UhnÃ¡k

> > btw2, UUID actually uses MD5 and SHA, but on a smaller input than full > file contents. > Pharo implements version 4, which uses purely random bits; not MD5/SHA/MAC. > > btw3, I love turtles all the way down, but given that crypto > algorithms are CPU bound and Pharo will be single-CPU for some time, > it might be pragmatic to have the crypto primitives to thread onto a > separate CPU, and maybe take advantage of hardware acceleration. Call > it SHAxExternal... > https://software.intel.com/en-us/articles/intel-sha-extensions There's an advantage of using UUIDs, because if you have larger files, hashing them might take a considerable amount of CPU time and disk I/O. But having it content-based is also an advantage, because it can be created independently (and verifiably). Peter

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Ben Coman

On Wed, Aug 12, 2015 at 2:09 AM, Sean P. DeNigris <sean(a)clipperadams.com> wrote: > Searching the archives, I found an interesting comment [1]: > "I think the UUIDGenerator in the image produces UUIDs which are good > enough for MC. " - Levente Uzonyi > > I am pretty well confused by UUIDs in general (they seem magical) and > Pharo's implementation. The use case I have in mind is a file library which > imports files into a single folder, but changes their names to something > guaranteed to be unique so that they don't overwrite each other. Would UUIDs > work in that case? Would the image ones be "good enough"? Are > primitive-generated UUIDs guaranteed to always be unique if, say, I move the > image to another OS and continue generating them with another VM? Thanks! > > [1] http://forum.world.st/UUID-and-Cog-tp2955687p2957172.html > Unless your requirements *specifically* need identical files to be maintained as duplicates, I would strongly consider using something content based like MD5 or SHA. Guaranteed to remain the same between OS and good-enough uniqueness. Its also compatible with external tools. Pharo seems to have an implementation. https://en.wikipedia.org/wiki/Secure_Hash_Algorithm Depending on the breadth of your audience, you may want to base it off HashFunction and allow user configuration of algorithm. Selectivity between security and performance can be useful. btw1, git uses SHA-1... https://git-scm.com/book/en/v2/Git-Internals-Git-Objects btw2, UUID actually uses MD5 and SHA, but on a smaller input than full file contents. Cross platform may(?) have to contend with there being several revisions of UUID (unless handling all past versions is implicit in all implementations), particularly by external tools. https://en.wikipedia.org/wiki/Universally_unique_identifier btw3, I love turtles all the way down, but given that crypto algorithms are CPU bound and Pharo will be single-CPU for some time, it might be pragmatic to have the crypto primitives to thread onto a separate CPU, and maybe take advantage of hardware acceleration. Call it SHAxExternal... https://software.intel.com/en-us/articles/intel-sha-extensions cheers -ben

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Peter UhnÃ¡k

The UUIDGenerator has unnecessarily heavy-handed implementation, however it does adhere to the RFC specs as far as I could tell. Which also means that it's definitely usable across images and platforms. If anything, the weak point would be the random number generator, not UUID. And at least on unix/linux it uses /dev/urandom so it should be pretty reliable. So ask yourself what's the probability of your PRNGs generating same 122 bits. This thread might also interest you http://forum.world.st/Contributing-to-VoyageMongo-improving-insertion-updat… Peter On Tue, Aug 11, 2015 at 8:09 PM, Sean P. DeNigris <sean(a)clipperadams.com> wrote: > Searching the archives, I found an interesting comment [1]: > "I think the UUIDGenerator in the image produces UUIDs which are good > enough for MC. " - Levente Uzonyi > > I am pretty well confused by UUIDs in general (they seem magical) and > Pharo's implementation. The use case I have in mind is a file library which > imports files into a single folder, but changes their names to something > guaranteed to be unique so that they don't overwrite each other. Would > UUIDs > work in that case? Would the image ones be "good enough"? Are > primitive-generated UUIDs guaranteed to always be unique if, say, I move > the > image to another OS and continue generating them with another VM? Thanks! > > [1] http://forum.world.st/UUID-and-Cog-tp2955687p2957172.html > > > > ----- > Cheers, > Sean > -- > View this message in context: http://forum.world.st/UUIDs-tp4842189.html > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > >

Aug. 11, 2015

UUIDs

by Sean P. DeNigris

Searching the archives, I found an interesting comment [1]: "I think the UUIDGenerator in the image produces UUIDs which are good enough for MC. " - Levente Uzonyi I am pretty well confused by UUIDs in general (they seem magical) and Pharo's implementation. The use case I have in mind is a file library which imports files into a single folder, but changes their names to something guaranteed to be unique so that they don't overwrite each other. Would UUIDs work in that case? Would the image ones be "good enough"? Are primitive-generated UUIDs guaranteed to always be unique if, say, I move the image to another OS and continue generating them with another VM? Thanks! [1] http://forum.world.st/UUID-and-Cog-tp2955687p2957172.html ----- Cheers, Sean -- View this message in context: http://forum.world.st/UUIDs-tp4842189.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 11, 2015

Re: [Pharo-users] Spreadsheet editor

by H. Hirzel

On 8/11/15, Peter UhnÃ¡k <i.uhnak(a)gmail.com> wrote: > Hi, > > since there has been talk about Tabular/DOCX, http://ss3.gemtalksystems.com/ss/Tabular.html > is there any project aimed at actually editing tables/spreadsheets inside > Pharo? > > There's Spreadsheet by Torsten, but that seems to be an abandoned > proof-of-concept. > > Peter > There is a start at using Glamour and Spec to view the tables in Tabular. http://ss3.gemtalksystems.com/ss/Tabular.html I have not tried it out yet. Needs a Glamour specialist to have a look. Not sure about editing. NeoCSV style import works ; limited export works. Currently I am focused on getting roundtrip Import / Export of XLSX files working for a slightly extended subset of the features. (cell attributes, in particular 'font size, word wrap and column width attributes') To have a display of it would be great. --Hannes TabularWorksheet>>showWithGlamour | wrapper matrix table | matrix := self cellsAsMatrix. wrapper := GLMWrapper new. wrapper show: [ :a | table := a table. 1 to: matrix columnCount do: [ :i | table column: i asString evaluated: [ :col | col at: i ] width: 50 ] ]. wrapper openOn: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i ]) TabularWorksheet>>showWithSpec | matrix tree specCols | matrix := self cellsAsMatrix. tree := TreeModel new. specCols := (1 to: matrix columnCount) collect: [ :i | TreeColumnModel new displayBlock: [ :node | (node content at: i) asString ]; headerLabel: i asString; yourself ]. tree columns: specCols. tree roots: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i ]). tree openWithSpec.

Aug. 11, 2015

Re: [Pharo-users] Help regarding Scroll Pane usage

by Jigyasa Grover

*Steps to reproduce:* 1. Open a fresh image 2. Load Configuration : World > Tools > Configuration Browser > sQuick_new 3. Do It `IndexInterface open` in playground 4. Search for a word, say **of** , type in input box and click on *SEARCH* button. The following screen appears: <http://forum.world.st/file/n4842176/57.png> It is desired for this to be scroll-able as when the number of search results extend beyond the screen/window extent, scroll-pane would be required. LINK to GitHUb ISSUE for further details: https://github.com/jig08/sQuick_new/issues/22 -- View this message in context: http://forum.world.st/Help-regarding-Scroll-Pane-usage-tp4838485p4842176.ht… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 11, 2015