Hi Elry, Finally I saved the file with asc extension, so I do not need to use coma as separator.
Thanks & regards, Sergio Tomillero Elry wrote: > > Hi Guys... > > For what it's worth here is what I did... > > I created a separate table to hold the the records to be imported > (this held User Name etc.). > > I created two template records (one french & one english localized) > and put a filter on the staging table that would get the import. > > On import - I created User Preference records based on the the > templates and the language preference of the record going into > > the staging table. > > This seemed to work rather well... > > Let me know what you think. > > On Jan 13, 5:48 am, Sergio Tomillero <[email protected]> wrote: >> 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-t... >> >>> Sent from the ARS (Action Request System) mailing list archive at >> >>> Nabble.com. >> >> >>> >> _______________________________________________________________________________ >> >>> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >> >>> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> >> >>> >> _______________________________________________________________________________ >> >>> UNSUBSCRIBE or access ARSlist Archives atwww.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-t... >> >> Sent from the ARS (Action Request System) mailing list archive at >> >> Nabble.com. >> >> >> >> _______________________________________________________________________________ >> >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >> >> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" >> >> > >> _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives atwww.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-t... >> Sent from the ARS (Action Request System) mailing list archive at >> Nabble.com. >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives atwww.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-tp21367970p21437227.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"
