Tag Archives: Download

Tips & Tricks

Automated Report Template for BITS DLPD Dissertation

3 Comments

This is not a blog post, but just sharing the report template used for the final semester dissertation/project at BITS, Pilani. I guess this is common to MS SS & MM courses offered by DLPD (WILPD). This is the result of the numerous email that keep floating during the semester, only adding to the confusion. So I created a Word template that one can use right away, for lazy bums like me who start late. Just define custom properties, and the report template will automatically fill itself up.

Usage:

  1. Download the file from either of the 2 links:
    – DocStoc (latest)
    – Box.Net
  2. On Windows, right-click, go to ‘Properties’, then the ‘Custom’ tab
  3. You will see all the fields used in the document like Report Title, Mentor Name, Student ID, etc.
  4. If not, in MS WORD 2007, go to ‘Prepare’ > ‘Properties’ from the OFFICE menu. Then ‘Document Properties’ > ‘Advanced Properties’ on the yellow band and ‘Custom’ tab on the pop-up.
  5. To modify a value,
    – Click on the field name in the field list
    – Change the ‘Value’ above
    – Click ‘Modify’
    – Repeat this procedure for all fields
  6. Do not delete any of the fields.
  7. Open the document now, select all the text (CTRL + A) and press F9.

I have taken care of the fonts, page numbers, table of contents, etc. You can copy-paste one of the existing chapters to create a new one. However, if something is missing as per the checklist, please bring it to everyone’s attention. We can discuss this via comments below.

Wishing you all good luck without your report & viva!

This intelligent template is dedicated to Sonal Purandare who motivated me to get started on the report and offered immense support in difficult times.

Data & Information

Converting CSV/Excel data to Doctrine YAML fixtures

6 Comments

I had done some research on this topic and found that some script was available in Python. With no knowledge of Python execution, I sought help from stackoverflow & got the answer there pointed to the same Python script 🙁 I decided I had to do something on my own! Ensuring the right no of spaces in the YAML could be a real pain – I haven’t found the error messages to be very friendly.

My challenge was to be able to generate a YAML for a table/schema using the nested-set behaviour in Doctrine. Instead of losing my mind on devising a human-readable format, I reverse engineered. I checked the resulting schema in the database and used that as the base for my CSV. Following this I wrote a simple macro that will output in the required format. This has evolved over a week or so, and has been thoroughly tested. I am sharing this file with 2 examples: one for the JobeetJob schema & other from the Hierarchical Data page on Doctrine.

Let me know if this helps! Vote for the answer on StackOverflow.

To start using:

  1. Download the ZIP file CSV/Excel to YAML Generator v2 & unzip it.
  2. Change the model name Continue reading Converting CSV/Excel data to Doctrine YAML fixtures →