Hello All,
In my previous post about Loading Employees in Siebel i described the process through CSV file and IO based approach.
In this post lets achieve the requirement with excel file and business service.
Prerequisite,
Formating the Excel File :
Here we are entering data from 2nd Row.
Now we need to write a business service that reads data row by row and insert data in siebel. Since we are reading data in terms of rows and columns, so 2nd Row 2nd column will fetch value Rahul , and 3rd Row 2nd column will fetch Ankit and this will be our base of iterating through the excel sheet.
Final Code :
In my previous post about Loading Employees in Siebel i described the process through CSV file and IO based approach.
In this post lets achieve the requirement with excel file and business service.
Prerequisite,
- Excel application installed on the machine (server), so this approach works only in Windows Environment.
- Accessible location where we need to place the Excel file
Formating the Excel File :
Here we are entering data from 2nd Row.
Now we need to write a business service that reads data row by row and insert data in siebel. Since we are reading data in terms of rows and columns, so 2nd Row 2nd column will fetch value Rahul , and 3rd Row 2nd column will fetch Ankit and this will be our base of iterating through the excel sheet.
Final Code :
- Reading Excel and Initializing BO and BO
var ExcelApp = COMCreateObject("Excel.Application");
ExcelApp.Workbooks.Open("C:/siebel/LoadEmployee.xlsx");
ExcelApp.Visible = false;
var oBOEmp = TheApplication().GetBusObject("Employee");
var oBCEmp = oBOLdVal.GetBusComp("Employee");
- Getting value from Excel columns
while(ExcelApp.ActiveSheet.Cells(i,1).Value!= null)
{
// Give the fields here
// Employee Details
var LastName = ExcelApp.ActiveSheet.Cells(i,1).Value;
var FirstName = ExcelApp.ActiveSheet.Cells(i,2).Value;
var Email = ExcelApp.ActiveSheet.Cells(i,3).Value;
var PhoneNumber = ExcelApp.ActiveSheet.Cells(i,4).Value;
var LoginName = ExcelApp.ActiveSheet.Cells(i,5).Value;
//Position Details
var Position = ExcelApp.ActiveSheet.Cells(i,6).Value;
//Responsibility Details
var Responsibility = ExcelApp.ActiveSheet.Cells(i,7).Value;
}
- Setting Fields Value and Invoking New Record
NewRecord(NewAfter);
SetFieldValue("Last Name",LastName);
SetFieldValue("First Name",FirstName);
SetFieldValue("Email",Email);
SetFieldValue("Phone Number",PhoneNumber);
SetFieldValue("Login Name",LoginName);
- Closing Excel File
ExcelApp.Quit();
ExcelApp = null;
Refer exact code and sample file here .. You can mail me for any comments or suggestions.
Thanks for info!
ReplyDeleteThanks for this instruction! Excel is not so easy as it may seem indeed. Everytime I have tasks with Excel I use the help of https://www.assignmentexpert.com/programming. They help me organize my projects so that it is easy for me to accomplish it. If I have difficulties understanding my assignments, they give me the problem solving assistance that I need and provide me with thorough explanation. Highly recommend this service!
ReplyDeleteHaving trouble with your Matlab assignments? Matlab Assignment experts got you covered. We work 24/7 to ensure that all your assignments are well-taken care of. We ensure time and quality delivery at all times. To get the best Matlab Homework Help, visit our website now (matlabassignmentexperts.com ) or send us an email through info@matlabassignmentexperts.com
ReplyDeleteHi there, I have some good news for you. Do you need Programming Homework Help? I am an online programming tutor with comprehensive programming experience in addition to a stellar academic record. Expect quality assignment solutions on programming languages such as PHP, Java, Python, C, C++ Programming, and Perl all at affordable prices. Am available on programminghomeworkhelp.com for any queries that you have.
ReplyDeleteMeet an experienced Programming
ReplyDeleteHomework Help expert, with more than 10 years of industry experience and who implemented solutions using Spring, Sling, Servlets and JSPs, and most recently, Adobe Experience Manager (AEM). Also, I am an Adobe Certified Developer in AEM 6 and have been developing components in the CMS for the last 4 years. I believe in my problem solving abilities which makes me one of the experts you would prefer to provide you C Homework Help .
Is Varanasi’s beauty seen only in its sunrises and sunsets? No. That’s why Varanasi Tours are musts. For example, you must experience a serene sunrise boat trip, an evening aarti on the Ganga and a walk through its narrow lanes.
ReplyDeleteI am a statistics professor with specialization in STATA. I offer both tutoring services and assignment completion services to students looking for Statistics Homework Help . If you are looking for a STATA Assignment Help expert then look no further. All my online classes are free while the assignments are completed at a reasonable fee. All your assignments are checked for grammar and plagiarism to ensure that you deliver the best to your lecturer.
ReplyDeleteAre you searching for a 3 Days Golden Triangle Tour ! Enjoy your tour with an affordable price at Optima Travels. We are always here to help you. For more details reach us instantly.
ReplyDeleteHi, professor, I have a question which I have been working on for my datasets. I want to know if there is a test that can be used to check for the equality of the medians. My assignment requires me to know how to test the median. It consists of medical data where we want to test the effectiveness of different methods used to treat cancer. They are chemotherapy radioactivity and surgery. Please as an Online Statistics Tutor would you suggest to me the appropriate test that I can use for this assignment? I have heard that you provide Statistics Assignment Help.
ReplyDeleteHow legit is your tutoring, and what do you, tutor? I understand that SPSS is wide. It can be used to handle nearly every statistical problem. Obviously, I assume that you won't delve in deeper on the complexities of statistics. Before I avail your STATA Assignment Help service, I need to know what you offer at Statistics Homework Help .
ReplyDeleteHi, I have sent my Java assignment to your email as instructed in your Programming Assignment Help portal. I don’t have much time online and therefore I am requesting you to check it now so that you can give me a quotation. All the details of my assignment are provided and I hope you get me a well-experienced C++ Assignment Help tutor to work on it. Kindly note that deadlines mean everything to me and I don’t expect you to take me rounds about the delivery of the work.
ReplyDeleteLooking for online Matlab Homework Help? Find reliable and efficient MatLab assignment solutions from experienced MatLab professionals at Matlab Assignment Experts. Visit our website today and boost your grades in MatLab. You can avail of our Matlab Assignment Help and score high grades.
ReplyDeleteDo you guys give a commission if someone decides to give you clients? I have more than 20 students who are looking for Programming Homework Help. I want to act as a broker between you and them provided we agree that you are going to pay me a certain percentage of the profit. If you prove to be reliable then I will give you a huge number of students because I have access to many of them.Right now I have couple of students looking for C++ Assignment Help.
ReplyDeleteMy advice to this company is one. Please don’t say you deliver timely Matlab assignment help yet some of your writers are too lazy to keep the deadlines. I was very clear that I needed my communications system assignment done within 24 hours and the person I gave the job promised he was going to keep time. Well, guess what, the person delivered the work two days later saying he had an issue with his laptop. I still don’t know what could have happened if I hadn’t been smart enough to lie about my deadline. It saved my life because I was able to hire another Matlab assignment helper for the task and this other person actually delivered the work in just 6 hours.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI heard that Statistics assignment help offer free online classes. how can I access them? Are there any charges that the above description does not offer? I need you as my STATA assignment Help expert by providing a little help on Hypergeometric distribution. It falls under the category of probability distribution. I could benefit greatly from free online classes.
ReplyDeleteIs Varanasi’s beauty seen only in its sunrises and sunsets? No. That’s why Varanasi Tours are musts. For example, you must experience a serene sunrise boat trip, an evening aarti on the Ganga and a walk through its narrow lanes.
ReplyDeleteDon’t want to pass up the chance to experience the famous Golden Triangle tour? The Golden Triangle with Rajasthan Tour takes you sightseeing all over Delhi, Agra and Jaipur and to important parts of Rajasthan State. Here,you see famous palaces, museums, and other world-famous sights—truly, a never-to-miss holiday.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteSuch a wonderful information blog post on this topic allassignmentservices.com provides assignment service at affordable cost in a wide range of subject areas for all grade levels, we are already trusted by thousands of students who struggle to write their academic papers and also by those students who simply want pay for assignment to save their time and make life easy.
ReplyDeleteI read this post,your post so nice and very informative post thanks for sharing this post.If you are searching the best assignment help service then visit Ozpaperhelp.com.
ReplyDeleteWe have the best assignment experts who always ready to help students. For more information kindly check our links:
Programming Language Assignment Help
Cheap Dissertation Help
C Programming Assignment Help
Dissertation Services
MATLAB Programming Assignment Help
Dissertation Writing Help Service
Sociology Dissertation Help
Computer Engineering Assignment Help
Psychology Assignment help
Innovation Management at Apple
ASP Programming Assignment Help
Case Study Of Tesco
Employment Relation Assignment Help
Evaluation Technical Quality
Visitor Behavior Management Assignment Help Uk
New Graduate Application Assignment Help Uk
Case Study Assignment Help UK
Taxation Theory Law Assignment Help UK
Financial Analysis Coca COla Amatil Assignment Help Uk
F# Assignment Help
Programming is the process of creating and assembling several sets of computer programmers in order to reach a high - end computing output in a staged procedure. With so many programming languages to pick from, settling on the best one can be difficult. You won't have to worry about the difficulties of programming assignments with Assignmenthelped.Our Computer Assignment Help programmers can best help you. Visit now:- Computer Programming Assignment Help
ReplyDeleteIf you are looking for a spray that can help you get rid of various issues, then Millennium Stud 5000 Spray for Men 20gm is the best. This spray will start showing its effect in just a few uses. There are various side effects of this spray, so before you start applying it, make sure you are well aware of everything. You can also visit Omsdelhi for more detailed information.
ReplyDelete