project-haystack Sign Up Information

Applying Haystack tags in CSV to import to Niagara 4

https://project-haystack.org/forum/topic/831

Ben Morrall wrote:

Hi there,

Niagara 4 user here - hoping I can get some help.

We would like to export a points list in CSV format, apply Haystack tags in Excel and then import the CSV file back into N4 with all the associated tags.

There are a few reasons for wanting to utilise Excel but to keep this concise, can anyone please advise as to the best course of action? We've hit a bit of a wall!

If what we would like to do is not possible, we would welcome any alternate suggestions. Especially if they closely resemble what we're trying to do - which is ultimately edit points and tags in Excel.

Thank you in advance and appreciate all the hard work!

Haystack experts

https://project-haystack.org/forum/topic/830

Rodolfo del Valle wrote:

Hey guys,

First of all. Thanks for the awesome job you have all done here. I''ve been a big fan and follower of Haystack and this is my first post here.

I''m actively using Haystack 4 and also expending it for some use cases are not considered yet in the project. I would like to bounce some ideas and to validate the work that I''m doing with somebody who considers themselves fluent in Haystack.

Is anybody available and willing to have some interesting talks? Sometimes I feel these conversations can get very tangential to philosophy :D

This is a commercial project, so you could expect some reward, NDAs, and also the option of collaborating in the long term.

Cheers and thanks for reading!

Steve Eynon wrote:

Hi Rodolfo,

That''s an intriguing post and I understand the need to converse with others over semantics and use-cases, but it may help your cause to specify the areas of expertise you''re interested in.

There are many experts in the various working groups who know their specific industry topics intimately, and there will be others whose industry knowledge is more general but know lots on the technical modelling side.

Also, some may not be comfortable publicly replying to this post either, so a means to contact you privately may help elicit responses.

Good luck!

Rodolfo del Valle wrote:

Thanks, Steve for the recommendation!

I''m pretty sure anybody who is an expert on Haystack can help. No specific knowledge of another industry is needed as per now we are focusing on extending HVAC related points.

If anybody wants to get in contact with me, you can shoot me an email to rodolfo at enviosystems . com

Regards, Rodolfo

Applying Haystack tags in CSV to import to Niagara 4

https://project-haystack.org/forum/topic/831

Paul Quinn wrote:

You may want to consider creating point (or equip) templates in SkySpark and putting a reference on the live point to the template. You can modify the point template and then write a function to periodically sync your point tags with the template.

I use a technique similar to this when initially importing equipment and points from a BMS.

Ben Morrall wrote:

Thanks Paul!

Our client isn''t using SkySpark, so any solution needs to encompass software they are familiar with, really.

The benefits of utilising Haystack are plain to see. We would like to deploy it on every project and encourage clients to adopt tagging as a constituent part of writing BMS software. The obvious barrier though, seems to be ease of use, i.e. how straightforward/time-consuming is it to tag an entire site?

System integrators are generally competent Excel and N4 users. If there is a way of simply exporting BMS points in CSV format, using fairly routine Excel methods to accelerate the tagging process, then importing that tagged BMS data back into N4, many more companies could harness the serviceability of Haystack.

I guess we just want to know if it''s possible to tag BMS points in Excel? If not, we think it would be a really useful supplementary feature that could greatly extend the observance of Haystack standards.

As an aside, whilst touching on extending the observance of Haystack standards another obstacle (especially in BMS/BAS use cases) is the absence of fault and alarm tags.

Brian Frank wrote:

The Java toolkit used by nhaystack does support exporting to CSV. You can check the output formats with the formats op:

http://yourhost/haystack/formats

If CSV is supported (which is should be), then you just need to make an HTTP get to read the points with the HTTP header Accept:"text/csv".

I would imagine there is a nice way to do this from the UI too, but not sure.

Or you can use curl or something like it. Or another alternative is to export to Zinc, JSON, etc and then use one of the many Haystack libraries to convert it to CSV.

Signup Verification for Project Haystack

Thanks for signing up on Project Haystack!

A new account has been created for:

• Daniel Carter
• username: @

To activiate your account click the link below:

https://project-haystack.org/user/verify?9yAQ2Q9on2XLxFzYvMwFJ2vQ1rRwaXRjaDQ0OTY2QGZsaWJ1LmNvbQ