Re: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?

[Steve Johnson]

Bruce, Perhaps import the file into Excel and see what happens.  Steve Sent from my BlackBerry KeyOne From: rby...@safesectors.com Sent: December 10, 2018 2:58 PM To: rbase-l@googlegroups.com Reply-to: rbase-l@googlegroups.com Subject: Re[4]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit? Rich: Ah, the eternal "garbage in" issue, which The Divine Being wrestles with daily as us folks down here keep producing more of it. R:BASE, however, don't take no trash from nobody, which is one of the reason to love it. Trash bites back, if allowed in, long after it seeps through the door, generally when your machine's "critical detector" is just itching to fire. Cheers, Bruce ------ Original Message ------ Sent: 12/10/2018 11:46:07 AM Subject: Re: Re[2]: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit? From: "Rich Jasinski" <r...@ogdengroup.com> To: rbase-l@googlegroups.com I have had an issue with garbage characters blowing up a csv load or a alpha char trying to load into an int  field Sent from my iPhone On Dec 10, 2018, at 2:25 PM, Bruce A. Chitiea <rby...@safesectors.com> wrote: Tony and Albert: Thanks for the insights. Cannot see a structural issue (yet), as both halves imported without burping; but an antivirus delay is an intriguing idea. If one assumes that antivirus was also interested in, and active on, all the shorter files which imported without incident, then file size seems implicated; suggesting the crossing of an internal delay threshold within R:BASE ("uh, I've waited long enough") due to AV dwell time. May be worth an experiment or two. Thanks! Bruce ------ Original Message ------ Sent: 12/9/2018 10:42:57 PM Subject: RE: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit? From: "Tony IJntema" <t.ijnt...@cio-bv.nl> To: rbase-l@googlegroups.com Bruce,   I have an application which imports several files of more than a million rows (size > 100 MB) and encounter no problems. My suggestion is to have a look into the file if there is a structure problem, like a missing quote or something else. You can start reading 600.000 rows and look what happens and so on   Tony     Van: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] Namens Bruce A. Chitiea Verzonden: maandag 10 december 2018 2:07 Aan: rbase-l@googlegroups.com Onderwerp: [RBASE-L] - GATEWAY IMPORT CSV - Practical Record Count / File Size Limit?   Win10Pro / RGBX5E   GATEWAY IMPORT CSV   Wondering if there's a practical limit to the record count or file size of a source CSV file, or if there's a "choke" setting to be tweaked.   I had successfully imported several CSV files, the largest of which contained 634,500 records (101mb. )   RBASE started and then dropped efforts (without error message) to import a file containing 800,000 records (128mb. )   Without additional modification to internal data or structure, once this file was cut into halves (400,000 records, @64mb each), RBASE happily imported the halves.   Thoughts?   Best wishes for the season, all!   Bruce Chitiea SafeSectors, Inc. 909.238.9012 m  -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.