isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Haywood <>
Subject Re: New screencast on bulk updates using the Excel domain service
Date Mon, 17 Feb 2014 09:05:35 GMT
On 17 February 2014 06:42, <> 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).


> BR
> Ranganath Varma
> -----Original Message-----
> From: Dan Haywood []
> 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]
> [2]
> [3]
> [4]
> 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.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message