Hello Matt, Thank you. I have saved the file with asc extension and indicanting # as separator and it works fine, so in this case I do not have to use coma as separator.
Kind regards. Sergio Tomillero Matt Worsdell-2 wrote: > > Sergio > > It will for an ascii file (.asc) > > Matt > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Sergio Tomillero > Sent: 13 January 2009 10:48 > To: [email protected] > Subject: Re: Creating massive User Preference records with the same > configuration > > Hello Matt, > > No, I can't. Remedy Import only recognizes coma (,) as separator. What I > have finally done is adding a double quote (") at the begining and at the > end of each field that contains coma as value. So, when exporting the > Excel > file to .csv, automatically the affected fields have three double quotes > ("""). Just replacing with notepad the ("") for nothing the affeced fields > remains with double quotes at the begining and at the end. So, when > importing the file using Remedy import, it recognizes that the coma is not > separator in the fields with values that contains double quote at the > begining and end. > > I guess it is not the most dynamic way, but I have not found any other > better. > > Thanks, > Sergio Tomillero > > > > > Matt Worsdell-2 wrote: >> >> You can use a custom delimiter, maybe use a pipe (|)? >> >> >>> Hello Jason, >>> >>> I tried it, but unfortunally there are some records which have colon (,) >>> and >>> semi-colon (;) as part of its values, so the import cannot be done. >>> >>> Thanks >>> >>> >>> >>> Jason Bess wrote: >>>> >>>> Sergio, you should be able to export all the fields of a single entry >>>> with >>>> the correct settings to a CSV. Generate a list of the login names. Add >>>> the >>>> login names and short description to the spreadsheet, copy all the >>>> remaining values down, and import with arimport. >>>> >>>> >>>> >>>> >>>> ________________________________ >>>> From: Sergio Tomillero <[email protected]> >>>> To: [email protected] >>>> Sent: Friday, January 9, 2009 11:17:55 AM >>>> Subject: Creating massive User Preference records with the same >>>> configuration >>>> >>>> Hello people, >>>> >>>> Users will connect into Remedy using the preference server. Most of >>>> them >>>> have customized the ar.ini file, for instance the Placement value. I >>>> have >>>> localized the corresponding fields between the ar.ini and the AR System >>>> User >>>> Preference form. Now that form has no records. About the users, there >>>> are >>>> hundreds with the same configuration and anothers with different. I >>>> would >>>> like to know how to create the records in the AR System User Preference >>>> form >>>> for those users whose customized configuration is the same, but without >>>> having to do Edit - Copy to New and changin the Login Name and Short >>>> Description for each record, because it should be a tedious task due to >>>> the >>>> elevate number of users. Is there any dinamic way to do it? >>>> >>>> Thank you in advance, >>>> Sergio Tomillero >>>> >>>> -- >>>> View this message in context: >>>> > http://www.nabble.com/Creating-massive-User-Preference-records-with-the-same > -configuration-tp21367970p21367970.html >>>> Sent from the ARS (Action Request System) mailing list archive at >>>> Nabble.com. >>>> >>>> > ____________________________________________________________________________ > ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >>>> >>>> > ____________________________________________________________________________ > ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >>>> >>>> >>> >>> -- >>> View this message in context: >>> > http://www.nabble.com/Creating-massive-User-Preference-records-with-the-same > -configuration-tp21367970p21413452.html >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> > ____________________________________________________________________________ > ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >>> >>> >> >> > ____________________________________________________________________________ > ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> >> > > -- > View this message in context: > http://www.nabble.com/Creating-massive-User-Preference-records-with-the-same > -configuration-tp21367970p21433104.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/Creating-massive-User-Preference-records-with-the-same-configuration-tp21367970p21437193.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
