• Recent
    • Tags
    • Popular
    • Register
    • Login

    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.

    Radix IoT Website Mango 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    Importing CSV files

    Scheduled Pinned Locked Moved User help
    3 Posts 2 Posters 2.3k Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • B Offline
      burslem2001
      last edited by

      Hello,

      I am trying to use the data source of type "data file" and want to import .csv files from a specified directory.

      1. I created a testing directory on the mango box. Tested that the directory exists using the check file option on
        the data source.

      2. Placed a .csv file in the testing directory.

        The csv file contents is:

        TIME, DP_TEST_VALUE
        12/10/2014 7:09,-1
        12/10/2014 7:24,-2
        12/10/2014 7:30,-3

      3. I added a data point to the data source called DP_TEST_VALUE in the .csv file.

      I have data point details "Logging All".

      I'm an seeing the value N/A value which is wrong. Not sure if the format is wrong. If someone can send me a link to
      that can show a simple example as shown above that would be great.

      Cheers,
      Gary C

      1 Reply Last reply Reply Quote 0
      • jeremyhJ Offline
        jeremyh
        last edited by

        I tried the data file source with a CSV file that I've previously used to import some data to a point using the 'import data' function. I would expect that they use the same method for parsing data but, having skimmed the help file for the data file source (you have to write your own classes?), maybe not..

        I couldn't get my data file source to work, but I didn't try very hard to figure it out, and it's not clear to me whether you need to create points for the DP_'s that you're importing, or what.
        But maybe you'll find my CSV of some use anyway. I notice that you wrote 'TIME' but my file has 'Time', for example.

        Are you running Mango as root? Maybe it's a permissions issue.

        Attachment: download link

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post