You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@isis.apache.org by Dan Haywood <da...@haywood-associates.co.uk> on 2014/02/16 16:51:12 UTC
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
Re: New screencast on bulk updates using the Excel domain service
Posted by GESCONSULTOR - Óscar Bou <o....@gesconsultor.com>.
Hi, Dan.
Really nice way to update domain entities from Excel!
There are plenty of use cases where users can speed up by updating fields massively through Excel.
And the ability to control the business logic applied on those updates by working through view models instead of the original domain entities is simply great.
Many Thanks!
El 16/02/2014, a las 16:51, Dan Haywood <da...@haywood-associates.co.uk> escribió:
> 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
Óscar Bou Bou
Responsable de Producto
Auditor Jefe de Certificación ISO 27001 en BSI
CISA, CRISC, APMG ISO 20000, ITIL-F
902 900 231 / 620 267 520
http://www.twitter.com/oscarbou
http://es.linkedin.com/in/oscarbou
http://www.GesConsultor.com
Este mensaje y los ficheros anexos son confidenciales. Los mismos contienen información reservada que no puede ser difundida. Si usted ha recibido este correo por error, tenga la amabilidad de eliminarlo de su sistema y avisar al remitente mediante reenvío a su dirección electrónica; no deberá copiar el mensaje ni divulgar su contenido a ninguna persona.
Su dirección de correo electrónico junto a sus datos personales constan en un fichero titularidad de Gesdatos Software, S.L. cuya finalidad es la de mantener el contacto con Ud. Si quiere saber de qué información disponemos de Ud., modificarla, y en su caso, cancelarla, puede hacerlo enviando un escrito al efecto, acompañado de una fotocopia de su D.N.I. a la siguiente dirección: Gesdatos Software, S.L. , Paseo de la Castellana, 153 bajo - 28046 (Madrid), y Avda. Cortes Valencianas num. 50, 1ºC - 46015 (Valencia). Asimismo, es su responsabilidad comprobar que este mensaje o sus archivos adjuntos no contengan virus informáticos, y en caso que los tuvieran eliminarlos.
Re: New screencast on bulk updates using the Excel domain service
Posted by GESCONSULTOR - Óscar Bou <o....@gesconsultor.com>.
Hi, Dan.
Really nice way to update domain entities from Excel!
There are plenty of use cases where users can speed up by updating fields massively through Excel.
And the ability to control the business logic applied on those updates by working through view models instead of the original domain entities is simply great.
Many Thanks!
El 16/02/2014, a las 16:51, Dan Haywood <da...@haywood-associates.co.uk> escribió:
> 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
Óscar Bou Bou
Responsable de Producto
Auditor Jefe de Certificación ISO 27001 en BSI
CISA, CRISC, APMG ISO 20000, ITIL-F
902 900 231 / 620 267 520
http://www.twitter.com/oscarbou
http://es.linkedin.com/in/oscarbou
http://www.GesConsultor.com
Este mensaje y los ficheros anexos son confidenciales. Los mismos contienen información reservada que no puede ser difundida. Si usted ha recibido este correo por error, tenga la amabilidad de eliminarlo de su sistema y avisar al remitente mediante reenvío a su dirección electrónica; no deberá copiar el mensaje ni divulgar su contenido a ninguna persona.
Su dirección de correo electrónico junto a sus datos personales constan en un fichero titularidad de Gesdatos Software, S.L. cuya finalidad es la de mantener el contacto con Ud. Si quiere saber de qué información disponemos de Ud., modificarla, y en su caso, cancelarla, puede hacerlo enviando un escrito al efecto, acompañado de una fotocopia de su D.N.I. a la siguiente dirección: Gesdatos Software, S.L. , Paseo de la Castellana, 153 bajo - 28046 (Madrid), y Avda. Cortes Valencianas num. 50, 1ºC - 46015 (Valencia). Asimismo, es su responsabilidad comprobar que este mensaje o sus archivos adjuntos no contengan virus informáticos, y en caso que los tuvieran eliminarlos.
Re: New screencast on bulk updates using the Excel domain service
Posted by David Tildesley <da...@yahoo.co.nz>.
Nice work :) . Looking forward to 1.4.0 also.
On Monday, 17 February 2014 4:52 AM, Dan Haywood <da...@haywood-associates.co.uk> wrote:
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
Re: New screencast on bulk updates using the Excel domain service
Posted by Mb Myco <mb...@myco.ws>.
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 <da...@haywood-associates.co.uk> wrote:
>
>> On 17 February 2014 06:42, <ch...@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
>>
Re: New screencast on bulk updates using the Excel domain service
Posted by Dan Haywood <da...@haywood-associates.co.uk>.
On 17 February 2014 06:42, <ch...@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
>
RE: New screencast on bulk updates using the Excel domain service
Posted by ch...@wipro.com.
Hi Dan,
That really great! We were looking for such feature.
Actually due to our company network policies I can't access some part of the page especially the documentation part of screencast.
http://isis.apache.org/reference/services/third-party/danhaywood-isis-domainservice-excel.html
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?
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
Re: New screencast on bulk updates using the Excel domain service
Posted by Mb Myco <mb...@myco.ws>.
Hi Dan,
Looks great, nice work!
Mike Burton
(Sent from my iPhone)
> On 16 Feb 2014, at 15:51, Dan Haywood <da...@haywood-associates.co.uk> wrote:
>
> 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
RE: New screencast on bulk updates using the Excel domain service
Posted by ch...@wipro.com.
Hi Dan,
That really great! We were looking for such feature.
Actually due to our company network policies I can't access some part of the page especially the documentation part of screencast.
http://isis.apache.org/reference/services/third-party/danhaywood-isis-domainservice-excel.html
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?
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