search

numero2 / contao-storelocator

Contao Plugin for managing stores (or in common address data) and providing a frontend-search based on geo data.
https://www.numero2.de/contao/erweiterungen/storelocator.html
GNU Lesser General Public License v3.0
13 stars 8 forks source link

CSV Import for further Data #31

Closed mr2017x closed 4 years ago

mr2017x commented 6 years ago

Good Day and thanks for the pretty nice extension. i am asking myself if it is possible to import more than the given csv-string name, email, url, telefon, fax, strasse, plz, ort, ländercode (ISO 3166-2).

For example: it would be perfect if the csv import would also handle description and opening times.

Thank you

bennyborn commented 6 years ago

These fields are left out on purpose. The problem with these data is the format and the capabilities of the CSV format itself.

A description contains HTML-Code which has attributes that are enclosed in double quotes which is also used to mark the actual cell data in a CSV. You'd need to correctly escape all double quotes in a description otherwise you'd risk ending up with garbled data.

For the opening times: We have 3 fields for each day - the day itself, opening time, closing time. The only really usable way (for a normal end user, not a developer) would be to add 3 columns for each day. Given a 5 to 7 day week we'd end up with 21 additional columns - way too much.

So at this point I don't really see a practical way to include these two fields in a simple CSV import.

mr2017x commented 6 years ago

Hi Benny,

thank you. regarding your opening time concerns i am totally with you regarding your concerns to Description i would appreciate an easy way - no html, and special chars should be fine by utf8?