• G
    Gord Bond

    Ah ok, thank you guys. This helps quite a bit. I am currently using the free license at the moment to investigate whether or not Mango is the right for our project. So far it seems really great and I'm glad there is a solution for my duplicates problem. I appreciate all the help here in the forums.

    posted in User help read more
  • G
    Gord Bond

    Hi Craig,

    I think I need to clarify my issue a little further. I am hoping to be able to upload data as either a csv file with many values/timestamps or a single value/value and have it update in the database only if the value at that timestamp has changed. I've tried both the "When Point Timestamp Changes" and "When Point Value Changes" logging properties with no luck.

    With regards to the methods I am adding the value:
    I'm currently using a couple of methods to get data in via a "Data File" datasource but all return the same issue of duplicate data for a specific timestamp. The first method is by placing a csv in the filestore and having the data source configured to look for any csv files in the filestore directory. What happens here is the first csv file is uploaded, then if I place the same file back in the folder all the values are logged to the database again despite the time stamps being identical. What I am expecting is none of the values to be logged because the timestamp hasn't changed. Ideally, if I were to adjust one of those values and reuploaded the file with the single adjustment, only the adjustment would be logged. The second method is setting a single value via the /point-values end point in the API. When I hardcode an identical time stamp to an existing one it is logged to the database and the previous value remains. I have a solution in mind for setting a single value which would involve an sql update via the sql-console update/query end points but that feels like a bit of a hack. I'm sure I'm misunderstanding how the logging is supposed to work so any help pointing me in the right direction would be greatly appreciated.

    Thanks,

    Gord

    posted in User help read more
  • G
    Gord Bond

    To add further context. I am using the "When Point Timestamp Changes" logging property. When I add a new point with the same timestamp it still logs to the database (checked this using the sql console).

    posted in User help read more
  • G
    Gord Bond

    Good Morning!

    I was hoping to get a little help with something I am currently struggling with. Is it possible to limit data points to one value per timestamp? For example, say I had a data point, "Electricity Consumed", and it had a point value of 1500 for the time stamp, 1595822400000. If I add a new point value for the exact same timestamp, I want the new value to be logged and the previous value to be deleted. Essentially updating the value at a specific timestamp. At the moment, whenever I add a new point value for the same timestamp I add the new value but the previous value also remains in the system.

    Thanks,
    Gord

    posted in User help read more
  • G
    Gord Bond

    Amazing. Thank you very much.

    posted in How-To read more
  • G
    Gord Bond

    Is it possible to access the tags for a data point when creating a script for a meta data point? I would like to use a switch case to do different calculations based on a point's tag. For instance, if a tag is kWh I would like to perform a different conversion calculation to GJ than a point with a Litres tag. I would then add all of the GJ values together and return this value.

    posted in How-To read more
  • G
    Gord Bond

    Final Update: It took some fiddling but installing the 3.7.x branch worked. All modules are loaded can now but placed in the git/ma-core-public/Core/web/modules directory and loaded into the build. If anyone is interested, I created documentation for the process I used to set up Eclipse for version 3.7.x. Feel free to reach out and I can share it.

    posted in Development general discussion read more
  • G
    Gord Bond

    Alright, I'm stuck. I tried pulling the 3.7.x branch rather than the main branch and following the same process for setting up the dev environment in Eclipse but when I go to build the project I get to the log in page but won't let me log in. It tries to take me to /ui/agree-to-license but stays on the log in page and says "You are already logged in as admin. Go to the main UI."

    In the logs it seems to be having trouble connecting to api.

    I'm wondering if I am using the right branch?

    posted in Development general discussion read more
  • G
    Gord Bond

    I may have solved my own problem. I am running version 3.8.0 and the logs say the modules need a core version of 3.7.

    posted in Development general discussion read more
  • G
    Gord Bond

    I recently set up my development environment in Eclipse and wanted to include a bunch of modules including the dashboardDesigner and dataFile modules that weren't part of the repository. Unfortunately, I can't get them to load when I launch my instance of Mango. I included the files I downloaded from the store in the git/ma-core-public/Core/web/modules directory as @phildunlap mentioned to do in an older post but they don't appear when I launch the core. I was hoping someone might be able to provide some insight into what I might be missing.

    Thanks,

    Gord

    posted in Development general discussion read more