topic Re: Update XML File in Operating System - HP-UX

Update XML File

Allanm — Tue, 29 Sep 2009 19:44:08 GMT

We have a certain set of tools in production that need to be access controlled through an xml file.

The format of the xml file is attached and I need a way to automate the update to this xml file when a user needs to be added and removed.

There are some 15 tools and the scenarios to consider here while adding a user is that -

1) User that needs a limited set of access to a few tools and not all.
2) Super user with all the access (*)

Thanks,
Allan

Re: Update XML File

James R. Ferguson — Tue, 29 Sep 2009 20:26:04 GMT

Hi Allan:

> I need a way to automate the update to this xml file when a user needs to be added and removed.

And so what do you want updated and/or deleted? Do we presume the '
Regards!

...JRF...

Re: Update XML File

Allanm — Tue, 29 Sep 2009 20:35:18 GMT

Yes that's correct JRF!

Regards,
Allan.

Re: Update XML File

James R. Ferguson — Tue, 29 Sep 2009 20:50:49 GMT

Hi Allan:

I would certainly use Perl. CPAN has a number of XML parsing modules to do the heavy lifting.

Regards!

...JRF...

Re: Update XML File

Allanm — Tue, 29 Sep 2009 21:23:18 GMT

JRF, I don't know Perl , can you make a script using Perl ?

Thanks,
Allan

Re: Update XML File

Allanm — Wed, 30 Sep 2009 00:29:51 GMT

JRF ,

I figured a way to design this and implement in bash ...

Plan to have a few intermediate files before the actual xml is uploaded.

One of the intermediate files would be a xml template file which has the required XML for adding a user. This template file would have sample data which would be replaced by "sed -e" and populated to a txt file and appended to the target xml access file.

Re: Update XML File

James R. Ferguson — Wed, 30 Sep 2009 11:20:25 GMT

Hi Allan:

> I figured a way to design this and implement in bash ...Plan to have a few intermediate files before the actual xml is uploaded. One of the intermediate files would be a xml template file which has the required XML for adding a user. This template file would have sample data which would be replaced by "sed -e" and populated to a txt file and appended to the target xml access file.

That sounds like a viable solution.

Regards!

...JRF...

Re: Update XML File

Allanm — Tue, 06 Oct 2009 22:01:09 GMT

Hi JRF/All,

I was able to make the script and got it working, Can you review it and suggest any improvements in coding.

I am not very happy with the multiple sed's, can you modify in someway so that I can avoid multiple sed's.

Attaching the script for your perusal.

Thanks,
Allan

Re: Update XML File

Allanm — Tue, 06 Oct 2009 23:32:57 GMT

The other thing that bothers me is that I am solving for adding one user only-

Currently this is how it works

1) Gets the user that needs to be added along with the tools that he will have access to from a file(1).(wget and get the file1)

2) I replace the values in a template file(2) ( which is currently has fields for one user only) with the values from file(1) and generate a append file(3).

3)The append-file is appended to the target xml file(4).

This solves for adding a user but not for deleting or any other scenario - lets say a user who is already added needs access to few more tools or he needs to be deleted.

My question is how can I make changes to make current script so that if I get file(1) with multiple users it can handle that and generates a brand new XML file instead of appending it.