Issue with Smart Import file upload.

Jordan_Gracey96 · 2024-04-08T09:33:33+00:00

There was an error rendering this rich post.

Hello,

I am trying to use the smart import feature and am having some issues with the file upload.

Basically when I try and upload a file I'm getting validation errors on my data. However when I do a copy and paste into the import table the data is accepted. The data is around 1750 rows so copying and pasting the data is not optimal. Any reason why this might happen?

Find more posts tagged with

Data Entry

Board Support

Data Sources

Community

Accepted answers

All comments

Rishabh Shahi

Hello Jordan,

Thanks for your message. One reason which comes to mind would be related to text data you might be attempting to upload through your Smart Import object. In past, it has been observed that the data load fails when there's a new line character anywhere in between the data within a cell, the process ends with an error.

to test, could you please revisit and check if you're able to load cell from particular column and one by one if you land up with one where it begins to fail, the problem might be happening because of an unsupported character for the upload.

Let me know if this helps or in case you observe something else

Thanks,

Rishabh Shahi

Jordan_Gracey96

Hi Rishabh,

I have went through each cell and retyped the cells that were giving errors and that did not help.

Overall I'm getting three errors:

CELL ERROR-The '[TEMP] Sub_Code' code in cell T3 does not exist (Have checked entity and value does exist)

CELL ERROR-The 'Project_ID' code width in cell A4 exceeds the maximum code width allowed (10) (All values in this column are the exact same)

CELL ERROR-Cell H4 is empty. It must contain a valid 'Original Item 4' code (Value is not empty)

When I enter values manually or Copy & Paste the smart import accepts them without any issue.

Thanks,

Jordan

Rishabh Shahi

Hello Jordan,

Sorry, this message got left out as a draft and never went out unfortunately. I hope your issue was resolved. If not, I suggest submitting a new support case (at support.board.com) so that we can investigate the problem your reported together with more details.

Thanks & Regards,

Rishabh Shahi

Sudeep Palkar

Hi Jordan,

If this is not too late for you, I faced a similar issue recently and the below article helped me to resolve the issue:

The presence of CrLf (New Line or Carriage Return-Line Feed) characters in some cells of the .xlsx file causes an odd parsing of the file while it’s been uploaded. Values following those characters are automatically shifted to following cell causing issue with suggested values, cells’ format and/or cells’ admitted size.

Parsing remains though correct when file content is copied and pasted into the table.

Solution found:

There are basically two workarounds to properly upload the files that show this unexpected behavior:

Copy/paste file content in Smart import tables ( file content is properly parsed and data upload is not blocked by the presence of odd characters)
Remove the CrLf characters from the .xlsx file. Due to the fact that they are practically invisible, there is a little workaround:
- Open the .xlsx file with excel
- Press Ctrl+H to bring on the screen the Search/Replace mask
- Click on Replace tab
- Place cursor in the Replace row
- Press Ctrl+J (it will show a blinking dot that should represent the CrLf character)
- Leave the “Replace with” line empty or enter a replacement string.
- Click on Replace all

File then will be purged and it will be possible to upload it.