Have you tried creating a view and then exporting it? It would certainly allow you to see if the data you need is there before you export it and the process will be considerably faster. BTW, exporting to the old format spreadsheet instead of a workbook is considerably faster. Last, make sure the spreadsheet where you want to export the data is not open; this will generate an error every time. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]] Sent: Wednesday, November 09, 2016 12:42 PM To: [email protected] Subject: Re: More Re: [RBASE-L] - Can't export any data Actually, one of my missteps with the date formatting earlier, cased me to end up with an excel file with just the column names. Maybe I could recreate that situation again too to get the column headings. Patti _____
From: Buddy Walker <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 6:17 PM Subject: RE: More Re: [RBASE-L] - Can't export any data I forgot to tell you save the columnames as a txt file. Open another blank worksheet. Now open the saved txt file and when asked the file is delimited with the comma separator. This will put each of your columnNames in a separate column. Copy the columnNames from the worksheet then past it to inserted row in your worksheet. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, November 8, 2016 6:11 PM To: [email protected] Subject: RE: More Re: [RBASE-L] - Can't export any data Patti Have you tried using the UNLOAD DATA OUT myCSVfile.CSV UNLOAD DATA FOR tablename USI columnList AS CSV WHERE yourWhereClause OUT TERM This won’t give you the Column Names but you can highlight and copy the columNames from the above UNLOAD. Open Excel and then open the csv file. Insert a row in Excel and then paste the columnNames. Now you can save as a xls/xlsw or csv. This should take a lot less time than waiting 10 minutes and give you a work around until you purchase updated version of R:Base. Buddy From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]] Sent: Tuesday, November 8, 2016 4:39 PM To: [email protected] Subject: Re: More Re: [RBASE-L] - Can't export any data And now, 10 minutes later, it gave me the file anyway. I give up. I hope to be buying the new version of Rbase soon anyway. Patti _____ From: Patti Jakusz <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, November 8, 2016 4:25 PM Subject: More Re: [RBASE-L] - Can't export any data I still get the error message, but now I get it 90 minutes later, after it pretended to export everything. Patti _____ From: 'Patti Jakusz' via RBASE-L <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, November 8, 2016 2:58 PM Subject: Re: [RBASE-L] - Can't export any data Your suggestion of trying the where clause is what did it though. I copied that from something I was doing earlier so I knew it worked. But I always have to change the date format when I export into excel and I forgot about doing it in the where clause too. Patti _____ From: karentellef via RBASE-L <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 2:53 PM Subject: Re: [RBASE-L] - Can't export any data That wouldn't have occurred to me to suggest! Karen -----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Nov 8, 2016 1:51 pm Subject: Re: [RBASE-L] - Can't export any data OMG! I changed the date format and didn't change it in my where clause. Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! _____ From: 'Patti Jakusz' via RBASE-L <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, November 8, 2016 2:49 PM Subject: Re: [RBASE-L] - Can't export any data Yes, the where clause is fine. I can try to create another table using it and export the other table. Patti _____ From: karentellef via RBASE-L <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 2:45 PM Subject: Re: [RBASE-L] - Can't export any data Whew, that's some "where" clause!!! Have you tried copy/paste of that where clause and run it from the R> prompt as a "browse"? Do you get all your data up that way? Karen -----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: rbase-l <[email protected]> Sent: Tue, Nov 8, 2016 1:36 pm Subject: Re: [RBASE-L] - Can't export any data I'm not using the Wizard, but I am using the Gateway interface screen. I tried to use the wizard, but there's no option for CSV files in it. I attached a snip of the screen. Maybe there's a time limit on Gateway and I have to buy the new version of Rbase??? Patti _____ From: Javier Valencia <[email protected]> To: [email protected] Sent: Tuesday, November 8, 2016 2:25 PM Subject: RE: [RBASE-L] - Can't export any data Are you using the Gateway Wizard or a command file? If it is the second, maybe you can post the code and we might be able to figure out the issue. I export all the time using both methods without any issues. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: 'Patti Jakusz' via RBASE-L [mailto:[email protected] <mailto:[email protected]?> ] Sent: Tuesday, November 08, 2016 1:20 PM To: [email protected] Subject: [RBASE-L] - Can't export any data Hello, I'm still using RBase 9.5 extreme. We have Microsoft Office 2013 on the office PC I get this error message when I try to export to Excel using gateway. Error of Data Export: Access Violation at Address 00405E34 in module 'RGB95_32.exe' Read of address FFFFFFF7 I sometimes get a 4KB file created, and if I click on it I get a messages that says "Do you want to save changes to Book1?" But no data shows up. This morning, when I tried, it would go through all 4000 records and then give me the error. Now I get the error immediately. When I try to export to a CSV file, I get the hourglass spinner thing for a while and then it stops. When I open the file it created, all I see are column headings. So I tried my laptop. I first exported into a CSV file and it was working - but I realized I forgot to change my date settings. So I cancelled the operation and started again. Now it won't work. I get the same results as when I tried it on the office PC - an hourglass then nothing but a file with column headings. I tried exporting to Excel on the laptop and I get the exact same error message as I did on the office pc. So I tried someone else's computer at work and it still wouldn't export. I replaced the database with a copy I had on a flashdrive and it didn't work. I have to get these files exported. I'm running out of ideas. The table has too many columns to use anything other formats. Can anyone figure out what is wrong? Thanks, Patti -- 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. -- 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. -- 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. -- 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. -- 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.
