Files
savethedate/import-data.html
Julien Lengrand-Lambert 69ec926474 Add firebase import script
2018-02-22 22:39:26 +01:00

73 lines
2.1 KiB
HTML

<!DOCTYPE html>
<html lang='eng'>
<head>
<script src="https://www.gstatic.com/firebasejs/4.9.1/firebase.js"></script>
<script>
var config = {
databaseURL: "https://rsvp-dbb88.firebaseio.com"
};
firebase.initializeApp(config);
var database = firebase.database();
</script>
<meta charset='UTF-8'>
<title>Importing data in Firebase</title>
</head>
<body>
<div id="content">
doe;jane@doe.com, john@doe.com; jane doe, john doe, baby doe;true
trump;donald@trump.gov; donald trump;false
</div>
<script>
function extractFromList(nameList){
var nameArray = nameList.split(",");
var names = [];
for(var i = 0; i < nameArray.length; i++){
names.push(nameArray[i].trim());
}
return names;
}
var data = document.getElementById("content").textContent;
var lines = data.split("\n");
for(var i =0; i < lines.length; i++){
var line = lines[i].trim();
if(line.length === 0){
console.log('line ', i, ' was empty');
}
else{
console.log(line);
var elements = line.split(";");
if(elements.length !=4 ) {
console.log('following line is not correctly formatted, skipping : ', line);
continue;
}
var key = elements[0].trim();
var emails = extractFromList(elements[1]);
var names = extractFromList(elements[2]);
var isAmerican = (elements[3] == 'true');
console.log('saving ', key);
firebase.database().ref('attendees/' + key).set({
emails: emails,
names: names,
isAmerican : isAmerican
});
}
}
alert("Finito!");
</script>
</body>
</html>