[Isis-users] Criar novo registro na Base usando MX

[De Smet Egbert]

Please first explain what is this CPF ? A field in your records ? Excuse my ignorance on this.
And I suppose I should read your last sentence 'If the existing CPF does not make inclusion of the registry' as : 'if the CPF does not exist, include the record' ?
I think the logics of the task you describe here now is slightly different from the one you presented first but no problem.
I would first create a database from your input.txt file anyway : with two databases in ISIS-format a lot more is possible, e.g. use a JOIN= parameter, index on a field and if a given term (a number or maybe your CPF ?) is not present in the index perform a process etc.

Egbert de Smet
Universiteit Antwerpen
________________________________
From: Jacqueline Pawlowski Oliveira [jackie at bu.ufmg.br]
Sent: Wednesday, April 12, 2017 10:38 PM
To: De Smet Egbert
Cc: isis-users at iccisis.org
Subject: RE: [Isis-users] Criar novo registro na Base usando MX


Hello Egbert. thanks for your answer.


I'm not using winisis because I'm doing an integration with another system that will read a data file, compare it with the CPF and if this CPF does not exist in my isis database it will include data from an file input.txt. But for this I need to compare whether or not the CPF exists on the isis database. If the existing CPF does not make inclusion of the registry.

How would the  proc command  in this case?

Thanks
____________________________________________
Jacqueline Pawlowski Oliveira
Divisão de Tratamento e Tecnologia da Informação
Biblioteca Universitária/UFMG
Tel:  (031) 3409-4619

[Mostrar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete]<UrlBlockedError.aspx>De Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete
[Ocultar detalhes deDe Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete]<UrlBlockedError.aspx>De Smet Egbert ---12/04/2017 05:23:45---Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete

De: De Smet Egbert <egbert.desmet at uantwerpen.be>
Para: Jacqueline Pawlowski Oliveira <jackie at bu.ufmg.br>, "isis-users at iccisis.org" <isis-users at iccisis.org>
Data: 12/04/2017 05:23
Assunto: RE: [Isis-users] Criar novo registro na Base usando MX
________________________________



Probably best to follow an alternative strategy : with an mx-procedure (proc=) you can first delete the records, in a separate database, which don't have the value '12345' as CPF and then import (append) that resulting set of records in your database.

Egbert de Smet
Universiteit Antwerpen
________________________________

From: isis-users [isis-users-bounces+egbert.desmet=ua.ac.be at iccisis.org] on behalf of Jacqueline Pawlowski Oliveira [jackie at bu.ufmg.br]
Sent: Wednesday, April 12, 2017 12:25 AM
To: isis-users at iccisis.org
Subject: [Isis-users] Criar novo registro na Base usando MX

Boa Tarde,


Preciso inserir dados em uma base de dados ISIS, acrescentando novos registros. (update).  Mas tenho que fazer uma validação antes. Por exemplo:  Se existir o dado de CPF= 12345 então não faça nada, se não, inserir um novo MFN com  dados de campo 100, 245 e 300.   Qual a melhor forma de fazer?  Posso fazer usando o MX?

Obrigada pela ajuda.


_______________
English

I need to insert data into an ISIS database, adding new records. (Update). But I have to do a validation before. For example: If the CPF data = 12345  then do nothing,  else  insert a new MFN with field  v100(data), v245(data) and v300(data) . What is the best way to do it? Can I do it using MX?

Thanks for  help.

Sorry my English :)
____________________________________________
Jacqueline Pawlowski Oliveira
Divisão de Tratamento e Tecnologia da Informação
Biblioteca Universitária/UFMG
Tel:  (031) 3409-4619

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20170412/26fc6b10/attachment.html>