Hey guys,
Ive currently automated a siebel application. Everything is working ok, except for one issue. The system takes in data and stores that data. The problem occurs because the developers have created a "no duplicates" policy (cant create duplicate data in the system)....therefore my excel sheet that im reading my input data from needs to be updated everytime i run the scripts (to keep the input data unique each time)
To make the data unique each run ive looked at putting a timestamp appended to the end of each input variable, ie read in the value "brian" from the excel sheet, but append "17.45 100908" to the end of it making it "brian 17.45 100908". This solution i have implemented but i was hoping for a better solution.
Does anyone know if it would be possible to call a sequence file or something where i could call the value in the sequence file once everytime i ran the script...without that number resetting when the script stopped. ie first time i run the script, call the sequence file which returns number "1", so i append this number to all data that gets read into my script. the next day i want to run the script again and when i call the sequence file it returns a "2" which i then append to all the data being read into my script. this solution would be alot cleaner and better.
Any help on this matter would greatly be appreciated
Regards,
Brian
Ive currently automated a siebel application. Everything is working ok, except for one issue. The system takes in data and stores that data. The problem occurs because the developers have created a "no duplicates" policy (cant create duplicate data in the system)....therefore my excel sheet that im reading my input data from needs to be updated everytime i run the scripts (to keep the input data unique each time)
To make the data unique each run ive looked at putting a timestamp appended to the end of each input variable, ie read in the value "brian" from the excel sheet, but append "17.45 100908" to the end of it making it "brian 17.45 100908". This solution i have implemented but i was hoping for a better solution.
Does anyone know if it would be possible to call a sequence file or something where i could call the value in the sequence file once everytime i ran the script...without that number resetting when the script stopped. ie first time i run the script, call the sequence file which returns number "1", so i append this number to all data that gets read into my script. the next day i want to run the script again and when i call the sequence file it returns a "2" which i then append to all the data being read into my script. this solution would be alot cleaner and better.
Any help on this matter would greatly be appreciated
Regards,
Brian
