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 AUTONUMbered?
(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
<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 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/em02351f46-82c5-4b1b-9725-b0e8321ebc5f%403bc9cdd6.com.
