As far as I'm aware, if you'd like to use the Import tool (or arimportcmd for that matter) and would want to import character fields with line breaks inside, that's just not possible with CSV files. You can do it with ARX files; here some escape sequences are available. However the ARX file format is not documented (or at least the documentation is not provided by BMC). You can just export one record to ARX format and see what it looks like. One other possibility is that you would create a filter that runs on Merge and that replaces your own defined character sequence (such as <CR> or \n or ....) and replaces it with a real carriage return character. You should create such a filter action for every field that you would like to import character data with line breaks into - probably two or three per Remedy form. In this case you CAN use the CSV file format to import data - as long as you use your own character sequence to indicate line breaks.
Hope this helps, Michiel On Tue, Apr 22, 2008 at 3:11 PM, Ben Chernys < [EMAIL PROTECTED]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
