**
Hi list,
We have a process to import data into Remedy from a file in windows. By clicking a button will invoke an Active Link and fire Run Process that will call a window bat file and execute arimport.exe to import data (with mapping) into remedy from a file.
The process works fine until we change the server option of "Users Prompted for Login" to "Always".
The problem is that our process encountered "The memory can not be read" PC error with "Prompt for Login" option checked.

This is an known issue in 4.5, and I was wondering if anybody made this work in 5.1.
Any inputs will be appreciated.


Example of the Run Process:
c:\progra~1\remedy\scan\import.bat "$Login Name$" "$Password$" "$SERVER$" > nul

Example of the import.bat file:
c:\progra~1\remedy\arimport.exe -m %3 -d c:\progra~1\remedy\scan -u %1 -p %2 -l c:\progra~1\remedy\scan\arimport.log"

Note: server name will be the mapping name.



Remedy: 5.01.02 patch 1313
SunOS 5.9
Oracle 9.2.0.4.0
Thanks.

George Tsai
Walgreens - IT Systems Architecture
Process Automation Initiatives
847-914-5210 This posting was submitted via the Web interface

George,

Instead of running the arimport through a batch file, have you tried using
arimportcmd (.exe in your ar system directory)? It is specifically
designed for command line imports. Your run process would look something
like this:

c:\progra~1\remedy\arimportcmd -u RemedyUserLogin -p RemedyUserPassword -m
MappingFileName -d
c:/progra~1/remedy/MappingFileDirectory -o c:\progra~1
\remedy\ImportFileName.csv

The mapping file (.arm) would look something like this:

MappingFileName
SchemaName: NameOfYourForm
ServerName: YourServer
Import-Filename: c:\progra~1\remedy\ImportFileName.csv
Import-File-Format: 2
Import-Field-Titles: 1
Import-Field-Separator:
Bad-Record-Handling: 1
Duplicate-Id-Handling: 0
Strip-White-Space: 1
Truncate-Values: 1
Disable-Required-ness: 1
Disable-Pattern: 1
Allow-Too-Many-Fields: 1
Allow-Too-Few-Fields: 1
Mapping: 536870901=$YourField1$
Mapping: 536870902=$YourField2$
Mapping: 536870935=$AndSoOn$
end

You can also run the arimportcmd without a mapping file in which case you
will also have to indicate the server (-x).


JR Wyer
CRM/RAC
Titan Systems Corporation
Test and Information Systems Division
C4 Information Management System (C4IMS)
Navy Global DMS Consolidated Help Desk (DCHD)
Email (Commercial): fwyer@titan.com


On Mon, 13 Jun 2005 14:51:38 -0500, George Tsai
wrote:

>Hi list,
>We have a process to import data into Remedy from a file in windows. By
>clicking a button will invoke an Active Link and fire Run Process that
>will call a window bat file and execute arimport.exe to import data (with
>mapping) into remedy from a file.
>The process works fine until we change the server option of "Users
>Prompted for Login" to "Always".
>The problem is that our process encountered "The memory can not be read"
>PC error with "Prompt for Login" option checked.
>
>This is an known issue in 4.5, and I was wondering if anybody made this
>work in 5.1.
>Any inputs will be appreciated.
>
>
>Example of the Run Process:
>c:\progra~1\remedy\scan\import.bat "$Login Name$" "$Password$" "$SERVER$"
>> nul
>
>Example of the import.bat file:
>c:\progra~1\remedy\arimport.exe -m %3 -d c:\progra~1\remedy\scan -u %1 -p
>%2 -l c:\progra~1\remedy\scan\arimport.log"
>
>Note: server name will be the mapping name.
>
>
>Remedy: 5.01.02 patch 1313
>SunOS 5.9
>Oracle 9.2.0.4.0
>Thanks.
>
>George Tsai
>Walgreens - IT Systems Architecture
>Process Automation Initiatives
>847-914-5210


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)