On 17 February 2014 06:42, <[email protected]> wrote: > > So just one question: You mentioned that this screencast is for bulk > updates through Excel. But Is this new feature can also do bulk inserts > using Excel? >
It would be easy enough to adapt the domain service to support this. The way the domain service works is that: - in ExcelService#toExcel() - ie for download - it exports the collection of view models, and creates a spreadsheet with the "viewModelMemento" column representing the Id of the view model, and the other columns representing the state of the fields of the view model. - in ExcelService#fromExcel() - ie for upload - it converts the spreadsheet into a collection of view models, with each view model given an Id corresponding to the viewModelMemento column, and the state copied over. If doing a bulk insert, then the "viewModelMemento" column doesn't make sense, because there is no existing data being exported. So I could imagine that a bulk insert would work simply by using an in-memory counter and using this as the id of each view model. After all: it's not the id that makes sense for a bulk insert, it's the data being copied across from the columns. Please experiment with this, if you get something working, then raise a pull request on my isis-domainservice-excel github repo and I'll incorporate. (Or, I might just do myself; having writen the above, I think it's pretty trivial to support). Cheers Dan > > BR > Ranganath Varma > > > -----Original Message----- > From: Dan Haywood [mailto:[email protected]] > Sent: Sunday, February 16, 2014 9:21 PM > To: users > Cc: dev > Subject: New screencast on bulk updates using the Excel domain service > > Hi folks, > > just a heads-up that the Isis website now contains a new page and > screencast [1] showing how Estatio [2] uses the Excel domainservice [3] > that I recently put together. > > I've also updated some of the existing pages which have screencasts for > them, and updated the main documentation page [4] so it is easier (through > a little icon) to see which pages have screencasts on them. > > Any feedback (positive or negative) let me know > > Cheers > Dan > > PS: hoping to do a 1.4.0 release this coming week. > > > [1] > > http://isis.apache.org/reference/services/third-party/danhaywood-isis-domainservice-excel.html > [2] https://github.com/estatio/estatio > [3] https://github.com/danhaywood/isis-domainservice-excel > [4] http://isis.apache.org/documentation.html > > The information contained in this electronic message and any attachments > to this message are intended for the exclusive use of the addressee(s) and > may contain proprietary, confidential or privileged information. If you are > not the intended recipient, you should not disseminate, distribute or copy > this e-mail. Please notify the sender immediately and destroy all copies of > this message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. > The company accepts no liability for any damage caused by any virus > transmitted by this email. > > www.wipro.com >
