Excel has never created .csv file correctly as it does not enclose text fields with the double quote (as you have found out). Unless you are careful, it will also strip the leading zeros off of the Entry_ID.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sergio Tomillero Sent: Tuesday, January 13, 2009 4:48 AM 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 >>> 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 >>> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
