Importing into ODK from microsoft access

Audrey_Karungi_Ngamb · July 8, 2015, 12:25pm

Hi,

I developed a research/ survey database for in Microsoft Access. Later on
found out that the tablets that the data collectors are going to use run on
android. Is there a way I can import into ODK from access?

yanokwa · July 8, 2015, 12:45pm

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

···

-- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access. Later on
found out that the tablets that the data collectors are going to use run on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 8, 2015, 12:55pm

Wow thanks for the quick feedback? Your suggestion implies that I have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be spread
out around the country and are working offline. Will they be able to save
the data locally on their tablets? How shall we consolidate it at a latter
date?

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access. Later on
found out that the tablets that the data collectors are going to use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

yanokwa · July 8, 2015, 1:04pm

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

···

-- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be spread
out around the country and are working offline. Will they be able to save
the data locally on their tablets? How shall we consolidate it at a latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access. Later
on
found out that the tablets that the data collectors are going to use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 8, 2015, 1:14pm

Thanks Yaw for the feedback this was very helpful. I will do as you have
suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be
spread
out around the country and are working offline. Will they be able to save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access. Later
on
found out that the tablets that the data collectors are going to use
run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 9, 2015, 1:12pm

Hi,

I am using the the XLSform to create my survey and so far so good. One
question though how would you advise I create the questions in XLS format
for the sample section, which is a table that I have in the attachment that
I am posting through this email.

The advice is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

sample.doc (52.5 KB)

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:14 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Thanks Yaw for the feedback this was very helpful. I will do as you have
suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I have
to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be
spread
out around the country and are working offline. Will they be able to
save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access.
Later
on
found out that the tablets that the data collectors are going to use
run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 9, 2015, 1:17pm

Another question in the select one option. What should I do if the answers
have more than one word? How should I place the underscore? The example has
it like this yes_no but my questions are for example as below:

Breast Feeding

How long after birth did you *first *breast feed (NAME)? choose one
Immediately or within first hour after delivery
-------------------------------------
Within one to eight
hours---------------------------------------------------------------
More than eight
hours-------------------------------------------------------------------
Did not breast feed

Again the advise is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:12 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Hi,

I am using the the XLSform to create my survey and so far so good. One
question though how would you advise I create the questions in XLS format
for the sample section, which is a table that I have in the attachment that
I am posting through this email.

The advice is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:14 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Thanks Yaw for the feedback this was very helpful. I will do as you have
suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I have
to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be
spread
out around the country and are working offline. Will they be able to
save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access.
Later
on
found out that the tablets that the data collectors are going to
use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 9, 2015, 1:47pm

Okay I think I have located an example for the select_one option however I
am still stuck in regards to the table format. Any ideas?

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:17 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Another question in the select one option. What should I do if the answers
have more than one word? How should I place the underscore? The example has
it like this yes_no but my questions are for example as below:

Breast Feeding

How long after birth did you *first *breast feed (NAME)? choose one

Immediately or within first hour after delivery
-------------------------------------

Within one to eight
hours---------------------------------------------------------------

More than eight
hours-------------------------------------------------------------------

Did not breast feed

Again the advise is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:12 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Hi,

I am using the the XLSform to create my survey and so far so good. One
question though how would you advise I create the questions in XLS format
for the sample section, which is a table that I have in the attachment that
I am posting through this email.

The advice is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:14 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Thanks Yaw for the feedback this was very helpful. I will do as you have
suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I
have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be
spread
out around the country and are working offline. Will they be able to
save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you
must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access.
Later
on
found out that the tablets that the data collectors are going to
use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in
the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit

https://groups.google.com/d/topic/opendatakit/p_SiWi_CSPA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

yanokwa · July 9, 2015, 2:10pm

Please stick to one issue per thread.

For tables, you can either go column first (ask all the questions about
each column 1, then all the questions about column 2) or row first (ask all
the questions about row 1, then all the questions about row 2).

Yaw

···

-- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Jul 9, 2015 at 8:47 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Okay I think I have located an example for the select_one option however I
am still stuck in regards to the table format. Any ideas?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:17 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Another question in the select one option. What should I do if the
answers have more than one word? How should I place the underscore? The
example has it like this yes_no but my questions are for example as below:

Breast Feeding

How long after birth did you *first *breast feed (NAME)? choose one

Immediately or within first hour after delivery
-------------------------------------

Within one to eight
hours---------------------------------------------------------------

More than eight
hours-------------------------------------------------------------------

Did not breast feed

Again the advise is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:12 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Hi,

I am using the the XLSform to create my survey and so far so good. One
question though how would you advise I create the questions in XLS format
for the sample section, which is a table that I have in the attachment that
I am posting through this email.

The advice is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:14 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Thanks Yaw for the feedback this was very helpful. I will do as you
have suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I
have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to be
spread
out around the country and are working offline. Will they be able to
save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

“Life is like riding a bicycle. In order to maintain balance, you
must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access.
Later
on
found out that the tablets that the data collectors are going to
use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in
the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit

https://groups.google.com/d/topic/opendatakit/p_SiWi_CSPA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

Audrey_Karungi_Ngamb · July 9, 2015, 2:27pm

Okay I will stick to one issue per thread noted. Regarding the tables hanks
for the tip.

Audrey Karungi Ngambeki

*CEO Co-Founder
Victorium Holdings
Software Development Company *

···

* Victorium.biz* | *Facebook* | *Twitter*< http://twitter.victorium.biz/> | *Blog *

"Life is like riding a bicycle. In order to maintain balance, you must keep
moving." - Albert Einstein

On Thu, Jul 9, 2015 at 7:10 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Please stick to one issue per thread.

For tables, you can either go column first (ask all the questions about
each column 1, then all the questions about column 2) or row first (ask all
the questions about row 1, then all the questions about row 2).

Yaw

Need ODK services? http://nafundi.com provides form design, server setup,
professional support, and software development for ODK.

On Thu, Jul 9, 2015 at 8:47 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Okay I think I have located an example for the select_one option however
I am still stuck in regards to the table format. Any ideas?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:17 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Another question in the select one option. What should I do if the
answers have more than one word? How should I place the underscore? The
example has it like this yes_no but my questions are for example as below:

Breast Feeding

How long after birth did you *first *breast feed (NAME)? choose
one

Immediately or within first hour after delivery
-------------------------------------

Within one to eight
hours---------------------------------------------------------------

More than eight
hours-------------------------------------------------------------------

Did not breast feed

Again the advise is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Thu, Jul 9, 2015 at 6:12 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Hi,

I am using the the XLSform to create my survey and so far so good. One
question though how would you advise I create the questions in XLS format
for the sample section, which is a table that I have in the attachment that
I am posting through this email.

The advice is much appreciated.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you must
keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:14 AM, Audrey Karungi Ngambeki < audreyk@victorium.biz> wrote:

Thanks Yaw for the feedback this was very helpful. I will do as you
have suggested.

Kind regards
Audrey

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you
must keep moving." - Albert Einstein

On Wed, Jul 8, 2015 at 6:04 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Audrey,

It's probably safest not to assume any implications.

Create forms with the fields you want your enumerators to collect.
Upload that to Aggregate and it'll create the relevant tables. Then
download the forms to ODK Collect for collection.

ODK Collect works great offline, so yes, the completed data will be
saved locally. Then use WiFi/cell to opportunistically send the data
to ODK Aggregate.

Once the data is in Aggregate, you can stream or export it out
(https://opendatakit.org/use/aggregate/data-transfer/) and do
whatever
with it (e.g., insert it into Access).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:55 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Wow thanks for the quick feedback? Your suggestion implies that I
have to
create new forms and tables in aggregate?

Another problem is that the data entrants are 10 and are going to
be spread
out around the country and are working offline. Will they be able
to save
the data locally on their tablets? How shall we consolidate it at a
latter
date?

Audrey Karungi Ngambeki

CEO Co-Founder
Victorium Holdings
Software Development Company *
*
Victorium.biz | Facebook http://facebook.victorium.biz/ |
Twitterhttp://twitter.victorium.biz/
| *Blog http://blog.victorium.biz *

"Life is like riding a bicycle. In order to maintain balance, you
must keep
moving." - Albert Einstein

On Wed, Jul 8, 2015 at 5:45 AM, Yaw Anokwa yanokwa@nafundi.com wrote:

Why not go the other way? Export the data from Aggregate into
Access
after your campaign.

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Wed, Jul 8, 2015 at 7:25 AM, Audrey Karungi Ngambeki audreyk@victorium.biz wrote:

Hi,

I developed a research/ survey database for in Microsoft Access.
Later
on
found out that the tablets that the data collectors are going to
use run
on
android. Is there a way I can import into ODK from access?

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to a topic in
the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit

https://groups.google.com/d/topic/opendatakit/p_SiWi_CSPA/unsubscribe
.

To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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