Re: EXTERNAL: Re: ARS 6.3 import question - RESOLVED
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.comwrote: ** 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
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.comwrote: ** 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARS 6.3 import question
Warren, would it be possible to create three fields for the three bits of information and then combine them into the real field using a filter? Drew SCAB Honduras On Thu, Feb 20, 2014 at 8:45 AM, Warren R. Baltimore II warrenbaltim...@gmail.com wrote: ** 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.comwrote: ** 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: EXTERNAL: Re: ARS 6.3 import question
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.commailto: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.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 19, 2014 5:13 PM To: arslist@ARSLIST.ORGmailto: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] On Behalf Of Warren R. Baltimore II Sent: Wednesday, February 19, 2014 4:08 PM To: arslist@ARSLIST.ORGmailto: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-5367tel: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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
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] 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-5367tel:410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARS 6.3 import question
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] On Behalf Of Warren R. Baltimore II Sent: Wednesday, February 19, 2014 4:08 PM To: arslist@ARSLIST.ORGmailto: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-5367tel:410-533-5367 _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