[Isis-users] ABCD - Entrada de dados - Data entry

Edwin Hübner edwin.hubner at gmail.com
Wed Nov 9 17:56:19 CET 2016


Dear Egbert,
The reported problem of not saving user records (access and users
databases) was easily fixed  Guilda. Thaks,  As for the problem of another
institution, whitch din't save new records, I tby ested with your
suggestion, enabling wxisurl in config.php and using the IP address, but it
did not sbyolve the problem. In the mean time I verified that the problem
occurs only when the user creates a new recrd by copying another (icon
"Copy this record at then end of the database"), When editing an existing
record, or creates a record from scratch, it saves normally. So I would
like to know what is the difference between editing an existing record or
creating a new one and saving,  and copying one and saving? Another
question: are ther limits that must be respected?
Note: It only happens with one of several databases. The difference is that
this database is the largest and has more complex fdt and fst. Suspecting
that it might be due to my fst, I did a test with a very small fst, but it
also did not save the record. Then I restored the/central folder backup of
version 1.4  and everything works normally. Any idea what could be wrong
with this database for 1.5.1?
Regards,
Edwin

Edwin Hübner
(5521)99647-1675

2016-11-05 8:59 GMT-02:00 De Smet Egbert <egbert.desmet em uantwerpen.be>:

> Change
> //$wxisUrl="http://localhost:9090/cgi-bin/$cisis_ver"."wxis.exe";
> $wxisUrl="";   //SI NO SE VA A UTILIZAR EL METODO POST PARA VER LOS
> REGISTROS
>
> to
>
> $wxisUrl="http://localhost:9090/cgi-bin/$cisis_ver"."wxis.exe";
> //$wxisUrl="";   //SI NO SE VA A UTILIZAR EL METODO POST PARA VER LOS
> REGISTROS
>
> and check if the problem persists. If you are not using 'localhost' but a
> real IP-no. then change that in the $wxisUrl line. Same for the port if you
> don't use 9090.
>
> Egbert de Smet
> Universiteit Antwerpen
> ------------------------------
> *From:* Edwin Hübner [edwin.hubner em gmail.com]
> *Sent:* Saturday, November 05, 2016 11:39 AM
> *To:* De Smet Egbert
> *Cc:* Ma.Mercedes MacLean; isis-users
>
> *Subject:* Re: [Isis-users] ABCD - Entrada de dados - Data entry
>
> Hi Egbert,
> Below you can see the part of my config.php. What is your suggestion?
> One of the servers where the problem occurs with acces and users database, has
> Internet access. I can ask the library head if it possible to give access
> to you. The other server is on the intranet and external access is more
> complicated.
>
> //Path to the wwwisis executable (include the name of the program)
> $Wxis="/opt/ABCD/www/cgi-bin/$cisis_ver"."wxis.exe";
> //$Wxis="";
>
> //Path to the wxis scripts
> $xWxis="/opt/ABCD/www/htdocs/$app_path/dataentry/wxis/";
>
> //Url for the execution of WXis, when using GGI in place of exec
> //$wxisUrl="http://localhost:9090/cgi-bin/$cisis_ver"."wxis.exe";
> $wxisUrl="";   //SI NO SE VA A UTILIZAR EL METODO POST PARA VER LOS
> REGISTROS
>
> Thanks,
> Edwin
>
>
> Edwin Hübner
> (5521)99647-1675
>
> 2016-11-05 4:19 GMT-02:00 De Smet Egbert <egbert.desmet em uantwerpen.be>:
>
>> Edwin,
>>
>> I noted that for the database ndoc, which gives you problems, the PFT has
>> quite some entries (a lot of 'if .. then.. fi'), so let me ask : are you
>> using the $wxisUrl variable in config.php or do you use the empty one ? If
>> empty, it means you don't use the 'post' method of http which allows for
>> longer URL's (with all parameters) ? Then try to use the other alternative
>> in config.php.
>> Since config.php is part of the Central folder with which you have been
>> experimenting, this could explain something.
>> On the other hand, the default users-database, which also gives you
>> problems, doesn't use such special PFT's as far as I know. So then it
>> remains totally unclear what is happening.
>>
>> Is there as way to give me remote access to one of the machines on which
>> you have this problem to try it myself ? As I am returning from a mission
>> this weekend I could give it a try next week.
>>
>> Egbert de Smet
>> Universiteit Antwerpen
>> ------------------------------
>> *From:* isis-users [isis-users-bounces+egbert.desmet=ua.ac.be em iccisis.org]
>> on behalf of Edwin Hübner [edwin.hubner em gmail.com]
>> *Sent:* Friday, November 04, 2016 4:52 PM
>> *To:* Ma.Mercedes MacLean
>> *Cc:* isis-users
>> *Subject:* Re: [Isis-users] ABCD - Entrada de dados - Data entry
>>
>> Hola María Mercedes,
>> Gracias por su interés en ayudar. Simplemsmente es la siguiente: No
>> guarda. Tanto los usuarios de préstamos, como em Administración de
>> usuarios del sistema. Al hacer clic en el botón "Guardar", no guarda el
>> registro. La pantalla se mantiene sin cambios y no muestra mensaje de
>> error.
>> Ahora el mismo problema ocurre em otro servidor.Uma base de datos de
>> producción no guarda registros nuevos.
>> Creo que tengo todos los scripts de la carpeta /central distribuido por
>> Duilda, pero si usted me puede dar acceso para  descarga a su carpeta /
>> central, puedo probar
>> Saludos,
>> Edwin
>>
>> Edwin Hübner
>> (5521)99647-1675
>>
>> 2016-11-04 13:26 GMT-02:00 Ma.Mercedes MacLean <gaspyy60 em gmail.com>:
>>
>>> Edwin, en este link esta funcionando mi carpeta www
>>>
>>> Y además carga usuarios y crea nuevos administradores.
>>>
>>> Fijate
>>>
>>> Yo subi el ABCD con TeamViewer
>>>
>>> Jamas fue a la Biblioteca.
>>>
>>>
>>>
>>> http://200.68.81.68:9090/cgi-bin/wxis.exe/iah/scripts/?IsisS
>>> cript=iah.xis&lang=es&base=HUASII
>>>
>>>
>>>
>>>
>>>
>>> María Mercedes MacLean
>>>
>>> gaspyy60 em gmail.com
>>>
>>> gaspyy2002 em yahoo.com.ar
>>>
>>> Visite nuestros proyectos
>>>
>>> www.proyectoleonardo.com.ar/proleon
>>>
>>>
>>>
>>>
>>> ------------------------------
>>>
>>> *De:* isis-users [mailto:isis-users-bounces+gaspyy60=
>>> gmail.com em iccisis.org] *En nombre de *Edwin Hübner
>>> *Enviado el:* viernes, 04 de noviembre de 2016 10:01 a.m.
>>> *Para:* Guilda Ascencio
>>> *CC:* isis-users
>>> *Asunto:* Re: [Isis-users] ABCD - Entrada de dados - Data entry
>>>
>>>
>>>
>>> (See in English below)
>>>
>>> Prezada Guilda,
>>> Tens alguma notícia sobre o problema relatado anteriormente, Isto é, que
>>> no ABCD 1.5.1 não está salvando registros nas bases de dados acces e users?
>>> Agora estou com o mesmo problema em um servidor Linux, com uma das
>>> bases de dados de produção: não está salvando registros novos. O estranho é
>>> que no início estava funcionando e de repente parou de gravar registros
>>> novos e somente com uma dentre várias bases de dados deste servidor. O que
>>> fiz: restaurei a versão 1.4 e tudo voltou funcionando normalmente, o que me
>>> leva a concluir que deve haver algum problema muito sutil  na versão 1.5.1.
>>> Para confirmar minha suspeita, substitui novamente a pasta /central pela
>>> da versão 1.5.1 e novamente não permite salvar registros novos.  O que
>>> acopntece: Clicando não botão "Salvar" não acontece nada: a tela não muda e
>>> não apresenta mensagem. Abaixo o log gerado por uma das tentativas.
>>> Pergunto se alguém mais, que está usando i.5.1 observou este problema?
>>>
>>> Att,
>>>
>>> Edwin
>>> _________________________
>>> Dear Guild,
>>> Do you have any news about the issue previously reported, that is, ABCD
>>> 1.5.1 did not save records of acces and users databases?
>>> Now I'm having the same problem on a Linux server, with one of the
>>> production databases: is not saving new records. The strange thing is that
>>> at the beginning it works and suddenly stopped saving new records and on
>>> only one of several databases on this server. What I did: I restored
>>> version 1.4 and everything works  normally, which leads me to conclude that
>>> there must be some very subtle problem in version 1.5.1. To confirm my
>>> suspicion, replaced gagain the  /center folder for the 1.5.1 version  and
>>> again does not allow saving new records. What happens: clicking no the
>>> "Save" button nothing happens: the screen does not change and presents no
>>> message. Below the log generated by one of the attempts. I wonder if anyone
>>> else who is using I.5.1 noted this problem?
>>>
>>> log.
>>> **Friday 4th of November 2016 09:17:57 AM Operador: edwin
>>> /central/dataentry/fmt.php /opt/ABCD/www/htdocs/central/dataentry/wxis/buscar.xis
>>> &cipar=/opt/ABCD/www/bases/ndoc/par/fgvdoc.par&Mfn=1&Opcion=
>>> ver&base=fgvdoc&Formato=/opt/ABCD/www/bases/ndoc/fgvdoc/pfts
>>> /pt/fgvdoc&path_db=/opt/ABCD/www/bases/ndoc/
>>> **Friday 4th of November 2016 09:18:11 AM Operador: edwin
>>> /central/dataentry/fmt.php /opt/ABCD/www/htdocs/central/dataentry/wxis/leer.xis
>>> &base=fgvdoc&cipar=/opt/ABCD/www/bases/ndoc/par/fgvdoc.par&M
>>> fn=1&Opcion=editar&login=edwin&password=jpow&Pft=(if p(v1) then '1
>>> 'v1'____$$$' fi),(if p(v5) then '5 'v5'____$$$' fi),(if p(v8) then '8
>>> 'v8'____$$$' fi),(if p(v90) then '90 'v90'____$$$' fi),(if p(v245) then
>>> '245 'v245'____$$$' fi),(if p(v362) then '362 'v362'____$$$' fi),(if
>>> p(v336) then '336 'v336'____$$$' fi),(if p(v300) then '300 'v300'____$$$'
>>> fi),(if p(v309) then '309 'v309'____$$$' fi),(if p(v508) then '508
>>> 'v508'____$$$' fi),(if p(v545) then '545 'v545'____$$$' fi),(if p(v561)
>>> then '561 'v561'____$$$' fi),(if p(v710) then '710 'v710'____$$$' fi),(if
>>> p(v505) then '505 'v505'____$$$' fi),(if p(v583) then '583 'v583'____$$$'
>>> fi),(if p(v595) then '595 'v595'____$$$' fi),(if p(v351) then '351
>>> 'v351'____$$$' fi),(if p(v506) then '506 'v506'____$$$' fi),(if p(v540)
>>> then '540 'v540'____$$$' fi),(if p(v546) then '546 'v546'____$$$' fi),(if
>>> p(v538) then '538 'v538'____$$$' fi),(if p(v590) then '590 'v590'____$$$'
>>> fi),(if p(v532) then '532 'v532'____$$$' fi),(if p(v534) then '534
>>> 'v534'____$$$' fi),(if p(v530) then '530 'v530'____$$$' fi),(if p(v544)
>>> then '544 'v544'____$$$' fi),(if p(v581) then '581 'v581'____$$$' fi),(if
>>> p(v591) then '591 'v591'____$$$' fi),(if p(v500) then '500 'v500'____$$$'
>>> fi),(if p(v509) then '509 'v509'____$$$' fi),(if p(v593) then '593
>>> 'v593'____$$$' fi),(if p(v594) then '594 'v594'____$$$' fi),(if p(v596)
>>> then '596 'v596'____$$$' fi),(if p(v600) then '600 'v600'____$$$' fi),(if
>>> p(v610) then '610 'v610'____$$$' fi),(if p(v653) then '653 'v653'____$$$'
>>> fi),(if p(v690) then '690 'v690'____$$$' fi),(if p(v691) then '691
>>> 'v691'____$$$' fi),(if p(v695) then '695 'v695'____$$$' fi),(if p(v949)
>>> then '949 'v949'____$$$' fi),(if p(v856) then '856 'v856'____$$$' fi),(if
>>> p(v970) then '970 'v970'____$$$' fi),(if p(v800) then '800 'v800'____$$$'
>>> fi),(if p(v810) then '810 'v810'____$$$' fi),(if p(v820) then '820
>>> 'v820'____$$$' fi),(if p(v599) then '599 'v599'____$$$' fi),(if p(v999)
>>> then '999 'v999'____$$$' fi),&path_db=/opt/ABCD/www/bases/ndoc/
>>>
>>>
>>>
>>> Regards,
>>>
>>> Edwin
>>>
>>>
>>> Edwin Hübner
>>> (5521)99647-1675
>>>
>>>
>>>
>>> 2016-10-21 13:56 GMT-02:00 Edwin Hübner <edwin.hubner em gmail.com>:
>>>
>>> Hola Guilda,
>>> También funciona bien para me y con otro servidor Linux que administro
>>> Tengo muchas bases de datos en el mismo servidor y este problema sólo se
>>> produce con las bases de datos acces y users.
>>> No tiene error de JavaScript. Cuando doi clic en el botón Guardar, se
>>> muestra en la parte inferior de la pantalla "javascript:EnviarForma"
>>> Ver adjunto el "frame source"
>>> gracias
>>>
>>>
>>> Edwin Hübner
>>> (5521)99647-1675
>>>
>>>
>>>
>>> 2016-10-21 13:16 GMT-02:00 Guilda Ascencio <guildaa em gmail.com>:
>>>
>>> Hola Edwin.
>>>
>>>
>>>
>>> Estuve probando lo que mencionas pero a mi me funciona bien. Me extraña
>>> que me digas que te ocurre con las BD acces y users y con más ninguna otra.
>>> Verifica por favor si no se está generando algún error de JavaScript.
>>> También despliega el "frame source" y me lo envías para ver si hay algo
>>> raro.
>>>
>>>
>>>
>>> Respecto a tu pregunta anterior de la lista de selección read-only hay
>>> otros tipos de entrada nuevos que te pueden servir:
>>>
>>>
>>>
>>> Select simple readonly
>>>
>>> Select multiple readonly
>>>
>>>
>>>
>>> Estos tienen la ventaja de permitir al operador eliminar de la lista el
>>> término si lo introdujo por error.
>>>
>>>
>>>
>>> Saludos,
>>>
>>>
>>>
>>> Guilda
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> 2016-10-21 5:43 GMT-05:00 Edwin Hübner <edwin.hubner em gmail.com>:
>>>
>>> Estimado Guild,
>>> Pregunté a la lista de usuarios, pero nadie me Asírespondió. Asi que me
>>> dirijo a usted en busca de ayuda. El problema es el siguiente: después de
>>> actualizar el varsão ABCD 1.5 a 1.5.1, no se guarda el registro al
>>> editar o crear nuevos usuarios registro de usuarios del préstamo y del
>>> sistema (bases de datos acces y users). Al hacer clic en el botom "Guardar"
>>> no se pasa nada. La pantalla no se cierra y no muestra mensaje. Ver archivo
>>> adjunto.
>>> He hecho todo lo posible, es decir:
>>> 1. Executado "Desbloquear base de datos", ya que podría ser bloaqueada
>>> 2. He copiado las basss de datos a mi computadora (también 1.5.1) para
>>> ver si no habría ningún problema con las bases de datos, todo funciona bien.
>>> 3.  He activado otra vez la versión anterior (1.5) y las dos bases de
>>> datos le permiten guardar resgistros, Todo funciona bien.
>>> 3. Reemplaze la  carpeta /central por el de mi equipo, pero el problema
>>> sigue el mismo
>>> El sistema operativo es Windows.
>>> Agradezco si me puede ayudar a desentrañar  este problema.
>>>
>>> Saludos,
>>>
>>> Edwin
>>>
>>> [image: Imagem inline 1]
>>>
>>>
>>> Edwin Hübner
>>> (5521)99647-1675
>>>
>>>
>>>
>>> 2016-10-19 16:10 GMT-02:00 Edwin Hübner <edwin.hubner em gmail.com>:
>>>
>>> Thank you Guilda,
>>>
>>> Yes, it works!
>>>
>>> Saludos,
>>>
>>> Edwin
>>>
>>>
>>> Edwin Hübner
>>> (5521)99647-1675
>>>
>>>
>>>
>>> Em 28 de setembro de 2016 18:26, Edwin Hübner <edwin.hubner em gmail.com>
>>> escreveu:
>>>
>>> (Em inglês abaixo)
>>> Prezados,
>>> Uma Pergunta/solicitação: Tenho necessidade, por questões de
>>> normalização de entradas, que não permita o usuário digitar manualmente a
>>> informação de um campo com picklist de outra base de dados
>>> (autoridades).Hoje só permite Tipo de entrada "Texto/Área de texto.
>>> Pergunto: Seria possível e desejável termos uma alternativa para bloquear a
>>> entrada manual neste caso?
>>> Att,
>>> Edwin
>>> -----------------------
>>> Dear,
>>> A question/request: I need, for standardization reason, that ABCD
>>> shoult  not allow the user to enter  manually  information on a field with
>>> a picklist from another database (authorities) .Today it only allows Entry
>>> type "Text/Text area . I ask: Is it possible and desirable to have an
>>> alternative to block the manual input in this case?
>>> Regards,
>>>
>>> Edwin Hübner
>>> (5521)99647-1675
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> isis-users mailing list
>>> isis-users em iccisis.org
>>> To manage your own subscription options go to:
>>> http://lists.iccisis.org/listinfo/isis-users
>>> Or contact Henk Rutten: hlrutten em xs4all.nl
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20161109/71c62d9a/attachment.html>
-------------- Próxima Parte ----------
Um anexo não-texto foi limpo...
Nome: image001.jpg
Tipo: image/jpeg
Tamanho: 16890 bytes
Descrição: não disponível
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20161109/71c62d9a/attachment.jpg>


More information about the isis-users mailing list