Questions.... Is the CSV file on the server or client?
Is it a static file or is the file modified over time? What database? What version? Possible Answers.... Hopefully the file resides on the server?.. If so AIE would be an easy tool to use to pump the file into a resident table within the ARS created for that.. If the file is on the client you may have some limitations.. You could view the file using the view field, and there are a few things you may be able to do on viewing the file.. Something you may have to play around with.. Running AIE jobs from a client if this file is on every user client is not really a feasible solution.. If you are using MS-SQL as the underlying database, MS-SQL had DTS (data transformation services) that could read csv files to update database tables. That could be another option – Having said that, DTS was taken away from the post 7.x versions of MS-SQL, but I think Microsoft replaced it with some other tool that does similar stuff.. Joe From: Shafqat Ayaz Sent: Friday, June 03, 2011 11:21 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Reading a file into a field ** Hi I remember a while back a thread on how to read a CSV file into a field. Unfortunately i cannot seem to access the ARSList archive. If anyone remembers or knows how to do this and would not mind sharing, I would be extremely grateful. Many thanks in advance Shafqat Ayaz _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
