Differences

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

--- dataload_after_excell_edit [2008/09/26 12:47 (16 years ago)] – created 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 ====
-==== Detailed Problem Solution ====
-Data Loading The Inventory
 From the Navigator menu, select Inventory and Purchases, Data Load, then Part Load.
 {{dataload1.jpg|}}
 Then click From File
 {{dataload2.jpg|}}
 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|}}
 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|}}
 Select Load into Regular Parts, and Skip header row, and click next.
 {{dataload7.jpg|}}
 Since we have already modified our data from within Excel, we can click next and completely bypass this page.
 {{dataload8.jpg|}}
 Click load to begin our data load.
-  {{dataload9.jpg|}}999999
-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.
+{{dataload9.jpg|}}
+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 58: / Line 82: @@
 Or you can go ahead and click on exit.
 {{dataload11.jpg|}}
 Your data load is now complete
-I hope that you find this information useful, and hope that this answers your questions. If not, please give us a phone call and we will be happy to assist you further.
+==== 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 =