Hi Joe the file is on the client and i want to show it on the client so no server side activity involved. I want to show the contents of the file in a View file, but i am not getting the input correct.
ARS 7.6.04 Oracle Client Windows Shafqat Ayaz ________________________________ From: Joe Martin D'Souza <jdso...@shyle.net> To: arslist@ARSLIST.ORG Sent: Monday, June 6, 2011 10:52 AM Subject: Re: Reading a file into a field ** 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: arslist@ARSLIST.ORG 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 _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"