Missing text in requirements from Excel import to ALM

  • Questions
  • Missing text in requirements from Excel import to ALM
Question ID: 104614
1
0

Hello. Have an issue where we when are tyring to import some requirements from excel into alm, we have instances where some of the text is disappearing.

Excel text can read: Field A, when chosen as OTHER should provide the following choices – User Defined, Owner Defined, User Unknown, Owner Unknown, Exception.

What we get in Alm after import can look like this: Field A, when chosen as OTHER should provide the following choices – User Defined, Owner User Unknown, Exception.

That’s just one example. Oher times its different imported text has missing text.

Any idea of a cause? Only spefici information I know about the excel file creation is that a lot if pasted in from word documents. Is there some issue of Word to Excel going on here? I can’t imagine there would be. Everything looks great in Excel if you just open the file.

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on September 24, 2012 5:26 pm
15 views
Answers (1)
2
Private answer

Guessing you have some ''phantom spaces'' in your excel fields and when importing over, ALM removes those spaces and takes the values to the right of them to the next space key.

Two common ''phantom spaces'' are char(160) and char(127) which are not removed even if you run the CLEAN function.

Best way to remove those values that might not go away is as follows:

1) Find an empty cell and enter:
=CHAR(160)
and then press F9 without pressing Enter

2)copy the contents of the cell with =CHAR(160) by using Ctrl+C

3)then go to Edit/Replace

4)in the Find text box hit Ctrl+V
then in the Replace textbox leave empty

5)hit Replace All (if you want to see them one by one...hit Replace)

Repeat the above steps but replace the =CHAR(160) with =CHAR(127) in step 1).

This is good if you have no idea if you have these spaces, or how many. You can use the built in Find and Replace to remove the values and see just how many you have in that file.

With the ''phantom spaces'' removed, try your import again and see if that fixes your missing text issue.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on September 24, 2012 5:28 pm
Hey, that looks to have worked. Huge thanks! There were a lot of those hidden spaces in just one document I tried the fix on.
( at September 24, 2012 6:06 pm)