AnsweredAssumed Answered

What 'configuration' do I use for a Excel sheet in a column?

Question asked by Brian Dalton on Feb 28, 2012
Latest reply on Mar 27, 2012 by Brian Dalton

Like • Show 0 Likes0
Comment • 6

Back here in This Thread, I got a great tip on how to ensure that the Description property from my SW files was read from the correct configuration for display in the File List Column I'd created. Now I have a new problem.

I use the same variable (Description) for other documents that are Excel spreadsheets. The variable is mapped to custom properties in the Excel sheet and all works well, but since I changed the Description column to "Look for variable in given list of configurations" I've got nothing showing for a Description for my Excel docs. I suppose that's because Excel sheets don't have configurations, and I don't know what "configuration" I should enter in the list so the a spreadsheet property will still be read...

I hope that's understandable...

Brian Dalton Mar 27, 2012 2:23 PM

Correct Answer

After putting out many other fires, I called my (incredibly helpful) VAR support tech, and she pointed me to the answer, which I somehow missed before (pretty obvious to me now - DOH!)

When you click the '+' button to add a configuration to look into, one of the options is to read variables from files that do not have configurations. Just what I wanted, and right in front of my eyes... guess I need new glasses!!

My support tech mentioned that when using this feature, the <Files without configurations> value should be at the top of the list, before any specific configs are listed.

See the reply in context

No one else had this question

Outcomes

Brian Dalton Feb 28, 2012 12:01 PM

Of course, the problem would go away if I could create multiple file list column sets and define which folder, or which file type each was used with, but it seems that if I create a second file list it just overrides the first - only the latest file list is effective.

Is there any way around this?

Actions

Jeremiah Feist @ Brian Dalton on Feb 28, 2012 12:09 PM

well - this would be more of a patch, not a solution - but couldn't you make 2 description columns?

Actions

Brian Dalton @ Jeremiah Feist on Feb 28, 2012 12:15 PM

Yes, I could.. but the real estate is already limited. I am (cautiously) optimistic about a better solution. Perhaps I will try some potential wildcards in the configuration list later...

Actions

Brian Dalton Mar 1, 2012 10:35 AM

It looks like there's no way to do this specifically. I'll have to keep futzing with the properties to see if I can get the Explorer display to 'choose' the right configuration when I leave the setting to 'Look for variable in all configurations'.

Actions

Brian Dalton @ Brian Dalton on Mar 14, 2012 6:06 PM

Well, this has turned out to be remarkably frustrating... it seems that when you set the column to look in all configurations, it essentially grabs one at random. Some files it grabs the Default config, other basically identical files it will grab some other config. I've seen it treat the exact same file in two different ways on two different days, when no changes have been made in the interim...WTH?

There's got to be some character or code I can put in the list of configs that tells the column to get the info from files that don't use configurations... someone else must have run into this wall before.

Actions

Brian Dalton @ Brian Dalton on Mar 27, 2012 2:23 PM

After putting out many other fires, I called my (incredibly helpful) VAR support tech, and she pointed me to the answer, which I somehow missed before (pretty obvious to me now - DOH!)

My support tech mentioned that when using this feature, the <Files without configurations> value should be at the top of the list, before any specific configs are listed.

Actions

6 Replies

Brian Dalton Feb 28, 2012 12:01 PM
Mark Correct
Correct Answer
Of course, the problem would go away if I could create multiple file list column sets and define which folder, or which file type each was used with, but it seems that if I create a second file list it just overrides the first - only the latest file list is effective.

Is there any way around this?
Like • Show 0 Likes0
Actions
- Jeremiah Feist @ Brian Dalton on Feb 28, 2012 12:09 PM
  Mark Correct
  Correct Answer
  well - this would be more of a patch, not a solution - but couldn't you make 2 description columns?
  Like • Show 0 Likes0
  Actions
  - Brian Dalton @ Jeremiah Feist on Feb 28, 2012 12:15 PM
    Mark Correct
    Correct Answer
    Yes, I could.. but the real estate is already limited. I am (cautiously) optimistic about a better solution. Perhaps I will try some potential wildcards in the configuration list later...
    Like • Show 0 Likes0
    Actions
Brian Dalton Mar 1, 2012 10:35 AM
Mark Correct
Correct Answer
It looks like there's no way to do this specifically. I'll have to keep futzing with the properties to see if I can get the Explorer display to 'choose' the right configuration when I leave the setting to 'Look for variable in all configurations'.
Like • Show 0 Likes0
Actions
- Brian Dalton @ Brian Dalton on Mar 14, 2012 6:06 PM
  Mark Correct
  Correct Answer
  Well, this has turned out to be remarkably frustrating... it seems that when you set the column to look in all configurations, it essentially grabs one at random. Some files it grabs the Default config, other basically identical files it will grab some other config. I've seen it treat the exact same file in two different ways on two different days, when no changes have been made in the interim...WTH?
  
  There's got to be some character or code I can put in the list of configs that tells the column to get the info from files that don't use configurations... someone else must have run into this wall before.
  Like • Show 0 Likes0
  Actions
  - Brian Dalton @ Brian Dalton on Mar 27, 2012 2:23 PM
    Unmark Correct
    Correct Answer
    After putting out many other fires, I called my (incredibly helpful) VAR support tech, and she pointed me to the answer, which I somehow missed before (pretty obvious to me now - DOH!)
    
    When you click the '+' button to add a configuration to look into, one of the options is to read variables from files that do not have configurations. Just what I wanted, and right in front of my eyes... guess I need new glasses!!
    My support tech mentioned that when using this feature, the <Files without configurations> value should be at the top of the list, before any specific configs are listed.
    Like • Show 0 Likes0
    Actions

What 'configuration' do I use for a Excel sheet in a column?

Outcomes

Related Content

Recommended Content