# Saving data from database to text/yaml file

**URL:** <https://www.ruby-forum.com/t/saving-data-from-database-to-text-yaml-file/185980>\
**Category:** Rails\
**Created:** [March 30, 2010, 3:23am UTC](https://www.ruby-forum.com/t/saving-data-from-database-to-text-yaml-file/185980 "2010-03-30T03:23:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![gautam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/7ab992/32.png) [@gautam](https://www.ruby-forum.com/u/gautam)\
**Post date:** [March 30, 2010, 3:23am UTC](https://www.ruby-forum.com/t/saving-data-from-database-to-text-yaml-file/185980/1 "2010-03-30T03:23:33Z")

</div>

Hello all…

I am new to rails.  
I have a rails app in which i want data from my database table into a  
text file.

I have a notices table that has three fields - title, body and user. I  
want this data to be stored in a text or yaml file.

Here is the code of what I am trying to do… But I am not able to get  
it done.

def save  
@notice = Notice.find(params[:id])  
f = File.new("#{RAILS\_ROOT}/public/notice.txt",“w”)  
debugger  
f.write @notice  
f.close  
end

Please help me.

---

<div class="post-metadata">

**Author:** ![gautam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/7ab992/32.png) [@gautam](https://www.ruby-forum.com/u/gautam)\
**Post date:** [March 30, 2010, 6:05pm UTC](https://www.ruby-forum.com/t/saving-data-from-database-to-text-yaml-file/185980/2 "2010-03-30T18:05:23Z")

</div>

@notice is an object. you need to write each attribute to the file.

f.write @notice.title  
f.write @notice.body  
f.write @notice.user

---

<div class="post-metadata">

**Author:** ![gautam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/7ab992/32.png) [@gautam](https://www.ruby-forum.com/u/gautam)\
**Post date:** [March 31, 2010, 10:00am UTC](https://www.ruby-forum.com/t/saving-data-from-database-to-text-yaml-file/185980/3 "2010-03-31T10:00:58Z")

</div>

Thank you for your reply…  
I am posting code for my controller - notices.  
The save method is at the last. I am not able to link and call this  
method and its not working as well.  
Please correct the code and help me.

class NoticesController \< ApplicationController

def index  
@notices = Notice.all

```
respond_to do |format|
  format.html # index.html.erb
  format.xml { render :xml => @notices }
end

```

end

def show  
@notice = Notice.find(params[:id])

```
respond_to do |format|
  format.html # show.html.erb
  format.xml { render :xml => @notice }
end

```

end

def new  
@notice = Notice.new

```
respond_to do |format|
  format.html # new.html.erb
  format.xml { render :xml => @notice }
end

```

end

def edit  
@notice = Notice.find(params[:id])  
end

def create  
@notice = Notice.new(params[:notice])

```
respond_to do |format|
  if @notice.save
    flash[:notice] = 'Notice was successfully created.'
    format.html { redirect_to(@notice) }
    format.xml { render :xml => @notice, :status

```

=\> :created, :location =\> @notice }  
else  
format.html { render :action =\> “new” }  
format.xml { render :xml =\> @notice.errors, :status  
=\> :unprocessable\_entity }  
end  
end  
end

def update  
@notice = Notice.find(params[:id])

```
respond_to do |format|
  if @notice.update_attributes(params[:notice])
    flash[:notice] = 'Notice was successfully updated.'
    format.html { redirect_to(@notice) }
    format.xml { head :ok }
  else
    format.html { render :action => "edit" }
    format.xml { render :xml => @notice.errors, :status

```

=\> :unprocessable\_entity }  
end  
end  
end

def destroy  
@notice = Notice.find(params[:id])  
@notice.destroy

```
respond_to do |format|
  format.html { redirect_to(notices_url) }
  format.xml { head :ok }
end

```

end

def save  
@notice = Notice.find(params[:id])  
f = File.new("#{RAILS\_ROOT}/public/jar/notice.txt",“w”)  
f.write @notice.title  
f.write @notice.body  
f.write @notice.user\_name  
f.close  
end

end