I need some automated scripting help

[Lean L]

I have the daunting task of updating some systems in about 4 databases and two web portals for about 200 units. There is a change of two fields total just spanned across those many things. Is there a program that allows for gui assisted programming that can take care of this easily?

Thanks

 

[Juddog]

If you write the GUI in VB, then you should be able to find the IP quickly.
http://www.youtube.com/watch?v=hkDD03yeLnU

 

[dank69]

You could probably do that with an original gameboy. Just remember to comment your code.

 

[Blieb]

I don't understand how either of the 2 responses have anything to do with the question.

1) What is the DB being modified?

Are you saying you have to make modifications in 4 databases only? Or 4 databases, but this "thing" is installed 200 times, meaning you have to do it at each "location"?

It sounds like you need a database alteration script and then execute it.

 

[iroast]

Why not do a db dump, edit SQL and then import?

 

[Lean L]

I don't understand how either of the 2 responses have anything to do with the question.

1) What is the DB being modified?

Are you saying you have to make modifications in 4 databases only? Or 4 databases, but this "thing" is installed 200 times, meaning you have to do it at each "location"?

It sounds like you need a database alteration script and then execute it.

Yeah it's a dumb database though. It's not sql, rather lotus notes and chameleon, which means I pretty much have to change entries via the gui I think.... It's corporate stuff... I would not ever use a db like these.

 

[Farmer]

What platform is this on? If windows, this could easily be done with VBScript or .NET.

 

[Lean L]

What platform is this on? If windows, this could easily be done with VBScript or .NET.

Yeah it is windows. I was thinking VBS but I don't really know the language. Are there prebuilt packages for this?

Alternatively I can take the opportunity to learn .net or vb.

 

[leeland]

if you had to do it via gui I had to use a product which at the moment escapes me but it was a screen capture peice of software that had a VB backend which allowed you to create macros...

so if you for instance had to enter a new customer...name, address, city, state, zip

you would pre-populate a file (csv, text, xls) in the correct order of the fields on the screen.

Then you configure the macro to go through to the appropriate screen (it records what steps you took) and then you enter your actions.

When you are finished you stop the macro, save it and then can replay it x amount of times based on what you have in your data file.


This only works for repetitive tasks like data entry from a single screen or a series of screens always doing the same task.

Might be some interest depending on what you have to do through a gui.