Hello everyone,

I am trying to import some data from a table in a web page
into a Remedy form.

I copy the web table and paste it into XL. For each data row
I combine the values into a single cell something like:

DATA 971 "abc" "def" "ghi"

I then copy the column and paste it into Notepad to create the
import file.

When I try to import I get,

“Record 1 : Not enough fields; found 3, expected 4. (ARERR 4210)”

The problem is in the spaces. If I remove each space and
re-type it from the keyboard, the import tool imports the
record. Obviously I don’t want to do this for 1000 records.

I can have two rows that appear identical character for
character in Notepad or MS Word. The only difference is that
I have removed and retyped the spaces in one row. Remedy will
import that row, but not the other.

What is there about spaces generated by XL that the import
tool doesn’t like?

Is there a better way of doing this altogether?

(ARS 6.3 patch 14, HPUX 11 server, Oracle 9.2 db)

Dwayne Martin
Computing Support
James Madison University

Excel usually tries to use Tabs to separate columns not spaces.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin
Sent: Thursday, February 23, 2006 10:49 AM
To: arslist@ARSLIST.ORG
Subject: Spaces in import file data copied from XL

Hello everyone,

I am trying to import some data from a table in a web page into a Remedy
form.

I copy the web table and paste it into XL. For each data row I combine
the values into a single cell something like:

DATA 971 "abc" "def" "ghi"

I then copy the column and paste it into Notepad to create the import
file.

When I try to import I get,

"Record 1 : Not enough fields; found 3, expected 4. (ARERR 4210)"

The problem is in the spaces. If I remove each space and re-type it
from the keyboard, the import tool imports the record. Obviously I
don't want to do this for 1000 records.

I can have two rows that appear identical character for character in
Notepad or MS Word. The only difference is that I have removed and
retyped the spaces in one row. Remedy will import that row, but not the
other.

What is there about spaces generated by XL that the import tool doesn't
like?

Is there a better way of doing this altogether?

(ARS 6.3 patch 14, HPUX 11 server, Oracle 9.2 db)

Dwayne Martin
Computing Support
James Madison University


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

Dwayne,

In Excel, perform a: File, Save As and make the Save File Type as .csv.
This is a standard import format for Remedy. A .csv file is a "comma
separated value" file. After you save the file, open it with Notepad to
see the format.

Generally. when I get the "Not Enough Fields" error on an Import, the error
has to do with the last column containing NULL values. To stop the error,
I create a extra column called Last that has a constant value of 1. This
ensures that the import file has a fixed number of columns for each record
and that the final column in each record has a data value of "1".

Ron Fariss

AIG Technologies
Remedy & TelAlert Administration
Work: (713) 831-2365
Cell: (281) 782-0979



"Grooms,
Frederick W" To: arslist@ARSLIST.ORG
ms@XO.COM> Subject: Re: Spaces in import file data copied from XL
Sent by: "Action
Request System
discussion
list(ARSList)"
ORG>


02/23/2006 01:07
PM
Please respond to
arslist






Excel usually tries to use Tabs to separate columns not spaces.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin
Sent: Thursday, February 23, 2006 10:49 AM
To: arslist@ARSLIST.ORG
Subject: Spaces in import file data copied from XL

Hello everyone,

I am trying to import some data from a table in a web page into a Remedy
form.

I copy the web table and paste it into XL. For each data row I combine
the values into a single cell something like:

DATA 971 "abc" "def" "ghi"

I then copy the column and paste it into Notepad to create the import
file.

When I try to import I get,

"Record 1 : Not enough fields; found 3, expected 4. (ARERR 4210)"

The problem is in the spaces. If I remove each space and re-type it
from the keyboard, the import tool imports the record. Obviously I
don't want to do this for 1000 records.

I can have two rows that appear identical character for character in
Notepad or MS Word. The only difference is that I have removed and
retyped the spaces in one row. Remedy will import that row, but not the
other.

What is there about spaces generated by XL that the import tool doesn't
like?

Is there a better way of doing this altogether?

(ARS 6.3 patch 14, HPUX 11 server, Oracle 9.2 db)

Dwayne Martin
Computing Support
James Madison University



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

**

Fred:

This looks like an attempt to convert an Excel .csv file to an .arx file. This will not work as Remedy uses "" to separate text data elements. Suggestion, put the double quote characters around the first and last part of the imported data, like this:

"abc def ghi"

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Grooms, Frederick W
Sent: Thursday, February 23, 2006 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Spaces in import file data copied from XL


Excel usually tries to use Tabs to separate columns not spaces.

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin
Sent: Thursday, February 23, 2006 10:49 AM
To: arslist@ARSLIST.ORG
Subject: Spaces in import file data copied from XL

Hello everyone,

I am trying to import some data from a table in a web page into a Remedy
form.

I copy the web table and paste it into XL. For each data row I combine
the values into a single cell something like:

DATA 971 "abc" "def" "ghi"

I then copy the column and paste it into Notepad to create the import
file.

When I try to import I get,

"Record 1 : Not enough fields; found 3, expected 4. (ARERR 4210)"

The problem is in the spaces. If I remove each space and re-type it
from the keyboard, the import tool imports the record. Obviously I
don't want to do this for 1000 records.

I can have two rows that appear identical character for character in
Notepad or MS Word. The only difference is that I have removed and
retyped the spaces in one row. Remedy will import that row, but not the
other.

What is there about spaces generated by XL that the import tool doesn't
like?

Is there a better way of doing this altogether?

(ARS 6.3 patch 14, HPUX 11 server, Oracle 9.2 db)

Dwayne Martin
Computing Support
James Madison University


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

20060125This posting was submitted with HTML in it

Thanks, Frederick!

True, when Excel gets converted into text it puts tabs between
columns. But I am using a formula to concat the fields into a
text line in a single cell. So only one column of data gets
copied and pasted.

Dwayne

---- Original message ----
>Date: Thu, 23 Feb 2006 13:07:12 -0600
>From: "Grooms, Frederick W"
>Subject: Re: Spaces in import file data copied from XL
>To: arslist@ARSLIST.ORG
>
>Excel usually tries to use Tabs to separate columns not spaces.
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG] On Behalf Of Dwayne Martin
>Sent: Thursday, February 23, 2006 10:49 AM
>To: arslist@ARSLIST.ORG
>Subject: Spaces in import file data copied from XL
>
>Hello everyone,
>
>I am trying to import some data from a table in a web page
into a Remedy
>form.
>
>I copy the web table and paste it into XL. For each data row
I combine
>the values into a single cell something like:
>
>DATA 971 "abc" "def" "ghi"
>
>I then copy the column and paste it into Notepad to create
the import
>file.
>
>When I try to import I get,
>
>"Record 1 : Not enough fields; found 3, expected 4. (ARERR 4210)"
>
>The problem is in the spaces. If I remove each space and
re-type it
>from the keyboard, the import tool imports the record.
Obviously I
>don't want to do this for 1000 records.
>
>I can have two rows that appear identical character for
character in
>Notepad or MS Word. The only difference is that I have
removed and
>retyped the spaces in one row. Remedy will import that row,
but not the
>other.
>
>What is there about spaces generated by XL that the import
tool doesn't
>like?
>
>Is there a better way of doing this altogether?
>
>(ARS 6.3 patch 14, HPUX 11 server, Oracle 9.2 db)
>
>Dwayne Martin
>Computing Support
>James Madison University
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

Dwayne Martin
Computing Support
James Madison University


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org