CSV format

Hi,

I’m wondering if the dashboard feed works for a CSV comma delimited format.
I can import the data from the feed link to an excel sheet, but when I save
as a CSV and try to Refresh all, it appears that there is no connection.
Is there a way to update the data as a CSV file, without having to
re-import the dashboard feed link every time?

Thanks,
Liz

Hi Liz,

Unfortunately, I don’t believe that Excel can easily do an automated
refresh on CSV files. You may need to keep the file in an Excel format,
and then save it to CSV when you need to use it as a CSV.

Alternatively, you can setup a daily saved export that is a CSV you can
just download as needed.

Sheel

··· On Tue, Mar 28, 2017 at 1:42 PM, Liz T wrote:

Hi,

I’m wondering if the dashboard feed works for a CSV comma delimited
format. I can import the data from the feed link to an excel sheet, but
when I save as a CSV and try to Refresh all, it appears that there is no
connection.
Is there a way to update the data as a CSV file, without having to
re-import the dashboard feed link every time?

Thanks,
Liz


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

Hi Sheel,

Thanks for your response!
Does creating a csv daily saved export mean that it will export every day
automatically? If so, does it create a new csv file for each export (every
day) or can I make it so that new data overwrites old versions?

Thanks!

··· On Tuesday, March 28, 2017 at 2:50:16 PM UTC-4, Sheel Shah wrote: > > Hi Liz, > > Unfortunately, I don't believe that Excel can easily do an automated > refresh on CSV files. You may need to keep the file in an Excel format, > and then save it to CSV when you need to use it as a CSV. > > Alternatively, you can setup a daily saved export that is a CSV you can > just download as needed. > > Sheel > > On Tue, Mar 28, 2017 at 1:42 PM, Liz T <lta...@gmail.com > wrote: > >> Hi, >> >> I'm wondering if the dashboard feed works for a CSV comma delimited >> format. I can import the data from the feed link to an excel sheet, but >> when I save as a CSV and try to Refresh all, it appears that there is no >> connection. >> Is there a way to update the data as a CSV file, without having to >> re-import the dashboard feed link every time? >> >> Thanks, >> Liz >> >> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sheel Shah > Project Manager | Dimagi > m: +1.781.428.5419 | skype: sheel_shah > > >

Hi Liz,

You will get a link to download a new CSV each day - depending on how you
setup your filters in the daily saved export, this could be just the last 7
days worth of day, or all the data in your project.

Sheel

··· On Tue, Mar 28, 2017 at 3:54 PM, Liz T wrote:

Hi Sheel,

Thanks for your response!
Does creating a csv daily saved export mean that it will export every day
automatically? If so, does it create a new csv file for each export (every
day) or can I make it so that new data overwrites old versions?

Thanks!

On Tuesday, March 28, 2017 at 2:50:16 PM UTC-4, Sheel Shah wrote:

Hi Liz,

Unfortunately, I don’t believe that Excel can easily do an automated
refresh on CSV files. You may need to keep the file in an Excel format,
and then save it to CSV when you need to use it as a CSV.

Alternatively, you can setup a daily saved export that is a CSV you can
just download as needed.

Sheel

On Tue, Mar 28, 2017 at 1:42 PM, Liz T lta...@gmail.com wrote:

Hi,

I’m wondering if the dashboard feed works for a CSV comma delimited
format. I can import the data from the feed link to an excel sheet, but
when I save as a CSV and try to Refresh all, it appears that there is no
connection.
Is there a way to update the data as a CSV file, without having to
re-import the dashboard feed link every time?

Thanks,
Liz


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-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 <(781)%20428-5419> | skype: sheel_shah


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

Thanks for your help Sheel!

··· On Wednesday, March 29, 2017 at 2:51:48 PM UTC-4, Sheel Shah wrote: > > Hi Liz, > > You will get a link to download a new CSV each day - depending on how you > setup your filters in the daily saved export, this could be just the last 7 > days worth of day, or all the data in your project. > > Sheel > > On Tue, Mar 28, 2017 at 3:54 PM, Liz T <lta...@gmail.com > wrote: > >> Hi Sheel, >> >> Thanks for your response! >> Does creating a csv daily saved export mean that it will export every day >> automatically? If so, does it create a new csv file for each export (every >> day) or can I make it so that new data overwrites old versions? >> >> Thanks! >> >> On Tuesday, March 28, 2017 at 2:50:16 PM UTC-4, Sheel Shah wrote: >>> >>> Hi Liz, >>> >>> Unfortunately, I don't believe that Excel can easily do an automated >>> refresh on CSV files. You may need to keep the file in an Excel format, >>> and then save it to CSV when you need to use it as a CSV. >>> >>> Alternatively, you can setup a daily saved export that is a CSV you can >>> just download as needed. >>> >>> Sheel >>> >>> On Tue, Mar 28, 2017 at 1:42 PM, Liz T wrote: >>> >>>> Hi, >>>> >>>> I'm wondering if the dashboard feed works for a CSV comma delimited >>>> format. I can import the data from the feed link to an excel sheet, but >>>> when I save as a CSV and try to Refresh all, it appears that there is no >>>> connection. >>>> Is there a way to update the data as a CSV file, without having to >>>> re-import the dashboard feed link every time? >>>> >>>> Thanks, >>>> Liz >>>> >>>> -- >>>> 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-user...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Sheel Shah >>> Project Manager | Dimagi >>> m: +1.781.428.5419 | skype: sheel_shah >>> >>> >>> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sheel Shah > Project Manager | Dimagi > m: +1.781.428.5419 | skype: sheel_shah > > >