Question

i did the task of importing csv file to MySql databse. But now my requirements are: 1. Rows and columns of csv file should match with rows and columns of MySql database such that if any row or column is missing, it should raise an error: "Missing @row1 or column 2".. 2. In my code, table header i.e. name, location, city etc; headings are often repeating on every import.

我的法典如下:

def load_csv

end

 def import_csv
csv=params[:file].read
n=0
parsed_file = CSV.parse(csv)
parsed_file.each  do |row|
i=User.new
i.name = row[0]
i.location = row[1]
i.city = row[2]
if i.valid?
i.save
n=n+1
GC.start if n%50==0
flash[:notice] = "CSV Imported Successfully, with  #{n} records"                                
end
end

In views:

<%= form_for(:user, :url => import_csv_user_path,  :html => {:multipart => true}) do |f| %>
 <table>
<tr>
<td>
<label for="dump_file">
Select a CSV File :
</label>
</td>
<td ><%= file_field_tag :file -%></td>
</tr>
<tr>
<td colspan= 2 ><%= submit_tag  Submit  -%></td>
</tr>
</table>
<% end -%>

请帮助我

Answer 1

我与你目前的工作一样。然而,我认为,这样做是一种非常好/有远见的前瞻性/想法/可取的解决办法,因为(验证CSV档案)并不是一项非常好的要求,因为我对数据库/模型的“转化控制”也是如此。这或许是你制定的所有法典,特别是对那些不是专家的人。

OK提出投诉。请允许我谈谈我的解决方法:

通过javascript。我没有以这种方式加以执行,但我倾向于这样做。步骤:
1. read local csv file( refer to jasmine s approach to load test fixture).
2. validate the columns between csv and database table s.
3. show result. if not pass, give user warning message.
通过远程垃圾处理法: 我以这种方式这样做,认为这样做并不好(也许我利用了许多支职...... d脏,而不是leg,难以检测,反应迟缓,ja......等) 如果是,仅使用直线的html页,而不是“方言”或“模式窗口”。
1. update file to remote server.
2. validate the csv file in remote server.
3. give user warning message if validation failed.

友情链接