¿ªÔÆÌåÓý

How to Import Links to database


 

Subject changed

How do I Import a list of links from y!g to a Database ?

Done it before!
I have previously built/imported data for Links databases on three groups transfered from y!g to
Gio. OK. [ normally I will build a spreadsheet, Save As a .csv and Import ]

I can import a .csv into columns more or less successfully, but links are not clickable . ok .
I can build a database of clickable URLs manually, row by row. ok

I cannot now figure out how to Import data to fill a Links database.
Has something changed?
or have I lost the plot?

Tony

On 20 Nov 2019 at 15:18, Samuel Murray wrote about :
Subject : Re: [GMF] clickable links in databa

On 20 Nov 2019 15:01, Tony Moody wrote:

If the column is set to type Link the column seems to close up, disappear, ??
An idea: just above the green "+Add Row" button there are blue buttons
that represent the columns. Check if the button for the "links" column
is blue (active, visible), not grey.

Samuel


-=-=-=-=-=-=-=-=-=-=-=-


 

¿ªÔÆÌåÓý

OK, I have had a bit of success,? by luck.

Briefly
  • I made a Links database and filled some rows manually,
  • Imported a .csv which gave me empty rows. ??
  • Then I edited the table properties and deleted the unused columns. (vague memory of having done that before)
  • Imported the .csv which gave me some Rows with data. But the fields contents are incorrect.

I'll try to give a full account when it is wright/Write/rite/right

ok,
Tony
?


 

¿ªÔÆÌåÓý

How to Import clickable links to Database.

Briefly
  • Data must be in a .csv file arranged as URL,Title ,Description in that order, without column headers.
  • Create the the database which must have only one column, which must be of Type "Links". Delete the other columns.
  • Click the "+Import Rows" button; Browse to and select the .csv file. Do not select "File has? Headers"? . Click "Import"

You should get a database, each "line" consisting of the? clickable Title over the Description.

Neat!

ok,
Tony