My co-worker and I end up editing a text file every time we image a Sales PC. It is not easy and we frequently make mistakes. There are only 5 variables but 4 are used multiple times and it would be nice if we could come up with a way of using batch file (or something similar) that we could just type the 5 variables and let it insert them in the correct places. I have PLAYED around some and am not having any luck. Any help would be greatly appreciated.post an example of the text file showing the variables and where they go, editing anything confidential if you need to.
Quote from: contrex on OCTOBER 31, 2007, 12:22:27 PM

post an example of the text file showing the variables and where they go, editing anything confidential if you need to.

use CRMBase
delete from au_st_sys_user
delete from au_system_user
delete from au_employee where emp_code = '%1'
insert into au_employee ( emp_code, first_name, last_name, create_emp, last_mdfy_emp, row_id, rec_mdfy_ind, rec_del_ind ) values ( '%1', '%2', '%3', 'aurum', 'aurum', 2, 'N', 'N' )
insert into au_user_class ( class_code, rec_del_ind ) values ( 'AurumSales', 'N' )
insert into au_system_user ( emp_code, login, pwd, create_emp, last_mdfy_emp, row_id, rec_mdfy_ind, rec_del_ind, class_code ) values ( '%1', '%1', '8_49_76_69_71_72_72_7F_30_2C_A_17_1A_6_ 5_14', 'aurum', 'aurum', 2, 'N', 'N', 'AurumSales' )
update au_system_user set exp_date = CURRENT_TIMESTAMP
update au_system_user set exp_date = exp_date + 60
insert into au_st_sys_user ( st_id, emp_code, st_emp_code, auth_key, authority_flag, enable_esd_ind, create_emp, last_mdfy_emp, row_id, rec_mdfy_ind, rec_del_ind ) values ( %4, '%1', '%1-R', '%5', 'TT', 'Y', 'aurum', 'aurum', 2, 'N', 'N' )
delete from au_system_id
insert into au_system_id ( emp_code, system_id, auth_key, class_code ) values ( '%1', '%4', '%5', 'AurumSales')
go