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,

    What did you export? The Table or the View?
    I am running SELECTseries 7 of DataManager and when I export the VIEW I am able to import changes made in Excel and I do not get errors.

    I have been using this technique, without issues, going back to at least SELECTseries 4.

    Its worth a try.

    Tony DeRosa
    Bentley Plant

     

    Tony DeRosa

    Senior Consultant

    Bentley Plant



Reply
  • Mike,

    What did you export? The Table or the View?
    I am running SELECTseries 7 of DataManager and when I export the VIEW I am able to import changes made in Excel and I do not get errors.

    I have been using this technique, without issues, going back to at least SELECTseries 4.

    Its worth a try.

    Tony DeRosa
    Bentley Plant

     

    Tony DeRosa

    Senior Consultant

    Bentley Plant



Children
No Data