GS1 The Global Languaje Busines

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
danielmaximiliano
Posts: 2146
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 162 times
Been thanked: 25 times
Contact:

GS1 The Global Languaje Busines

Post by danielmaximiliano » Mon Aug 13, 2012 10:46 pm

Hello Everyone / Hola a todos :

Translate Google :

Implementing my POS point of sale application, I needed to have on hand a list of countries (GS1 Prefix) and thus identify the origin of the product for sale.
these prefixes are assigned by the international organization GS1.
you can look at: http://www.gs1.org/barcodes/support/prefix_list
the products handled by the POS system are EAN13 (European Article Number) This application generated from a table of countries and their prefixes, another table containing prefixes, image name, order.
The order indicates the location of the 120 images available from a total of 1026 GS1 prefixes available.
these images are displayed depending on the product entered the POS application, you can couple this code with your application as the same (code) is released for use on my part.
Read my comment in GS1.PRG [attachment=1]GS1 Sources.rar[/attachment]

PD: the application takes a while to load the grid, in my post is instant, can not find the error if you have some time and desire can help me fix this?


Español:

Implementando mi aplicación P.O.S point of sale, necesitaba tener a mano una lista de paises (Prefix GS1) y de esa forma identificar el origen del producto en venta.
estos prefijos estan asignados por la entidad internacional GS1.
puede usted mirar en : http://www.gs1.org/barcodes/support/prefix_list
los productos manejados por el sistema P.O.S son EAN13 (European Article Number) esta aplicacion genera a partir de una tabla de paises y su prefijos, otra tabla conteniendo Prefijos, nombre de la imagen , orden.
el orden indica la ubicacion de las 120 imagenes disponibles de un total de 1026 prefijos GS1 disponibles.
estas imagenes son mostradas dependiendo del producto ingresado con la aplicación P.O.S, usted puede acoplar este codigo con su aplicacion ya que la misma (codigo) esta liberado para su uso por mi parte.
Lea mi comentario en GS1.PRG
GS1 Sources.rar
(449.04 KiB) Downloaded 505 times
PD:la aplicacion tarda un poco en cargar el grid, en mi post es instantaneo; no encuentro el posible error si usted tiene un poco de tiempo y ganas puede ayudarme a corregirlo ?
USE.jpg
USE.jpg (108.57 KiB) Viewed 4940 times
In the routine of the POS system of the country image is searched in this way. (This method is being changed to improve the code)

En la rutina del sistema P.O.S la imagen del pais es buscada de esta manera. (este metodo se esta cambiando para mejorar el codigo)

Code: Select all

Function CargarItems()                                 /**********************************************************/
Sele 1
Productos->( DBGOTOP() ) 
    Do While !Eof()
              AADD( aCargarItems ,  { GetCode( Productos->PAIS ) , ;
                                               Productos->CODIGO , ;
                                               Productos->SCS    , ;
                                               Productos->RUBRO  } )
                  Productos->(DBSKIP(1))
    End Do
Return ( aCargarItems )


Function GetCode(nCountry)                          /**********************************************************/
Local nFor            := 0 
Local nPosCountry     := 0
Local cPosCountry     := ''

 For nFor := 1 To 111
    IF  STR( nCountry, 3 ) =  aBanderas[nFor][CODIGO_PAIS]
          nPosCountry    :=   Val ( aBanderas[nFor][ORDEN_PAIS] )
          Return( nPosCountry )      
    Else      
          nPosCountry    := 70
    Endif
 Next    

Return( nPosCountry )
Attachments
Prefix List GS1.jpg
Prefix List GS1.jpg (90.21 KiB) Viewed 4940 times
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

User avatar
esgici
Posts: 4513
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 389 times
Been thanked: 111 times
Contact:

Post by esgici » Tue Aug 14, 2012 12:58 am

Hola Daniel

Your project is quite informative;

thanks to sharing :D

At beginning occurs a delay ( about 15 seconds ),

surely you had noticed it.

Saludos :)
Viva INTERNATIONAL HMG :D

User avatar
danielmaximiliano
Posts: 2146
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 162 times
Been thanked: 25 times
Contact:

Post by danielmaximiliano » Tue Aug 14, 2012 1:26 am

esgici wrote:Hola Daniel

At beginning occurs a delay ( about 15 seconds ),

surely you had noticed it.

Saludos :)
Hello Esgici:
My POS application is instantaneous generation GRID, here in this example GS1Prefix takes about 2 minutes to show the GRID in both images 16x16 px 32x32 px like, can you send me your. EXE to test the application compiled here for you? ??
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

User avatar
esgici
Posts: 4513
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 389 times
Been thanked: 111 times
Contact:

Post by esgici » Tue Aug 14, 2012 1:34 am

Hola Daniel
danielmaximiliano wrote:... can you send me your. EXE to test the application compiled here for you? ??
Of course.

( Please rename gs1.eze to gs1.exe)

Saludos
gs1Exe.rar
Only executable file of GS1 project.
(784.41 KiB) Downloaded 421 times
Viva INTERNATIONAL HMG :D

User avatar
danielmaximiliano
Posts: 2146
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 162 times
Been thanked: 25 times
Contact:

Post by danielmaximiliano » Tue Aug 14, 2012 1:47 am

esgici wrote:Hola Daniel
danielmaximiliano wrote:... can you send me your. EXE to test the application compiled here for you? ??
Of course.

( Please rename gs1.eze to gs1.exe)

Saludos
gs1Exe.rar
Hi Esgici :
Igual, la aplicacion compilada por usted tarda unos 2 minutos en aparecer en pantalla.

algo debe parar en mi Windows 7 Home Premiun 64. 4gb.
alguien mas puede testear???

Still, the application compiled for you takes about 2 minutes to appear on the screen.

something must stop on my Windows 7 Home Premium 64. 4GB.
someone else can test?? :cry:
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

User avatar
esgici
Posts: 4513
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 389 times
Been thanked: 111 times
Contact:

Post by esgici » Tue Aug 14, 2012 1:58 am

Hola Daniel
danielmaximiliano wrote:Still, the application compiled for you takes about 2 minutes to appear on the screen.
If I understand right, some "initial" process ( such as building some files, converting SDF to DBF and vice versa etc) take some time. I guess that this file process doesn't necessary after first run, fe if that files are already exist.

Does reason of delay may be that process ?

TIA

Saludos
Viva INTERNATIONAL HMG :D

User avatar
Rathinagiri
Posts: 5263
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 169 times
Been thanked: 172 times
Contact:

Post by Rathinagiri » Tue Aug 14, 2012 2:54 am

Very informative and useful. Thanks for sharing. I will go thru the code for the delay.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
esgici
Posts: 4513
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 389 times
Been thanked: 111 times
Contact:

Post by esgici » Wed Aug 15, 2012 1:21 pm

Hola Daniel
danielmaximiliano wrote: Still, the application compiled for you takes about 2 minutes to appear on the screen.
I did some tests for determine reason of delay.

I hope that it help you.

Saludos
GS1_Test.zip
Slightly modified code of GS1
(5.63 KiB) Downloaded 325 times
GS1_Test.PNG
Result of delay test on GS1
GS1_Test.PNG (157.18 KiB) Viewed 4824 times
Viva INTERNATIONAL HMG :D

User avatar
danielmaximiliano
Posts: 2146
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 162 times
Been thanked: 25 times
Contact:

Post by danielmaximiliano » Wed Aug 15, 2012 2:54 pm

:cry:
I did some tests for determine reason of delay.
Prefix List GS1_2012-08-15_11-39-33.jpg
Prefix List GS1_2012-08-15_11-39-33.jpg (92.65 KiB) Viewed 4817 times
wrong line 142 in GS1.PRG

Code: Select all

     GS1(301, 799 , 'France'       ,  34)
Replace with

Code: Select all

     GS1(301, 379 , 'France'       ,  34)
DBF .jpg
DBF .jpg (54.57 KiB) Viewed 4817 times
Before 1017 record

Equal :cry:
HMGforum.jpg
HMGforum.jpg (12.4 KiB) Viewed 4817 times
I will continue to review the source code, and check the machine with HijackThis and malware and found several spyboot malware on my machine.

voy a seguir revisando el codigo fuente, ya revise la maquina con Hijackthis, antimalware and spyboot malware y encontre varios en mi maquina.

gracias esgici por revisar el codigo y el ejemplo suminstrado

Esgici thanks for reviewing the code and the example most supply :D
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

User avatar
danielmaximiliano
Posts: 2146
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 162 times
Been thanked: 25 times
Contact:

Post by danielmaximiliano » Wed Aug 15, 2012 6:42 pm

Hi / Hola :

Modificando un poco el codigo gane velocidad.

Translate google : Modifying a bit the code up to speed
HMGforum.jpg
HMGforum.jpg (12.4 KiB) Viewed 4805 times
Ahora / Now
Prefix List GS1_2012-08-15_15-28-23.jpg
Prefix List GS1_2012-08-15_15-28-23.jpg (100.29 KiB) Viewed 4805 times
GS1 Source.rar
(452.08 KiB) Downloaded 372 times
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

Post Reply