Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Hi Craig,

I already have a fix for this in for the next version. I did this:

while (true) { String line = in.readLine(); if (line == null) { if (terminated) break; else throw new IOException("no data"); } readParts(line.split("\\s+")); readError(); }

I have added the table:

create table reportInstanceUserComments ( reportinstanceId int not null, typeId int not null, typeKey int not null, ts bigint not null, userid int not null, commentText varchar(1024) not null) alter table reportinstanceusercomments add constraint reportInstanceUserCommentsFk1 foreign key (reportInstanceId) references reportInstances(id) on delete cascade;

And then in ReportDao.java, code to select comments from the userComments table and add to reportInstanceUserComments

+ //Insert the reportInstanceUserComments + if (instance.getIncludeUserComments() != ReportVO.USER_COMMENTS_NONE ) { + String ucSQL = "insert into reportInstanceUserComments "+ + " (reportInstanceId,typeId, typeKey, ts, userId, commentText)"+ + " select "+ instance.getId() +", uc.commentType, uc.typeKey, uc.ts, uc.userId, uc.commentText "+ + " from userComments uc "; + + + if (instance.isFromInception() && instance.isToNow()) + ejt.update(ucSQL, new Object[] {}); + else if (instance.isFromInception()) + ejt.update(ucSQL +" where uc.ts<? ", + new Object[] {instance.getReportEndTime()}); + else if (instance.isToNow()) + ejt.update(ucSQL +" where uc.ts>=? ", + new Object[] {instance.getReportStartTime()}); + else + ejt.update(ucSQL +" where uc.ts>=? and uc.ts<? ", + new Object[] {instance.getReportStartTime(), instance.getReportEndTime()}); + + ejt.update(ucSQL + " join reportInstanceData rid on uc.typeKey=rid.pointValueId where uc.commentType=" + UserComment.TYPE_POINT_VALUE); + ejt.update(ucSQL + " join reportInstanceEvents rie on uc.typeKey=rie.eventId where uc.commentType=" + UserComment.TYPE_EVENT); + + + } + // If the report had undefined start or end times, update them with values from the data. if (instance.isFromInception() || instance.isToNow()) {

and then to select the comments from the reportInstanceUserComments table for inclusion when the report is being displayed:

public List<EventInstance> getReportInstanceEvents(int instanceId) { - return query(EVENT_SELECT, new Object[] {instanceId}, new EventDao.EventInstanceRowMapper()); - } + List<EventInstance> results = query(EVENT_SELECT, new Object[] {instanceId}, new EventDao.EventInstanceRowMapper()); + attachEventRelationalInfo(results, instanceId); + return results; + } + + private void attachEventRelationalInfo(List<EventInstance> list, int instanceId) { + for (EventInstance e : list) + attachEventRelationalInfo(e, instanceId); + } + + private void attachEventRelationalInfo(EventInstance event, int instanceId) { + event.setEventComments(query( + ReportUserCommentRowMapper.USER_COMMENT_SELECT + + " and typeId=" + UserComment.TYPE_EVENT + + " and typeKey=?", new Object[] {instanceId, event.getId()}, new UserCommentRowMapper())); + } + + public List<ReportUserComment> getReportInstanceUserComments(int instanceId) { + return query( + ReportUserCommentRowMapper.USER_COMMENT_SELECT + + " order by ts asc", new Object[] {instanceId}, new ReportUserCommentRowMapper()); + } + + class ReportUserCommentRowMapper implements GenericRowMapper<ReportUserComment> { + public static final String USER_COMMENT_SELECT = + "select distinct uc.userId, u.username, uc.ts, uc.commentText, uc.typeId, uc.typeKey "+ + "from reportInstanceUserComments uc join users u on uc.userId = u.id "+ + "where reportInstanceId=? "; + + public ReportUserComment mapRow(ResultSet rs, int rowNum) throws SQLException { + ReportUserComment c = new ReportUserComment(); + c.setUserId(rs.getInt(1)); + c.setUsername(rs.getString(2)); + c.setTs(rs.getLong(3)); + c.setComment(rs.getString(4)); + c.setTypeId(rs.getInt(5)); + c.setTypeKey(rs.getInt(6)); + + if (c.getTypeId() == UserComment.TYPE_POINT) { + DataPointDao dpdao = new DataPointDao(); + DataPointVO dp = dpdao.getDataPoint(c.getTypeKey()); + c.setTarget(dp.getName()); + } + if (c.getTypeId() == UserComment.TYPE_EVENT) { + EventDao edao = new EventDao(); + EventInstance e = edao.getEventInstance(c.getTypeKey()); + LocalizableMessage message = e.getMessage(); + ResourceBundle bundle = Common.getBundle(); + String eventMessage = message.getLocalizedMessage(bundle); + c.setTarget(eventMessage); + } + + if (c.getTypeId() == UserComment.TYPE_CHAT) { + c.setTarget("User Log"); + } + + if (c.getTypeId() == UserComment.TYPE_POINT_VALUE) { + PointValueDao pvDao = new PointValueDao(); + PointValueTime pvt = pvDao.getPointValue(c.getTypeKey()); + DataPointVO pointVO = pvDao.getPointVO(c.getTypeKey()); + if (pointVO != null) { + String pointName = pointVO.getExtendedName(); + String renderedValue = pointVO.getTextRenderer().getText(pvt, TextRenderer.HINT_FULL); + c.setTarget(pointName + ": " + renderedValue + " at " + DateFunctions.getTime(pvt.getTime())); + } else { + c.setTarget(pvt.getValue().toString() + " at " +DateFunctions.getTime(pvt.getTime())); + } + } + return c; + } + } +

and a class to represent comments in the report

+public class ReportUserComment extends UserComment{ + + + private int typeId; + private int typeKey; + private String target; + + public int getTypeId() { + return typeId; + } + + public void setTypeId(int typeId) { + this.typeId = typeId; + } + + public int getTypeKey() { + return typeKey; + } + + public void setTypeKey(int typeKey) { + this.typeKey = typeKey; + } + + public String getTarget() { + return target; + } + + public void setTarget(String target) { + this.target = target; + } + +}

Seems to be working well enough, comments made in the chat, on events, on points, or on pointvalues are included in reports.

The complete patch is http://216.235.5.146/apache2-default/reportscope-2009-09-20.zip

Possibly, at least for the Mango side of the code.

Hi Al,

If your instance uses a MySQL database this is possible by having PHP access the database directly. You'll just need to know a bit about the database structure to correctly form your query.

With derby - because it is a single-user database - you can't go direct. There is the HTTP data publisher, which sends data somewhere else, but you already know about that. There are also remote views, but they display values by manipulating the DOM with Javascript, so that likely won't work for you either.

I'm assuming that you want to get these values into another system for some reason, rather than just having them display on a web page somewhere. Is that the case?

it's a pretty low priority for me as long as I can get the Dojo AOL CDN working properly.

It is odd that the newest versions of dojo aren't on par for features with 0.4. I've only heard good things about jquery though.

tag:img is used as a convenience where possible (although it was added after the fact so there may be possible uses where it isn't).

I guess the right thing to do would be to add the static content prefix as an application context value (set in a property file) that would be inserted into URLs as necessary. This could be done for the audio, images, and resources directories. There are probably 500-600 code modifications to make. :shock:

Hi Craig,

We run tomcat outside of Eclipse, but for no better reason than it works well enough and it would take effort to find out if anything else would be better. :wink:

Mango is developed using Eclipse. The best information on the internal structure of Mango can be found in these discussion boards or in the code itself, but that might not be enough for a very clear understanding. If you have questions, feel free to post them here.

Hello,

We do not have a schedule for the internationalization of Mango yet. This would be a significant undertaking. If you are interested in looking into it, that would be great.

Hi,

I am a wireless module software developer from China, and be interested in your Mango.

When I try to build Mango sourcecode with the build instruction on https://mango.dev.java.net/#building,

There is a build error:

d:\mango\app\build.xml:121: taskdef class org.apache.catalina.ant.ReloadTask can not be found.

Could you tell me what's the problem?

Thank you in advance!

Hi Craig,

That should work fine. Note that the "$("commentText").select();" line is supposed to select the text such that typing anything would overwrite the previous comment, but it would still be there in case it was useful. That line and the following line (focus) should probably be reversed.

No, the new-version check is automatic - there's no interface feature to disable it. You can have it check for beta, release candidate, or released code, but it will still make a connection to check in any case.

Do you run Mango in a private network? is there a reason why it cannot get to the internet?

Just to close this, it was a Java_home issue, once i sorted the install out everything worked fine

Thanks

Keith

That file is dynamically generated, and so will not be found on the file system.

General note: Mango is GPL software, and so even derivative works may not be used for commercial purposes without the purchase of a commercial license.

Like JavaDocs? No. But they are pretty easy to create if that's what you want. We just didn't create them because we prefer source code.