Importing Excel not working
192 0 3Hello there!
I'm trying to import an Excel file in dominKnow and it doesn't work, it's throwing this error: https://imgur.com/a/wLznt99
Any idea what's causing that?
Just a little background; I had to replace some characters everywhere in my project and I noticed that the "Find and Replace" tool doesn't catch everything. So, I exported to Excel, changed everything in there and tried to import it back. This is when I got this error message in the link above.
I did put the updated text in correct column and that's the only thing that I've changed in Excel. Also, I tried importing using Chrome, Edge, Firefox... all of them are giving me the same error.
Thanks!
Answers ( 3 )
It sounds like you have done all the correct steps. The most typical issues are renaming the Excel, not putting content into the correct fields or removing fields that don't have content. Please submit a ticket to our support team with the name and ID of the project and a copy of your import file so they can take a look.
Comments
( 0 )Thanks Paul!
Just a FYI, this is not the only project, I tried with 2 more and all three are giving me the same error.
I can try to clean the Excel file and leave the edited lines, but I have a lot of edits... I'll test with a few of them, see if it goes through this time, but otherwise, I'll open a ticket with support like you said.
Comments
( 1 )
FYI I did a quick test and the process was working for me.
Also if you leave any of the "new text" fields blank it will skip those, so only the "changes" need to be populated.
I tried importing back the Excel file with only the lines that changed (about 30 lines across the whole file), leaving all the other lines empty, and I'm still getting the same error :(
I'll send an email to support.
Comments
( 1 )
Sorry to hear that. I'm sure our support team will be able to get to the bottom of that for you!
Comments
( 0 )