Re: Reading a file into a field
Assuming the username of the workstation is the same as the Remedy username, you might be able to use something like this for your qualification C:\Documents and Settings\$USER$\My Documents\file.csv First use a set field and the display Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, June 06, 2011 9:20 PM To: arslist@ARSLIST.ORG Subject: Re: Reading a file into a field ** You have to set the view field to the file name with the full file path.. some systems do not like long file names so in case of long file or directory names you may have to convert those into the 8.3 DOS format if you know what I mean.. Joe From: Shafqat Ayazmailto:shafq...@yahoo.com Sent: Monday, June 06, 2011 8:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Reading a file into a field ** 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 Ayazmailto:shafq...@yahoo.com Sent: Friday, June 03, 2011 11:21 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto: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.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited.
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Reading a file into a field
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
Re: Reading a file into a field
You have to set the view field to the file name with the full file path.. some systems do not like long file names so in case of long file or directory names you may have to convert those into the 8.3 DOS format if you know what I mean.. Joe From: Shafqat Ayaz Sent: Monday, June 06, 2011 8:39 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Reading a file into a field ** 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_ _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
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
