Bdtjtk

I know more python and R than JavaScript and I am currently trying to write a program that uses the node.js module "themeparks" in order to create a database of wait times for analytical purposes. I'm going off the examples for the app that rely on for-loops for writing the "wait times" for rides and the ride name itself. I plan on running one for loop for the ride name in the exact same manner as the ride.waiTime for the csv header, but setup a scheduler to not run as often.

Long story short, I am currently trying to make this for loop begin on a new row in the csv file, but instead I either get continuous columns added every time the for loop is run, or when I try to att "rn" within the for loop, it wants put each wait time on a new row (which I understand.

I simple want to start this forloop on a new row (the next one) everytime it runs, except maybe the first time if that's possible?

// include the Themeparks library

var Themeparks = require("themeparks");

var fs = require('fs');



//Date

var datetime = require('node-datetime');

var dt = datetime.create();

var TodayDate = dt.format('m-d-Y');

var newLine= "rn";





// access a specific park



var disneyMagicKingdom = new Themeparks.Parks.WaltDisneyWorldMagicKingdom

// access wait times by Promise

disneyMagicKingdom.GetWaitTimes().then(function(rides){





for(var i=0 , ride; ride=rides[i++];) 

{

    //console.log((ride.name + ": " + ride.waitTime + " minutes wait"))

    fs.appendFileSync( TodayDate + ' MK.csv', ride.waitTime + ", " );

}

}, console.error);

Okay, so I made some assumptions based on what I'd expect this CSV to look like, so let me know if this is correct. Here is the example output I was able to get this, including a header:

Ride_Name,Wait_Time

"Stitch's Great Escape! - Temporarily Closed",0

"Monsters, Inc. Laugh Floor",25

"Walt Disney World Railroad - Frontierland",0

"Walt Disney's Enchanted Tiki Room",0

"Sorcerers of the Magic Kingdom",0

"The Barnstormer",65

"Walt Disney World Railroad - Fantasyland",0

"Casey Jr. Splash 'N' Soak Station",0

"Cinderella Castle",0

"Under the Sea - Journey of The Little Mermaid",70

...

"The Magic Carpets of Aladdin",0

"The Many Adventures of Winnie the Pooh",70

"Tom Sawyer Island",0

"Tomorrowland Speedway",55

"Tomorrowland Transit Authority PeopleMover",35

"Walt Disney World Railroad - Main Street, U.S.A.",0

"Walt Disney's Carousel of Progress",0

"Country Bear Jamboree",0

"The Hall of Presidents",0

A couple things to note, before I show the code. You typically want to make sure there's no extra spaces between the values and the commas, as that could be considered data to whatever is parsing your CSV file. I also added quotes to the names of the rides, since as you can see, Monsters, Inc. Laugh Floor has a comma, Monsters and Inc. Laugh Floor were being split into two columns. Now let's talk about the code:

First thing, to get the header, you can just print that header to your file, outside of the for loop you have. Then, I modified fs.appendFileSync( TodayDate + ' MK.csv', ride.waitTime + ", " ); to print the ride name (wrapped in quotes) and removed the extra space after the ,. After that line is printed, in order to go to the new line, I appended a "rn" to the line, so that the next row of data is properly inserted at below the next line. The code could definitely be simplified, but I kept the new line piece separate for examples sake.

// Print the header with the Ride_Name and Wait_Time, before looping through the data

// Printing it before will prevent it from being printed before each row of data

fs.appendFileSync(TodayDate + ' MK.csv', 'Ride_Name,Wait_Timern');



disneyMagicKingdom.GetWaitTimes().then(function(rides) {



    for(var i=0 , ride; ride=rides[i++];)

    {

        // Write out the data in this format: "<RIDE NAME>",<WAIT TIME>

        fs.appendFileSync( TodayDate + ' MK.csv', """ + ride.name + """ + "," + ride.waitTime);

        // Write out a new line so that when this loop repeats, the next row will be written on its own line

        fs.appendFileSync(TodayDate + ' MK.csv', 'rn');

    }

}, console.error);