Re: Import without import tool?
As part of the install of AR System Server it is put into the bin directory. You do have the import tool on the server as well. I realized from laurent's post it actually resides inside a .jar file (arapiext7604_build002) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Friday, March 08, 2013 7:55 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? Thanks for your comments Danny. > Remedy Integration Kit. (I think its integration). It's what is used for > the BMC installers. Its like a driver program on steroids. In the > suggested case, it would replace the Remedy Import Tool. A number of people have mentioned this - where is it? Bear in mind I don't have ITSM (we're 100% bespoke) and we're on Windows servers... > You could have a directory copied to the persons desktop with the Remedy > Import Tool. It doesn't have to be installed. This might be the easiest solution. (Although I was looking forward to dusting off the API doc). > Or if you want to stick to workflow, then create an attachment table for > your person to save to. Then use the save attachment workflow and run > process to execute anything that is server side for example the data > import etc. My server doesn't have Remedy Data Import installed - so unless someone can tell me where this magical rik is - then this isn't an option... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
:) Its not downloadable anywhere. I don't even think its documented to be honest. So it can be found within the packages of any installer. So not easy to get I agree. With regards to the import tool on the server, I meant copy it to the server so you could write some workflow/run process to execute it. There is also the driver.exe program on the server which can be scripted. Always a good choice before breaking out the API doc. But it that floats your boat then compile away :) > Thanks for your comments Danny. > > >> Remedy Integration Kit. (I think its integration). It's what is used for >> the BMC installers. Its like a driver program on steroids. In the >> suggested case, it would replace the Remedy Import Tool. > > A number of people have mentioned this - where is it? > Bear in mind I don't have ITSM (we're 100% bespoke) and we're on Windows > servers... > > >> You could have a directory copied to the persons desktop with the Remedy >> Import Tool. It doesn't have to be installed. > > This might be the easiest solution. (Although I was looking forward to > dusting off the API doc). > >> Or if you want to stick to workflow, then create an attachment table for >> your person to save to. Then use the save attachment workflow and run >> process to execute anything that is server side for example the data >> import etc. > > My server doesn't have Remedy Data Import installed - so unless someone > can tell me where this magical rik is - then this isn't an option... > > ___ > 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"
Re: Import without import tool?
Thanks for your comments Danny. > Remedy Integration Kit. (I think its integration). It's what is used for > the BMC installers. Its like a driver program on steroids. In the > suggested case, it would replace the Remedy Import Tool. A number of people have mentioned this - where is it? Bear in mind I don't have ITSM (we're 100% bespoke) and we're on Windows servers... > You could have a directory copied to the persons desktop with the Remedy > Import Tool. It doesn't have to be installed. This might be the easiest solution. (Although I was looking forward to dusting off the API doc). > Or if you want to stick to workflow, then create an attachment table for > your person to save to. Then use the save attachment workflow and run > process to execute anything that is server side for example the data > import etc. My server doesn't have Remedy Data Import installed - so unless someone can tell me where this magical rik is - then this isn't an option... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
Hi Kerry, Remedy Integration Kit. (I think its integration). It's what is used for the BMC installers. Its like a driver program on steroids. In the suggested case, it would replace the Remedy Import Tool. You could have a directory copied to the persons desktop with the Remedy Import Tool. It doesn't have to be installed. Or you could write something although the whole maintenance issue with that type of thing is something you want to think about. dataimport.bat again doesn't have to live on the server. It can be on his/her desktop including the mapping. As long as there is java there, you are good to go. You might want to speak to Misi to see if his product can take a csv as well as an arx http://rrr.se/en/products/rrrchive.html Or if you want to stick to workflow, then create an attachment table for your person to save to. Then use the save attachment workflow and run process to execute anything that is server side for example the data import etc. Good luck Regards Danny Single Sign On (SSO) for the BMC Remedy AR System and ITSM http://www.javasystemsolutions.com/jss/ssoplugin > At the risk of sounding stupid: what/where is RIK? > > Also bear in mind I'm on a 100% bespoke arsystem. There are no OTB > applications installed. > > I think my best course of action will be to write a super small c# api > program... I can't see any other way forward at the moment. > > ___ > 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"
Re: Import without import tool?
At the risk of sounding stupid: what/where is RIK? Also bear in mind I'm on a 100% bespoke arsystem. There are no OTB applications installed. I think my best course of action will be to write a super small c# api program... I can't see any other way forward at the moment. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
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"
Re: Import without import tool?
I have always wondered about using rik but figured there wasn't any documentation on usage since it is a back-end thing. Not sure why it took me until today to just run the command to see the help. On Thu, Mar 7, 2013 at 7:22 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > You should be able to script the rik program (which has to be there as it > is used during the install) to do the dataimport > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock > Sent: Thursday, March 07, 2013 8:29 AM > To: arslist@ARSLIST.ORG > Subject: Re: Import without import tool? > > Arghhh - well it looks like I can't do that because the server doesn't > have the import tool installed!!! > > K > > > Kerry, > I have typically written a process that they attach the csv to an > attachment field and then I save it to the server and run the import there. > > > > > ___ > 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"
Re: Import without import tool?
Kerry, Another option is via SLQ and Bulk Insert (If someone there has DB skills, a job/script can be scheduled.) You will need a SQL Client on the machine that will run SQL. Recommend a DB user other then ARAdmin * Create Table (Holder Remedy table or DB Table and Create a Remedy View Form against it) * Need a 15 CHAR unique column (SQL can set one) * Use Bulk Insert to import the data * Verify the data * Once data is in a DB Table (Remedy Table or Remedy View Form against DB Table) you can run Remedy Code against it and Push/Pull/Manipulate... (Escalations, Filters) Examples BULK INSERT EmployeeDB.dbo.Employees FROM 'C:\Data\EmployeeData_c.dat' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\r\n' ); OR BULK INSERT mdb_cleanse.dbo.[@repository employee list] FROM ‘C:\Users\djones\Documents\Run Queries\Employee_List.csv’ WITH ( FIELDTERMINATOR = ‘,’, ROWTERMINATOR = ‘\n’ ) Google Bulk Insert for many examples. Take Care Dale Jones DCS Raleigh, NC 919-523-6034 From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Raman Arora [arora.raman8...@gmail.com] Sent: Thursday, March 07, 2013 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? ** I remember I used to get that done using Command line interfacethere were certain parameters that I used. arimportcmd was the command...I'm sure if you search that, you'll get whet you want. Raman On Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W mailto:frederick.w.gro...@xo.com>> wrote: You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Kerry Murdock Sent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "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"
Re: Import without import tool?
** Oh, sorry for that I figured it was arslist :pErf... I didn't look at the email address itself, indeed it's something else (vyomlabs)...Sorry again.On 07 Mar, 2013,at 05:38 PM, Raman Arora wrote:**We are getting your mails, Laurent... :)...may be a single mailbox rejected it..I received a similar rejection mail.-RamanOn Thu, Mar 7, 2013 at 10:04 PM, laurent matheo <lm...@me.com> wrote:**It seems AREMail rejected my email, don't know why, perhaps because I gave some java command line?Anyway, in 7.6.04 you can directly attack DataImport through command line :)It works even on Unix/Linux (this is a live example tried on Suse here https://communities.bmc.com/communities/message/287980#287980). I don't put the java command line here, in case it was the reason it was rejected.On 07 Mar, 2013,at 04:47 PM, Raman Arora <arora.raman8...@gmail.com> wrote: **I remember I used to get that done using Command line interfacethere were certain parameters that I used.arimportcmd was the command...I'm sure if you search that, you'll get whet you want. RamanOn Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W <frederick.w.gro...@xo.com> wrote:You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry MurdockSent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there.___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"_ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Import without import tool?
We are getting your mails, Laurent... :)...may be a single mailbox rejected it..I received a similar rejection mail. -Raman On Thu, Mar 7, 2013 at 10:04 PM, laurent matheo wrote: > ** > It seems AREMail rejected my email, don't know why, perhaps because I gave > some java command line? > > Anyway, in 7.6.04 you can directly attack DataImport through command line > :) > It works even on Unix/Linux (this is a live example tried on Suse here > https://communities.bmc.com/communities/message/287980#287980). > > I don't put the java command line here, in case it was the reason it was > rejected. > > > > On 07 Mar, 2013,at 04:47 PM, Raman Arora > wrote: > > ** > I remember I used to get that done using Command line interfacethere > were certain parameters that I used. > arimportcmd was the command...I'm sure if you search that, you'll get whet > you want. > > Raman > > > > On Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W < > frederick.w.gro...@xo.com> wrote: > >> You should be able to script the rik program (which has to be there as it >> is used during the install) to do the dataimport >> >> Fred >> >> -Original Message- >> From: Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock >> Sent: Thursday, March 07, 2013 8:29 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: Import without import tool? >> >> Arghhh - well it looks like I can't do that because the server doesn't >> have the import tool installed!!! >> >> K >> >> >> Kerry, >> I have typically written a process that they attach the csv to an >> attachment field and then I save it to the server and run the import there. >> >> >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "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"
Re: Import without import tool?
** It seems AREMail rejected my email, don't know why, perhaps because I gave some java command line?Anyway, in 7.6.04 you can directly attack DataImport through command line :)It works even on Unix/Linux (this is a live example tried on Suse here https://communities.bmc.com/communities/message/287980#287980).I don't put the java command line here, in case it was the reason it was rejected.On 07 Mar, 2013,at 04:47 PM, Raman Arora wrote:**I remember I used to get that done using Command line interfacethere were certain parameters that I used.arimportcmd was the command...I'm sure if you search that, you'll get whet you want. RamanOn Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W <frederick.w.gro...@xo.com> wrote:You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry MurdockSent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there.___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"_ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Import without import tool?
** In 7.6.04 you can directly attack DataImport through command line :)It works even on Unix/Linux (this is a live example tried on Suse here https://communities.bmc.com/communities/message/287980#287980):java -cp /opt/bmc/ARSystem/api/lib/arapi7604_build002.jar:/opt/bmc/ARSystem/api/lib/log4j-1.2.14.jar:/opt/bmc/ARSystem/api/lib/arapiext7604_build002.jar com.bmc.arsys.apiext.data.DataImport -x lmasuse -u Demo -p Demo -l "/tmp/test/log2.log" -o "/tmp/test/report.xml" -a 3500#!/bin/shjava -cp /opt/bmc/ARSystem/api/lib/arapi7604_build002.jar:/opt/bmc/ARSystem/api/lib/log4j-1.2.14.jar:/opt/bmc/ARSystem/api/lib/arapiext7604_build002.jar com.bmc.arsys.apiext.data.DataImport -x lmasuse -u Demo -p Demo -l "/tmp/test/log2.log" -o "/tmp/test/report.xml" -a 3500 -x= ARS Server-u= username-p= password-a= ARS Tcp port-l= log path-o= import fileOn 07 Mar, 2013,at 04:47 PM, Raman Arora wrote:**I remember I used to get that done using Command line interfacethere were certain parameters that I used.arimportcmd was the command...I'm sure if you search that, you'll get whet you want. RamanOn Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W <frederick.w.gro...@xo.com> wrote:You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry MurdockSent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there.___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"_ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Import without import tool?
I remember I used to get that done using Command line interfacethere were certain parameters that I used. arimportcmd was the command...I'm sure if you search that, you'll get whet you want. Raman On Thu, Mar 7, 2013 at 8:52 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > You should be able to script the rik program (which has to be there as it > is used during the install) to do the dataimport > > Fred > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock > Sent: Thursday, March 07, 2013 8:29 AM > To: arslist@ARSLIST.ORG > Subject: Re: Import without import tool? > > Arghhh - well it looks like I can't do that because the server doesn't > have the import tool installed!!! > > K > > > Kerry, > I have typically written a process that they attach the csv to an > attachment field and then I save it to the server and run the import there. > > > > > ___ > 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"
Re: Import without import tool?
You should be able to script the rik program (which has to be there as it is used during the install) to do the dataimport Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, March 07, 2013 8:29 AM To: arslist@ARSLIST.ORG Subject: Re: Import without import tool? Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
Arghhh - well it looks like I can't do that because the server doesn't have the import tool installed!!! K Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
8.0/8.1. Integration tool with "Spoon". The old AIE... Upgraded as well Sent from my iPhone On Mar 7, 2013, at 5:58, Bira Mata wrote: > ** hi, > You can use AIE job to import the data from .csv file. > > On Thu, Mar 7, 2013 at 9:49 PM, 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" > > _ARSlist: "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"
Re: Import without import tool?
Kerry, I have typically written a process that they attach the csv to an attachment field and then I save it to the server and run the import there. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, March 07, 2013 3:49 AM To: arslist@ARSLIST.ORG Subject: Import without import tool? 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"
Re: Import without import tool?
I should have said - it's a 100% bespoke system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Import without import tool?
hi, You can use AIE job to import the data from .csv file. On Thu, Mar 7, 2013 at 9:49 PM, Kerry Murdock < kerry.murd...@remedycontractor.com> 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"