I think you may leverage Data Management Tool for this activity.
Thanks
Mahesh
On Thu, Jan 20, 2011 at 11:42 AM, Lammey, Peter A.
wrote:
> **
>
> I was tasked to setup a spreadsheet ingest process that would create
> resolved incidents in our Incident 7.02 system.
>
> I updated all filters on th
Watch the filter log closely - updates to that HPD form result in updates to
several other forms, especially if you have integrated products like SLM
installed. I had a problem once where the web service interface provided a
Middle Initial field that wasn't on one of the underlying forms.
On Thu,
This would be an error writing to the HPD:Help Desk form review the filter that
writes to this form.
-Original Message-
From: Lammey, Peter A.
To: arslist
Sent: Thu, Jan 20, 2011 11:44 am
Subject: Trying to setup Remedy Import into HPD:IncidentInterface_Create
**
I was tasked to
I was tasked to setup a spreadsheet ingest process that would create resolved
incidents in our Incident 7.02 system.
I updated all filters on the HPD:IncidentInterface_Create form to fire on Merge
as well as Submit and it works for creating open Assigned tickets however after
mapping all the fie
(0) 21 483 6482
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Maheshwari, Rahul
Sent: 07 July 2009 15:12
To: arslist@ARSLIST.ORG
Subject: Re: getting error while importing the data using BMC Remedy Import Tool
The problem i
:57 PM
To: arslist@ARSLIST.ORG
Subject: getting error while importing the data using BMC Remedy Import Tool
Hi,
When i try to import data (AR Server Data, AP:Process Definition) from one
server to another server, I am getting the following error.
This is my original data which is imported from Test
PM
To: arslist@ARSLIST.ORG
Subject: getting error while importing the data using BMC Remedy Import Tool
Hi,
When i try to import data (AR Server Data, AP:Process Definition) from one
server to another server, I am getting the following error.
This is my original data which is imported from Test
","Can Reassign?","Approval Success*","If
Multiple Approvers*","Allow Ad Hoc Next Approver?*","Validate
Approvers?*","Require Password?*","Created By*"
"test","AAA:TST:TWO","Ad Hoc","Active&
behalf of Jack Samson
Sent: Fri 12/21/2007 9:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Exported CSV format not valid for Remedy Import Tool
** Yes, the sql server export looks like:
TicketNumberColumn,DescriptionColumn
TicketNumberval,Descriptionval
TicketNumberval,Descriptionval
TicketNumberval
Of Jack Samson
Sent: Friday, December 21, 2007 8:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Exported CSV format not valid for Remedy Import Tool
** Yes, the sql server export looks like:
TicketNumberColumn,DescriptionColumn
TicketNumberval,Descriptionval
TicketNumberval,Descriptionval
valid for Remedy Import Tool> To:
arslist@ARSLIST.ORG> > Is the SQL server export tool creating the CSV with
commas as the> delimiter? If yes, does the data contain commas in places? If
yes, that> will make the CSV invalid.> > -Original Message-> From:
Action Reque
Sent: Friday, December 21, 2007 7:17 AM
To: arslist@ARSLIST.ORG
Subject: Exported CSV format not valid for Remedy Import Tool
**
All,
We have another database where records are exported into a csv file. We
have the need to import these records into Remedy now. We are using the
ARS 6.3 import
Hi,
If the file does not have doublequotes it is not a CSV-file that AR Import
can parse.
If you do not have any ","-characters in the data, you can import it as an
asc-file with "," as delimiter instead.
To convert your file, you will not need to create an AR-API-program. But
you may have to cr
All,
We have another database where records are exported into a csv file. We have
the need to import these records into Remedy now. We are using the ARS 6.3
import tool.The export was performed through SQL server export tool. What I
have found is the columns and data that was exported with
f you can be more specific with the
problem you are having I could help you.
Teresa
From: Action Request System discussion list(ARSList) on behalf of Mimi Lakew
Sent: Fri 9/22/2006 3:29 PM
To: arslist@ARSLIST.ORG
Subject: modifying data from Remedy Import
**
I h
@ARSLIST.ORG
Subject: modifying data from Remedy Import
**
I have big data on excell and my manager is telling me it is possible to
upgrade the existing data on remedy form by importing this csv file. Can
anybody tell me if that is possible and how? I tried it and it didn't work for
me.
**
I have big data on excell and my manager is telling me it is possible to upgrade the existing data on remedy form by importing this csv file. Can anybody tell me if that is possible and how? I tried it and it didn't work for me. It is Windows/ SQL Server 2000 Remedy 5.1.2
I had the same; commas in the data. Write your values to the csv in
quotes. "Value 1","Value 2","Value 3", ... ,"Value 37"
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
. <[EMAIL PROTECTED]> wrote:
**
Thanks I'll give that a try.
-Original Message-From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG]Sent: Wednesday, August 16, 2006 6:05 PMTo: arslist@ARSLIST.ORG
Subject: Re: Remedy Import**
I've seen that. For me
**
Thanks
I'll give that a try.
-Original Message-From: Action Request System
discussion list(ARSList) [mailto:[EMAIL PROTECTED]Sent:
Wednesday, August 16, 2006 6:05 PMTo:
arslist@ARSLIST.ORGSubject: Re: Remedy
Import**
I've seen that. For me it's alwa
**
I've seen that. For me it's always been because a comma was in the data or I had some hard returns where they should not be. Sometimes opening the csv in a hex editor will give a clue. Never have I had it work one time and not the other. - Scott "Baytops, Abdullah P." <[EMAIL PROTECT
Hello Everyone,
I have a little problem that is spurattic when using Remedy Import.
I am in the process of importing some data from a CSV file that has about
3000 rows and 40 columns. During the import I get the following error:
Example
Line (202) 37 fields expected only 35 fields
tem discussion list(ARSList) [mailto:arslist@ARSLIST.ORG
] On Behalf Of Jason McDonaldSent: Thursday, August 03, 2006 4:14 AM
To: arslist@ARSLIST.ORGSubject: Re: Remedy Import - Limits to 15 records
**
I am sure that there was no change in the 16th row when compared to the 15th row w.r.t. less
ldSent: Thursday, August 03, 2006 4:14 AMTo:
arslist@ARSLIST.ORGSubject: Re: Remedy Import - Limits to 15
records
**
I am sure that there was no change in the 16th row when compared to the
15th row w.r.t. less columns having data.
One more point to note is that I get this error *ALL THE TI
if needed. /L ars-Original Message-From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Mike WhiteSent: Monday, July 31, 2006 3:51 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy Import - Limits to 15 records
Length probably changed after the 15th record
Behalf Of Mike White
Sent: Monday, July 31, 2006 3:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Import - Limits to 15 records
Length probably changed after the 15th record (column populated for rows
1-14, but not for 15th, or vice-versa). I haven't seen your data, but this
is where I'd
Have you checked the Error Handling tab in the Preferences dialog in
BMC Remedy Import?
You might want to check the box before "Import Records with Too Few
Fields" if your data file is correct, but the import keeps moaning
about this.
IMO this would be the easiest option to deal with
M> cc:
Sent by: "Action Subject: Re: Remedy Import -
Limits to 15 records
Request System
<[EMAIL PROTECTED]cc:
COM> Subject: Re: Remedy Import -
Limits to 15 records
ascribe to malice, that which can be explained by incompetence.
On 7/31/06, Jason McDonald <[EMAIL PROTECTED]> wrote:
** But in that case how does it work for the first 15 records?
On 7/31/06, Mike White <[EMAIL PROTECTED]> wrote:
> It's caused by variable-length record
**
But in that case how does it work for the first 15 records?
On 7/31/06, Mike White <[EMAIL PROTECTED]> wrote:
It's caused by variable-length records. Remedy Import doesn't toleratethem too well. When we import from .csv, we make sure the last column is
fully populated - m
**
Its weird that remedy import can't handle the last few empty columnsEscpecially when usually the columns appearing in the last are temporary columns in remedy forms (as the field names start with z..) Anyways, guess i'll have to cut and paste some column in which there is data f
It's caused by variable-length records. Remedy Import doesn't tolerate
them too well. When we import from .csv, we make sure the last column is
fully populated - moving columns if necessary. This will fix/set your
record length.
Mike White
Office: 813-978-2192
E-mail: [EMAIL
**
Hi List,
Once again I seek your advice.
This pertains to Remedy 6.0.3.
I am really getting irritated when trying to import data via the Remedy Import Tool. Irrespective of what form it is and how much data I have in the CSV file, Import always breaks at 15th record with the message
34 matches
Mail list logo