Comments for Import Data with ExcelToCI at http://www.erpassociates.com , comment 1 to 8 out of 8 comments http://www.erpassociates.com Sat, 04 Feb 2012 21:47:59 +0100 FeedCreator 1.7.3 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1685 I encounter a problem that when I click "Submit Data" button, an error message is prompted. It said "The response text is not valid XML. Login Data cleared." The login user's permission is already attached specified CI and WEBLIB_SOAPTOCI, they are granted full access. So I don't know the cause of this error message, can anyone solve it? (This ExcelToCI is in 2003 Excel version and I use it to upload data to a PeopleSoft 9.1 environment which deploys PT 8.52) - Joe Chan Tue, 06 Dec 2011 21:27:16 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1673 Hi, it was nice experince to see this much benificial info here.. I have also one question " How we can update the EFFDT field by using EXCEL TO CI...." By online application it can possible by using correct history but through Excel to CI it is giving error. Thanks Abdul - Abdul Rabb Tue, 15 Nov 2011 04:39:47 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1637 I want to add multiple programs for one application number on ADM_APPL_ENTRY1 Component. For this purpose I have created a new CI, by inserting new rows in program, plan and sub plan on CI template and repeat these rows for three times according to their template number. After the selection I got three times program, plan and sub plan columns on data input. But when I run this CI it generate some unknown errors, on the other side when I use this same practice on ACAD_HISTORY component for subjects studied in previous education this CI run successfully, So how can I create a CI for ADM_APPL_ENTRY1 component which can add multiple programs for one application? - Syed Faheem Abbas Fri, 15 Jul 2011 04:42:41 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1636 I want to add multiple programs for one application number on ADM_APPL_ENTRY1 Component. For this purpose I have created a new CI, by inserting new rows in program, plan and sub plan on CI template and repeat these rows for three times according to their template number. After the selection I got three times program, plan and sub plan columns on data input. But when I run this CI it generate some unknown errors, on the other side when I use this same practice on ACAD_HISTORY component for subjects studied in previous education this CI run successfully, So how can I create a CI for ADM_APPL_ENTRY1 component which can add multiple programs for one application? Regards, Syed Faheem Abbs - Syed Faheem Abbas Fri, 15 Jul 2011 04:34:33 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1635 I want to add multiple programs for one application number on ADM_APPL_ENTRY1 Component. For this purpose I have created a new CI, by inserting new rows in program, plan and sub plan on CI template and repeat these rows for three times according to their template number. After the selection I got three times program, plan and sub plan columns on data input. But when I run this CI it generate some unknown errors, on the other side when I use this same practice on ACAD_HISTORY component for subjects studied in previous education this CI run successfully, So how can I create a CI for ADM_APPL_ENTRY1 component which can add multiple programs for one application? Regards, Syed Faheem Abbas - Syed Faheem Abbas Fri, 15 Jul 2011 04:31:14 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1576 I created a CI in App designer, tested it there and then used the ExceltoCI2007 to create the data entry spreadsheet. I typed in 5 test rows and staged data for submission. Errors were returned for each line indicating that I'd left required fields blank. I posted the data and entered the required fields, but I continue to get the errors when I re-submit. I've tried to locate the log that I requested with login, but it is not in the C:Temp directory that I saw referenced above. Can you tell what I did wrong and where the log file is for ExceltoCI2007? Thanks, ds - Deb Woj Tue, 15 Feb 2011 11:51:09 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1575 I have read all of the posts a couple of times and found them to be helpful. I am using Excel 2007 with the ExcelToCI2007 component interface spreadsheet. I've been looking for the log that I expected to find in the C:temp directory, but can't find it even though I clicked the Generate Log option on the Login window. Secondly, I'm wondering why I get errors about entering values in required fields when those fields have data in them. Any help would be appreciated. - Woj Tue, 15 Feb 2011 11:32:58 +0100 http://www.erpassociates.com/peoplesoft-corner-weblog/utilities/import-data-with-exceltoci.html#comment-1524 While creating ExceltoCI for acadmeic institution table I had entered value for Description say Indian Institute of Technology corresponding to Institution IIT , on submitting data it is saying value not found Description field is neither promipt table nor lookup - shruti Thu, 18 Nov 2010 02:40:49 +0100