Hi Aitor I'm sorry for my late reply, but I was very busy these days. We changed the names of the entities, removing namespaces, that's way we removed the entities, sorry for the inconvenience. regarding how to store the data into CKAN, see my comments below. Thanks and best regards Davide Il 02/07/2015 17:39, Aitor Magán ha scritto: > Hi Davide, Hi Monica, Hi All, > > @Davide: I've created the component to retrieve the data from the > Context Broker and push it to CKAN. I've used the approach that I told > you yesterday since I've no news from you. However, I cannot test the > service since all the entities have been removed from the CB instance. > Why? > > @Monica: Have you asked Manuel how demo tickets should be created? > (pattern,...) > > BR > Aitor > > 2015-07-01 15:53 GMT+02:00 Aitor Magán <amagan at conwet.com > <mailto:amagan at conwet.com>>: > > Hi Davide, Hi all, > > I'm not pretty sure, but I think that the information about the > prosumers is static (it does not changes) so I don't understand > why this information has to be stored in the Context Broker. I > think that the best place to store static information is CKAN. > I think it's better to mantain those entities in the CB: they also may change in some attributes. Is it a big issue to leave them in the CB? > > I don't know if I've understood you, but you want two different > datastes a day: one for meters and another one for loads. > yes > Should every row of both dataset contains prosumer information? I > think this is a waste of space since the information about the > prosumers will be replicated a lot of times. > The datasets will be more self-explaining when containing prosumers data. With ad-hoc reporting capabilities (within SpagoBI but also with CKAN I think), users will be able to display values grouping by prosumers attributes (city, type, ...) in a very simple way if the dataset contains that information; otherwise, the user has to join the dataset to another one (that's possible but more complicated). We have to clarify a difference between "dataset" term in SpagoBI and CKAN: 1. in SpagoBI a dataset is 1 file or 1 SQL statement or 1 script..... 2. in CKAN a dataset is a container for 1 or more resources. When CKAN datasets are imported into SpagoBI, a SpagoBI dataset is defined for each resource available within the CKAN dataset. > > In my opinion, the best approach is the following one: one dataset > for each prosumer. Everyday, the system will attach two different > resources to these datasets: one for meters and one for loads. The > prosumer information can be stored in the dataset metadata. What > do you think? > I don't like this approach very much: according to me, it's better to put information about all prosumers in the same file: in this way, final users (with ad-hoc reporting) will be able both to aggregate on all prosumers and to filter data for a single prosumer quite easily. If the users wants to aggregate values for several prosumers, it is quite difficult if values are stored in different datasets. What do you think? According to me we don't have to worry about space occupation (at least not in this moment) or to think about optimization, we have to show how components work and interoperate. > > P.S. I've installed the extension that allows you to download > information stored in the datastore as CSV. :) > Good! Can you please provide us some documentation in order to understand how to use it? > > BR > Aitor > > 2015-07-01 13:46 GMT+02:00 Davide Zerbetto <davide.zerbetto at eng.it > <mailto:davide.zerbetto at eng.it>>: > > Hi all > we updated the CB entities as we discussed yesterday and their > documentation on the technical document. > @Aitor: your component should subscribe for Meter and Load > entities creation and update, then data should be collected in > flat datasets: I propose 1 dataset for meters and 1 dataset > for loads, collecting data for 1 day. The best would be CSV > files containing information about the prosumer and the > meter/load: each line of the csv should contain prosumer info > plus meter/load. > Regarding names of the columns: we used namespaces, but we are > thinking about removing them. Is it possible for you to define > more simple CSV columns names? for example: > BusinessDemo:Prosumer:address:name --> Prosumer Name > BusinessDemo:Prosumer:address:city --> City > BusinessDemo:Prosumer:address:country --> Country > BusinessDemo:Prosumer:address:number--> Address number > and so on. > Thanks and best regards > Davide > > > Il 29/06/2015 10:47, Aitor Magán ha scritto: >> I need to know the entities that you are using in the Context >> Broker and the structure of the CKAN datasets that you expect. >> >> BR >> Aitor >> >> 2015-06-29 10:38 GMT+02:00 Davide Zerbetto >> <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>>: >> >> Hi Aitor >> referring to the work plan >> <https://docs.google.com/document/d/1I9FoZ8KkzXOXNPvrWOklzU5ajboQ1hSEZevfGomEWas/edit>, >> do you have enough information to start with task T.2.2? >> I don't know if the information we provided on the >> technical document if enough for you... >> Thanks and best regards >> Davide >> >> Il 29/06/2015 10:26, Aitor Magán ha scritto: >>> Sorry Davide, I do not understand the question. What >>> information do I need to start collecting data? >>> >>> BR >>> Aitor >>> >>> 2015-06-29 10:23 GMT+02:00 Davide Zerbetto >>> <davide.zerbetto at eng.it <mailto:davide.zerbetto at eng.it>>: >>> >>> Hi all >>> we installed the Prosumers Simulator (the mock >>> component that generates anonymous data) on the same >>> VM hosting the CB. >>> Now it is running. I updated the technical document >>> also. >>> Of course if you have comments, don't hesitate to ask. >>> @Aitor: do you have enough information to start >>> collecting data into CKAN datasets? >>> Thanks and best regards >>> Davide >>> -- >>> >>> -- >>> >>> *Davide Zerbetto* >>> SpagoBI Consultant >>> >>> *SpagoBI Labs >>> Engineering Group* >>> Corso Stati Uniti, 23/C - 35127 Padua - Italy >>> Phone: +39 049 8283411 <tel:%2B39%20049%208283411> >>> Fax: +39-049.8700272 <tel:%2B39-049.8700272> >>> www.spagobi.org <http://www.spagobi.org> - >>> www.eng.it <http://www.eng.it/web/eng_en/home> >>> >>> >>> Respect the environment. Please don't print this >>> e-mail unless you really need to. >>> >>> The information transmitted is intended only for the >>> person or entity to which it is addressed and may >>> contain confidential and/or privileged material. Any >>> review, retransmission, dissemination or other use >>> of, or taking of any action in reliance upon, this >>> information by persons or entities other than the >>> intended recipient is prohibited. If you received >>> this in error, please contact the sender and delete >>> the material from any computer. >>> >>> >>> _______________________________________________ >>> Fiware-apps mailing list >>> Fiware-apps at lists.fi-ware.org >>> <mailto:Fiware-apps at lists.fi-ware.org> >>> https://lists.fi-ware.org/listinfo/fiware-apps >>> >>> >>> >>> >>> -- >>> Best Regards >>> Aitor Magán >>> >>> Twiter <https://twitter.com/AitorMagan> >>> <https://es.linkedin.com/in/aitormagan> >>> <https://github.com/AitorMagan> >>> >>> >>> _______________________________________________ >>> Fiware-apps mailing list >>> Fiware-apps at lists.fi-ware.org <mailto:Fiware-apps at lists.fi-ware.org> >>> https://lists.fi-ware.org/listinfo/fiware-apps >> >> -- >> >> -- >> >> *Davide Zerbetto* >> SpagoBI Consultant >> >> *SpagoBI Labs >> Engineering Group* >> Corso Stati Uniti, 23/C - 35127 Padua - Italy >> Phone: +39 049 8283411 <tel:%2B39%20049%208283411> >> Fax: +39-049.8700272 <tel:%2B39-049.8700272> >> www.spagobi.org <http://www.spagobi.org> - www.eng.it >> <http://www.eng.it/web/eng_en/home> >> >> >> Respect the environment. Please don't print this >> e-mail unless you really need to. >> >> The information transmitted is intended only for the >> person or entity to which it is addressed and may contain >> confidential and/or privileged material. Any review, >> retransmission, dissemination or other use of, or taking >> of any action in reliance upon, this information by >> persons or entities other than the intended recipient is >> prohibited. If you received this in error, please contact >> the sender and delete the material from any computer. >> >> >> _______________________________________________ >> Fiware-apps mailing list >> Fiware-apps at lists.fi-ware.org >> <mailto:Fiware-apps at lists.fi-ware.org> >> https://lists.fi-ware.org/listinfo/fiware-apps >> >> >> >> >> -- >> Best Regards >> Aitor Magán >> >> Twiter <https://twitter.com/AitorMagan> >> <https://es.linkedin.com/in/aitormagan> >> <https://github.com/AitorMagan> > > -- > > -- > > *Davide Zerbetto* > SpagoBI Consultant > > *SpagoBI Labs > Engineering Group* > Corso Stati Uniti, 23/C - 35127 Padua - Italy > Phone: +39 049 8283411 <tel:%2B39%20049%208283411> > Fax: +39-049.8700272 <tel:%2B39-049.8700272> > www.spagobi.org <http://www.spagobi.org> - www.eng.it > <http://www.eng.it/web/eng_en/home> > > > Respect the environment. Please don't print this e-mail > unless you really need to. > > The information transmitted is intended only for the person or > entity to which it is addressed and may contain confidential > and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in > reliance upon, this information by persons or entities other > than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the > material from any computer. > > > > > -- > Best Regards > Aitor Magán > > Twiter <https://twitter.com/AitorMagan> > <https://es.linkedin.com/in/aitormagan> > <https://github.com/AitorMagan> > > > > > -- > Best Regards > Aitor Magán > > Twiter <https://twitter.com/AitorMagan> > <https://es.linkedin.com/in/aitormagan> <https://github.com/AitorMagan> -- -- *Davide Zerbetto* SpagoBI Consultant *SpagoBI Labs Engineering Group* Corso Stati Uniti, 23/C - 35127 Padua - Italy Phone: +39 049 8283411 Fax: +39-049.8700272 www.spagobi.org <http://www.spagobi.org> - www.eng.it <http://www.eng.it/web/eng_en/home> Respect the environment. Please don't print this e-mail unless you really need to. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 3639 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 1379 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment.jpe> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 3639 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment-0001.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 1379 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment-0001.jpe> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/png Size: 3639 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment-0002.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 1379 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment-0002.jpe> -------------- next part -------------- A non-text attachment was scrubbed... Name: spagobi.png Type: image/png Size: 3639 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment-0003.png> -------------- next part -------------- A non-text attachment was scrubbed... Name: image006.jpg Type: image/jpeg Size: 1379 bytes Desc: not available URL: <https://lists.fiware.org/private/fiware-apps/attachments/20150702/14d5760d/attachment.jpg>
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy