Import 2000

From Pro 9 Wiki
Revision as of 12:15, 20 March 2023 by FuzzyBot (talk | contribs) (Updating to match new version of source page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Import of aggregated traffic costs

The import Import of aggregated traffic costs is a general import link that may be used for any type of aggregated charges on object level. By preparing a file according to this file specification you may import any type of aggregated costs.


How to - Create an import template

Create an import template by pressing show import template under file definition panel.

An excel sample file with the correct import format is created, enter the values according to instructions in sample file.


How to - Do an Import - Common Settings

  1. Compare and adjust the file to the file format definition for the specific import type
    • You can find the file format definitions for most imports by opening the file definition section at the bottom of the import page
    • Fields marked as mandatory (*) must be filled in
    • Ensure that there are no empty rows at the end of the file
  2. Save the file from the other system as a tab separated text file
  3. Give the file a name
    1. Copy it to a shared directory on the server - enter \\server name\directory
      • The server name is the name of the server where Pro 9 is installed
      • The directory is the name of the shared directory where the import file will be placed - e.g. \\server1\import
    2. Copy to a folder on your local computer
      • Contact Servicedesk to change system settings to import by browsing
  4. Open the appropriate import type in the Reports & Integrations view
  5. Enter the name of the import file in the file name or choose file from your local computer
  6. Enter the imports specific settings, specified below
  7. Select to validate during the import; the validation check for the correct number of column, that the data type of each column matches the data in the row and that the max length of each column isn't exceeded
    • No - select if you don´t want to use the validate function or if the file definition is missing
    • Note: If file definition is missing the validation function have no impact
    • Yes (stop on validation error) - select if you want the import to stop on validation error
    • Yes (continue on validation error) - select if you want the import to show validation error after the import is done
    • Note: Have in mind that a larger file can take longer to validate due to the capacity on the server!
  8. Select data mappings
  9. Check the show when ready box to show the import report in the open view when ready

Note: It is possible to run the same import simultaneous and import more the one file at the time


How to - Do an Import - Import Specific Settings

  1. Select a main group
  2. Select what period the costs should be invoiced on
  3. Select the node the costs apply to
  4. Select object type the costs apply to
  5. Select currency that is used
  6. Select an account to refer the costs to
  7. Define a period for when the costs originated:
    1. Select a start date
    2. Select an end date
  8. Select an organization group where to place new objects
  9. If mark-up is used, enter that in Increase cost with %
    • Enter 10 for a 10% increase
    • To define a discount, enter a negative percentage value
  10. Define a traffic category where to place new traffic types
  11. Check the create new traffic types box if this import should be able to create new traffic types
  12. Click on try
    • The report will display any previously performed imports and any errors in the current import
  13. Check the compilation
  14. If errors have occurred:
    1. Correct any errors
    2. Click on try again
  15. If everything looks OK, click on import
    • If a previous import for the same period, node and start date has been done, it will be replaced
  16. A report with the result of the import is shown


How to - Schedule an Import

  1. Click Schedule this import in the Links menu Icon Links.png
  2. Read more about how to schedule an import

How to - Review Import History and Delete Imports

In the history tab, you can review the import settings or, if needed, delete a previously made import.

  1. Open history tab