Validate the field mappings. Look closely at your .CSV file to be sure that all the columns line-up. If there is a carriage-return (line-feed) in any of the text files, the import tool will see that as the start of a new record. When it hits the next one and the fields don't line-up, it just bails with little report. Also, pipe the output to a log file. I may hold more information.
The Import tool is cool through 7.6.04, far as I know. It's usually the data. We run it a lot from a batch file (lights-out, cron-job) and just track the logging, 'cause it always works. Good luck; r From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Gupta, Girish Sent: Friday, May 31, 2013 6:02 PM To: [email protected] Subject: Re: Importing Error ** If possible, check the import mode ( eg append, update, skipduplicate?, ..). I am not sure how we check the import mode from import tool though. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Steve Kallestad Sent: 31 May 2013 05:03 To: [email protected] Subject: Re: Importing Error ** A few versions back I ran into an issue where exports were missing either the first or last record, but that's about it. The import tool has been reliable in my experience - with both csv and arx files. On Fri, May 31, 2013 at 1:32 PM, Joe D'Souza <[email protected]> wrote: ** I never had this problem, but I wonder if the import tool is encountering some sort of a end of file character in between the file and stops processing after that, hence no error. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Abdullah Baytops Sent: Friday, May 31, 2013 11:05 AM To: [email protected] Subject: Importing Error Importance: High Has anyone ever experienced the following problem. I have created an .ARX file in which I am using the Remedy import tool to import data into a custom form. I have also created a .CSV of the information as well in which it tell me it has 19k records in the csv file. When I import using the remedy import it always stops less than the amount of file on the sheet and in the .arx file. It also says all records were imported with no error but I now because the sheet has 19k rows it really hasnt imported all the files. Does anyone have any idea what could be happening or provide any additional assistance. V/R Abdul Baytops _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
