bulk importing datapoints

[JF89]

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

and with only one point

[ThomasEinasto]

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.

[phildunlap]

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.

[CraigWeb]

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.

[JF89]

HI Craig,

It works perfectly with libreoffice , as you said.

Thank you very much.
Best regards

[cwangv]

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.

[Ralf]

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.

[phildunlap]

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.

[Jared Wiltshire]

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.