The answer was to create a .arx file, and that turned out to be pretty easy. I just used Notepad++ to create the headers, and then used replace to get rid of the commas and replace with " ". The only thing I had to do extra was add "DATA" to the start of each line of data and in the field with the return, swap out return for "\n". Worked like a charm and did not take more then 20 minutes.
Thanks for the help! Warren On Thu, Feb 20, 2014 at 12:23 PM, Reiser, John J <john.j.rei...@lmco.com>wrote: > ** > > Warren, > > I tried it with the Data Import tool 8.1 and even though the CRs were not > visible in the .csv file when viewed with notepad it imported multiple > lines to the field in question. > > So if an upgrade is in your future it looks like it will work then. > > > > Thank you, > > --- > John J. Reiser > Remedy Developer/Administrator > > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II > *Sent:* Thursday, February 20, 2014 9:45 AM > *To:* arslist@ARSLIST.ORG > *Subject:* EXTERNAL: Re: ARS 6.3 import question > > > > ** > > Thanks folks! John, the quotes were added by excel. I tried taking them > out to see if that affected it, but no go.... > > > > Fred, I'll pull a .arx and see if I can't replicate it. > > > > Warren > > On Wed, Feb 19, 2014 at 5:18 PM, Reiser, John J <john.j.rei...@lmco.com> > wrote: > > ** > > Warren, > > Are the double quotes that you displayed actually in the cell? I would > think they encapsulate the CR. > > > > Fred's idea is probably the best and not too hard to implement. > > > > Thank you, > > --- > John J. Reiser > Remedy Developer/Administrator > > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > *Sent:* Wednesday, February 19, 2014 5:13 PM > *To:* arslist@ARSLIST.ORG > *Subject:* EXTERNAL: Re: ARS 6.3 import question > > > > ** > > I would convert it to an ARX format > > > > The difference between CSV and ARX is not that great. In ARX the line > break is \n in the text. The separator is a space instead of a comma. > (and there is a couple of extra header lines) > > > > Fred > > > > > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Warren > R. Baltimore II > *Sent:* Wednesday, February 19, 2014 4:08 PM > *To:* arslist@ARSLIST.ORG > *Subject:* ARS 6.3 import question > > > > ** > > I have been batting this around for a bit. I feel like I've done this > before, but I can't seem to figure it out. > > > > I've got a .csv file that needs to be imported into remedy. I'm using the > arimport tool. > > > > It's a straightforward file with one exception. One row has a line break > in each entry. It is VERY important that this be maintained in the exact > same format it is being entered. > > > > For example, an entry may say: > > > > "Functional Role iPhone > replace blackberry" > > > > It must be placed into the field so that a check can be run against it in > an attempt to find a previous entry. The problem that I am having is that > the import tool is treating the line break as the end of the entry. It > then jumps to the next line (replace blackberry) and attempts to treat it > as a separate entry. > > > > Any ideas on how I can handle this. I suspect that the .xml format is my > answer, if so, any idea how I can (easily) convert the file? > > > > Thanks in advance! > > -- > Warren R. Baltimore II > Remedy Developer > 410-533-5367 > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > -- > Warren R. Baltimore II > Remedy Developer > 410-533-5367 _ARSlist: "Where the Answers Are" and have been for 20 > years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
