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
#yiv6141912464 #yiv6141912464 -- _filtered #yiv6141912464 {panose-1:2 4 5 3 5 4
6 3 2 4;} _filtered #yiv6141912464 {font-family:Calibri;panose-1:2 15 5 2 2 2 4
3 2 4;} _filtered #yiv6141912464 {font-family:HelveticaNeue;panose-1:0 0 0 0 0
0 0 0 0 0;}#yiv6141912464 #yiv6141912464 p.yiv6141912464MsoNormal,
#yiv6141912464 li.yiv6141912464MsoNormal, #yiv6141912464
div.yiv6141912464MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6141912464 a:link,
#yiv6141912464 span.yiv6141912464MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6141912464 a:visited, #yiv6141912464
span.yiv6141912464MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6141912464 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6141912464
p.yiv6141912464msonormal0, #yiv6141912464 li.yiv6141912464msonormal0,
#yiv6141912464 div.yiv6141912464msonormal0
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6141912464
p.yiv6141912464msonormal, #yiv6141912464 li.yiv6141912464msonormal,
#yiv6141912464 div.yiv6141912464msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6141912464
p.yiv6141912464msochpdefault, #yiv6141912464 li.yiv6141912464msochpdefault,
#yiv6141912464 div.yiv6141912464msochpdefault
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv6141912464
p.yiv6141912464msonormal1, #yiv6141912464 li.yiv6141912464msonormal1,
#yiv6141912464 div.yiv6141912464msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv6141912464
p.yiv6141912464msochpdefault1, #yiv6141912464 li.yiv6141912464msochpdefault1,
#yiv6141912464 div.yiv6141912464msochpdefault1
{margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv6141912464
span.yiv6141912464msohyperlink {}#yiv6141912464
span.yiv6141912464msohyperlinkfollowed {}#yiv6141912464
span.yiv6141912464emailstyle18 {}#yiv6141912464 span.yiv6141912464msohyperlink1
{color:blue;text-decoration:underline;}#yiv6141912464
span.yiv6141912464msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv6141912464
span.yiv6141912464emailstyle181 {color:#1F497D;}#yiv6141912464
span.yiv6141912464EmailStyle29 {color:windowtext;}#yiv6141912464
span.yiv6141912464EmailStyle30 {color:windowtext;}#yiv6141912464
.yiv6141912464MsoChpDefault {font-size:10.0pt;} _filtered #yiv6141912464
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv6141912464 div.yiv6141912464WordSection1
{}#yiv6141912464 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.
