Differences

This shows you the differences between two versions of the page.

--- dataload_after_excell_edit [2008/09/26 12:49 (16 years ago)] – swind
+++ dataload_after_excell_edit [2021/05/11 12:03 (3 years ago)] (current) – [Data load After Editing Excel Spreadsheet] tanya
@@ Line 1: / Line 1: @@
-====== Dataload After Editting Excell Spreadsheet ======
+====== Data load After Editing Excel Spreadsheet ======
-[[http://wws5.com/|{{http://wws5.com/images/topxxxgif-ani.gif  |Windward Software}}]]
 ======  ======
-Once you have edditted your inventory information, wether it is adjusting stock counts, or prices, etc. You will need to re-import that data back into System Five. The first thing that you should always do prior to a data load is do a backup. Just in case you either encounter an error or the items are imported into a wrong location.
+Once you have edited your inventory information, whether it is adjusting stock counts, or prices, etc. You will need to re-import that data back into System Five. The first thing that you should always do prior to a data load is do a backup. Just in case you either encounter an error or the items are imported into a wrong location.
 ==== Data Loading The Inventory ====
@@ Line 11: / Line 12: @@
 From the Navigator menu, select Inventory and Purchases, Data Load, then Part Load.
 {{dataload1.jpg|}}
@@ Line 17: / Line 19: @@
 Then click From File
 {{dataload2.jpg|}}
@@ Line 23: / Line 26: @@
 You will then need to browse to the file you created in the previous section, and make sure that the drop down menu shows Comma Separated Values (*.csv). Select your file and click on open.
 {{dataload3.jpg|}}
@@ Line 30: / Line 34: @@
 Click Next to continue.
-{{dataload4.jpg|}}44444
+{{dataload4.jpg|}}
 You will need to match all the columns with the appropriate column field from the drop down box. If you do not want to import a column, then you still must select the column, but select the column field named none. We recommend setting the Category name column to none so that it is ignored.
-  {{dataload5.jpg|}}555555
+{{dataload5.jpg|}}
 The most important column is the Category Column. This one absolutely must be selected, or all items will be placed in one category. Once all the columns have been named, click next.
 {{dataload6.jpg|}}
@@ Line 43: / Line 54: @@
 Select Load into Regular Parts, and Skip header row, and click next.
 {{dataload7.jpg|}}
@@ Line 49: / Line 61: @@
 Since we have already modified our data from within Excel, we can click next and completely bypass this page.
 {{dataload8.jpg|}}
@@ Line 55: / Line 68: @@
 Click load to begin our data load.
 {{dataload9.jpg|}}
@@ Line 60: / Line 74: @@
-When the data load is complete, Click ok, then you can View the Log, which is a more complete listing of what was done during the data load, than what appears in this summary.
+When the data load is complete, Click OK, then you can View the Log, which is a more complete listing of what was done during the data load, than what appears in this summary.
 {{dataload10.jpg|}}
@@ Line 67: / Line 82: @@
 Or you can go ahead and click on exit.
 {{dataload11.jpg|}}
@@ Line 77: / Line 95: @@
+==== Video Example ====
+<HTML>
+<iframe width="560" height="315" src="https://www.youtube.com/embed/iOanjcGLCJ8?rel=0" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
+</HTML>
 ======
-[[http://mywindward.wws5.com|{{  http://wws5.com/support/images/cust_support_banner_bottom.jpg  |myWindward}}]]
+= Steve Wind Sept 26 2008 =