Comments for Import Data with ExcelToCI at http://www.erpassociates.com , comment 1 to 4 out of 4 comments http://www.erpassociates.com Fri, 30 Jul 2010 05:51:42 +0100 FeedCreator 1.7.3 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1572 I am currently trying to insert rows in Job data using excel to CI utility. When I try with 7,8 rows I succeed but for more than that I get The response text is not valid XML. Login Data cleared”, “Error occurred in routine sendSOAPRequest_SubmitToDB… The XML string contains invalid characters. Please suggest - Vinod Tue, 18 May 2010 15:50:58 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1550 I'm having the same promblem "Jeanie" was experiencing 1 1/2 yr ago - Has anyone seen a scenario where you get an "OK" status indicating all went well and the data was loaded, but no data was actually written to the database? I'm loading items via the IN_MST_ITM_XLS CI. Built template and input a line of data to load, staged data for submission, and clicked on "Submit Data" on the "Staging and Submission" page. I get a status back that all is "OK", but there's no data when in check in psoft. Can anyone provide a solution? Many thanks! - Angie Thu, 15 Apr 2010 10:25:14 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1549 Hi Brent, Thanks for such a nice documentation for the step to step procedures to be followed for using ExceltoCI. I am creating some of these for fresh NA Payroll implementation for my client. There are hundreds of rows of data for many basic configuration components like earning codes, deduction codes, Tax, special accumulators, additional pay, shift codes etc. Configuring them by entering data in the PeopleSoft page had been a nightmare for our functional resources. Creating exceltoci for these is comparatively easy and also highly reusable. Thanks for the idea to use this Rocky....... - Rocky Thu, 15 Apr 2010 09:55:43 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1535 seeing an issue where the status is OK or Warning and yet the database insert did not happen. i redo the load and it will work on subsequent tries. in addition to this issue, i'm seeing it only load 2 at a time. anyone know why this is happening?? - jenn Thu, 25 Mar 2010 00:07:37 +0100