But the DatasetId should not be cleared on an update to an existing record. It sounds like the import is trying to create new records with a NULL DatasetId
One issue with exporting Remedy data to a csv and then trying to later update records based on field '1' is that Excel will remove leading zeros in the Request ID. Example a record where field '1' is equal to 000000000005150 will be 5150 when opening the csv in Excel. You will need to set formatting on the data in the field '1' column to Custom and add the zero padding as a format. Then save the csv. If you close the csv, open it again in Excel and save you will lose the formatting because csv files cannot save formatting options. I always open a csv in a text editor prior to importing to verify the zero padding is in the data file. Hope this help, Jason On Sun, Jul 18, 2010 at 10:48 PM, Nair, Rajesh IN BOM SISL < [email protected]> wrote: > ** > > HI Amanullah, > > Field Datasetid and Name on the form is a mandate field. > > The sheet should this fields and value. > > > > Regards > > Rajesh > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *IT (Amanullah Bashir Ahmed) > *Sent:* Monday, July 19, 2010 10:59 AM > *To:* [email protected] > *Subject:* Re: Bulk Updates > > > > Hi Chowdhury, > > As per your recommendation I ran AR Report including People ID and save > that report in .csv file then I add column Site+ on .csv file. In > Preferences I select “Update old record”. I also mapped Field ID 1(People ID > ). When I start import, the error is appearing and that error is attached. > Can you please guide me where I am wrong. > > > > Thanks & Regards > > > > Amanullah > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Chowdhury, Tauf > *Sent:* Tuesday, July 06, 2010 5:50 PM > *To:* [email protected] > *Subject:* Re: Bulk Updates > > > > ** > > Amanullah, > > If the site will be different for all of these people, the best thing to do > (from my experience) is to run an AR report including the People ID (field > 1) and report out to a .csv file. This should include the 10,000 users. You > can then add a column for ‘Site+’ on the .csv and update it with information > from your Site form (The values need to exist on the Site form before you > proceed). Then you would just use the import tool to import back that .csv > file. Just make sure in Preferences you select “Update old record…” Make > sure you map Field ID 1 (People ID). > > Of course, try it in a dev environment first. Good luck! > > > > To the U.S. listers, hope you all had a great Independence Day! > > > > *Tauf** **C**howdhury** **|** **F**orest** **L**aboratories**, **I**nc.* > > Analyst, Service Management > > Mobile:646.483.2779 > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *IT (Amanullah Bashir Ahmed) > *Sent:* Tuesday, July 06, 2010 4:47 AM > *To:* [email protected] > *Subject:* Bulk Updates > > > > Hi there, > > Version 7.1 > > How I can update records on Site+ field on General tab of people. How can I > update more than 10,000 records of people? Is there bulk updates option. > Which document would be useful for me to resolve the issue? > > > > > > Thanks & Regards > > > > Amanullah > > > > > > DISCLAIMER:"This e-mail message including any of its attachments is > intended solely for the addressee(s) and may contain privileged information. > If you are not the addressee or you have received this email message in > error, please notify the sender who will remove your details from its > database. You are not authorized to read, copy, disseminate, distribute or > use this e-mail message or any attachment to it in any manner and must > delete the email and destroy any hard copies of it. This e-mail message does > not contain financial instructions or commitments of any kind. Any views > expressed in this message are those of the individual sender and do not > necessarily reflect the views of Emirates NBD PJSC, or any other related > subsidiaries, entities or persons." > ------------------------------ > > This e-mail and its attachments may contain Forest Laboratories, Inc. > proprietary information that is privileged, confidential or subject to > copyright belonging to Forest Laboratories, Inc. This e-mail is intended > solely for the use of the individual or entity to which it is addressed. If > you are not the intended recipient of this e-mail, or the employee or agent > responsible for delivering this e-mail to the intended recipient, you are > hereby notified that any dissemination, distribution, copying or action > taken in relation to the contents of and attachments to this e-mail is > strictly prohibited and may be unlawful. If you have received this e-mail in > error, please notify the sender immediately and permanently delete the > original and any copy of this e-mail and any printout. > > Click > here<https://www.mailcontrol.com/sr/LLOHGX1JgeXTndxI%21oX7UjJJ%21anWfNjRGUAfkEmQfy%21VQ7dz1RML2utM0tqYTA539x59Q%21EPlESbYw94u+b0NQ==>to > report this email as spam. > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend > WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > ------------------------------ > Important notice: This e-mail and any attachment there to contains > corporate proprietary information. If you have received it by mistake, > please notify us immediately by reply e-mail and delete this e-mail and its > attachments from your system. > Thank You. > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
