Is 'None' the same as '---'?

Users
1

Until I can get the link working again between our Excel dashboard and our
database export on CommCareHQ (see other post in this group) I am resorting
to downloading the html database from CommCareHQ and pasting it into our
Excel dashboard.

In this process the word 'None' appears a lot in the downloaded file. These
'None's are not present when the link with the database in Excel works and
brings the data straight in.

Before I start changing all the formulas to cope with the appearance of
'None' can you confirm that this is exactly equivalent to '---' (ie a
missing value).

Many thanks

Simon
13/9/16

2

Hi Simon,

If you are seeing "None" show up where you would expect that there is a
missing value then that sounds like a possible bug. None should only show
up if that was an option in one of the questions, so if you are seeing
something different, please report an issue so that our support team can
take a look.

Thanks,

Jeremy

··· On Tue, Sep 13, 2016 at 4:14 AM, Simon Berry wrote:

Until I can get the link working again between our Excel dashboard and our
database export on CommCareHQ (see other post in this group) I am resorting
to downloading the html database from CommCareHQ and pasting it into our
Excel dashboard.

In this process the word 'None' appears a lot in the downloaded file.
These 'None's are not present when the link with the database in Excel
works and brings the data straight in.

Before I start changing all the formulas to cope with the appearance of
'None' can you confirm that this is exactly equivalent to '---' (ie a
missing value).

Many thanks

Simon
13/9/16

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

3

Thanks Jeremy. I've submitted a bug report.

Regards

Simon
15/9/16

··· On 14 September 2016 at 18:40, Jeremy W. wrote:

Hi Simon,

If you are seeing "None" show up where you would expect that there is a
missing value then that sounds like a possible bug. None should only show
up if that was an option in one of the questions, so if you are seeing
something different, please report an issue so that our support team can
take a look.

Thanks,

Jeremy

On Tue, Sep 13, 2016 at 4:14 AM, Simon Berry simon@colalife.org wrote:

Until I can get the link working again between our Excel dashboard and
our database export on CommCareHQ (see other post in this group) I am
resorting to downloading the html database from CommCareHQ and pasting it
into our Excel dashboard.

In this process the word 'None' appears a lot in the downloaded file.
These 'None's are not present when the link with the database in Excel
works and brings the data straight in.

Before I start changing all the formulas to cope with the appearance of
'None' can you confirm that this is exactly equivalent to '---' (ie a
missing value).

Many thanks

Simon
13/9/16

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

--
You received this message because you are subscribed to a topic in the
Google Groups "commcare-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/4f2xs1fxHak/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.