CSV File Import

File format

This is a comma delimited format with each field separated with a comma (,) and encapsulated with double quotes (""). Each row in the file denotes a unique store / location and each field (column) in that row carrier specific information about that location / store. Following are the list of fields needed:

Column Name Mandatory Length Example Since
1 storeId true 16 "030HHE" 1.0
2 storeName false 128 "Haywards Heath" 1.0
3 city false 64 "Haywards Heath" 1.0
4 postCode true 16 "RH16 1DR" 1.0
5 countryCode true 3 "GBR" 1.0
6 address true 256 "4 Palmerston House; Commercial Square" 1.0
7 latitude true 10 "51.006035" 1.0
8 longitude true 10 "-0.102897" 1.0
9 telephoneNumber false 16 "+44 7894 465 4561" 1.0
10 logoUrl false 128 "http://logodomain.com/nicelogo.jpg" 1.0
11 photoUrls false 512 "http://logodomain.com/nicephoto1.jpg,http://logodomain.com/nicephoto2.jpg" 1.0
12 hasDisabledAccess false Boolean "true" 1.0
13 description false 512 "Nice Store" 1.0
14 mondayOpeningTimes false - "09:00-15:00,16:00-21:00" 1.0
15 tuesdayOpeningTimes false - "09:00-17:00" 1.0
16 wednesdayOpeningTimes false - "09:00-17:00" 1.0
17 thursdayOpeningTimes false - "09:00-17:00" 1.0
18 fridayOpeningTimes false - "09:00-17:00" 1.0
19 saturdayOpeningTimes false - "09:00-17:00" 1.0
20 sundayOpeningTimes false - "09:00-17:00" 1.0
21 tags false - "pharmacy,refrigerated,potato" 1.1

Example line in the file

"030HHE","Haywards Heath","Haywards Heath","RH16 1DR","GBR","4 Palmerston House; Commercial Square","51.006035","-0.102897","+44 7894 465 4561","http://logodomain.com/nicelogo.jpg","http://logodomain.com/nicephoto1.jpg,http://logodomain.com/nicephoto2.jpg","true","Nice Store","09:00-15:00,16:00-21:00","09:00-17:00","09:00-17:00","09:00-17:00","09:00-17:00",,"09:00-17:00","pharmacy,refrigerated,potato"

results matching ""

    No results matching ""