Hi Sanjana, You've already determined that the import cannot read data with embedded newlines.
What actually happens is that the record with the data newline character is truncated at that character and processes (is imported) fine, not withstanding that the record itself is truncated at that newline (ie, the field containing the new line is incorrect and all subsequent fields of the file are NULL for that record. The import tool then processes the "next" record - which is really the continuation of the previous data record, ie the rest of the single field's data that had the embedded newline and all subsequent row data. There are several ways around this problem. Use Meta-Update www.softwaretoolhouse.com, which handles such data with embedded newlines no problem. Replace the newlines with \n. The BMC Import tool will accept certain specific "escape sequences". I'm not familiar off-hand with the set. If you have but a few such records, you may be able to spot them in Notepad (on Windows) and then manually change the line ends to \n. You'd have no problems on Unix to also manually change the newlines in question with (shudder) vi. Automating the recognition of such newlines that are actually embedded is not that hard too. After all, Meta-Update does it. I expect a simplish regular expression should isolate (Axton?) these embedded newlines allowing an automated replacement with awk, gawk, sed, etc. For those of you on Windows, you can install the cygwin (www.cygwin.com) GNU environment to whatever levels you like. Cheers Ben Chernys -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanjana AGARWAL Sent: April 22, 2008 1:48 PM To: [email protected] Subject: Arimport to for importing data in Remedy 6.3 Hello, Whenever I tried to import some data in "Description" or "Worklog" field having "Enter" (linefeed or a new line character) in it. For example: "To include the purge of ATTRIBUTE_HISTORY table 4.3Patch 4.3 already delivered to Agrate in WW09 2008 for Testings." I got the following error message: Record 1 : Required field cannot be reset to a NULL value -- Summary (ARERR 326) ------------ Required field cannot be reset to a NULL value -- Requester Name+ (ARERR 326) ------------ Required field cannot be reset to a NULL value -- Requester Login Name+ (ARERR 326) ------------ Required field cannot be reset to a NULL value -- Description (ARERR 326) ------------ Required field cannot be reset to a NULL value -- Create-date (ARERR 326) And if I remove the new line character For example: "To include the purge of ATTRIBUTE_HISTORY table 4.3Patch 4.3 already delivered to Agrate in WW09 2008 for Testings." It imports fine. Could anyone help me out in importing data with new line characters. Regards Sanjana ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
