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) [[email protected]] on
behalf of Raman Arora [[email protected]]
Sent: Thursday, March 07, 2013 10:47 AM
To: [email protected]
Subject: Re: Import without import tool?
**
I remember I used to get that done using Command line interface....there 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
<[email protected]<mailto:[email protected]>> 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:[email protected]<mailto:[email protected]>] On Behalf Of Kerry
Murdock
Sent: Thursday, March 07, 2013 8:29 AM
To: [email protected]<mailto:[email protected]>
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"
