Skip to content
+1-888-319-3663

COMMUNITY FORUM

Cannot Import a Translation Table

marcb@progressive-solutions.com asked 8 years ago
I've been attempting to import a translation table and can't find a successful way of doing it.  The documentation makes it sound pretty straight forward:
– Put your data on a sheet called 'Sheet1'
– Have a column titled From
– Have a column titled To

I've attempted these scenarios:
1) Excel 2013 file with From and To on Sheet1 but other columns as well
   – error stating I need a From and To column
2) Excel 2003 file with From and To on Sheet1 but other columns as well
  – error stating I need a From and To column
3) Excel 2013 file with only From and To on Sheet1
  – error stating I need a From and To column
4) Excel 2003 file with only From and To on Sheet1
  – no error, but nothing imported either

This is in SmartConnect 20.12.2.38.
Lorren replied 8 years ago

Marc,  you need to include the brackets around the From and To.  The column headings should be [From] and [To].  Lorren

marcb@progressive-solutions.com replied 8 years ago

I had tried that too, but on your suggestion tried a series of tests again with column labels of [From] and [To].  And all attempts resulted in the message 'Count not import the spread sheet, make sure there is a [From] and [To] column on Sheet1.

1) Excel 2013, [From] and [To] columns with formulas, plus other columns
2) Excel 2013, [From] and [To] columns with no formulas, plus other columns
3) Excel 2013, [From] and [To] columns with no formulas, and no other columns
4) Excel 2003, [From] and [To] columns with no formulas, and no other columns
5) Excel 2003, [From] and [To] columns with no formulas, and no other columns and removed special characters from values (ie. %, ?, *)

Can you send me a working sample of a spreadsheet?  I've attempted this in multiple client installs as well and none work.  We are looking at very large translation tables and will literally save hours (and probably many mistakes) if the translation table can be imported.

Answers
Best Answer
marcb@progressive-solutions.com answered 8 years ago
A few more tests and I think I figured out the quirks and I've got a pattern that works.

Requirements:
– Excel 2003 files only.  Excel 2007, 2010, 2013 files aren't supported.
– Column titles must be From and To (no square brackets).
– Special characters are ok.
– Extra columns are ok.
– Formulas are ok in the From and To columns.
– If you attempt an import that fails, you will not be able to subsequently import anything into that translation table.  You must delete the translation table and recreate it.  Once an import fails the translation table is not importable.

Steps:
1) Add the From and To columns as columns A and B
2) Save the file into an Excel 2003 format
3) Create your translation table
4) Hit the import button
5) If the import fails, delete the translation table and start again
Chris Dew answered 8 years ago
The SmartConnect 2013 release has allowed you to do this in any version of Excel sheet and you can have the From and To columns anywhere you want in the Sheet1 spreadsheet. This version works on all versions of GP10 and up and all versions of CRM 4.0 and up.

Thanks,
Chris
Paul replied 7 years ago

as of today, still an issue with ver 20.13.1.89
Thanks for sharing. Marc, you no doubt saved me hours!
Merry Christmas


If you would like to submit an answer or comment, please sign in to the eOne portal.