isis-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mb Myco <m...@myco.ws>
Subject Re: New screencast on bulk updates using the Excel domain service
Date Mon, 17 Feb 2014 14:19:47 GMT
Need to take care where there are dependent items, eg some columns may contain FK or ID of
another entity, that might already exist or might be part of the current import.

Best Regards

Mike Burton
(Sent from my iPhone)



> On 17 Feb 2014, at 09:05, Dan Haywood <dan@haywood-associates.co.uk> wrote:
> 
>> On 17 February 2014 06:42, <chittari.varma@wipro.com> 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:dan@haywood-associates.co.uk]
>> 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
>> 

Mime
View raw message