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 3 Documentation Website Mango 4 Documentation Website

  • Hello,

    After watching the tutorial bulk importing datapoints, I tried to create points, but without success.

    Here are the errors that I have:

    Do you have any idea of the setup error I was able to make?
    Best regards

    0_1565192189538_databulk csv import.png
    0_1565192215681_databulk csv import2.png
    and with only one point
    0_1565192227049_databulk csv import3.png


  • As I have not used this yet but seeing your pictures I suggest you adding original xid and xid for each point.

    XIDs are required as they are the unique IDs of the points.

    On your third picture the error also indicates that property xid must not be null i.e it should have value.


  • Hi JF89,

    Can you share the CSV that you're trying to upload as text? Sometimes Excel and other spreadsheet applications can perform some unfortunate reformatting.

    @ThomasEinasto
    The CSV upload does allow you to leave the columns blank as he has done if the action is "CREATE". I was using a text editor and I was only able to get it to complain about the XID when I set it to "EMPTY" but it wasn't the same issue pictured in JF89's screenshots.


  • Hi @JF89

    I tested this today by first creating a single numeric point as a seed, copied down and then changed the names and offsets. I did not have any issue. I also think that excel could be changing the format of the CSV. You should use libre office calc. It is great for working with CSV.


  • HI Craig,

    It works perfectly with libreoffice , as you said.

    Thank you very much.
    Best regards


  • Hi,
    Just a follow-up question:
    what are the available options under column 'Action' - so far I know they are: 'Create', 'Modify'.
    What if i want to keep a row unchanged? Is there a keyword for that?
    I tried removing the points (rows) that i didn't need change and only kept the ones that I needed to modify/create in the CSV file. What happened was i lost the ones that i didn't want to change after importing the csv file.

    Any pointer will be appreciated.

    Thanks.


  • Hi cwangv,

    'UPDATE' is the standard option if you download a csv.

    If you don't change anything in a object row, you can leave it as it is.

    I am doing the modifying and adding new data points as a separate operation and I have no errors so far.


  • Hi cwangv,

    I tried removing the points (rows) that i didn't need change and only kept the ones that I needed to modify/create in the CSV file. What happened was i lost the ones that i didn't want to change after importing the csv file.

    So you just removed the rows from the CSV, imported it, and the data points that were not in the CSV no longer exist? Can you provide more explicit steps, as I was not able to replicate with the above steps.


  • Removing the row from the CSV is the correct course of action if you do not want to modify that point in any way. The available options are CREATE, UPDATE, and DELETE. I will consider adding something like DO_NOTHING or IGNORE for convenience.