Or use the Java API to read the CSV and import the information. DONT use direct SQL calls into the DB to import AR data.
On Thursday, March 7, 2013 4:49:13 AM UTC-6, Kerry Murdock wrote: > > I don't know if I'm missing something obvious or not but here goes... > > Remedy 7.6.4 > > I've got a customer who wants to import a .csv file on a regular basis. He > doesn't have the remedy import tool on his machine (and it's unlikely he'll > be able to get it installed). What would be an easy way to get the data > from the .csv file into a remedy form from the Remedy User tool? > > Idea 1: > I've thought about copy/pasting it into a text box and writing some code > to read the commas and push it one line at a time. > > Idea 2: > Use the remedy server dataimport command line - but that will be tricksy > as the server is quite locked down. > > Ideas 3: > Erm... > > Kerry > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"