Wednesday, 22 November 2017

Load Employees in Siebel : Reading Data from Excel File

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,

  • 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.

66 comments:

  1. Thanks 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!

    ReplyDelete
  2. Having 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

    ReplyDelete
  3. Skipped your Matlab classes because of other commitments of a busy job schedule? You don’t have to worry. At Matlab assignment experts, we offer tuition classes to ensure that you catch up with your classmates or even understand the area you did not understand in class. We offer classes based on your topics of need and we work based on your schedule. Our Matlab Assignment Experts are available to ensure that your grades are soaring high.

    ReplyDelete
  4. I have immense knowledge in using Java for any task. I offer C Assignment Help services to students looking for Programming
    Assignment 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.

    ReplyDelete
  5. As an experienced SAS assignment solver I offer free online tutoring services. I understand that sometimes students miss classes for various reasons. One may have been sick and ended up missing a very important class or many may be combining class and work therefore work getting more attention. To ensure that you catch up with the rest of the students, I offer online classes at your convenience. My classes offer all STATA units including but not limited to survival analysis, panel data analysis, volatility modeling, and principal component analysis and factor analysis. Comment back to get in touch with me for Statistics Assignment Help.

    ReplyDelete
  6. 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.

    ReplyDelete
  7. I am an Online
    STATA Tutor
    . I offer free tutoring classes in linear regression, variance, multi variance analysis, and random sampling. All my classes are meant to improve you as a statistics student as well as help you tackle your Statistics Assignment. My students are afraid of the STATA unit because their predecessors have meant them to believe that it’s a hard unit to handle. As much as it’s not that simple, I help you enjoy studying it.

    ReplyDelete
  8. I 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.

    ReplyDelete
  9. Matlab 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

    ReplyDelete
  10. I can comfortably say that I relied on Statistics Assignment Help form my SPSS assignment. They were very good and the grades I got were decent. However, one thing I would like to be handled is the customer care team. As much as the work is quality, communication is important. One customer care lady kept on telling me that I wait for my work instead of calling her to know how far the work was. I felt disrespected because I had paid for that service and I deserved to know the progress. Other than that communication hitch I experienced I highly rate this team for the quality of the work. I will work with them again and again.

    ReplyDelete
  11. Meet an experienced Programming
    Homework 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 .

    ReplyDelete
  12. I have a bachelor's of science in computer science and several years field experience, therefore you can expect high quality codes from me. Currently, I provide Java Homework Help in a reputable online assistance company. I will be glad to help in file handling, string manipulations, object-oriented programming concepts, exception handling and Java interfaces. Chat with me on programming homework help or email me at info@programminghomeworkhelp.com

    ReplyDelete
  13. I am a professional java developer with years of experience in providing Programming
    Assignment Help
    and working in a Java
    Homework Help
    platform. I focus on Android mobile app development, cloud development, and Java desktop or JEE projects. I am committed to producing quality java assignment solutions.

    ReplyDelete
  14. I am a professional java developer with years of experience in providing Programming
    Assignment Help
    and working in a Java
    Homework Help
    platform. I focus on Android mobile app development, cloud development, and Java desktop or JEE projects. I am committed to producing quality java assignment solutions.

    ReplyDelete
  15. 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:
    Survival analysis
    Principal component and factor analysis
    Panel data analysis
    Percentage variance
    Hypothesis testing
    T-Test hypothesis

    ReplyDelete
  16. 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.

    ReplyDelete
  17. I 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.

    ReplyDelete
  18. Are 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.

    ReplyDelete
  19. During 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
    experts provide.

    ReplyDelete
  20. 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.

    ReplyDelete
  21. Move with Optima Travels for your 4 Days Golden Triangle Tour . Make your journey comfortable with us. Our price is always reasonable.

    ReplyDelete
  22. Hi, 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.

    ReplyDelete
  23. Having 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.

    ReplyDelete
  24. Wondering 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.

    ReplyDelete
  25. How 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 .

    ReplyDelete
  26. Hi, 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.

    ReplyDelete
  27. Looking 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.

    ReplyDelete
  28. Hi 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.

    ReplyDelete
  29. Do 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.

    ReplyDelete
  30. 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.

    ReplyDelete
  31. 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.

    ReplyDelete
  32. My 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.

    ReplyDelete
  33. When 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.

    ReplyDelete
  34. My 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.

    ReplyDelete
  35. This comment has been removed by the author.

    ReplyDelete
  36. I 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.

    ReplyDelete
  37. Hello, 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.

    ReplyDelete
  38. Hello, 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.

    ReplyDelete
  39. I 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.

    ReplyDelete
  40. My 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.

    ReplyDelete
  41. The 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.

    ReplyDelete
  42. Can 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.

    ReplyDelete
  43. The Matlab homework help expert I hired for my control systems assignment skipped a part of the task. I have sent an email with all the details. I am not complaining that the work is not done well. It was actually done excellently and overall, I enjoyed your Matlab assignment help services only that the part that was missing is very important. I had to communicate with him again informing about the issue. After the communication the expert completed my assignment, still it would had been better on his part if he would have verified it himself before sending it to me.

    ReplyDelete
  44. .Are you looking for bike rent in bhubaneswer? We highly recommend Mocar a premium rental place, where you can get bike rent in bhubaneswar. Contact us today to get more information.

    ReplyDelete
  45. So I am here to talk about something that happened to me last week when I logged into the site to get Matlab homework help. I always love the fact that the Matlab assignment help experts here work round the clock but on this particular day, I placed an order for a signal processing task but no one responded to my request until three hours. This was worrying because I needed the assignment done quickly as it was due the following day. Even though you did meet my deadline, please improve on your communication.

    ReplyDelete
  46. Move 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.

    ReplyDelete
  47. The tutor who provided me with C++ Homework Help skipped the auto sum function of the program I wanted to be developed. I have sent an email with all the details I had sent and what was developed. I am not complaining about your Programming Homework Help service but the work is not done well. It was actually done excellently only that that one function is missing. If I present the working with any missing function it will be termed as incomplete and therefore I may end up missing a lot of marks for it. Kindly have it added as soon as possible so that I forward it to my supervisor.

    ReplyDelete
  48. As 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?

    ReplyDelete
  49. 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.

    ReplyDelete
  50. Move 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.

    ReplyDelete
  51. Hi. Can you provide me with R Studio homework solutions this week? I am looking for an online tutor who can make me improve in this subject and help me score good grades in no time. I will also want notes from you that are error-free and well-researched. If you offer an assignment of business economics, I can do that as well. Let me know if you can be of any help to me. I am waiting for your immediate response.

    ReplyDelete
  52. Don’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.

    ReplyDelete
  53. This comment has been removed by the author.

    ReplyDelete
  54. Do 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.

    ReplyDelete
  55. Hi. 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.

    ReplyDelete
  56. I 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

    ReplyDelete
  57. For my exam, I need Gretl Assignment Help urgently. If anyone is there, please suggest, I will hire them instantly. Also I need JMP Homework Help. Please let me know the price and experience of the expert whether they will help me to score good marks in the exam.

    ReplyDelete
  58. Such 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.

    ReplyDelete
  59. If you are looking for a reliable and affordable car rental company, we highly recommend Mocar, a premium rental place, where you can get the best car rental in Bhubaneswar as well as bike rent at an affordable price.

    ReplyDelete
  60. Hello. I have to write my online exams in a few days and I am struggling to cover the entire syllabus. I want someone who could provide Mathematics Online Exam Help. My budget is also limited and so I am looking for some cheap Exam Help. Do you also offer Statistics Online Exam Help? kindly revert soon.

    ReplyDelete
  61. 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.

    ReplyDelete
  62. 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

    ReplyDelete
  63. If 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

Siebel GoTo View - Handling Realtime cases

 Hello All,  We all must have used GoTo view functionality of siebel to navigate to a particular view from current view. What if the require...