Databases
StackOverflow2013
Postsdbo
POObjective-C - Parsing a .csv, extracting and inserting information, then displaying the .csv as an interface for editing
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POObjective-C - Parsing a .csv, extracting and inserting information, then displaying the .csv as an interface for editing
    text
    copied!<p>This question has been troubling me for the past week. Below, I will list my issue, and the research I have put into it. </p> <p><strong>The scenario:</strong> I was given a .csv file with 5000 rows and three columns. The three columns are defined as:</p> <p>Site ID|Site Name|Site URL</p> <p><strong>My task:</strong> To create an HTML interface for the designers of the company to rate each site on a scale of 1-5. </p> <p><strong>My plan of action:</strong> I am a new hire. I am getting accustomed to the language I was hired for, which was Objective-C. </p> <p>My algorithm for the project was to:</p> <ol> <li>Parse the .csv</li> <li>Remove the "Site Name" variable</li> <li>Create a new .csv that contains the below variables: Site ID|Site URL|Rating|Image</li> <li>Display the new .csv (with all aforementioned items) as an HTML page where there are toggles for "Ratings", which when pressed, will log the rating into the .csv which it was imported (or loaded) from. </li> </ol> <p>The "Image" section I will be using a piece of software by the name of Paparazzi (on the Mac OS X operating system) which takes a fully formatted screenshot of the main page and saves it as a PNG file. I plan on using the file extension URL (which is stored locally) and load it into the "Image" column, thus when the designer clicks on the image, he is able to load the image that is stored locally. </p> <p><strong>My issue:</strong> As Objective-C is not entirely a scripting language, I am confused with some of the libraries I may need and/or methods I can implement this. I have the algorithm, but I am wholy unsure with the implementation. </p> <p><strong>My questions:</strong> If you have done a project similar to this before with Objective-C, what tips can you provide for me? How does one load the .csv as a HTML interface where upon edit, it will save this edit into the .csv? Will I need any servers for this, or is everything executable from just a machine? How do you grab an image (stored locally), extract its file extension, and load it onto the .csv? </p> <p>The most important question: Is this achievable through Objective-C? My reasoning behind it is, I want to advance my knowledge of OC through a task like this. Yes, using Python is easier, but is it possible to do this with Objective-C?</p> <p>Thank you. </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload