Strange
Try doing the same, but with the .exe file - the .bat file seems to work
(the bat file essentially launches the non-gui version of the data
import tool)
Den 19-08-2011 18:30, Sam Cerrato skrev:
Thanks Don and Jonas...here's the dataimport.bat file:
C:\Program Files\BMC Software\ARSystem\dataimporttool>DataImport.bat
Command Line Options:
-u<user> : Required login parameter that identifies the user
accou
nt.
-p<password> : Optional login parameter that identifies the password.
Omit the option if the user account has no password.
-x<servername> : Login parameter that specifies the server to log in
to.
This option overrides the server specified in the mapping. If this option is
no
t specified, the server name in the mapping is used.
-w<authenticator> : Name of an external authentication string or Windows
NT
domain. This is related to the Login window Authentication field, which is
disc
ussed in the Configuring guide.
-r<programnumber> : RPC program number. Private server, for example, if a
d
edicated import server is available. If not specified, the default is the admin
server 390600.
-a<tcpport> : TCP port number. Port number for the server. This
value
is especially important in a multiple server environment. The option also
ident
ifies a TCP specific port, if chosen.
-l<logfile> : Full path name of the log file. Use this option to log
details of the import execution.
-e<fieldids> : Duplicate fields. IDs of the fields to check for
duplic
ate data. For example, for the Short Description field, you would enter the valu
e 8. By default, the Request ID field (field ID 1) is used when -e parameter is
omitted. Multiple values can be specified by separatng them with commas (2,4,8)
-n<option> : Suppress filters. When the system is merging entries
on
forms, this command instructs arimportcmd to suppress the merge filters.
-t<option> : Multiple match option. Use when more than one entry
mat
ches. Enter a value of 3 to affect the first match, and a value of 5 to affect a
ll matches.
-o<filename> : Data file name. Name of the file containing data to
imp
ort. If specified, this option overrides the data file specified in the mapping.
If not specified, the data file specified in the mapping is used.
-o<directory> : To use multithreaded data import tool use this option
w
ith directory name. All the files under this directory will be imported. All thi
s data will be imported in the schema provided in the command. If mapping file i
s provided and data dir contains different types of files like .arx,.csv,.xml an
d .asc then this mapping file should be same for all these files.
-f<formnames> : Destination form name. Name of the form to import
into.
If specified, this option overrides the form specified in the mapping. If not
s
pecified, the form specified in the mapping is used.
-v<option> : Forces override. If the user has logged in from a
diffe
rent IP address, this option tells the server to use the new IP address of the B
MC Remedy Import client and invalidates the old IP address.
-i<option> : Suppress default values. If specified this option is
sp
ecified import will ignore the default values of fields if the value in the data
file is null or not supplied.
-M<mappingfile> : Full path name of mapping file. Required fully
qualifie
d path name of the mapping file to use.
-D<option> : Duplicate ID. Defines how to process records that
conta
in request IDs, which duplicate those already in the form. With this option, you
must include one of the following numbers:
0 : Generate new ID for all records
1 : Reject duplicate records
2 : Generate new ID for duplicate records
3 : Replace old record with new record
4 : Update old record with new records data (the
def
ault)
-q<option> : Suppresses the required field property for non core
fie
lds.
-c<option> : Truncates character values longer than the field
length
for character fields.
-h<option> : Suppresses pattern matching for fields. If supplied
the
$PATTERN$ field limit is ignored
-charset<name> : Specifies the character set used in the data file. The
character set name must be supplied as listed in the IANA Charset Registry
-b<option> : Sets the transaction size to use.
-threads<PoolSize>: Sets the Maximum Thread Pool size. This is optional par
ameter, if not specified then it is set to default value 50
-filelist<files> : Comma separated list of
files(report.arx,test.csv,data.
xml). When -o option is data directory then only this option can be used else th
is is of no use. This is optional and takes precedence over -pattern.
-pattern<string> : Specifies a pattern for matching file names and import
them using multiple threads. When -o option is data directory then only this opt
ion can be used else this is of no use. This is optional.
-custom : Full path name of the XML file containing user-defined
custom options for handling date/time values and real numbers. This is optional.
-z : Full path name of the options XML file which contains
d
ata import commands with its own Data/File(Import) options. This is optional.
-g<option> : Forces the bulk transaction to be used with -e option,
for which it is switched off by default. This is optional and a value of 1 means
enabled.
-og<OverlayGroup> : Sets the Overlay Group. This is optional parameter, if
not specified then it is set to default(No overlay group)
-Q<option> : Fall back to old behavior of Data Import
Tool(Default
is false i.e. 0)
Usage - WITH MAPPING FILE: arimportcmd -x server -u user -p password -M mappingf
ile -o datafile -f targetform -e duplicatefield -n suppressfilters -t multimatch
option -l logfile -a portnumber -r rpcprogNum -w AuthenticationServer -i suppres
sdefaultvalues
Values for Username and Password are required.
Usage - WITHOUT MAPPING FILE: arimportcmd -x server -u user -p password -o dataf
ile -f "targetform=fileform" -e duplicatefield -n suppressfilters -t multimatcho
ption -l logfile -a portnumber -r rpcprogNum -D DupId -w AuthenticationServer -i
suppressdefaultvalues
Values for Username, Password, Server, Datafile are required.
Usage - Multi Threaded Data Import WITH MAPPING FILE: arimportcmd -x server -u u
ser -p password -M mappingfile -o datadir -f "targetform=fileform" -e duplicatef
ield -n suppressfilters -t multimatchoption -l logfile -a portnumber -r rpcprogN
um -D DupId -w AuthenticationServer -i suppressdefaultvalues -threads poolSize -
filelist files
Values for Username, Password, Datadir are required. Mapping file should
be
same for all the data files inside datadir
Usage - Multi Threaded Data Import WITHOUT MAPPING FILE: arimportcmd -x server -
u user -p password -o datadir -f "targetform=fileform" -e duplicatefield -n supp
ressfilters -t multimatchoption -l logfile -a portnumber -r rpcprogNum -D DupId
-w AuthenticationServer -i suppressdefaultvalues -threads poolSize -filelist fil
es
Values for Username, Password, Server, Datadir are required.
C:\Program Files\BMC Software\ARSystem\dataimporttool>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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"
