![]() ![]() "A few hundred products", are you for real? I run LightSpeed for two of my companies and each run well above 7k of inventory. I have been using POS on Macs for over 25 years, what you are saying is absolute BS. Please talk about what you really know and don't make up BS. ![]() There is no way you know both LightSpeed and PIMS to backup your claims. Hello FileMaker & Great Plains flash back. Supplier was found to already exist in the database.Ha ha, yeah I ran PIMS. Supplier exists in database, skipping duplicate supplier. The name of the file saved to your desktop reflects the type of import or update you are doing, such as product_import_log.txt. The Import Log includes any lines that were not imported, the Product Code, and the reason. OnSite displays how many records were imported, and any that were not.Įvery time you import or update data a log file is saved to your desktop that notifies you if any data failed to import, and why. For example, if you have an associate who has already matched fields for the source data that you are also importing, you can import their preset files to save time.Ĭlick Import to import your data. You can export and import preset files to have your fields automatically arranged according to an imported preset file. You can optionally click Presets to save this configuration for a future import so that you do not have to manually re-match the same field order. If there are any records you want to omit from the import, select the Omit This Record checkbox for the record you want to omit. Using the Browse slider, slide it from left to right to review your original data to ensure it will be imported the way you expect. It also means that if the product codes in your original data are not unique, only the first line item creates a new product. This means that if your original data matches a product code with the existing products in OnSite, the record will be skipped. For example, choosing Except Matches on Product Code skips records that have a Product Code identical to one already in the system. In the Options area, you can skip records that match on some fields.For example, if you are importing billing address cities, you can import a number of cities in one import, or you can click the arrow, and choose one city to be imported into all of the records you’re importing. If you do not click the arrow, the values from your source data are imported to the target field of each imported record. If you click the arrow, you can choose a pre-defined value to add it to the records you import. If there is an arrow in the first column it means that this field has a pre-defined set of values in OnSite. You can use the Action gear at the bottom to select or clear all. If you do not want to import data into a field, clear its checkbox. Using the window’s two-column layout, match the target fields in the second column with your source data in the first column by dragging and dropping them into the proper order. To omit a record, use the Browse slider to find the record and click Omit This Record. It is recommended that you include the column headings in your file, as they can be omitted when you do the import but are useful for matching fields. This file must be a tab-delimited text file or a comma-separated text file, and each line should represent a different record. On the Tools menu click Import Tools > Import Suppliers.Ĭlick Open File and find the source file that contains your original data.Auto-populated fields can also include value lists that are defined in OnSite, such as Phone Types (home, work and so on), and checkbox attribute fields that use a built-in Y/N value list. For example, if your source data contains an Account Status of Waiting, add this to the list of Account Statuses in OnSite before you import. Supplier ID you can import (not displayed)Īny data that you import into a pre-defined field (a field with a down arrow) must already exist in OnSite exactly as it appears in the original data. * Make sure that the values you're importing match these OnSite values. Your data needs to match these names, so modify the data you're importing to match these names.Open the file in Microsoft Excel or iWork Numbers to see the data presented in a format that you can use as a guideline for arranging your data. Download and unzip the supplier import template.In OnSite StoreMaster, manually back up your data.Migrating from another POS? Bring your valued suppliers along with OnSite's importing capability, and give your suppliers a seamless transition. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |