WebSite X5Help Center

 
Derek K.
Derek K.
User

Setting up MySql data base with hyperlinks in data fields  en

Autor: Derek K.
Visitado 1106, Seguidores 1, Compartilhado 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

Publicado em
11 RESPOSTAS - 1 CORRIGIR
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?

Ler mais
Publicado em de John S.
Derek K.
Derek K.
User
Autor

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

Ler mais
Publicado em de 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.

Ler mais
Publicado em de John S.
Derek K.
Derek K.
User
Autor

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

Ler mais
Publicado em de 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.

Ler mais
Publicado em de 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

Ler mais
Publicado em de John S.
Derek K.
Derek K.
User
Autor

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.

Ler mais
Publicado em de Derek K.
Derek K.
Derek K.
User
Autor

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

Ler mais
Publicado em de Derek K.
 ‪ KolAsim ‪ ‪
 ‪ KolAsim ‪ ‪
Moderator

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

Ler mais
Publicado em de  ‪ KolAsim ‪ ‪