Patti:
Would you please do this for me?
1. Create a two-column temporary table of just MomAge and BabyAge (no
HIPPA violation);
CREATE TEMP TABLE OhBaby_tt +
( MomAge NUMERIC (5,1) , +
BabyAge NUMERIC (5,1) )
2. Insert the MomAge and BabyAge data you're attempting to export into
the temp table;
INSERT INTO OhBaby_tt +
SELECT MomAge , +
BabyAge +
FROM HeadStWork +
WHERE Exit2Dat IS NOT NULL
3. At the R>, UNLOAD the temp table as "OhBaby.rmd"
OUTPUT OhBaby_tt.rmd
UNLOAD ALL FOR OhBaby_tt
OUTPUT Screen
4. Attach OhBaby_tt.rmd to a message and send to [email protected].
I'll beat on it and see what happens.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 3/3/2016 9:45:23 AM
Subject: [RBASE-L] - Re: It didn't work RE: problem exporting
decimalsintoExcelWorkbook
From: "Patti Jakusz" <[email protected]>
To: [email protected]
Cc:
Hi Bruce,
I'm using Rbase 9.5 Extreme, exporting into Excel 2007.
Yes, if I reformat the column in Excel, they appear correctly. I was
trying to avoid having someone "fix" it before it was sent off to the
people who require it. They have to go in and encrypt it anyway, I
guess.
Thank you for your help, though !
Patti
--------------------------------------------------------------------------------
From: Bruce Chitiea <[email protected]>
To:[email protected]
Sent: Thursday, March 3, 2016 12:34 PM
Subject: [RBASE-L] - Re: It didn't work RE: problem exporting decimals
intoExcelWorkbook
Patti:
A few questions:
1. Which version of R:BASE are you using?
2. To which version of Excel are you exporting?
3. If you reformat the column within Excel, do the numbers appear,
properly formatted?
Here's how:
a. <Right-Click> on the column header (A or B)
b. Select "Format Cells ..." from the drop-down menu
c. Select the "Number" tab (if not already active)
d. Select "Number" from "Category"
e. Set "Decimal Places" value to however many decimal places you prefer
f. Hit "OK"
Granted, that's still a step for the "data entry clerk", but does that
help?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 3/3/2016 9:19:19 AM
Subject: [RBASE-L] - Re: It didn't work RE: problem exporting decimals
intoExcel Workbook
From: "Patti Jakusz" <[email protected]>
To: [email protected]
Cc:
I found the Export Wizard but it didn't let me specify the data type of
the Excel column receiving the data. It only let me change the font,
alignment and background.
So the numeric Rbase fields showed up in Excel rounded up to the next
integer. When you click on an individual cell, it shows the real number
at the top of the screen, but the spreadsheet shows all integers
Plus, using the wizard rearranged my exported columns and didn't allow
me to specify the workbook Tab Name.
Maybe the rounding problem is a bug. It doesn't do it if I export into
an Excel Spreadsheet, only if I do it to a Workbook.
Patti
--------------------------------------------------------------------------------
From: Javier Valencia <[email protected]>
To:[email protected]
Sent: Wednesday, March 2, 2016 7:23 PM
Subject: [RBASE-L] - RE: problem exporting decimals into Excel Workbook
Patti,
The *.rgw file stores the specifications that allow you to recreate the
export file. You set up your export parameters one time (for each
specific export/format) using the Gateway wizard and then you store the
parameters in a *.rgw file. Next time you want to export the same file
you just specify the *.rgw that you created and that has you settings
and the export file is generated; makes sense?
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From:[email protected] [mailto:[email protected]] On Behalf Of Patti
Jakusz
Sent: Wednesday, March 02, 2016 3:26 PM
To:[email protected]
Subject: [RBASE-L] - RE: problem exporting decimals into Excel Workbook
I will try this tomorrow when I'm back at work. I never heard of an
.rgw file. Can it contain multiple spreadsheet pages and be opened
with Excel?
Patti
--------------------------------------------------------------------------------
From: Javier Valencia <[email protected]>
To:[email protected]
Sent: Wednesday, March 2, 2016 2:57 PM
Subject: [RBASE-L] - RE: problem exporting decimals into Excel Workbook
Patti,
Use the Gateway Wizard to generate a spreadsheet export where you can
specify the columns and formatting and save the export as a *.rgw file.
Next time you can just specify the file you saved with all the saved
formatting. Works very well.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From:[email protected] [mailto:[email protected]] On Behalf Of Patti
Jakusz
Sent: Wednesday, March 02, 2016 1:47 PM
To:[email protected]
Subject: [RBASE-L] - problem exporting decimals into Excel Workbook
I sent this yesterday with my Excel attachment, but I don't think anyone
ever got it. So I'll try again without the attachment.
--------------------------------------------------------------------------------
From: Patti Jakusz <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tuesday, March 1, 2016 10:49 AM
Subject: problem exporting decimals into Excel Workbook
Hello,
I have to export data into Excel Workbook format, producing multiple
spreadsheet pages. My file has two columns (MomAge and BabyAge) that
are numeric (5,1) values. When I open the resulting spreadsheet, I find
those two columns formatted as a Number with zero decimal places and the
result has been rounded.
I tried exporting to a regular Excel Spreadsheet and it works fine. But
that doesn't give me what I need.
How can I get the decimals to show up without having the data-entry
clerk go in and reformat the columns in Excel?
Here is the syntax for one of the sheets:
GATEWAY EXPORT xlsw HealthyStartHeadSt.xlsx +
SELECT HVSiteName, MomName, MomAge, +
ProgStart, ProgEnd, BabyFNM, BABYLNM, BabyDOB, DaysProg, BabyAge +
from HEADSTWork order by MOMNAME whe EXIT2DAT is not null +
OPTION COL_NAMES ON +
|TAB_NAME Dismissed and > 2.5, < 4.0
Patti
