WebSite X5Help Center

 
Derek K.
Derek K.
User

Setting up MySql data base with hyperlinks in data fields  en

Autore: Derek K.
Visite 1113, Followers 1, Condiviso 0  

I am trying to build a data base in order to compare service levels and service costs. Cannot find anything already built that would allow me to do what I want so I was thinking of MySql and using the data base viewer in WebsiteX5 Pro. The issue is that I can build the comparative table but the software provided by my host company doesn't seem to allow me to import data from a CSV file and add a hyperling to a field. Does anyone have a solution for this.

Thanks

Derek

Postato il
11 RISPOSTE - 1 CORRETTO
John S.
John S.
User

You can always do it manually.

You can add links, images and so.

What software do you have for the database?

Who is your provider?

Would it be possible for you to have ODBC connection to your database?

Leggi di più
Postato il da John S.
Derek K.
Derek K.
User
Autore

i am using the data base software from Ionos and phpMy Admin. I am not into programming as such and really struggling with phpMyAdmin. Is there easier software out there that will do what I want.

Thanks

Derek

Leggi di più
Postato il da Derek K.
John S.
John S.
User

With phpMyAdmin it should be possible to make an import. And the import could be from a csv file.

Leggi di più
Postato il da John S.
Derek K.
Derek K.
User
Autore

Thanks John. Your second answer seems to provide the solution, I just need to do some reading and see if I can work it out. I have imported a CSV into phpMyAdmin but I cannot see how you can put any hyperlinks into a table.

Thanks

Derek

Leggi di più
Postato il da Derek K.
John S.
John S.
User

You make the link by putting in something like this :

<a href="url">link text</a>

The field with the link should be of type varchar and the length should be long enough to hold the full content.

If you could have very  long url's you could set the length to 500.

Try to make an import - be sure that the target field can hold the values from the source fields.

You could eventually try with a simple import ( without links ).

When you have this to function you could manually make a link in one of the records.

When you have this to function you could import a file in which tere is links.

If you are having big troubles with this, then I will suggest the csv-viewer. If you want me to make a test for you, then you can contact me here : http://calendarforum.dk/contact.html

I will then tell what is needed - I think only a csv-file will be needed.

Leggi di più
Postato il da John S.
John S.
John S.
User

If you have a varchar field with a length more than 60 then try to put this in the field :

<a href="http://calendarforum.dk">Good webcalendar</a>

You should then see a clickable link. The text for the link will be : Good webcalendar

Leggi di più
Postato il da John S.
Derek K.
Derek K.
User
Autore

John you are a star. I will have a play around with your ideas later this week when I have enough time to dedicate to the project.

Leggi di più
Postato il da Derek K.
Derek K.
Derek K.
User
Autore

Thanks KolAsim but I need a search function which I get with data base viewer but not with csv viewer

Leggi di più
Postato il da Derek K.
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator

... sorry, the CSV Viewer is limited ... hi ...

Leggi di più
Postato il da  ‪ KolAsim ‪ ‪