Yup done it a few times too.. works like a charm as long as the import tool finds the files in the path that is suggested in the csv file..
Joe ________________________________ From: pritch <[email protected]> To: [email protected] Sent: Thu, August 5, 2010 11:29:13 AM Subject: Re: Importing files with Data Import Tool Yes - I had to do that also when we transitioned from another system to remedy - moved all the data over. The import file does need the full path (I even had the drive in mine) and file name. Depending on what form you're importing them into, you'll probably need the reference as to what ticket they relate to. The setup of the (in my case .csv file) took a bit of formulas to manipulate the data then copy and paste values into the sheet I actually used for the import. I tested with one or two first to make sure I had everything set right - then did over 15,000 attachments - loaded in about 45 minutes. My suggestion is to make sure you test with one or two attachments get the desired result - then it becomes a walk in the park! On Thu, 5 Aug 2010 17:11:51 +0200, ARS Dummie <[email protected]> wrote: > Hi guys, > > yes... I think Misi meant the path of the attachment file. > It works fine for me now like this. I just took the header of an existing > arx-file, enriched the csv-file from the customer a little and pasted this > content below the header of the arx-file. > Then I created the corresponding folder in the folder where the arx-file is > and copied all the needed attachments into this directory. > Import works great without any problems. > > Thanks!!! > > Dan > > On Thu, Aug 5, 2010 at 5:00 PM, Joe DeSouza <[email protected]> wrote: > >> ** >> "If I remember right, it was important to have a path relative to where >> the actual ARX-file is. Preferably located in sub-directories underneath >> the >> ARX file." >> You mean the path of the attachment file, and not the ARX-file.. >> >> Joe >> >> ------------------------------ >> *From:* Misi Mladoniczky <[email protected]> >> *To:* [email protected] >> *Sent:* Thu, August 5, 2010 5:35:28 AM >> *Subject:* Re: Importing files with Data Import Tool >> >> Hi, >> >> Export some files to an ARX-file and look at the format. >> >> I have done similar thing where I created an ARX-file to import external >> files. >> >> If I remember right, it was important to have a path relative to where >> the >> actual ARX-file is. Preferably located in sub-directories underneath the >> ARX >> file. >> >> Best Regards - Misi, RRR AB, http://www.rrr.se >> >> Products from RRR Scandinavia: >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. >> Find these products, and many free tools and utilities, at http://rrr.se. >> >> > Hi listers, >> > >> > our customer has about 300 files (attachments) that he wants to upload >> > to >> > an >> > attachment field of a form. >> > They gave us a csv-file with the format >> > "document-name;document-date;file-name" and a bunch of files which file >> > names are corresponding to the values in the file-name field of the >> > csv-file. >> > >> > Is there any way to import them using the Remedy Data Import tool (v >> > 7.5)?? >> > >> > The documentation is only about exporting attachments and how to import >> > arx-files including attachment directories. But I can not find anything >> > with >> > csv-files and a self-created directory of attachments. >> > >> > Thanks in advance for some ideas. >> > >> > Cheers, >> > Dan >> >> _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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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"
