Thank you. This is very helpful!
Lin
On 2025-04-14 5:12 p.m., Bruce Chitiea wrote:
Lin: Dan is one of the hands who helped me back in the day. Glad you
found him.
These other errors you mention ... here's what I learned to do when
prepping Excel data for seamless Gateway import:
(1) Remove all horizontal and vertical lines from the data set
(2) Highlight and format any Excel *Date* column as/Format Cells >
Number > Category > Date > Type: **3/14/2012*/
(3) Highlight and format any Excel column containing alphanumerics
(words, word/letter-and-number mixes, embedded dashes or punctuations)
as /Format Cells > Number > Category >/*Text*. Do not rely on Excel's
default "General" category.
(4) Highlight and format any Excel column containing dollars and cents
($1,000.15) as /Format Cells > Number > Category > *Number* > [Decimal
places: 2 | Negative Numbers: -1234.10 | Use 1000 Separator: Blank]/
(5) Format *Integer* columns the same as for dollars & cents, except
set Decimal Places = 0.
That will eliminate a lot of data sin. Next, are your key columns
ready to pass relational rule checking during importing?
(a) For an Excel column containing Primary Key (PK) values:
(a1). Are all entries the *same data type* (e.g. Integer)?
(a2). Are there any *empty (NULL) cells*? A definite import killer.
(a3). Check for *duplicate values* with /Data > Remove Duplicates/.
This will allow you to check a single column, identify dupes, while
not removing anything (except by accident; best to save the
spreadsheet first).
(a4). Does any ONE OR MORE PK values in the Excel column *duplicate a
value* in the already-populated target R:BASE PK column?
(a5). Is the target R:BASE PK column *AUTONUM*bered?
(b) For an Excel column containing Foreign Key (FK) values:
(b1). Same as (a1).
(b2). There can be NULLs unless the target R:BASE column is defined
NOT NULL (this is true for any column).
(b2). Does any ONE OR MORE FK values *NOT MATCH* their related PK values?
There's more, but that's a start.
Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "[email protected]" <[email protected]>
To "RBASE-L" <[email protected]>
Date 4/14/2025 4:18:20 PM
Subject Re: [EXTERNAL] [RBASE-L] - Need help with Importing data from
Excel
Thanks Dan. That seems to have worked. No idea why it didn't the
first time I tried that!! It does stop when it hits an error and
exits without anything telling you it has hit an error, which is
annoying, but not insurmountable
Lin
On Monday, April 14, 2025 at 12:30:05 PM UTC-7 Daniel Goldberg wrote:
To have it ignore the header row, put first row to 2.
Dan Goldberg
*From:*[email protected] <[email protected]> *On
Behalf Of *Lin MacDonald
*Sent:* Monday, April 14, 2025 11:17 AM
*To:* [email protected]
*Subject:* [EXTERNAL] [RBASE-L] - Need help with Importing data
from Excel
You don't often get email from [email protected]. Learn why this
is important <https://aka.ms/LearnAboutSenderIdentification>
I want to import data from Excel into an existing table and I
can't seem to do it.
-I have formatted my Excel sheet to match my Data table. I tell
it what file and then join the columns with the letters from
Excel. The next screen shows up with no data. I added a
header line to my Excel sheet and the data showed up but would
not load - claiming it was seeing a blank field. My Header line
showed up as the first row of data so I assumed that was throwing
it off. I have not since been able to get my data to show up no
matter what I do. And, I don't get any error messages.
-what am I missing?
Thanks for the help!
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/8d4c3a01-5e7a-4ca8-a46d-6ec68701776b%40app.fastmail.com
<https://groups.google.com/d/msgid/rbase-l/8d4c3a01-5e7a-4ca8-a46d-6ec68701776b%40app.fastmail.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/4daf421b-f179-4bd8-a1e7-da143b9da731n%40googlegroups.com
<https://groups.google.com/d/msgid/rbase-l/4daf421b-f179-4bd8-a1e7-da143b9da731n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to a topic in the
Google Groups "RBASE-L" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/rbase-l/LYUwL6BNwTM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
[email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/em02351f46-82c5-4b1b-9725-b0e8321ebc5f%403bc9cdd6.com
<https://groups.google.com/d/msgid/rbase-l/em02351f46-82c5-4b1b-9725-b0e8321ebc5f%403bc9cdd6.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
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].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/e4aa814b-3099-46ff-9c35-0a7f78351852%40gmail.com.
