I want to import an existing Excel file into the database of my group. Any suggestions? Not seeing it working when I tried the import table with a csv file.
Thanks

Terry,

I want to import an existing Excel file into the database of my group.
Any suggestions? Not seeing it working when I tried the import table
with a csv file.

As I recall the secret handshake is to create the table with column names that exactly match the text of (and perhaps the order of) the names in the header row of the csv file. As if that was obvious.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

Thanks -

Strange that you can't just upload an existing table, though.

Can it be Yahoo has an easier system? Wouldn't have expected that.

Terry

Terry,

Strange that you can't just upload an existing table, though.

Not really. You need to define the Type and other attributes for each column, and those can't necessarily be inferred from the csv data.

But I will agree that the UI could be a lot friendlier about it. And in particular it ought to be possible to import the table with a default column type and extract the column Names from the first row of the csv.
cf:

Or better still would be something like Excel's Text-to-columns wizard which allows you to interactively define the column types while viewing a preview of a few rows.

Can it be Yahoo has an easier system? Wouldn't have expected that.

Easier, but more limited in capability.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

开云体育

Thanks - appreciate the help, and will work on it. The spreadsheet in question has about 20 columns, but I tested with a few, and it imported easily.

Apparently, though, you have to include ALL columns when you set it up; you can't do them in stages. At least not in a way this techno-novice can figure out.

Terry

Perhaps too much detail, but this is generally how it worked for me.

• Make sure you have a header row in your CSV file
• Create a new table in the Databases section of GIO
• Make sure each column name in the CSV file matches each column name in the GIO database
• In the GIO database, click "+ Import Rows"
• Choose your CSV file and make sure "File Has Header Line" is checked
• Click "Import"

You need to define the Type and other attributes for each column, and those can't necessarily be inferred from the csv data.

Shal,

Seems to me that since the values in the csv file are text, that "text" might be a good first guess at the type.

?

Thanks for providing the secret, once I got the columns named right, it just worked. ?:-)

?

My row numbers now start at 37, because I deleted the 18 rows twice before I got all the columns to load. ?Anybody have any idea how to renumber them from "1", besides completely deleting table, and doing it from scratch? ?For now I'll just live with them staring at 37.

?

Thanks again,

Bob

Bob,

Seems to me that since the values in the csv file are text, that
"text" might be a good first guess at the type.

In an export from a Yahoo Group table they are simply text. Otherwise, it could vary.

Thanks for providing the secret, once I got the columns named right,
it just worked. :-)

Yeah, that tripped me up for quite a while.

My row numbers ...

Don't think of the IDs as row numbers. That will always trip you up.

Anybody have any idea how to renumber them from "1",

You cannot. Each row has an ID that is assigned when the row was created, and never changes. Think of them more like message numbers, a given number permanently identifies the content of that row.

besides completely deleting table, and doing it from scratch?

Well, there is that way. But it is a losing battle unless no one will ever delete any rows.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list

And make sure your text values are wrapped in double quotes.? Tab delimited is not enough, the value need to be surrounded with quotes.