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
ReplyDeleteI have immense knowledge in using Java for any task. I offer C Assignment Help services to students looking for Programming
ReplyDeleteAssignment Help. My services have helped students around the world score high grades. I can help you with object-oriented programming, website development, string manipulation, and machine learning in Java.
Hi 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.
ReplyDeleteI took Matlab homework helpfrom this website for my communications system assignment but the solution I got was not what I could call quality work. Of course, I can only speak from my own experience. Yes, they assigned the task to another Matlab assignment helper and the person did a good job but my question is, why not vet all the experts to find out who is really up to the task and who is not so that people can hire anyone knowing he/she will get the job done? It would save time and make things easier for everybody.
ReplyDeleteMatlab is one of the most demanded units in engineering. However many students avoid it because it is seen as a difficult topic. We are however here to ensure that you get the best Matlab Assignment Help to raise your grade as well as improving your market value. To have your Matlab assignments completed on time visit us today at matlabbassignmentexperts.com
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 .
Many students find it hard to combine school and work. That is why I decided to start offering online tutoring classes at the convenience of the students. Other than Statistics Homework Help tutoring service I also provide solutions to students looking for SAS Assignment Help Expert . I can provide you Statistics Assignment Help ensuring that you perform well. I offer help in:
ReplyDeleteSurvival analysis
Principal component and factor analysis
Panel data analysis
Percentage variance
Hypothesis testing
T-Test hypothesis
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.
ReplyDeleteDuring this coronavirus period, I want to learn a new skill; free lessons can be of importance. I want to learn SPSS. I need someone one experience who can guide me through the process. Maybe you will be happy to extend your SPSS Assignment Help services to me. I have heard a lot about services
ReplyDeleteexperts provide.
Kindly let me know whether you still provide Programming Assignment Help. I am specifically looking for an expert for my Java Homework Help. I have seen the email where I am supposed to send the work and therefore I am sending it right away. Go through it and let me know how much I am required to pay to have the work completed in three weeks. I hope that your quality of work is good because I don’t want any more online disappointments.
ReplyDeleteMove with Optima Travels for your 4 Days Golden Triangle Tour . Make your journey comfortable with us. Our price is always reasonable.
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.
ReplyDeleteHaving trouble with your Matlab assignments? Matlab Assignment Help team 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.
ReplyDeleteWondering where to get an Online Matlab Tutor? At Matlab Assignment Help, we offer timely classes for all Matlab students in need. Other than the tuition classes, we also complete your assignments ensuring that you get the top grade in your class. Our prices are fair because we understand that most students don’t have a source of income. However, the fair price does not mean the quality of work is compromised. Visit our website “ Matlab Homework Help”today and talk to an expert.
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.
ReplyDeleteHi there, I am a statistics student who loves the course but is highly challenged by it. I therefore need a very experienced statistics homework help expert to do my statistics assignment on SAS. If you have a good SAS assignments help expert then I am willing to pay today to have the work started.
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.
ReplyDeleteWhen I take Matlab assignment help online, I expect the solution not only to fetch me good grades but also to help me with my exam revisions. I was not impressed at all by the Matlab assignment helper who tackled my signal processing homework. Even if it secured me a good grade, I am still having trouble understanding anything in the solution so technically I still have to deal with voluminous books to understand this topic. I hope you guys can try and simplify the solutions in the future to make them easier to understand.
ReplyDeleteMy roommate and I hired a Matlab assignment help expert from this site for our numerical methods assignments. The solutions were delivered in a timely version and I would have said more nice things about this Matlab Assignment Experts service but I believe the expert didn’t give the tasks his all. I agree, the price was quite reasonable and the solutions did prevent us from failing so thank you.
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.
ReplyDeleteHello, I am a biostatistics student from the UK and I want to know if you provide statistics homework help services in my country. Here, I cannot find a single tutor who can capably help me improve in this subject. So, when I came across your site, I thought of giving a try as your services are impressive. My sister had also studied from one of your team members and she told me you were brilliant. Thus, I hope you can help me out urgently.
ReplyDeleteI want to be honest with you. I am not the type of person who easily gets annoyed at people. Three months ago I sent you an email seeking programming assignment help. My C assignment was completed on time but after a struggle with the first Java homework help expert I was assigned. I only enjoyed working with you after I demanded for a new tutor. The new person I was given was amazing. Always available when needed and a good communicator. I don’t know whether you allow people to decide who should handle their papers because if it was possible then that is what I would do for the rest of my assignments.
ReplyDeleteMy control systems solution was great but unfortunately, it was delivered a day after the deadline. I took Matlab assignment help from here because I had read some really good reviews about MatlabAssignmentExperts and especially where the customers were happy about their assignments being delivered on time and sometimes even a few days before the deadline. I had a totally different experience and the only reason I was able to beat my deadline was that I had given the Matlab assignment helperwho handled my task the wrong deadline. Still, the platform isn’t so bad because I got a decent grade from the solution they prepared but they should address the late delivery issue asap.
ReplyDeleteThe tutor who provided me with C++ Homework Help was really good. Other than completing the work he also told me that you guys offer tutoring services. This was such good news because I skipped several C++ classes and I believe I will catch up through this platform. However, I would like to know what process I should follow to secure a tutor. I really need your Programming Homework Help and tutoring services to ace my classes.
ReplyDeleteCan STATA be used on the cloud? I was just wondering If I could use the software on the cloud. Cloud computing is one of the trends in today’s computing world. Perhaps a Statistics Assignment Help expert could help me know if I can use STATA for cloud computing. As an experienced online STATA Assignment help expert, you can explain to me if STATA can be used for cloud computing.
ReplyDeleteMove with Optima Travels for Ayodhya Tour Packages. Here are various types of tour packages available for tourists. Our price is always reasonable. We have multiple payment options. Feel relaxed after booking your tour with us.
ReplyDeleteAs a statistics homework help expert, there is several statistical software that you can be proficient in. I need to know precisely Which is your preferred software for statistical analysis? Do you use SAS? Most of my assignments are in SAS. I need someone who can provide me Sas assignment help handle assignments in SAS? Can you do my statistics homework using SAS?
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.
ReplyDeleteDo you offer Math homework help to students? I am weak at math and I want to score good grades by the end of my term. Please let me know your charges and the process of hiring your tutors. I will join accordingly. Thank you for your time.
ReplyDeleteIf you are looking for Essay Writing Help online then you can find the best Assignment Experts who can help you with your Assignment. You can submit assignment for Law Essay Writing Assignment , Business Essay, Evaluative Essay, Gantt Chart Essay, Literature Essay writing, Management Essay , Management Essay
ReplyDeleteHi. I am looking for the best R studio assignment help today. Since I do not have much time left and I need to submit the work at the earliest, I require a potential expert for statistics tutor help. Please give me a good tutor at affordable rates this month so that I can soar new heights in no time. In case you are unable to help, let me know. I am waiting for your response. Thank you for your time.
ReplyDeleteI ordered the Python assignment from this site and had few corrections to be done in the assignment. The corrections were up to the mark. Their assignment services are really immaculate. The paper is written after a thorough research and by complying with the university standards. My lecturer deducts marks for making small mistake in the programming. Best Assignment Support team have drafted the assignment with perfection and without rework. The Programming Assignment Help service of this company is so amazing. I highly recomment to take the Python Assignment Help service of theirs
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
Hey. Do you offer statistics assignment help at your stop? I have been looking for this for a long time now as my exams are knocking at the door. Please let me know if you can offer accounting assignment help to my friends also as they are looking for it now. I also want finance homework help since I love this subject and want to improve in it as much as I can. Please give me details regarding all of them at the earliest. I am waiting for your response.
ReplyDeleteProgramming 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