Merge branch 'master' into sync
diff --git a/erpnext/analysis/search_criteria/trend_analyzer/trend_analyzer.py b/erpnext/analysis/search_criteria/trend_analyzer/trend_analyzer.py
index ad57181..2198204 100644
--- a/erpnext/analysis/search_criteria/trend_analyzer/trend_analyzer.py
+++ b/erpnext/analysis/search_criteria/trend_analyzer/trend_analyzer.py
@@ -107,7 +107,7 @@
# Item Group
if item_group or based_on == 'Item Group':
add_tab += ' ,`tabItem` t3, `tabItem Group` t4 '
- add_cond += ' AND t3.name = t2.item_code AND t3.item_group = t4.name and (t4.name = "%s" or t4.name IN (SELECT t5.name FROM `tabItem Group` t5,`tabItem Group` t6 WHERE t5.lft BETWEEN t6.lft and t6.rgt and t5.docstatus !=2 and ifnull(t5.is_group,"No") = "No" and t6.name = "%s"))' % (based_on != 'Item Group' and item_group or '%(value)s', based_on != 'Item Group' and item_group or '%(value)s')
+ add_cond += ' AND t3.name = t2.item_code AND t3.item_group = t4.name and (t4.name = "%s" or t4.name IN (SELECT t5.name FROM `tabItem Group` t5,`tabItem Group` t6 WHERE t5.lft BETWEEN t6.lft and t6.rgt and t5.docstatus !=2 and t6.name = "%s"))' % (based_on != 'Item Group' and item_group or '%(value)s', based_on != 'Item Group' and item_group or '%(value)s')
# Customer
if customer or based_on == 'Customer':
diff --git a/erpnext/setup/page/import_data/import_data.html b/erpnext/setup/page/import_data/import_data.html
index 5f9556b..29f0cc3 100644
--- a/erpnext/setup/page/import_data/import_data.html
+++ b/erpnext/setup/page/import_data/import_data.html
@@ -41,6 +41,7 @@
<li>Select the saved CSV file, identify the date format if any</li>
<li>Click on "Import"</li>
</ol>
+ <br />
<h4>Over-writing Guide</h4>
<ol>
<li>To over-write data, click on "Do you want to over-write records?" and then download template</li>
@@ -48,6 +49,30 @@
<li>Over-writing of child table data will delete all previous data of child table and re-import. so before over-writing child tables, export all data from system, modify them and then re-import</li>
<li>Over-write checkbox will be checked while importing</li>
</ol>
+ <br />
+ <h4>Do you have Non-English data?</h4>
+ You may need to save the file with UTF-8 encoding for data to be imported correctly.
+ <br /><br />
+ Microsoft Excel Users:<br />
+ There is no obvious way of saving a CSV file with UTF-8 encoding.<br />
+ You will need to follow these steps:
+ <ol>
+ <li>In Excel, save the file in CSV (Comma Delimited) format</li>
+ <li>Open this saved file in Notepad</li>
+ <li>Click on File -> Save As</li>
+ <li>File Name: <your filename>.csv<br />
+ Save as type: Text Documents (*.txt)<br />
+ Encoding: UTF-8
+ </li>
+ <li>Click on Save</li>
+ </ol>
+ <br />
+ OpenOffice or LibreOffice Users:<br />
+ <ol>
+ <li>While saving as CSV, check "Edit Filter Settings".</li>
+ <li>You will be prompted for Encoding.</li>
+ <li>Make sure it is "UTF-8" and click on OK.</li>
+ </ol>
</div>
</td>
<td style="border: 1px solid #AAA; padding: 4px;">