Hi John! That's not it. The leading zeros are still there. I get an error message that the ClassID can't be BMC_PRINTER (or BMC_COMPUTERSYSTEM etc) and it needs to be BMC_ASSETBASE. So I changed it in my .csv file and now I'm able to import my changes. I then just change it back to BMC_PRINTER, etc.
Weird. Thanks again! Lisa On Wed, Oct 17, 2012 at 4:12 PM, Reiser, John J <[email protected]>wrote: > ** > > Lisa,**** > > ** ** > > If the Request-ID field does not have a prefix I’ll bet that then leading > zeros are missing.**** > > When you open a .csv in excel it treats Request-ID values as numbers and > strips the leading zeros.**** > > You can always format the column a special case and set the template as > 000000000000000, that’s 15 zeros.**** > > Save the file and it will and the Request-ID with the correct number of > zeros.**** > > ** ** > > Thank you,**** > > --- > John J. Reiser > Remedy Developer/Administrator **** > > Senior Software Development Analyst > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me **** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Lisa Kemes > *Sent:* Wednesday, October 17, 2012 2:09 PM > *To:* [email protected] > *Subject:* EXTERNAL: Updates via Import into Asset**** > > ** ** > > ** **** > > Hello all!! :) **** > > **** > > We import assets into the AST:XXX forms (for example AST:Monitor). We do > not use AIE. Customer imported records into the AST:Monitor form and put > hyphens in the serial number and would like to take them out (the > hyphens). We exported the data into a .csv file, cleared out the hyphens > and now would like to import the updates. **** > > **** > > Is there an easy way to do this? I tried doing an import using the data > import tool (using the Update Old Record with New Record's Data option > under "Handle Duplicate Request IDs by") and it wants to add this to the > database, not update it.**** > > **** > > Any ideas?**** > > **** > > ARS 7.5**** > > ITSM 7.5**** > > Windows 2003**** > > SQL**** > > **** > > Thanks!**** > > **** > > Lisa**** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
