Sorry, I got sidetracked. I wanted to use the new format workbook because I
needed more columns than the old spreadsheet.
Patti
From: Javier Valencia <[email protected]>
To: [email protected]
Sent: Wednesday, November 9, 2016 3:11 PM
Subject: RE: More Re: [RBASE-L] - Can't export any data
#yiv0537066370 #yiv0537066370 -- _filtered #yiv0537066370
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0537066370
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv0537066370
{font-family:HelveticaNeue;}#yiv0537066370 #yiv0537066370
p.yiv0537066370MsoNormal, #yiv0537066370 li.yiv0537066370MsoNormal,
#yiv0537066370 div.yiv0537066370MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0537066370 a:link,
#yiv0537066370 span.yiv0537066370MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0537066370 a:visited, #yiv0537066370
span.yiv0537066370MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0537066370 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370MsoAcetate, #yiv0537066370 li.yiv0537066370MsoAcetate,
#yiv0537066370 div.yiv0537066370MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv0537066370
p.yiv0537066370msonormal0, #yiv0537066370 li.yiv0537066370msonormal0,
#yiv0537066370 div.yiv0537066370msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msonormal, #yiv0537066370 li.yiv0537066370msonormal,
#yiv0537066370 div.yiv0537066370msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msochpdefault, #yiv0537066370 li.yiv0537066370msochpdefault,
#yiv0537066370 div.yiv0537066370msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msonormal1, #yiv0537066370 li.yiv0537066370msonormal1,
#yiv0537066370 div.yiv0537066370msonormal1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msochpdefault1, #yiv0537066370 li.yiv0537066370msochpdefault1,
#yiv0537066370 div.yiv0537066370msochpdefault1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
span.yiv0537066370msohyperlink {}#yiv0537066370
span.yiv0537066370msohyperlinkfollowed {}#yiv0537066370
span.yiv0537066370msohyperlink1 {}#yiv0537066370
span.yiv0537066370msohyperlinkfollowed1 {}#yiv0537066370
span.yiv0537066370emailstyle181 {}#yiv0537066370 span.yiv0537066370emailstyle29
{}#yiv0537066370 span.yiv0537066370emailstyle30 {}#yiv0537066370
p.yiv0537066370msonormal2, #yiv0537066370 li.yiv0537066370msonormal2,
#yiv0537066370 div.yiv0537066370msonormal2
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0537066370
span.yiv0537066370msohyperlink2
{color:blue;text-decoration:underline;}#yiv0537066370
span.yiv0537066370msohyperlinkfollowed2
{color:purple;text-decoration:underline;}#yiv0537066370
p.yiv0537066370msonormal01, #yiv0537066370 li.yiv0537066370msonormal01,
#yiv0537066370 div.yiv0537066370msonormal01
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msonormal3, #yiv0537066370 li.yiv0537066370msonormal3,
#yiv0537066370 div.yiv0537066370msonormal3
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msochpdefault2, #yiv0537066370 li.yiv0537066370msochpdefault2,
#yiv0537066370 div.yiv0537066370msochpdefault2
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msonormal11, #yiv0537066370 li.yiv0537066370msonormal11,
#yiv0537066370 div.yiv0537066370msonormal11
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv0537066370
p.yiv0537066370msochpdefault11, #yiv0537066370 li.yiv0537066370msochpdefault11,
#yiv0537066370 div.yiv0537066370msochpdefault11
{margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv0537066370
span.yiv0537066370msohyperlink11
{color:blue;text-decoration:underline;}#yiv0537066370
span.yiv0537066370msohyperlinkfollowed11
{color:purple;text-decoration:underline;}#yiv0537066370
span.yiv0537066370emailstyle1811 {color:#1F497D;}#yiv0537066370
span.yiv0537066370emailstyle291 {color:windowtext;}#yiv0537066370
span.yiv0537066370emailstyle301 {color:windowtext;}#yiv0537066370
span.yiv0537066370EmailStyle43 {color:#1F497D;}#yiv0537066370
span.yiv0537066370BalloonTextChar {}#yiv0537066370 span.yiv0537066370SpellE
{}#yiv0537066370 .yiv0537066370MsoChpDefault {font-size:10.0pt;} _filtered
#yiv0537066370 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0537066370
div.yiv0537066370WordSection1 {}#yiv0537066370 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,
PEO: 913-829-0888H: 913-397-9605C: 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 dataOMG! 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 dataI'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, PEO: 913-829-0888H: 913-397-9605C:
913-915-3137 From: 'Patti Jakusz' via RBASE-L [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.
--
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.
