I have a view set up with some user profile details, including one which is a "Label name" - It's how someone would like to be addressed.

When i run this export from within Drupal, the export comes out OK, and the label name is correct. However, this is a very big run, and we need to run it overnight, using drush.

The output file (I'm using XLS (i.e html!)) does not contain the label_name column. I've tried deleting it, and re-adding it. Creating a clone of the view display. Various debugging texts, to make sure I'm running the right view and not losing my mind!)

Nothing I do appears to make this column show when output via drush.

Can anyone suggest what might be the problem, or at least give me a way to track this down further?

Comments

robearls’s picture

robearls CreditAttribution: robearls commented

Even though I looked for the answer for hours before I posted this, as usual, posting is the catalyst to finding the answer. /sigh

The problem was that Drush does not, by default, have permission to access the field that I was trying to output.

The solution, in this case, is to use "drush -u 1 ..." to run the export, giving drush admin access, so every field is accessible.

robearls’s picture

robearls CreditAttribution: robearls commented
Status: Active » Closed (works as designed)
Alexander Hadj Hassine’s picture

Alexander Hadj Hassine CreditAttribution: Alexander Hadj Hassine commented
Issue summary: View changes

#1
Posted by robearls on September 23, 2013 at 1:07pm

...The solution, in this case, is to use "drush -u 1 ..." to run the export, giving drush admin access, so every field is accessible.

You make my day!