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"
