Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6973 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2014-06-17 11:54 +0100 |
| Last post | 2014-06-18 14:19 +0100 |
| Articles | 11 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-06-17 11:54 +0100 |
| Subject | AppendDelimited 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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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]
| From | "Jamal" <someone@example.com> |
|---|---|
| Date | 2014-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2014-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]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2014-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2014-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]
| From | Karl Wochele <kw@e©os-system.dot.de> |
|---|---|
| Date | 2014-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]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2014-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