Data Management Tool 7.6.04
Have successfully used the data management tool to load data from the spreadsheets. Data contained within the spreadsheets for some notes fields had text seperated over several lines. When you use the tool, the text then appears on one line. Is there a way to re format the text imported back to it's original look within the spredsheet? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Data Management Tool 7.6.04
Simon, I don't believe there is. The reason it was lost is the DMT converts the spreadsheets from XLS to CSV, this CSV can't have multi-line encoding, so it has to strip the enters out before it's even loaded into Remedy, which means that Remedy knows nothing about it having ever existed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, January 28, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: Data Management Tool 7.6.04 Have successfully used the data management tool to load data from the spreadsheets. Data contained within the spreadsheets for some notes fields had text seperated over several lines. When you use the tool, the text then appears on one line. Is there a way to re format the text imported back to it's original look within the spredsheet? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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: Data Management Tool 7.6.04
Bugger... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Tuesday, 29 January 2013 10:30 a.m. To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool 7.6.04 Simon, I don't believe there is. The reason it was lost is the DMT converts the spreadsheets from XLS to CSV, this CSV can't have multi-line encoding, so it has to strip the enters out before it's even loaded into Remedy, which means that Remedy knows nothing about it having ever existed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Simon Ellis Sent: Monday, January 28, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: Data Management Tool 7.6.04 Have successfully used the data management tool to load data from the spreadsheets. Data contained within the spreadsheets for some notes fields had text seperated over several lines. When you use the tool, the text then appears on one line. Is there a way to re format the text imported back to it's original look within the spredsheet? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
