Many, many years ago when I was working at the local coal mine, they bought a pit system that would not talk to any other system. The system they bought scheduled loaders, dozers, shovels, drills and other mine equipment and also the trucking from the load point to the various stockpiles and the grizzly to the treatment plant. I wrote a translation system, as my job included keeping track of the coal for financial reporting purposes. There were numerous types of coal, numerous stockpiles, the treatment plant production, the train shipments 1,000 Km (600 miles) to the port on the West coast.
I wrote a “system” where the plant production department printed the report to a text file designed for 17 inch x 11 inch perforated paper. I then imported the file through a form, after which I processed the data that was imported to remove all the lines that were not production information. Using 4.5, it took about 2.5 hours to process the information from one month’s production. The clean coal production from this mine was 6,000,000 tonnes of clean metallurgical coal each year. There were 70+ trucks carting the coal around, 24 hours a day, 365 days a year. There were thousands of pages of printed information for a month’s production. The point I am making is that perhaps if you brought the data into a temporary table (not available in the day), all zillion rows, and then processed it to eliminate anything but the 400 rows of data you need you could get R:Base to do your heavy lifting. I am absolutely certain that with RBGXE this would take only minutes to run. Albert > On May 30, 2017, at 10:40 AM, Buddy Walker <[email protected]> wrote: > > Dick > > Have you tried to open the csv file in Excel or RBedit. This may tell you if > there are actually a lot of blank rows. > > Buddy > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Carpet Broker, Dick Fey > Sent: Tuesday, May 30, 2017 11:29 AM > To: RBase Maillist <[email protected]> > Subject: [RBASE-L] - Syntax, Load command > > Trying to load a price file from a vendor. Have it ins CSV format. > Unable to figure out how to limit the number of rows. > Tried all the syntax in the Load help, but nothing seems to work. > It is loading thousands, but there is only 400 lines of data. > > Dick Fey > > > -- > Carpet Broker Inc > P: 913-894-9211 > F: 913-894-0138 > > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
