Importing into ODK from microsoft access

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?

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.

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.

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.

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.

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.

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

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

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

  3. Within one to eight
    hours---------------------------------------------------------------

  4. More than eight
    hours-------------------------------------------------------------------

  5. 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.

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

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

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

  3. Within one to eight
    hours---------------------------------------------------------------

  4. More than eight
    hours-------------------------------------------------------------------

  5. 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.

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

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

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

  3. Within one to eight
    hours---------------------------------------------------------------

  4. More than eight
    hours-------------------------------------------------------------------

  5. 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.

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

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

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

  3. Within one to eight
    hours---------------------------------------------------------------

  4. More than eight
    hours-------------------------------------------------------------------

  5. 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.