Lisa, If you rename the .csv file to a .txt file and then open it with Excel and format the Request ID as text, all of the zeros will remain. The problem is that Excel sees .csv files as spreadsheet format and assumes that leading zeros are unnecessary and unwanted
Ron Fariss AIG Global Services Service Desk Automation 713-831-2365 (Office) 281-782-0979 (Mobile) ________________________________ From: "Action Request System discussion list(ARSList)" [mailto:[EMAIL PROTECTED] On Behalf Of "Kemes, Lisa" Sent: Wednesday, September 05, 2007 10:19 AM To: [email protected] Subject: Re: Import Issues - 6.3 ** I agree with Shawn. This exact same thing happened to me. I had a customer send me a .csv file with the Request ID field, but the leading zeros were deleted from it (which happens if you open up a .csv file in excel and make a change and save it). So it ended up creating 150 new records. Make sure the leading zeros are in your Request ID field on your csv file. Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Tuesday, September 04, 2007 11:33 AM To: [email protected] Subject: Re: Import Issues - 6.3 ** Shawn when you say you have mapped the Request ID field, what exactly did you do? for the import to update, your import file has to contain the exact Request Id numbers as in the form, or it will not work. If it is complaining about field id 8 which is Short Description, which is a required field, then it is trying to create new records, not update them. The way I usually do it is to export the Request Id field out in a seperate file, then cut and paste it into my import file, under field id 1. thanks shafqat Shawn Stonequist <[EMAIL PROTECTED]> wrote: Greetings List!! I'm running into something strange while doing an import. I have the preferences set to update records, and have mapped the Request ID field. For some reason, the import tool complains that Field ID 8 is missing (which, it shouldn't, it should be updating existing Request ID, which already has Field ID 8 filled in). So I map it (its not like this field is changing so I don't care as much). When I check the User Tool, I now have twice as many records as I started with. Again, the preferences are set to "Update", not "Replace" or "Generate New", so I'm very confused. Shawn Stonequist EMNS, Inc. Remedy 6.3 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Shafqat Ayaz "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.." ________________________________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. <http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhos ting/?p=PASSPORTPLUS> __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
