Hi
I’ve created a LibreOffice spreadsheet which I call “Index of Films in Print.” It has four columns: title, director, premiere date, and availability (where you can buy it or watch online). Eventually I want to create a web page where the data can be sorted by each column. So far I have 2,400 rows. My goal is to index every film in print. My understanding is that for large amounts of data I should use a database rather than a spreadsheet for the web page. I’m an absolute beginner with database. I’ve tried setting up one, connecting to my spreadsheet (which I saved as a csv file) and I created a form in design view with four label boxes and four text boxes which I grouped together. I can see all my data and it’s in the correct boxes. Here are the problems:
- the text in my spreadsheet had hyperlinks and it seems they weren’t imported
- special characters have been reformatted (e.g. “Crazy Cinématographe. Europäisches Jahrmarktkino” was converted to “Crazy Cinématographe: Europäisches Jahrmarktkino”) When I try to enter text in the text boxes (with design mode off) nothing happens
Any suggestions or pointers would be very much appreciated.