TIP: CM: Getting https://t.co/vy9ImpM5IL: Received fatal alert: handshake_failure? https://t.co/FgcFxmXS99… https://t.co/j6oVehMxw2
0
I have an issue importing an XLS spreadsheet with multi-values separated by comma into an AUX table.
Currently the only method that works is formatting the spreadsheet in this format.
Column 1 Column 2
--------------------------------------
Title 1 Value 1
Title 1 Value 2
Title 1 Value 3
------------------------------------
My current spreadsheet is in this format
Column 1 Column 2
Title 1 Value1, Value2, Value3
Is there anyway to enhance SBM to import XLS with this format as multi-relational values?
Currently the only method that works is formatting the spreadsheet in this format.
Column 1 Column 2
--------------------------------------
Title 1 Value 1
Title 1 Value 2
Title 1 Value 3
------------------------------------
My current spreadsheet is in this format
Column 1 Column 2
Title 1 Value1, Value2, Value3
Is there anyway to enhance SBM to import XLS with this format as multi-relational values?
Like
Steven Nguyen likes this post.
Responses (2)
-
Accepted Answer
0I would suggest you add this to the "Ideas" section as an enhancement request. As you rightly point out, the current "out-of-the-box" solution is to have multiple rows in your spreadsheet.
https://www.serenacentral.com/community/ideas
Sorry can't help further. -
Accepted Answer
0You could create a script in Excel to parse the comma-delimited fields in the second column and create additional rows in the spreadsheet.
And of course you can use AppScript or ModScript do the parsing and record creation after importing the .XLS into your aux table.
Any scripting effort needs to be balanced with how much time it would take to manually do the work, and often the script would be run. If this is a one-time only import, it might be more cost-effective to have a volunteer manually edit the spreadsheet and split the delimited fields.
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »