Data import

Forums Designer Building applications Data import

  • Post
    Frenck Smit
    Participant

    Best community,

    When i try to import data through an Excel import file for some data items i get the following message, which result in a failed import:

    Error

    I am wondering what the system flags as a so-called ‘ID Column’. Since i don’t know which columns this are.
    I’m looking forward in hearing from you.

    Regards,

Viewing 5 replies - 1 through 5 (of 5 total)
  • Replies
    Jochem Spronk
    Moderator
    Up
    0
    Down

    hi Frenck,

    The excel import function has two options: allow or do not allow duplicates. If you choose “do not allow duplicates” that means that you have choose which ID is your unique reference. To choose your unique ID fairly easy. Pick a colomn in your excel file and add “[ID]”. IF you saved your excel, then you can import that file.

    Jochem

    Frenck Smit
    Participant
    Up
    0
    Down

    Jochem,

    Yes i did see that. But i did the following and still got the error:
    1. Set ‘No duplicates allowed’ = TRUE in the userflow
    2. Create an Excel file which imports ‘Product’ data items
    3. Set column with feature ‘Name’ to –> ‘Name[ID]’ to make sure it checks for duplicate products with the same name (this is not allowed)
    4. Importing the Excel gives me the error: Data item ‘Product’ has more than one ID column.

    So it seems that i do need to define extra specific columns as [ID] columns, but i do not know which ones.

    Frenck Smit
    Participant
    Up
    0
    Down

    Another error:

    Error2

    Which property is it referring to? Which one is required?

    triggre
    Keymaster
    Up
    0
    Down

    Hi Frenck,

    This one gave me a bit of a headache 🙂

    Firstly, to quickly address “So it seems that i do need to define extra specific columns as [ID] columns, but i do not know which ones.”: The [ID] is something you pick in Excel. It can be any property from your data item with unique values and you can always have at most one column marked as [ID] in your Excel-file. You can’t do anything wrong there (as long as you pick one column with unique values).

    Now, regarding the Excel-file you imported. I retrieved it so I could have a look at it and some really weird stuff is going on in there. For some reason, there is a lot more in there than I’m seeing and I have no clue why (maybe you know). On the Product-tab, columns A through K are filled with data you entered. However, even though I don’t see it, Excel also seems to think there is something in columns L through R as well, which would make sense with the error in Triggre from you last screenshot. The same goes for a lot of the rows. When I deleted columns L through R and most of the rows and tried to import the file (on my test environment), it imported just fine. So that would solve the immediate problem I think.

    I’ve never seen this before. We will need to build some logic that ignores data that isn’t there, but at the same time Excel seems to think is there.

    René Stout
    Participant
    Up
    0
    Down

    I had the same once. In the column Email there were empty cells, but Triggre gaver errors. So I sorted on the column, filled an emtpy field with an X and cleared the cell again. Then I copied that clear value to the other ’empty’ cells.

    After that the import went ok.

Viewing 5 replies - 1 through 5 (of 5 total)

Tagged: 

  • The topic ‘Data import’ is closed to new replies.

Get started for free and experience the power of the Triggre platform.

By signing up for your free account, you agree to receive e-mails from Triggre.

By using our site you agree to our use of cookies to deliver a better site experience.