I have pictures that I imported in Tropy, and their metadata in a CSV file and in a JSON file. I understood that is possible to import these metadata as a JSON file but it does not work. The format is probably wrong, but my knowledge in this field is close to 0.
I don’t know if it would be easier to change the format of the JSON (and following which template?) or to work from the CSV? In the second case, do you have any advice to transform the CSV automatically to a JSON in the right format (I’ve created the template with the right fields in Tropy).
Here is the JSON one, but I cannot upload the CSV unfortunately.
{
“type”: “FeatureCollection”,
“features”: [
{
“type”: “Feature”,
“properties”: {
“location”: "Bardo National Museum, Tunis, Tunisia ",
“Dutch_caption”: “Zuilenzaal in de harem van het Bardopaleis in Tunis”,
“filename”: “Zuilenzaal in de harem van het Bardopaleis in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.134036,
36.809459
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “rue Andalouse, Tunis, Tunisia”,
“Dutch_caption”: “Twee pratende mannen in de Rue Andalouse in Tunis”,
“filename”: “Twee pratende mannen in de Rue Andalouse in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.320704,
36.838094
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “place de l’Independance, Tunis, Tunisia”,
“Dutch_caption”: "Straatgezicht in Tunis op 14 juli ",
“filename”: “Straatgezicht in Tunis op 14 juli .jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.179486,
36.799691
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “rue Des Libraires, Tunis, Tunisia”,
“Dutch_caption”: “Straat met boekwinkels en boekhandelaren in Tunis”,
“filename”: “Straat met boekwinkels en boekhandelaren in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.17975,
36.800892
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Le Marché Central de Tunis, Tunis, Tunisia”,
“Dutch_caption”: “Plein met markthallen en publiek in Tunis”,
“filename”: “Plein met markthallen en publiek in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.17742,
36.797504
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “La Medina, Tunis, Tunisie”,
“Dutch_caption”: “Klanten bij een winkel in de souk van Tunis”,
“filename”: “Klanten bij een winkel in de souk van Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.171726,
36.798013
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Qasba, Tunis, Tunisia”,
“Dutch_caption”: “Gezicht op Tunis vanuit de kasba”,
“filename”: “Gezicht op Tunis vanuit de kasba.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.165774,
36.798858
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Sidi Mahrez Mosque, Tunis, Tunisia”,
“Dutch_caption”: “Gezicht op Tunis met op de achergrond de koepels van de Sidi Mahrez moskee”,
“filename”: “Gezicht op Tunis met op de achergrond de koepels van de Sidi Mahrez moskee.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.168487,
36.804204
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Monument Place de la Kasbah, Tunis, Tunisia”,
“Dutch_caption”: “Gezicht op Place de la Kasbah in Tunis”,
“filename”: “Gezicht op Place de la Kasbah in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.167299,
36.797867
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Vieux port, Lac de Tunis, Tunisia”,
“Dutch_caption”: “Gezicht op het meer en het haventerrein van Tunis”,
“filename”: “Gezicht op het meer en het haventerrein van Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.191925,
36.798894
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Byrsa acropolis, Carthage, Tunisia”,
“Dutch_caption”: “Gezicht op de ruïnes van de Tempel van Ceres in Carthago”,
“filename”: “Gezicht op de ruïnes van de Tempel van Ceres in Carthago.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.322778,
36.8525
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Bab al Bahr, Tunis, Tunisia”,
“Dutch_caption”: “Gezicht op de Avenue de France in Tunis met stadspoort, winkels en voorbijgangers op 14 juli”,
“filename”: “Gezicht op de Avenue de France in Tunis met stadspoort, winkels en voorbijgangers op 14 juli.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.1756,
36.799158
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Bardo Palace, Tunis, Tunisia”,
“Dutch_caption”: “Exterieur van het Bardopaleis in Tunis2”,
“filename”: “Exterieur van het Bardopaleis in Tunis2.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.145161,
36.813161
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Bardo Palace, Tunis, Tunisia”,
“Dutch_caption”: “Exterieur van het Bardopaleis in Tunis”,
“filename”: “Exterieur van het Bardopaleis in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.145161,
36.813161
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Church of White Fathers, Carthage, Tunisia”,
“Dutch_caption”: “Exterieur van de kloosterkerk van de Witte Paters in Carthago”,
“filename”: “Exterieur van de kloosterkerk van de Witte Paters in Carthago.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.333842,
36.867493
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Bardo Palace, Tunis, Tunisia”,
“Dutch_caption”: “Doorkijk naar de kamer van de sultan in het Bardopaleis in Tunis”,
“filename”: “Doorkijk naar de kamer van de sultan in het Bardopaleis in Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.145161,
36.813161
]
}
},
{
“type”: “Feature”,
“properties”: {
“location”: “Souk el Attarine, Tunis, Tunisie”,
“Dutch_caption”: “Arcade met zittende figuren in de parfumsouk van Tunis”,
“filename”: “Arcade met zittende figuren in de parfumsouk van Tunis.jpg”
},
“geometry”: {
“type”: “Point”,
“coordinates”: [
10.172269,
36.797789
]
}
}
]
}
Thank you very much