Lesson 6 - Bulk Updates

Copying data to Excel

Copying a block of cells.

In a table view, place a mouse pointer on a starting cell's border and move it until the pointer changes to a plus sign. Press left mouse button and move to the ending cell. Release the button and press Ctrl+C to copy the marked data block into the clipboard.

Export Item Master List

Open Excel spreadsheet and right-click on the starting cell and select Paste from the popup menu or just use Ctrl+V to paste your data.

Paste Item Master List Data

The data block will appear in the spreadsheet.

The data block in a spreadsheet

Copying a few rows.

Place a mouse pointer on a record selector or a first row. Press left mouse button and move it down to the last row. Release the button and press Ctrl+C to copy the marked rows into the clipboard.

Selecting a few data rows

Copying a few columns.

Place a mouse pointer on a title of the first column. Press left mouse button and move it right to the last column. Release the button and press Ctrl+C to copy the marked columns into the clipboard.

Selecting a few data columns

Before marking columns, you can move unwanted columns out of the block by placing a mouse pointer on the title, pressing the left mouse button, and dragging the column to the right.

Copying all rows.

Click the top-left corner of the table view screen, press Ctrl+C, return to the spread sheet, click a cell to start insert from , and press Ctrl+V.

Selecting all data rows

Exporting Data to a spreadsheet

In Almyta, you can find a few pre-defined data exports. You can also add a number of new exports or we can email you some upon a request. Let us export Item Master List into a spreadsheet. On the Data/Saved Exports screen, select Export Item Master List , and click the CSV button. The CSV format is handled by all spreadsheet applications, it contains only data, but no formatting. Therefore, it is the most portable and compact way to manage your data when formatting is not involved.

Exporting Data to a spreadsheet

Importing Data from Excel Save your spreadsheet in CSV format. In Microsoft Excel, use File/Save As or in later version, click the Office button, choose Save As and then other formats.

Saving Excel file in CSV format

Choose CSV (comma-delimited) type of file.

Picking a proper spreadsheet format

Start your company in Almyta and go to the Data/Import. (1) Select Item Master List in the Import Database list (2) Click the Load File button If your CSV file contains column headers, check First Row is a Header and click Map. Otherwise, choose column names at the top of the table for each column you want to import. (3) Click the Import button

Importing Item Master List back into Inventory Software

Before clicking the Import button, you can modify any data in the fields and/or add new records at the bottom of the table.






Last updated on December 27, 2012

Resources

Packages & Extras

Lessons & Tutorials

Inventory Articles




| Buy Now | Help | Software License | Privacy Policy | Free Software |
| Inventory Software Module | Why Almyta Inventory Software? |
Inventory Software Lessons: | 0 | 1 | 2 | 3 | 4 | 5 | 6 |

© almyta systems 2003 - 2024