Hdroidgui Dbf

Issues and Discussions related to Harbour

Moderator: Rathinagiri

mruizcanete
Posts: 16
Joined: Sat Apr 19, 2014 10:17 am

Hdroidgui Dbf

Post by mruizcanete »

Recently, Alexander Kresin has developed a dbf browser with his tool Hdroidgui. Has anyone checked its functionality? I have some issues with my mobile, so I can't dowload it from github. It could be another incredible step for us if this app works properly...
https://github.com/alkresin/hddbf
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: Hdroidgui Dbf

Post by Roberto Lopez »

mruizcanete wrote:Recently, Alexander Kresin has developed a dbf browser with his tool Hdroidgui. Has anyone checked its functionality? I have some issues with my mobile, so I can't dowload it from github. It could be another incredible step for us if this app works properly...
https://github.com/alkresin/hddbf
I've built successfully the first version. I've not tested after updates (there were a couple of them).

It is a wonderful thing.

Easy, nice and powerful.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
MigSoft
Posts: 74
Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:

Re: Hdroidgui Dbf

Post by MigSoft »

Hi,

Thanks to Roberto and guidelines posted on this forum, start some tests with the library of Alexander Kresin resulting in a pleasant surprise.

Saludos,

Miguel Angel Juárez Apaza
https://www.migsoft.ml
Attachments
Screenshot_2015-03-25-pag3.png
Screenshot_2015-03-25-pag3.png (86.97 KiB) Viewed 9243 times
Screenshot_2015-03-25-pag2.png
Screenshot_2015-03-25-pag2.png (91.51 KiB) Viewed 9243 times
Screenshot_2015-03-25-pag1.png
Screenshot_2015-03-25-pag1.png (152.45 KiB) Viewed 9243 times
Last edited by MigSoft on Tue Oct 29, 2019 3:43 am, edited 1 time in total.
Regards,

MigSoft.
User avatar
serge_girard
Posts: 3158
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Hdroidgui Dbf

Post by serge_girard »

Nice !

Serge
There's nothing you can do that can't be done...
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Hdroidgui Dbf

Post by mol »

Hi Miguel,
Are you using windows?
If yes, can you place here your guide to start?
Regards, Marek
User avatar
MigSoft
Posts: 74
Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:

Re: Hdroidgui Dbf

Post by MigSoft »

Hi Marek,

Yes, soon I will publish a guide to start.

Regards,

Miguel Juárez

You can download new "hddbf.apk" in http://migsoft.ml/2015/03/guia-de-inicio-hdroidgui
Attachments
Screenshot_2015-03-26-23-22-21.jpg
Screenshot_2015-03-26-23-22-21.jpg (64.63 KiB) Viewed 9094 times
Last edited by MigSoft on Tue Oct 29, 2019 3:43 am, edited 1 time in total.
Regards,

MigSoft.
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Hdroidgui Dbf

Post by mol »

It would be great!
Thanks in advance!
gvaronas
Posts: 109
Joined: Wed Aug 06, 2008 5:21 pm

Re: Hdroidgui Dbf

Post by gvaronas »

Hola Roberto:
He logrado hacer funcionar el ejemplo "hddbf" y funcionó muy bien, luego lo modifique para trabajar con hbNetIO y una tabla de un poco mas de 2000 registros, funciona, pero solo puede navegar hasta el registro 48 o 50, luego sale una ventanita que dice: "se ha detenido la aplicación hddbf" y un boton de "Aceptar" que al hacer click alli, se detiene la aplicación y termina.

Salu2,
GVS
Attachments
Screenshot_2015-03-29-18-47-48.png
Screenshot_2015-03-29-18-47-48.png (143.08 KiB) Viewed 8997 times
Screenshot_2015-03-29-18-48-04.png
Screenshot_2015-03-29-18-48-04.png (45.1 KiB) Viewed 8997 times
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: Hdroidgui Dbf

Post by Roberto Lopez »

gvaronas wrote:Hola Roberto:
He logrado hacer funcionar el ejemplo "hddbf" y funcionó muy bien, luego lo modifique para trabajar con hbNetIO y una tabla de un poco mas de 2000 registros, funciona, pero solo puede navegar hasta el registro 48 o 50, luego sale una ventanita que dice: "se ha detenido la aplicación hddbf" y un boton de "Aceptar" que al hacer click alli, se detiene la aplicación y termina.

Salu2,
GVS
Deberías enviarle a Alex, una ejemplo mínimo reproduciendo el problema, para que pueda analizarlo.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
gvaronas
Posts: 109
Joined: Wed Aug 06, 2008 5:21 pm

Re: Hdroidgui Dbf

Post by gvaronas »

Roberto Lopez wrote:
gvaronas wrote:Hola Roberto:
He logrado hacer funcionar el ejemplo "hddbf" y funcionó muy bien, luego lo modifique para trabajar con hbNetIO y una tabla de un poco mas de 2000 registros, funciona, pero solo puede navegar hasta el registro 48 o 50, luego sale una ventanita que dice: "se ha detenido la aplicación hddbf" y un boton de "Aceptar" que al hacer click alli, se detiene la aplicación y termina.

Salu2,
GVS
Deberías enviarle a Alex, una ejemplo mínimo reproduciendo el problema, para que pueda analizarlo.
Hola Roberto:
Disculpa la demora en la respuesta, actualmente solamente me estoy dedicando a investigar estos temas los fines de semana.
Hice mi reporte en el grupo de usuarios de harbour, pero tuve dificultad para agregar las imagenes y los fuentes del proyecto, aparte que mi inglés, aun con la ayuda del google, es pésimo.
De todas formas, reporto aquí lo que quise hacer en el grupo de usuarios de harbour:
===========================================================================

Hi Alex:

[Google]

First I want to express my appreciation for their efforts in developing this wonderful tool.
I've done some tests with HDroidGUI and describe my results here:
With the utilitarian "newproject.exe" I created a new project called "hdNetIO".
I modified the code examples for an APK that allows me to make a table BROWSE "test.dbf" located in the "C:\hb32\tests" folder.
When I compile the project with "build.bat" for the APK I have to run the "build.bat" 2 or 3 times.
The first time I get this:

=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
Acceso denegado.
Acceso denegado.
Acceso denegado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java
javac: directory not found: obj
Usage: javac <options> <source files>
use -help for a list of possible options
Presione una tecla para continuar . . .
C:\android\projects\hdNetIO>
=================================================================================

the second time, sometimes I get this:

=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
El sistema no puede encontrar el archivo especificado.
Acceso denegado.
Acceso denegado.
El sistema no puede encontrar el archivo especificado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/dx.bat --dex --output=bin/classes.dex obj C:\android\projects\HDroidGUI\libs

UNEXPECTED TOP-LEVEL ERROR:
java.io.FileNotFoundException: bin\classes.dex (El sistema no puede encontrar la ruta especificada)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:110)
at com.android.dx.command.dexer.Main.openOutput(Main.java:940)
at com.android.dx.command.dexer.Main.runMonoDex(Main.java:316)
at com.android.dx.command.dexer.Main.run(Main.java:246)
at com.android.dx.command.dexer.Main.main(Main.java:215)
at com.android.dx.command.Main.main(Main.java:106)
Presione una tecla para continuar . . .
=================================================================================

and in the second or third time, and believe me the APK and I get this:

=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
El sistema no puede encontrar el archivo especificado.
El sistema no puede encontrar el archivo especificado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/dx.bat --dex--output=bin/classes.dex obj C:\android\projects\HDroidGUI\libs
'lib/armeabi/libharbour.so'...
'lib/armeabi/libh4droid.so'...
error de herramienta de claves: java.lang.Exception: No se ha generado el par de claves, el alias <key2> ya existe
java.lang.Exception: No se ha generado el par de claves, el alias <key2> ya existe
at sun.security.tools.KeyTool.doGenKeyPair(KeyTool.java:1529)
at sun.security.tools.KeyTool.doCommands(KeyTool.java:969)
at sun.security.tools.KeyTool.run(KeyTool.java:340)
at sun.security.tools.KeyTool.main(KeyTool.java:333)
jar signed.

Warning:
No -tsa or -tsacert is provided and this jar is not timestamped. Without a times
tamp, users may not be able to validate this jar after the signer certificate's
expiration date (2042-08-27) or after any future revocation date.
Verifying alignment of bin/hdNetIO.apk (4)...
50 META-INF/MANIFEST.MF (OK - compressed)
362 META-INF/KEY2.SF (OK - compressed)
740 META-INF/KEY2.RSA (OK - compressed)
1857 AndroidManifest.xml (OK - compressed)
2590 classes.dex (OK - compressed)
22783 lib/armeabi/libharbour.so (OK - compressed)
1067338 lib/armeabi/libh4droid.so (OK - compressed)
Verification succesful
Presione una tecla para continuar . . .

C:\android\projects\hdNetIO>
=================================================================================

What could be happening?

Ok, after obtaining the APK, charge NETIO on a PC with Windows 7 Ultimate 64 bits as follows:

=================================================================================
Microsoft Windows [Versión 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.

C:\Users\SySGVS>c:\hb32\bin\hbnetio -iface=192.168.1.34 -rootdir=c:\hb32
Harbour NETIO Server 3.2.0dev (r1503052135)
Copyright (c) 2009-2015, Przemyslaw Czerpak, Viktor Szakats
http://harbour-project.org/

2015-04-11 16:56:42.969 Ready to accept connections.
2015-04-11 16:56:42.969 Listening on: 192.168.1.34:2941
2015-04-11 16:56:42.969 Root filesystem: c:\hb32
2015-04-11 16:56:42.969 RPC support: disabled
2015-04-11 16:56:42.969 Encryption: disabled
2015-04-11 16:56:42.969 RPC filter module: not set
=================================================================================

Then I install and run the APK on my cell phone and displayed like this:

Image

But when I try to navigate beyond the record about 50, the APK aborted and get this:

Image

What could be happening?

Deputy project folder "HDNet"

BestRegards
GVS

==================================================================================================

[IN SPANISH]

[NOTA: Adjunto texto original en español ]

Hola Alex:

En primer lugar quiero expresar mi agradecimiento por su esfuerzo en el desarrollo de esta maravillosa herramienta.

He hecho unas pruebas con HDroidGUI y aqui comento mis resultados:

Con el utilitario "newproject.exe" he creado un nuevo proyecto llamado "hdNetIO".

He modificado el código de los ejemplos para hacer un APK que me permita hacer un BROWSE de la tabla "test.dbf" que se encuentra en la carpeta "C:\hb32\tests".

Cuando compilo el proyecto con "build.bat", para obtener el APK tengo que ejecutar el "build.bat" 2 o 3 veces.

En la primera vez me sale esto:
=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
Acceso denegado.
Acceso denegado.
Acceso denegado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java
javac: directory not found: obj
Usage: javac <options> <source files>
use -help for a list of possible options
Presione una tecla para continuar . . .
C:\android\projects\hdNetIO>
=================================================================================

en la segunda vez, a veces me sale esto:

=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
El sistema no puede encontrar el archivo especificado.
Acceso denegado.
Acceso denegado.
El sistema no puede encontrar el archivo especificado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/dx.bat --dex --output=bin/classes.dex obj C:\android\projects\HDroidGUI\libs

UNEXPECTED TOP-LEVEL ERROR:
java.io.FileNotFoundException: bin\classes.dex (El sistema no puede encontrar la ruta especificada)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:110)
at com.android.dx.command.dexer.Main.openOutput(Main.java:940)
at com.android.dx.command.dexer.Main.runMonoDex(Main.java:316)
at com.android.dx.command.dexer.Main.run(Main.java:246)
at com.android.dx.command.dexer.Main.main(Main.java:215)
at com.android.dx.command.Main.main(Main.java:106)
Presione una tecla para continuar . . .
=================================================================================

y en la segunda o tercera vez, ya me crea el APK y me sale esto:

=================================================================================
C:\android\projects\hdNetIO>build.bat
No se pudo encontrar C:\android\projects\hdNetIO\src\org\harbour\hdNetIO\R.java
El sistema no puede encontrar el archivo especificado.
El sistema no puede encontrar el archivo especificado.
Harbour 3.2.0dev (r1503052135)
Copyright (c) 1999-2015, http://harbour-project.org/

C:\android\projects\hdNetIO>c:/Android/android-ndk-r10d\prebuilt\windows\bin\make.exe -f c:/Android/android-ndk-r10d/build/core/build-local.mk 1>a1.out 2>a2.out

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/aapt.exe package -f -m -S res -J src -M AndroidManifest.xml -I c:/Android/sdk/platforms/android-22/android.jar

C:\android\projects\hdNetIO>call C:/PROGRA~2/java/jdk1.7.0_75/bin/javac -d obj -cp c:/Android/sdk/platforms/android-22/android.jar;C:\android\projects\HDroidGUI\libs -sourcepath src src/org\harbour\hdNetIO/*.java

C:\android\projects\hdNetIO>call c:/Android/sdk/build-tools/22.0.1/dx.bat --dex--output=bin/classes.dex obj C:\android\projects\HDroidGUI\libs
'lib/armeabi/libharbour.so'...
'lib/armeabi/libh4droid.so'...
error de herramienta de claves: java.lang.Exception: No se ha generado el par de claves, el alias <key2> ya existe
java.lang.Exception: No se ha generado el par de claves, el alias <key2> ya existe
at sun.security.tools.KeyTool.doGenKeyPair(KeyTool.java:1529)
at sun.security.tools.KeyTool.doCommands(KeyTool.java:969)
at sun.security.tools.KeyTool.run(KeyTool.java:340)
at sun.security.tools.KeyTool.main(KeyTool.java:333)
jar signed.

Warning:
No -tsa or -tsacert is provided and this jar is not timestamped. Without a times
tamp, users may not be able to validate this jar after the signer certificate's
expiration date (2042-08-27) or after any future revocation date.
Verifying alignment of bin/hdNetIO.apk (4)...
50 META-INF/MANIFEST.MF (OK - compressed)
362 META-INF/KEY2.SF (OK - compressed)
740 META-INF/KEY2.RSA (OK - compressed)
1857 AndroidManifest.xml (OK - compressed)
2590 classes.dex (OK - compressed)
22783 lib/armeabi/libharbour.so (OK - compressed)
1067338 lib/armeabi/libh4droid.so (OK - compressed)
Verification succesful
Presione una tecla para continuar . . .

C:\android\projects\hdNetIO>
=================================================================================

¿Qué puede estar pasando?

Ok, luego de obtener el APK, cargo el NetIO en una PC con Windows 7 Ultimate 64 bits de la siguiente manera:

=================================================================================
Microsoft Windows [Versión 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.

C:\Users\SySGVS>c:\hb32\bin\hbnetio -iface=192.168.1.34 -rootdir=c:\hb32
Harbour NETIO Server 3.2.0dev (r1503052135)
Copyright (c) 2009-2015, Przemyslaw Czerpak, Viktor Szakats
http://harbour-project.org/

2015-04-11 16:56:42.969 Ready to accept connections.
2015-04-11 16:56:42.969 Listening on: 192.168.1.34:2941
2015-04-11 16:56:42.969 Root filesystem: c:\hb32
2015-04-11 16:56:42.969 RPC support: disabled
2015-04-11 16:56:42.969 Encryption: disabled
2015-04-11 16:56:42.969 RPC filter module: not set
=================================================================================

Luego instalo ejecuto el APK en mi teléfono celular y se muestra asi:



Pero cuando intento navegar mas alla del registro 50 aproximadamente, el APK aborta y sale esto:



¿Qué puede estar pasando?

Adjunto carpeta del proyecto hdNetIO

BestRegards
GVS
Attachments
IMG_20150411_173134.JPG
IMG_20150411_173134.JPG (25.9 KiB) Viewed 8828 times
Screenshot_2015-04-11-17-16-27.png
Screenshot_2015-04-11-17-16-27.png (33.71 KiB) Viewed 8828 times
hdNetIO.7z
(9.54 KiB) Downloaded 371 times
Post Reply