ODK Aggregate 1.4.7 - In filters "Where" clause is disabled

What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.
What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

What browser are you using?

We only test with Firefox and Chrome.

When clicking on the "where..." entry, this should display a drop-down
where you can choose a different field-name.

It looks like the list of choices for that drop-down box is displaced below
the field-name selection, (meta:instanceID) so that it doesn't appear as
part of that display.

··· On Mon, Jun 8, 2015 at 2:50 AM, Piyush Shah wrote:

What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.
What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I face the same issue here. ODK aggregator v1.4.7 on windows server 2008

··· On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote: > > What steps will reproduce the problem? > 1. Click on Add Filter > > What is the expected output? What do you see instead? > I can mention the where clause for filtering data. > Instead of it where clause is disabled. > What version of the product are you using? On what operating system? > ODK Aggregate 1.4.7 on Windows Server 2008 > > >

Thanks Mitch.

I am using Chrome and Firefox only.

In the previous version of ODK Aggregate (1.4.6) it's working fine but in
current version the "where" clause is disable.

··· On Tuesday, 9 June 2015 00:15:05 UTC+5:30, Mitch Sundt wrote: > > What browser are you using? > > We only test with Firefox and Chrome. > > When clicking on the "where..." entry, this should display a drop-down > where you can choose a different field-name. > > It looks like the list of choices for that drop-down box is displaced > below the field-name selection, (meta:instanceID) so that it doesn't appear > as part of that display. > > > On Mon, Jun 8, 2015 at 2:50 AM, Piyush Shah <piyus...@gmail.com > wrote: > >> What steps will reproduce the problem? >> 1. Click on Add Filter >> >> What is the expected output? What do you see instead? >> I can mention the where clause for filtering data. >> Instead of it where clause is disabled. >> What version of the product are you using? On what operating system? >> ODK Aggregate 1.4.7 on Windows Server 2008 >> >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

I face the same issue here. ODK aggregator v1.4.7 on windows server 2008

What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.

What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

Hi, I´m facing same issue, windows 8, using Chrome V 47.0.2526.80 m

Is it have been solved? do we have any idea of when could be solved? what should we do? I was using filters as a way of searching for information, and now I have to export the data to search on them.

Thanks,

Pablo

··· El miércoles, 21 de octubre de 2015, 10:16:32 (UTC+2), Rofand K escribió: > On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote:

Confirmed that this is an issue.

This won't be fixed quickly, but I will investigate it for the the 1.4.8
release.

··· On Mon, Jun 8, 2015 at 10:09 PM, Piyush Shah wrote:

Thanks Mitch.

I am using Chrome and Firefox only.

In the previous version of ODK Aggregate (1.4.6) it's working fine but in
current version the "where" clause is disable.

On Tuesday, 9 June 2015 00:15:05 UTC+5:30, Mitch Sundt wrote:

What browser are you using?

We only test with Firefox and Chrome.

When clicking on the "where..." entry, this should display a drop-down
where you can choose a different field-name.

It looks like the list of choices for that drop-down box is displaced
below the field-name selection, (meta:instanceID) so that it doesn't appear
as part of that display.

On Mon, Jun 8, 2015 at 2:50 AM, Piyush Shah piyus...@gmail.com wrote:

What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.
What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

--

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

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I have not yet had time to research this issue.

It appears to be a CSS issue; hopefully related to moving from GWT 2.6.1 to
GWT 2.7.

··· On Tue, Dec 15, 2015 at 3:14 AM, wrote:

El miércoles, 21 de octubre de 2015, 10:16:32 (UTC+2), Rofand K escribió:

I face the same issue here. ODK aggregator v1.4.7 on windows server 2008

On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote:
What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.

What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

Hi, I´m facing same issue, windows 8, using Chrome V 47.0.2526.80 m

Is it have been solved? do we have any idea of when could be solved? what
should we do? I was using filters as a way of searching for information,
and now I have to export the data to search on them.

Thanks,

Pablo

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I confirm this bug as well. In 1.4.5 it was fine (cannot check for 1.4.6)
I hope the upgrade to 1.4.8 will be smooth.

Best,
piqo

··· On Wednesday, June 10, 2015 at 1:57:05 AM UTC+2, Mitch Sundt wrote: > > Confirmed that this is an issue. > > This won't be fixed quickly, but I will investigate it for the the 1.4.8 > release. > > > On Mon, Jun 8, 2015 at 10:09 PM, Piyush Shah <piyus...@gmail.com > wrote: > >> Thanks Mitch. >> >> I am using Chrome and Firefox only. >> >> In the previous version of ODK Aggregate (1.4.6) it's working fine but in >> current version the "where" clause is disable. >> >> On Tuesday, 9 June 2015 00:15:05 UTC+5:30, Mitch Sundt wrote: >>> >>> What browser are you using? >>> >>> We only test with Firefox and Chrome. >>> >>> When clicking on the "where..." entry, this should display a drop-down >>> where you can choose a different field-name. >>> >>> It looks like the list of choices for that drop-down box is displaced >>> below the field-name selection, (meta:instanceID) so that it doesn't appear >>> as part of that display. >>> >>> >>> On Mon, Jun 8, 2015 at 2:50 AM, Piyush Shah wrote: >>> >>>> What steps will reproduce the problem? >>>> 1. Click on Add Filter >>>> >>>> What is the expected output? What do you see instead? >>>> I can mention the where clause for filtering data. >>>> Instead of it where clause is disabled. >>>> What version of the product are you using? On what operating system? >>>> ODK Aggregate 1.4.7 on Windows Server 2008 >>>> >>>> >>>> -- >>>> -- >>>> Post: opend...@googlegroups.com >>>> Unsubscribe: opendatakit...@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...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Mitch Sundt >>> Software Engineer >>> University of Washington >>> mitche...@gmail.com >>> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

Given that this is a long-standing issue, it might make sense to open an
issue on the issue tracker, ya? I'm happy to do so. Certainly, running a
1.4.5 VM still seems like a viable workaround for folks that need filters.
The only thing that makes me hesitate is that it hasn't been done already,
so maybe there's a reason.

While I'm at it - there is no other way to get metadata to export, right?

D

··· On Tuesday, December 15, 2015 at 11:52:21 AM UTC-8, Mitch Sundt wrote: > > I have not yet had time to research this issue. > > It appears to be a CSS issue; hopefully related to moving from GWT 2.6.1 > to GWT 2.7. > > > On Tue, Dec 15, 2015 at 3:14 AM, <nuncaestardes...@gmail.com wrote: > >> El miércoles, 21 de octubre de 2015, 10:16:32 (UTC+2), Rofand K escribió: >> > I face the same issue here. ODK aggregator v1.4.7 on windows server 2008 >> > >> > On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote: >> > What steps will reproduce the problem? >> > 1. Click on Add Filter >> > >> > >> > What is the expected output? What do you see instead? >> > I can mention the where clause for filtering data. >> > Instead of it where clause is disabled. >> > >> > What version of the product are you using? On what operating system? >> > ODK Aggregate 1.4.7 on Windows Server 2008 >> >> Hi, I´m facing same issue, windows 8, using Chrome V 47.0.2526.80 m >> >> Is it have been solved? do we have any idea of when could be solved? what >> should we do? I was using filters as a way of searching for information, >> and now I have to export the data to search on them. >> >> Thanks, >> >> Pablo >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@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...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

That will depend upon whether 1.4.8 is forced by changes that are occurring
in the AppEngine deployment scripts.

··· On Mon, Oct 5, 2015 at 2:47 AM, El Piqo wrote:

I confirm this bug as well. In 1.4.5 it was fine (cannot check for 1.4.6)
I hope the upgrade to 1.4.8 will be smooth.

Best,
piqo

On Wednesday, June 10, 2015 at 1:57:05 AM UTC+2, Mitch Sundt wrote:

Confirmed that this is an issue.

This won't be fixed quickly, but I will investigate it for the the 1.4.8
release.

On Mon, Jun 8, 2015 at 10:09 PM, Piyush Shah piyus...@gmail.com wrote:

Thanks Mitch.

I am using Chrome and Firefox only.

In the previous version of ODK Aggregate (1.4.6) it's working fine but
in current version the "where" clause is disable.

On Tuesday, 9 June 2015 00:15:05 UTC+5:30, Mitch Sundt wrote:

What browser are you using?

We only test with Firefox and Chrome.

When clicking on the "where..." entry, this should display a drop-down
where you can choose a different field-name.

It looks like the list of choices for that drop-down box is displaced
below the field-name selection, (meta:instanceID) so that it doesn't appear
as part of that display.

On Mon, Jun 8, 2015 at 2:50 AM, Piyush Shah piyus...@gmail.com wrote:

What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.
What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

--

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

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

I finally had time to investigate and fix the filter problem. It will be
fixed in the next ODK Aggregate release, probably in January.

w.r.t. metadata -- do you mean publishing or exporting to csv?

··· On Mon, Dec 28, 2015 at 9:35 AM, wrote:

Given that this is a long-standing issue, it might make sense to open an
issue on the issue tracker, ya? I'm happy to do so. Certainly, running a
1.4.5 VM still seems like a viable workaround for folks that need filters.
The only thing that makes me hesitate is that it hasn't been done already,
so maybe there's a reason.

While I'm at it - there is no other way to get metadata to export, right?

D

On Tuesday, December 15, 2015 at 11:52:21 AM UTC-8, Mitch Sundt wrote:

I have not yet had time to research this issue.

It appears to be a CSS issue; hopefully related to moving from GWT 2.6.1
to GWT 2.7.

On Tue, Dec 15, 2015 at 3:14 AM, nuncaestardes...@gmail.com wrote:

El miércoles, 21 de octubre de 2015, 10:16:32 (UTC+2), Rofand K escribió:

I face the same issue here. ODK aggregator v1.4.7 on windows server
2008

On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote:
What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.

What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

Hi, I´m facing same issue, windows 8, using Chrome V 47.0.2526.80 m

Is it have been solved? do we have any idea of when could be solved?
what should we do? I was using filters as a way of searching for
information, and now I have to export the data to search on them.

Thanks,

Pablo

--

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

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

That's great to hear, Mitch!

I am wanting to get timestamps in CSV export (or JSON is fine too). The
only way I've been able to do this in the past is with a filter.

D

··· On Mon, Dec 28, 2015 at 11:19 AM, Mitch Sundt wrote:

I finally had time to investigate and fix the filter problem. It will be
fixed in the next ODK Aggregate release, probably in January.

w.r.t. metadata -- do you mean publishing or exporting to csv?

On Mon, Dec 28, 2015 at 9:35 AM, davclark@berkeley.edu wrote:

Given that this is a long-standing issue, it might make sense to open an
issue on the issue tracker, ya? I'm happy to do so. Certainly, running a
1.4.5 VM still seems like a viable workaround for folks that need filters.
The only thing that makes me hesitate is that it hasn't been done already,
so maybe there's a reason.

While I'm at it - there is no other way to get metadata to export, right?

D

On Tuesday, December 15, 2015 at 11:52:21 AM UTC-8, Mitch Sundt wrote:

I have not yet had time to research this issue.

It appears to be a CSS issue; hopefully related to moving from GWT 2.6.1
to GWT 2.7.

On Tue, Dec 15, 2015 at 3:14 AM, nuncaestardes...@gmail.com wrote:

El miércoles, 21 de octubre de 2015, 10:16:32 (UTC+2), Rofand K escribió:

I face the same issue here. ODK aggregator v1.4.7 on windows server
2008

On Monday, 8 June 2015 12:50:58 UTC+3, Piyush Shah wrote:
What steps will reproduce the problem?

  1. Click on Add Filter

What is the expected output? What do you see instead?
I can mention the where clause for filtering data.
Instead of it where clause is disabled.

What version of the product are you using? On what operating system?
ODK Aggregate 1.4.7 on Windows Server 2008

Hi, I´m facing same issue, windows 8, using Chrome V 47.0.2526.80 m

Is it have been solved? do we have any idea of when could be solved?
what should we do? I was using filters as a way of searching for
information, and now I have to export the data to search on them.

Thanks,

Pablo

--

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

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

--

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/CtQqeSVlNq8/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.

--
Dav Clark
Data Scientist
Berkeley D-Lab + BIDS
bead.glass
917-544-8408

Hi guys,

just want to ask when will the new version (that solves filtering issues) be available?

Thanks.

Raffy

Hi guys, I´m having another issue, (that I solve in another way). I export
the database in a CSV and then download the images and everything with
excel macros, but, now the exports are without extension with the name
"binaryData". Inside it is basically a CSV, so it is not a serious problem
with the program I wrote, now i just programed it so it basically starts by
adding the csv extension, but just saying about this other issue.

Regards,

Pablo

··· On Thu, Feb 4, 2016 at 1:28 PM, wrote:

Hi guys,

just want to ask when will the new version (that solves filtering issues)
be available?

Thanks.

Raffy

--

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/CtQqeSVlNq8/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.

Pablo hi,
Would like to know more about those macros of yours, more especially do
they link images to excel

··· On 4 February 2016 at 18:01, Pablo Rodríguez < nuncaestardesillegaspronto@gmail.com> wrote:

Hi guys, I´m having another issue, (that I solve in another way). I export
the database in a CSV and then download the images and everything with
excel macros, but, now the exports are without extension with the name
"binaryData". Inside it is basically a CSV, so it is not a serious problem
with the program I wrote, now i just programed it so it basically starts by
adding the csv extension, but just saying about this other issue.

Regards,

Pablo

On Thu, Feb 4, 2016 at 1:28 PM, rivera.raffy@gmail.com wrote:

Hi guys,

just want to ask when will the new version (that solves filtering issues)
be available?

Thanks.

Raffy

--

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/CtQqeSVlNq8/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.

--
**In sun set years education is not associated with standard of living and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

Well, it´s not perfect but it works for me:

i do call to progress which is just a status bar, and obviously you´ll have
to make it work to read the links in the columns where you have it.

That´s the main module, but I use much more but I am not allowed to share
them all, if you know what you are doing then you are already close enough.

Sub DownloadPics2()
Application.ScreenUpdating = True
Dim ws As Worksheet

Dim Lastrow As Long, i As Long, j, k As Long
Dim strPath As String
Dim porcentaje As Single
Dim respuesta, respuesta2 As Integer
Dim basura As String
ActiveSheet.Name = "Export"
Set ws = Sheets("Export")

'~~> Name of the sheet which has the list
'Miro cuantas lineas hay y las compruebo todas

respuesta = MsgBox("¿do you wanna download the pictures? It can take

some time", vbYesNo + vbQuestion, "report")

If respuesta = vbYes Then

respuesta2 = MsgBox("¿do you wanna add already existing pictures (so it

does not download themn again)? if you do then drop then in the next window
" & CARPETA, vbYesNo + vbQuestion, "Reporte campaña")
If respuesta2 = vbYes Then
basura = FilePath2
End If

Lastrow = ws.Range("B" & Rows.count).End(xlUp).Row
For i = 2 To Lastrow '<~~ 2 because row 1 has headers
    For j = 8 To 18

    If ws.Cells(i, j).Value <> "" Then
        If j >= 8 Then
            'MsgBox "es la primera"
            strPath = ws.Range("d" & i).Value & "_" & (j - 7) & ".jpg"
            If Dir(CARPETA & "\" & strPath) <> "" Then
                'MsgBox "existe el primero"
                For k = 8 To 18
                    If ws.Cells(i, k).Value <> "" Then
                        'MsgBox "escribo link existente"
                        strPath = ws.Range("d" & i).Value & "_" & (k -
  1. & ".jpg"
    ws.Hyperlinks.Add Anchor:=ws.Cells(i, k),
    Address:=CARPETA & "" & strPath, TextToDisplay:=strPath
    End If
    Next k
    j = 19
    End If
    End If
    If j <> 19 Then
    strPath = ws.Range("d" & i).Value & "_" & (j - 7) & ".jpg"
    Ret = URLDownloadToFile(0, ws.Cells(i, j).Value, CARPETA &
    "" & strPath, 0, 0)
    If Ret = 0 Then

                ws.Hyperlinks.Add Anchor:=ws.Cells(i, j),
    

Address:=CARPETA & "" & strPath, TextToDisplay:=strPath
Else
ws.Cells(i, j).Value = "ERROR DE DESCARGA"
ws.Cells(i, j).Interior.Color = 250
End If
End If
End If

    porcentaje = Format(((11 * (i - 2) + (j - 8)) / ((Lastrow - 1) *

11)) * 100, "standard") 'Format(i / (LastRow + 1) * 100, "standard")
Progress porcentaje
Next j
Next i

Else
'do nothing

End If

End Sub

··· On Fri, Feb 5, 2016 at 6:27 AM, Ayoub Kakande wrote:

Pablo hi,
Would like to know more about those macros of yours, more especially do
they link images to excel

On 4 February 2016 at 18:01, Pablo Rodríguez < nuncaestardesillegaspronto@gmail.com> wrote:

Hi guys, I´m having another issue, (that I solve in another way). I
export the database in a CSV and then download the images and everything
with excel macros, but, now the exports are without extension with the name
"binaryData". Inside it is basically a CSV, so it is not a serious problem
with the program I wrote, now i just programed it so it basically starts by
adding the csv extension, but just saying about this other issue.

Regards,

Pablo

On Thu, Feb 4, 2016 at 1:28 PM, rivera.raffy@gmail.com wrote:

Hi guys,

just want to ask when will the new version (that solves filtering
issues) be available?

Thanks.

Raffy

--

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/CtQqeSVlNq8/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.

--
**In sun set years education is not associated with standard of living and
medical care access; it is the the financial myosin and actin!!!

**** Don't give me fish, teach me how to fish

Kayoub K
0772656158 / 0703516660
Data Manager
Mujhu Research Collaboration
Mulago Hosp
Msc Enterprise Architecture

--

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/CtQqeSVlNq8/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.