Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #6973 > unrolled thread

AppendDelimited limit

Started byMartin <spam@spam.spam>
First post2014-06-17 11:54 +0100
Last post2014-06-18 14:19 +0100
Articles 11 — 6 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  AppendDelimited limit Martin <spam@spam.spam> - 2014-06-17 11:54 +0100
    Re: AppendDelimited limit Martin <spam@spam.spam> - 2014-06-17 11:54 +0100
    Re: AppendDelimited limit "Jamal" <someone@example.com> - 2014-06-17 11:02 -0400
      Re: AppendDelimited limit Martin <spam@spam.spam> - 2014-06-18 14:21 +0100
    Re: AppendDelimited limit D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2014-06-18 11:18 +0200
      Re: AppendDelimited limit Johan Nel <johan.nel@xsinet.co.za> - 2014-06-18 03:25 -0700
        Re: AppendDelimited limit Martin <spam@spam.spam> - 2014-06-18 14:19 +0100
      Re: AppendDelimited limit Martin <spam@spam.spam> - 2014-06-18 14:20 +0100
      Re: AppendDelimited limit Sherlock <sherlock@sherlock.com.au> - 2014-06-18 07:47 -0700
    Re: AppendDelimited limit Karl Wochele <kw@e©os-system.dot.de> - 2014-06-18 13:07 +0200
      Re: AppendDelimited limit Martin <spam@spam.spam> - 2014-06-18 14:19 +0100

#6973 — AppendDelimited limit

FromMartin <spam@spam.spam>
Date2014-06-17 11:54 +0100
SubjectAppendDelimited limit
Message-ID<97Vnv.9897$LU4.323@fx19.fr7>
Hello

I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD 
is AXDBFCDX and it stops importing at 1675 records.

Any ideas please?

Thanks

Martin

[toc] | [next] | [standalone]


#6974

FromMartin <spam@spam.spam>
Date2014-06-17 11:54 +0100
Message-ID<E7Vnv.9898$LU4.4214@fx19.fr7>
In reply to#6973
6000 lines sorry


On 17/06/2014 11:54, Martin wrote:
> Hello
>
> I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
> is AXDBFCDX and it stops importing at 1675 records.
>
> Any ideas please?
>
> Thanks
>
> Martin

[toc] | [prev] | [next] | [standalone]


#6976

From"Jamal" <someone@example.com>
Date2014-06-17 11:02 -0400
Message-ID<lnplar$gki$1@speranza.aioe.org>
In reply to#6973
Hi Martin,

Most likely your CSV file is not formatted properly. Google for free CSV 
file validator and what it reports.

Jamal

"Martin"  wrote in message news:97Vnv.9897$LU4.323@fx19.fr7...

Hello

I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
is AXDBFCDX and it stops importing at 1675 records.

Any ideas please?

Thanks

Martin 

[toc] | [prev] | [next] | [standalone]


#6984

FromMartin <spam@spam.spam>
Date2014-06-18 14:21 +0100
Message-ID<7ngov.4750$VV3.3747@fx32.fr7>
In reply to#6976
Appears to be OK as if I split into 4 files it works perfectly

On 17/06/2014 16:02, Jamal wrote:
> Hi Martin,
>
> Most likely your CSV file is not formatted properly. Google for free CSV
> file validator and what it reports.
>
> Jamal
>
> "Martin"  wrote in message news:97Vnv.9897$LU4.323@fx19.fr7...
>
> Hello
>
> I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
> is AXDBFCDX and it stops importing at 1675 records.
>
> Any ideas please?
>
> Thanks
>
> Martin

[toc] | [prev] | [next] | [standalone]


#6978

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2014-06-18 11:18 +0200
Message-ID<8vl2q9pffqb4or2rb89rq7fv1e4lqmngaf@4ax.com>
In reply to#6973
On Tue, 17 Jun 2014 11:54:08 +0100, Martin <spam@spam.spam> wrote:

Hello Martin,
>
>I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD 
>is AXDBFCDX and it stops importing at 1675 records.
>

I use a CSV import class which is based on the work of Geoff Schaller,
with some bug fixes and additions. It works like this:

LOCAL oCSVImport AS CSVServer

		oCSVImport:=CSVServer{cCSVFile}
		oCSVImport:HasHeaderRow:=lHasHeader
		oCSVImport:UseQuotesForStrings:=lUseQuots
		oCSVImport:cSeparator:=cSepParam
		oCSVImport:cQuot:=cQuot					
		cDBFFile:="csvimport.dbf"
		lOk:=oCSVImport:ReadFromDisk(cDBFFile,nFieldLen)

If you're interested, send me a mail and I'll send you the MEF.

As Jamal says, also here if something is wrong in the CSV file,
including seperators or quotes different from what you assigned, it
will end up with a message that it failed.

Dick

[toc] | [prev] | [next] | [standalone]


#6979

FromJohan Nel <johan.nel@xsinet.co.za>
Date2014-06-18 03:25 -0700
Message-ID<54a0b570-5d06-4362-bed9-efbd3bd8d4d9@googlegroups.com>
In reply to#6978
Hi Martin,

As Jamal and Dick indicated probable cause some unexpected character in the CSV.

I would look at line 1675 and 1676.  If line 1675 is imported correctly, then the cause will be on line 1676.  If 1675 is partially imported, look at the column upto where correctly populated and you will have your culprit.

Good idea might be to create an import file starting with line 1674 and see what happens with it during the import.

HTH,

Johan Nel
Vulcan VIP
Durban, South Africa.

[toc] | [prev] | [next] | [standalone]


#6981

FromMartin <spam@spam.spam>
Date2014-06-18 14:19 +0100
Message-ID<jlgov.4747$VV3.1933@fx32.fr7>
In reply to#6979
I finshed at 1666 (end of an order) and then did 1000 lines including 
these, they went through no problem

On 18/06/2014 11:25, Johan Nel wrote:
> Hi Martin,
>
> As Jamal and Dick indicated probable cause some unexpected character in the CSV.
>
> I would look at line 1675 and 1676.  If line 1675 is imported correctly, then the cause will be on line 1676.  If 1675 is partially imported, look at the column upto where correctly populated and you will have your culprit.
>
> Good idea might be to create an import file starting with line 1674 and see what happens with it during the import.
>
> HTH,
>
> Johan Nel
> Vulcan VIP
> Durban, South Africa.
>

[toc] | [prev] | [next] | [standalone]


#6983

FromMartin <spam@spam.spam>
Date2014-06-18 14:20 +0100
Message-ID<pmgov.4749$VV3.612@fx32.fr7>
In reply to#6978
I will send an email later thanks

On 18/06/2014 10:18, D.J.W. van Kooten wrote:
> On Tue, 17 Jun 2014 11:54:08 +0100, Martin <spam@spam.spam> wrote:
>
> Hello Martin,
>>
>> I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
>> is AXDBFCDX and it stops importing at 1675 records.
>>
>
> I use a CSV import class which is based on the work of Geoff Schaller,
> with some bug fixes and additions. It works like this:
>
> LOCAL oCSVImport AS CSVServer
>
> 		oCSVImport:=CSVServer{cCSVFile}
> 		oCSVImport:HasHeaderRow:=lHasHeader
> 		oCSVImport:UseQuotesForStrings:=lUseQuots
> 		oCSVImport:cSeparator:=cSepParam
> 		oCSVImport:cQuot:=cQuot					
> 		cDBFFile:="csvimport.dbf"
> 		lOk:=oCSVImport:ReadFromDisk(cDBFFile,nFieldLen)
>
> If you're interested, send me a mail and I'll send you the MEF.
>
> As Jamal says, also here if something is wrong in the CSV file,
> including seperators or quotes different from what you assigned, it
> will end up with a message that it failed.
>
> Dick
>

[toc] | [prev] | [next] | [standalone]


#6985

FromSherlock <sherlock@sherlock.com.au>
Date2014-06-18 07:47 -0700
Message-ID<7f446705-329d-48a7-bdb0-cfe2b9874166@googlegroups.com>
In reply to#6978
Dick

snip[ If you're interested, send me a mail and I'll send you the MEF. ]

I dont remember seeing this class before.. can I have a look.


Phil McGuinness   sherlock@sherlock.com.au

[toc] | [prev] | [next] | [standalone]


#6980

FromKarl Wochele <kw@e©os-system.dot.de>
Date2014-06-18 13:07 +0200
Message-ID<c0da7qFq3aoU1@mid.individual.net>
In reply to#6973
Hi Martin,

just another thought (as you use ADS):

could it be you started a transaction before the import and you exceeded 
the available number of data locks defined on the server?

HTH
Karl

Am 17.06.2014 12:54, schrieb Martin:
> Hello
>
> I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
> is AXDBFCDX and it stops importing at 1675 records.
>
> Any ideas please?
>
> Thanks
>
> Martin

[toc] | [prev] | [next] | [standalone]


#6982

FromMartin <spam@spam.spam>
Date2014-06-18 14:19 +0100
Message-ID<mlgov.4748$VV3.2335@fx32.fr7>
In reply to#6980
No transactions

On 18/06/2014 12:07, Karl Wochele wrote:
> Hi Martin,
>
> just another thought (as you use ADS):
>
> could it be you started a transaction before the import and you exceeded
> the available number of data locks defined on the server?
>
> HTH
> Karl
>
> Am 17.06.2014 12:54, schrieb Martin:
>> Hello
>>
>> I am trying to append a > 600 line CSV into a DBF, using VO 2.8 SP$, RDD
>> is AXDBFCDX and it stops importing at 1675 records.
>>
>> Any ideas please?
>>
>> Thanks
>>
>> Martin

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web