person objects update
Dear all, Just a sugestion Could it be possible to include the full name of the person in the detailed explanations of the ripe-dbm robot when creating new person objects in the ripe database ? If I remember well, in the previous version this was done ? This will be very usefull to more easily parse the results of an update and to import them in our own database. Example : The following object(s) were processed SUCCESSFULLY: --- Create SUCCEEDED: [person] CS2321-RIPE ***Info: Authorisation for [person] CS2321-RIPE using mnt-by: authenticated by: SKYNETBE-MNT Could be : Create SUCCEEDED: [person] Chris Sanders NEW nic-hdl : CS2321-RIPE Thanks, --- Pieterjan d'Hertog, Belgacom ANS/ROC Internet Expertise Center
On Tue, 16 Mar 2004, Pieterjan d'Hertog wrote:
Could it be possible to include the full name of the person in the detailed explanations of the ripe-dbm robot when creating new person objects in the ripe database ? If I remember well, in the previous version this was done ? This will be very usefull to more easily parse the results of an update and to import them in our own database.
You can include the full name in the subject line of the request. Now the full name will also be included in the subject line of the SUCCESS or FAILED mail. However, this will produce warnings, but the update should work as long as the name doesn't include anything that would be interpreted as a command. I'm not sure, if there maybe exists a kind of remarks command. Simply RTFM ;-) I just tried it. This was the result:
At 16:24 16/03/2004, Robert S. Plaul wrote:
On Tue, 16 Mar 2004, Pieterjan d'Hertog wrote:
Could it be possible to include the full name of the person in the detailed explanations of the ripe-dbm robot when creating new person objects in the ripe database ? If I remember well, in the previous version this was done ? This will be very usefull to more easily parse the results of an update and to import them in our own database.
You can include the full name in the subject line of the request. Now the full name will also be included in the subject line of the SUCCESS or FAILED mail. However, this will produce warnings, but the update should work as long as the name doesn't include anything that would be interpreted as a command. I'm not sure, if there maybe exists a kind of remarks command. Simply RTFM ;-)
yes for shure but this doesn't help if you have a backlog and have to submit more than 100 person objects in one mail :-) --- Pieterjan d'Hertog, Belgacom ANS/ROC Internet Expertise Center
Hi, On Tue, Mar 16, 2004 at 04:33:57PM +0100, Pieterjan d'Hertog wrote:
yes for shure but this doesn't help if you have a backlog and have to submit more than 100 person objects in one mail :-)
You might want to consider using syncupdates. Create the person objects from a script, and directly get the results back, without having to send mail and parse responses. Way cool feature. Gert Doering -- NetMaster -- Total number of prefixes smaller than registry allocations: 58081 (57882) SpaceNet AG Mail: netmaster@Space.Net Joseph-Dollinger-Bogen 14 Tel : +49-89-32356-0 80807 Muenchen Fax : +49-89-32356-299
Hi, | On Tue, Mar 16, 2004 at 04:33:57PM +0100, Pieterjan d'Hertog wrote: | > yes for shure but this doesn't help if you have a backlog and have to | > submit more than 100 person objects in one mail :-) | | You might want to consider using syncupdates. Create the person objects | from a script, and directly get the results back, without having to | send mail and parse responses. | | Way cool feature. Indeed!, and as of yet, totally unknown for me :) Sorry for being noob, but can you point me to the documentation that provides information on how to use such a direct communication with the ripedb, is it XML based, so that I can telnet into some server and interact directly with the software? Are many people using syncupdates ? I'm not entirely happy with email interaction (to put it mildly ;-) -- Met vriendelijke groet, BIT BV / Pim van Pelt PBVP1-RIPE
Hi, On Wed, Mar 17, 2004 at 10:21:18AM +0100, Pim van Pelt wrote:
| You might want to consider using syncupdates. Create the person objects | from a script, and directly get the results back, without having to | send mail and parse responses. | | Way cool feature.
Indeed!, and as of yet, totally unknown for me :)
*g*
Sorry for being noob, but can you point me to the documentation that provides information on how to use such a direct communication with the ripedb, is it XML based, so that I can telnet into some server and interact directly with the software?
It's not XML based, but uses the same templates and auth mechanisms as the e-mail-interface, and uploads them via HTTP/HTTPS POST to the RIPE DB server. The result is then returned in the same HTTP request. I can't find the specific documentation right now, but sample code is available on http://www.ripe.net/ripencc/mem-services/tools/list.html, near the end of the page ("Prototype for Synchronous Updates..."). The script itself is here: http://www.ripe.net/db/syncupdates/sup_cli.pl
Are many people using syncupdates ?
We're using it extensively, and it's just what we have been asking for ;-) Gert Doering -- NetMaster -- Total number of prefixes smaller than registry allocations: 58081 (57882) SpaceNet AG Mail: netmaster@Space.Net Joseph-Dollinger-Bogen 14 Tel : +49-89-32356-0 80807 Muenchen Fax : +49-89-32356-299
Hi Gert, Thanks for pointing out syncupdates... On 2004-03-17 10:24:37 +0100, Gert Doering wrote: [...]
It's not XML based, but uses the same templates and auth mechanisms as the e-mail-interface, and uploads them via HTTP/HTTPS POST to the RIPE DB server. The result is then returned in the same HTTP request.
I can't find the specific documentation right now, but sample code is available on http://www.ripe.net/ripencc/mem-services/tools/list.html, near the end of the page ("Prototype for Synchronous Updates...").
There's documentation at http://www.ripe.net/ripencc/pub-services/db/syncupdates/index.html http://www.ripe.net/ripencc/pub-services/db/syncupdates/syncupdates-manual.h... Best regards,
The script itself is here: http://www.ripe.net/db/syncupdates/sup_cli.pl
Are many people using syncupdates ?
We're using it extensively, and it's just what we have been asking for ;-)
Gert Doering -- NetMaster -- Total number of prefixes smaller than registry allocations: 58081 (57882)
SpaceNet AG Mail: netmaster@Space.Net Joseph-Dollinger-Bogen 14 Tel : +49-89-32356-0 80807 Muenchen Fax : +49-89-32356-299
-- Engin Gunduz RIPE NCC Software Engineering Department
Dear Pieterjan, On 2004-03-16 15:58:22 +0100, Pieterjan d'Hertog wrote:
Dear all,
Just a sugestion Could it be possible to include the full name of the person in the detailed explanations of the ripe-dbm robot when creating new person objects in the ripe database ? If I remember well, in the previous version this was done ?
I guess it was in v2 database software. That was almost 3 years ago ;) I think it makes sense. We will put this into our wish list.
This will be very usefull to more easily parse the results of an update and to import them in our own database.
Example :
The following object(s) were processed SUCCESSFULLY:
--- Create SUCCEEDED: [person] CS2321-RIPE
***Info: Authorisation for [person] CS2321-RIPE using mnt-by: authenticated by: SKYNETBE-MNT
Could be :
Create SUCCEEDED: [person] Chris Sanders
NEW nic-hdl : CS2321-RIPE
How about this: Create SUCCEEDED: [person] CS2321-RIPE (Chris Sanders) so that everything is in a single line? Regards, -engin -- Engin Gunduz RIPE NCC Software Engineering Department
Thanks, --- Pieterjan d'Hertog,
Dear Engin, <SNIP>
How about this:
Create SUCCEEDED: [person] CS2321-RIPE (Chris Sanders)
so that everything is in a single line? </SNIP>
That would be great ! :-) I've also another problem with accentued caracter (like é,è,à) For example in the person field this gives an error : Véronique Bonne :
Update FAILED: [person] AUTO-43 ***Error: Syntax error in object
person: V.ronique Bonne ***Error: Syntax error in "V.ronique Bonne" address: Booiebos 25 address: 4031 Drongen address: Belgium phone: +32 9 265 95 65 nic-hdl: AUTO-43 mnt-by: SKYNETBE-MNT changed: ripe@skynet.be 20040127 source: RIPE
And in the other fiels accents are replaced by a "." --- OBJECT BELOW CREATED: person: JONG-HYUB CHOI address: Chauss.e de la Hulpe 175 ^^^^^^^^ address: 1170 Bruxelles address: Belgium phone: +32 2 351 55 87 nic-hdl: JC1949-RIPE mnt-by: SKYNETBE-MNT changed: ripe@skynet.be 20031217 source: RIPE This causes us trouble when we try to delete the objects automaticaly afterwards. Is it foreseen to add support for accentueted caracters to the db ? Thanks a lot for your time. Pieterjan.
Hi Pieterjan, On 2004-03-16 17:26:21 +0100, Pieterjan d'Hertog wrote: [...]
I've also another problem with accentued caracter (like é,è,à)
For example in the person field this gives an error :
Véronique Bonne :
Update FAILED: [person] AUTO-43 ***Error: Syntax error in object
person: V.ronique Bonne ***Error: Syntax error in "V.ronique Bonne"
The person/role attribute is a search key. So it must not contain any non-ASCII character (this restriction derives from the fact that the whois protocol does not have any means for specifiying or negotiating the character set, so any non-ASCII character would be problematic as it would not be known which actual letter it stands for). That accented 'e' is converted into a dot because of a bug. Please see below.
address: Booiebos 25 address: 4031 Drongen address: Belgium phone: +32 9 265 95 65 nic-hdl: AUTO-43 mnt-by: SKYNETBE-MNT changed: ripe@skynet.be 20040127 source: RIPE
And in the other fiels accents are replaced by a "."
--- OBJECT BELOW CREATED:
person: JONG-HYUB CHOI address: Chauss.e de la Hulpe 175 ^^^^^^^^
This is a known bug. Any non-ASCII character will be converted into a dot due to this bug. We are working on fixing this one.
address: 1170 Bruxelles address: Belgium phone: +32 2 351 55 87 nic-hdl: JC1949-RIPE mnt-by: SKYNETBE-MNT changed: ripe@skynet.be 20031217 source: RIPE
This causes us trouble when we try to delete the objects automaticaly afterwards. Is it foreseen to add support for accentueted caracters to the db ?
Thanks a lot for your time.
Pieterjan.
Best regards, -- Engin Gunduz RIPE NCC Software Engineering Department
participants (5)
-
Engin Gunduz -
Gert Doering -
Pieterjan d'Hertog -
Pim van Pelt -
Robert S. Plaul