Data Manager Import from Excel

Hi,

I exported a list from Data Manager to Excel, edited some of the info, and am now trying to import back into Data Manager. When attempting to do so, Data Manager makes it to the end of the list, then starts trying to import the blank rows. This gives the following error (I have 1330 rows of data in Excel):

TAG_TYPE value is needed to import record #1330
 TAG_NO value is needed to import record #1330
 TAG_TYPE value is needed to import record #1331
 TAG_NO value is needed to import record #1331
 TAG_TYPE value is needed to import record #1332
 TAG_NO value is needed to import record #1332
 TAG_TYPE value is needed to import record #1333
 TAG_NO value is needed to import record #1333 ... (etc)

After attempting to import almost 200 blank rows, Data Manager gives up and aborts the import. There isn't any extra data after row 1330 in any of the columns. Any advice on this issue would be greatly appreciated, thanks.

Parents
  • Mike,

    Thank you for bringing your question to the forum. These types of import errors usually stem from the fact that the .XLS sheet doesn't have the KEYTAG, TAG_TYPE and TAG_NO columns in the header. Also, they must be in that order and must be the first three fields in the list. The Keytag column can be blank but the Tag_Type and Tag_No columns must have data in them as they are required in the project database. Please review this and let us know your results.

    Thank you,

    Brandon Moberg

Reply
  • Mike,

    Thank you for bringing your question to the forum. These types of import errors usually stem from the fact that the .XLS sheet doesn't have the KEYTAG, TAG_TYPE and TAG_NO columns in the header. Also, they must be in that order and must be the first three fields in the list. The Keytag column can be blank but the Tag_Type and Tag_No columns must have data in them as they are required in the project database. Please review this and let us know your results.

    Thank you,

    Brandon Moberg

Children
  • Brandon,

    Thanks for responding to my post. The first three columns in my excel sheet are KEYTAG, TAG_NO, and TAG_TYPE. I realize that's a different order than the order you listed, but that's the order shown in Data Manager (and the order I get when exporting from Data Manager) so it should match up. Also, it seems that Data Manager has no trouble importing the rows in Excel that have content, but when it gets to the end of the list and hits the first empty row (1330) is when it gives the errors.

    So in the rows I'm receiving the errors for, there isn't any content in the TAG_NO or TAG_TYPE cell like you had suggested, but that's because there isn't supposed to be any content there as it's the end of the list. Data Manager is trying to import rows after it's reached the end of my list. Since it can't, it aborts the import. I hope that clears up the issue.
  • Brandon,

    I've managed to get a little bit further. I copied the contents into a fresh excel file and tried to import that file. Data Manager made it past the previous error, but in exchange produced the following error:

    I/O TYPE field generated error in record #256 : Multiple-step operation generated errors. Check each status value. [Microsoft Cursor Engine]
    Unable to update record #256 with keytag 0000012252

    I got this error for each row that contained any content in the I/O Type field (record #256, #257, #258, etc). Any thoughts on this?

    Thanks.
  • Mike,

    Thanks for the clarification. It does sound like the ordering is not the issue after that input. At this point I would like to see your Excel sheet. Also, as this is the case it might be best to go ahead and take this offline and create a new Service Request for you. Please forward your Excel file to my direct email address below:

    Brandon Moberg
    brandon.moberg@bentley.com

    Thanks Mike

  • I made an example about "data manager" via Userform.

    Really it's many features .
    - Data Adding
    - Data Delition
    - Data Update
    - Searching with The Userform
    - Progress Bar Feature
    - Scrolling the Listbox with Spin Buttons
    - Next ,Previous ,First ,Last Recording Buttons
    - Sheet Hide / Show Features with Toggle Button

    For Template's Video :https://www.youtube.com/watch?v=9WFaofOHtPs

    For Downloading Click Here