In my attempt to implement it, here my questions so far:
In the --query command is it required to have downloaded the
spreadsheet? If I have to do this everyday, the process won't be automated.
I also tried using the download link address, but that did not seem to work.
In the picture attached, I am simply just trying to put the excel
spreadsheet in the same directory (I will later put it in another the goal
directory), but I am receiving an error message I am not sure how to deal
with. I appreciate any help on figuring out what is wrong with the cmd line
prompt I wrote and why the output spreadsheet won't be placed in the same
directory.
I appreciate your help in answering these questions,
The "--query" parameter is what tells the tool what to download and what
columns to export. That file shouldn't need to change so you should be able
to keep that the same.
The error message you're getting is because your query file is missing the
"Data Source" column.
···
On 17 February 2017 at 18:53, Hakan Berk wrote:
In my attempt to implement it, here my questions so far:
In the --query command is it required to have downloaded the
spreadsheet? If I have to do this everyday, the process won't be automated.
I also tried using the download link address, but that did not seem to work.
In the picture attached, I am simply just trying to put the excel
spreadsheet in the same directory (I will later put it in another the goal
directory), but I am receiving an error message I am not sure how to deal
with. I appreciate any help on figuring out what is wrong with the cmd line
prompt I wrote and why the output spreadsheet won't be placed in the same
directory.
I appreciate your help in answering these questions,
Does the Data Source column not come with the Daily Export?
If not and I have to create a column, how would I automate this process so
I can export to a specific folder daily?
Thanks,
Hakan
···
On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
>
> HI Hakan
>
> The "--query" parameter is what tells the tool what to download and what
> columns to export. That file shouldn't need to change so you should be able
> to keep that the same.
>
> The error message you're getting is because your query file is missing the
> "Data Source" column.
>
> On 17 February 2017 at 18:53, Hakan Berk <hakan....@gmail.com > wrote:
>
>> Hi,
>>
>> I was using the CommCare Data Export Tool found here
>> and
>> I had a couple questions. My goal is to be able to get CommCare to
>> automatically put daily exports into a folder in a specific directory on my
>> computer.
>>
>> In my attempt to implement it, here my questions so far:
>>
>> 1) In the --query command is it required to have downloaded the
>> spreadsheet? If I have to do this everyday, the process won't be automated.
>> I also tried using the download link address, but that did not seem to work.
>>
>> 2) In the picture attached, I am simply just trying to put the excel
>> spreadsheet in the same directory (I will later put it in another the goal
>> directory), but I am receiving an error message I am not sure how to deal
>> with. I appreciate any help on figuring out what is wrong with the cmd line
>> prompt I wrote and why the output spreadsheet won't be placed in the same
>> directory.
>>
>> I appreciate your help in answering these questions,
>>
>> Hakan
>>
>>
>> --
>> 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.
>>
>
>
>
> --
> Simon Kelly
> Director of Server Engineer | Dimagi
>
···
On 20 February 2017 at 17:20, Hakan Berk wrote:
Does the Data Source column not come with the Daily Export?
If not and I have to create a column, how would I automate this process so
I can export to a specific folder daily?
Thanks,
Hakan
On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
HI Hakan
The "--query" parameter is what tells the tool what to download and what
columns to export. That file shouldn't need to change so you should be able
to keep that the same.
The error message you're getting is because your query file is missing
the "Data Source" column.
In my attempt to implement it, here my questions so far:
In the --query command is it required to have downloaded the
spreadsheet? If I have to do this everyday, the process won't be automated.
I also tried using the download link address, but that did not seem to work.
In the picture attached, I am simply just trying to put the excel
spreadsheet in the same directory (I will later put it in another the goal
directory), but I am receiving an error message I am not sure how to deal
with. I appreciate any help on figuring out what is wrong with the cmd line
prompt I wrote and why the output spreadsheet won't be placed in the same
directory.
I appreciate your help in answering these questions,
Hakan
--
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.
--
Simon Kelly
Director of Server Engineer | Dimagi
I was able to run the data export with your sample file, but when I tried
to set up my own excel file it did not seem to work. There are two attached
screenshots. One of them displays what I put in my spreadsheet, the other
is the output from the command window.
The command window line data_source_str = get_column_by_name(worksheet,
'data source')[0].value seems to be returning null? I don't understand why
it would do that if I put "form" under my data source.
Could you let me know what I am doing wrong with the configuration of the
excel file?
···
On Tuesday, February 21, 2017 at 8:26:36 AM UTC-5, skelly wrote:
>
> Hi Hakan
>
> I think you may be confusing the tools. The CommCare Data Export Tool
> requires an Excel configuration file which you have to create manually.
> Here's an example config file for exporting forms:
> https://github.com/dimagi/commcare-export/blob/master/examples/demo-registrations.xlsx?raw=true
>
> I'd recommend that you read through the wiki page which has instructions
> on the configuration file:
> https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-C.ExcelConfigurationDetails
>
> On 20 February 2017 at 17:20, Hakan Berk <hakan....@gmail.com > wrote:
>
>> Does the Data Source column not come with the Daily Export?
>>
>> If not and I have to create a column, how would I automate this process
>> so I can export to a specific folder daily?
>>
>> Thanks,
>>
>> Hakan
>>
>> On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
>>>
>>> HI Hakan
>>>
>>> The "--query" parameter is what tells the tool what to download and what
>>> columns to export. That file shouldn't need to change so you should be able
>>> to keep that the same.
>>>
>>> The error message you're getting is because your query file is missing
>>> the "Data Source" column.
>>>
>>> On 17 February 2017 at 18:53, Hakan Berk wrote:
>>>
>>>> Hi,
>>>>
>>>> I was using the CommCare Data Export Tool found here
>>>> and
>>>> I had a couple questions. My goal is to be able to get CommCare to
>>>> automatically put daily exports into a folder in a specific directory on my
>>>> computer.
>>>>
>>>> In my attempt to implement it, here my questions so far:
>>>>
>>>> 1) In the --query command is it required to have downloaded the
>>>> spreadsheet? If I have to do this everyday, the process won't be automated.
>>>> I also tried using the download link address, but that did not seem to work.
>>>>
>>>> 2) In the picture attached, I am simply just trying to put the excel
>>>> spreadsheet in the same directory (I will later put it in another the goal
>>>> directory), but I am receiving an error message I am not sure how to deal
>>>> with. I appreciate any help on figuring out what is wrong with the cmd line
>>>> prompt I wrote and why the output spreadsheet won't be placed in the same
>>>> directory.
>>>>
>>>> I appreciate your help in answering these questions,
>>>>
>>>> Hakan
>>>>
>>>>
>>>> --
>>>> 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.
>>>>
>>>
>>>
>>>
>>> --
>>> Simon Kelly
>>> Director of Server Engineer | Dimagi
>>>
>> --
>> 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.
>>
>
>
>
> --
> Simon Kelly
> Director of Server Engineer | Dimagi
>
What doesn't make sense to me is that I just put my form URL into the
demo-registration.xlsx and it worked. So that isn't the problem and I'm not
sure what else it could be.
Thanks,
Hakan
···
On Friday, February 24, 2017 at 11:25:13 AM UTC-5, Hakan Berk wrote:
>
> Thanks for bringing up that clarification.
>
> I was able to run the data export with your sample file, but when I tried
> to set up my own excel file it did not seem to work. There are two attached
> screenshots. One of them displays what I put in my spreadsheet, the other
> is the output from the command window.
>
> The command window line data_source_str = get_column_by_name(worksheet,
> 'data source')[0].value seems to be returning null? I don't understand why
> it would do that if I put "form" under my data source.
>
> Could you let me know what I am doing wrong with the configuration of the
> excel file?
>
> Thanks,
>
> Hakan
>
>
>
> On Tuesday, February 21, 2017 at 8:26:36 AM UTC-5, skelly wrote:
>>
>> Hi Hakan
>>
>> I think you may be confusing the tools. The CommCare Data Export Tool
>> requires an Excel configuration file which you have to create manually.
>> Here's an example config file for exporting forms:
>> https://github.com/dimagi/commcare-export/blob/master/examples/demo-registrations.xlsx?raw=true
>>
>> I'd recommend that you read through the wiki page which has instructions
>> on the configuration file:
>> https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-C.ExcelConfigurationDetails
>>
>> On 20 February 2017 at 17:20, Hakan Berk wrote:
>>
>>> Does the Data Source column not come with the Daily Export?
>>>
>>> If not and I have to create a column, how would I automate this process
>>> so I can export to a specific folder daily?
>>>
>>> Thanks,
>>>
>>> Hakan
>>>
>>> On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
>>>>
>>>> HI Hakan
>>>>
>>>> The "--query" parameter is what tells the tool what to download and
>>>> what columns to export. That file shouldn't need to change so you should be
>>>> able to keep that the same.
>>>>
>>>> The error message you're getting is because your query file is missing
>>>> the "Data Source" column.
>>>>
>>>> On 17 February 2017 at 18:53, Hakan Berk wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I was using the CommCare Data Export Tool found here
>>>>> and
>>>>> I had a couple questions. My goal is to be able to get CommCare to
>>>>> automatically put daily exports into a folder in a specific directory on my
>>>>> computer.
>>>>>
>>>>> In my attempt to implement it, here my questions so far:
>>>>>
>>>>> 1) In the --query command is it required to have downloaded the
>>>>> spreadsheet? If I have to do this everyday, the process won't be automated.
>>>>> I also tried using the download link address, but that did not seem to work.
>>>>>
>>>>> 2) In the picture attached, I am simply just trying to put the excel
>>>>> spreadsheet in the same directory (I will later put it in another the goal
>>>>> directory), but I am receiving an error message I am not sure how to deal
>>>>> with. I appreciate any help on figuring out what is wrong with the cmd line
>>>>> prompt I wrote and why the output spreadsheet won't be placed in the same
>>>>> directory.
>>>>>
>>>>> I appreciate your help in answering these questions,
>>>>>
>>>>> Hakan
>>>>>
>>>>>
>>>>> --
>>>>> 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.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Simon Kelly
>>>> Director of Server Engineer | Dimagi
>>>>
>>> --
>>> 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.
>>>
>>
>>
>>
>> --
>> Simon Kelly
>> Director of Server Engineer | Dimagi
>>
>
Sorry for the bunch of questions, just really trying to understand how this
works.
How does the scheduling of this process work? Every time I run it, I am
asked for my username / password. If I was to set up a scheduler to do this
everyday, even when I'm not at the computer would it still work or would it
require username / password?
Thanks,
Hakan
···
On Friday, February 24, 2017 at 11:30:09 AM UTC-5, Hakan Berk wrote:
>
> What doesn't make sense to me is that I just put my form URL into the
> demo-registration.xlsx and it worked. So that isn't the problem and I'm not
> sure what else it could be.
>
> Thanks,
>
> Hakan
>
> On Friday, February 24, 2017 at 11:25:13 AM UTC-5, Hakan Berk wrote:
>>
>> Thanks for bringing up that clarification.
>>
>> I was able to run the data export with your sample file, but when I tried
>> to set up my own excel file it did not seem to work. There are two attached
>> screenshots. One of them displays what I put in my spreadsheet, the other
>> is the output from the command window.
>>
>> The command window line data_source_str = get_column_by_name(worksheet,
>> 'data source')[0].value seems to be returning null? I don't understand why
>> it would do that if I put "form" under my data source.
>>
>> Could you let me know what I am doing wrong with the configuration of the
>> excel file?
>>
>> Thanks,
>>
>> Hakan
>>
>>
>>
>> On Tuesday, February 21, 2017 at 8:26:36 AM UTC-5, skelly wrote:
>>>
>>> Hi Hakan
>>>
>>> I think you may be confusing the tools. The CommCare Data Export Tool
>>> requires an Excel configuration file which you have to create manually.
>>> Here's an example config file for exporting forms:
>>> https://github.com/dimagi/commcare-export/blob/master/examples/demo-registrations.xlsx?raw=true
>>>
>>> I'd recommend that you read through the wiki page which has instructions
>>> on the configuration file:
>>> https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-C.ExcelConfigurationDetails
>>>
>>> On 20 February 2017 at 17:20, Hakan Berk wrote:
>>>
>>>> Does the Data Source column not come with the Daily Export?
>>>>
>>>> If not and I have to create a column, how would I automate this process
>>>> so I can export to a specific folder daily?
>>>>
>>>> Thanks,
>>>>
>>>> Hakan
>>>>
>>>> On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
>>>>>
>>>>> HI Hakan
>>>>>
>>>>> The "--query" parameter is what tells the tool what to download and
>>>>> what columns to export. That file shouldn't need to change so you should be
>>>>> able to keep that the same.
>>>>>
>>>>> The error message you're getting is because your query file is missing
>>>>> the "Data Source" column.
>>>>>
>>>>> On 17 February 2017 at 18:53, Hakan Berk wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I was using the CommCare Data Export Tool found here
>>>>>> and
>>>>>> I had a couple questions. My goal is to be able to get CommCare to
>>>>>> automatically put daily exports into a folder in a specific directory on my
>>>>>> computer.
>>>>>>
>>>>>> In my attempt to implement it, here my questions so far:
>>>>>>
>>>>>> 1) In the --query command is it required to have downloaded the
>>>>>> spreadsheet? If I have to do this everyday, the process won't be automated.
>>>>>> I also tried using the download link address, but that did not seem to work.
>>>>>>
>>>>>> 2) In the picture attached, I am simply just trying to put the excel
>>>>>> spreadsheet in the same directory (I will later put it in another the goal
>>>>>> directory), but I am receiving an error message I am not sure how to deal
>>>>>> with. I appreciate any help on figuring out what is wrong with the cmd line
>>>>>> prompt I wrote and why the output spreadsheet won't be placed in the same
>>>>>> directory.
>>>>>>
>>>>>> I appreciate your help in answering these questions,
>>>>>>
>>>>>> Hakan
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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.
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Simon Kelly
>>>>> Director of Server Engineer | Dimagi
>>>>>
>>>> --
>>>> 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.
>>>>
>>>
>>>
>>>
>>> --
>>> Simon Kelly
>>> Director of Server Engineer | Dimagi
>>>
>>
I'm not sure why you're getting that error. It does look like it has the
right information in it.
Regarding the scheduling, you can supply the username and password via
command line options. Run "commcare-export --help" to see the full list of
options.
···
On 24 February 2017 at 18:57, Hakan Berk wrote:
Sorry for the bunch of questions, just really trying to understand how
this works.
How does the scheduling of this process work? Every time I run it, I am
asked for my username / password. If I was to set up a scheduler to do this
everyday, even when I'm not at the computer would it still work or would it
require username / password?
Thanks,
Hakan
On Friday, February 24, 2017 at 11:30:09 AM UTC-5, Hakan Berk wrote:
What doesn't make sense to me is that I just put my form URL into the
demo-registration.xlsx and it worked. So that isn't the problem and I'm not
sure what else it could be.
Thanks,
Hakan
On Friday, February 24, 2017 at 11:25:13 AM UTC-5, Hakan Berk wrote:
Thanks for bringing up that clarification.
I was able to run the data export with your sample file, but when I
tried to set up my own excel file it did not seem to work. There are two
attached screenshots. One of them displays what I put in my spreadsheet,
the other is the output from the command window.
The command window line data_source_str = get_column_by_name(worksheet,
'data source')[0].value seems to be returning null? I don't understand why
it would do that if I put "form" under my data source.
Could you let me know what I am doing wrong with the configuration of
the excel file?
Thanks,
Hakan
On Tuesday, February 21, 2017 at 8:26:36 AM UTC-5, skelly wrote:
Does the Data Source column not come with the Daily Export?
If not and I have to create a column, how would I automate this
process so I can export to a specific folder daily?
Thanks,
Hakan
On Monday, February 20, 2017 at 8:58:29 AM UTC-5, skelly wrote:
HI Hakan
The "--query" parameter is what tells the tool what to download and
what columns to export. That file shouldn't need to change so you should be
able to keep that the same.
The error message you're getting is because your query file is
missing the "Data Source" column.
In my attempt to implement it, here my questions so far:
In the --query command is it required to have downloaded the
spreadsheet? If I have to do this everyday, the process won't be automated.
I also tried using the download link address, but that did not seem to work.
In the picture attached, I am simply just trying to put the excel
spreadsheet in the same directory (I will later put it in another the goal
directory), but I am receiving an error message I am not sure how to deal
with. I appreciate any help on figuring out what is wrong with the cmd line
prompt I wrote and why the output spreadsheet won't be placed in the same
directory.
I appreciate your help in answering these questions,
Hakan
--
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.
--
Simon Kelly
Director of Server Engineer | Dimagi
--
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.
--
Simon Kelly
Director of Server Engineer | Dimagi
