EN FR

CSV to Citadel JSON converter

This PHP converter library is meant to be used as a service that can convert CSV files to Citadel-JSON files on the fly.

It includes the following services:

Step 1: Prepare and publish your CSV file

Preparing the CSV file is not part of that tool. The CSV file should contain at least the geographical coordinates (latitude and longitude) and a title. Publish the file anywhere it can be accessed by a web address (URL). Using a public datastore is recommended.


Step 2: Use the template generator

Open the template generator in a new window

The CSV fields needs to be mapped to Citadel JSON fields, which are designed to be easily displayed into a mobile application. The converter can be configured with a PHP array, but this tool make the process easier for non-developpers to prepare the fields mapping.

Besides preparing the data themselves, this is the most important part as it will define how your data will be displayed into the final mobile application.

Once done, you will get a rather un-readable text file (serialized PHP array), but don't worry and publish that file anywhere it can be accessed by a web address (URL). This way you will be able to use it in the converter, and reuse it for any other CSV file that is formatted the same way.


Step 3: Generate the converter URL

The following form will generate an URL that can be used to get the converted file, or directly into your application to provide it with a live data source.

Download generated Citadel-JSON file

OR use this direct URL into your app:

http://items.fr/apps/citadel/converter-php-lib/convert.php?source=samples%2Fdataset.csv&filename=&remote_template=&serialized_template=&format=citadel&import=csv

OR use this shorter URL:

http://items.fr/apps/citadel/converter-php-lib/convert.php?u=02f3a1910e66626897d6584ed956135a


Configure to get the converted file