I agree with John. I ALWAYS audit my data with a text editor. I've found once after if I exported data as a csv, opened in Excel and decided I didn't need the last column and deleted it. I ended up with errors. Turned out I had sporadic commas at the ends of some rows. Now I leave my export alone and just ignore extra columns during the import.
One other tip - If your export includes 'Request ID' change your .csv export to .txt before opening in Excel and you can preserve the "0" padded field by designating it text. I hate that Excel truncates like that.
Good Luck.
Steve
On 8/3/06, Reiser, John J <[EMAIL PROTECTED]> wrote:
**Jason,Some one may have stated this already but when you check your file do you use Excel or notepad/wordpad. I have seen "section breaks" in a .csv file when opened in Excel that just appears as a blank line in notepad. That could explain the "every 15th record" phenomenon.Try a simple sort in excel and resave the file in .csv format. The import should work.And I've never had a problem with data missing in the last column as long as there are enough "," commas in each row of the text file.HTH,John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
From: Action Request System discussion list(ARSList) [mailto:[email protected] ] On Behalf Of Jason McDonald
Sent: Thursday, August 03, 2006 4:14 AM
To: [email protected]
Subject: 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 TIME*, when any csv has more than 15 records.Nevertheless, ensuring that the last column contains data seems to be the easiest way IMHO.Thanks for all your inputs. You guys are great!
/J
On 8/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:I've seen the same, so when working with Excel I always have the last column filled with data, and check with CTRL/End that the last cell is selected, some times a row 'outside the dataarea' can be selected (and this can disturb the import),in that case copy the data and put in a new spr.sheet. We often have a field 'Importfile' in our forms, makes it easy to validate the import and maybe delete the imported records and start again if needed. /L ars
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]]On Behalf Of Mike White
Sent: Monday, July 31, 2006 3:51 PM
To: [email protected]
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 look first.
Matt makes good points about data condition. Hard returns result in two
(or more) records where you intended one. Field mapping would misalign.
Imbedded commas in text could be problematic, too. (.csv files are
comma-separated).
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Carey Matthew
Black" To: [email protected]
<[EMAIL PROTECTED] cc:
COM> Subject: Re: Remedy Import - Limits to 15 records
Sent by: "Action
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
07/31/2006 09:43
Please respond to
arslist
Jason,
If the columns are "empty data values" in the file. Then do not map
them in the import tool. (It might help.) However, apparently, some
rows have data, or null data, defined for them.
I have seen such behaviour when the csv file is edited with Excel.
Another possible point of confusion is how "hard returns" are dealt
with in csv format. Some editors write them as hard returns and thus
break up the single line format of csv.
Keep in mind that filters that fire on merge can look at data supplied
to display only fields too. (A good, old school, way to do some
signaling for data merge work IMHO.)
Then again... this could be as "simple" as a bad client install, or a bug
too.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never 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 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 PROTECTED]
> >
> >
> >
> > "Jason McDonald"
> > <[EMAIL PROTECTED] To:
> [email protected]
> > COM> cc:
> > Sent by: "Action Subject: Remedy Import -
> Limits to 15 records
> > Request System
> > discussion
> > list(ARSList)"
> > <[EMAIL PROTECTED] .
> > ORG>
> >
> >
> > 07/31/2006 09:15
> > Please respond to
> > arslist
> >
> >
> >
> >
> >
> >
> > **
> > 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 -
> > "[Record 16 of XX] : Unable to import. Found 30 columns, expected 32"
> >
> > Note that it always says that it found X-2 columns when there are
actually
> > X columns in the CSV file.
> >
> > In order to import all the records, I have to keep on deleting the
first
> 15
> > records from the csv file so that the import can process another 15
> > records.
> >
> > Can anyone help on this?
> > Thanks.
> > __20060125_______________________This posting was
> submitted with HTML in
> > it___
> >
> >
>
_______________________________________________________________________________
> > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
> >
>
>
> __20060125_______________________This posting was
> submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it_____20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
