User Tools

Site Tools


Get the Most Out of Your ERP

The Windward Professional Services Catalog

Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.

Follow Windward Software

New Feature Round-up

Data load After Editing Excel Spreadsheet

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

From the Navigator menu, select Inventory and Purchases, Data Load, then Part Load.

Then click From File

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.

Click Next to continue.

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.

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.

Select Load into Regular Parts, and Skip header row, and click next.

Since we have already modified our data from within Excel, we can click next and completely bypass this page.

Click load to begin our data load.

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.

Or you can go ahead and click on exit.

Your data load is now complete

Video Example

= Steve Wind Sept 26 2008 =

dataload_after_excell_edit.txt · Last modified: 2021/05/11 12:03 (3 months ago) by tanya