Skip to content

How to Set Up a File for Export in RapidStart for Dynamics NAV

ArcherPoint How-To Blog: Step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV

NOTE: This process will only work for basic Card imports.

If you need to work with more complex projects or a group of imports, contact ArcherPoint for instructions.

Locating RapidStart Services

In the search bar, type Rapid and select the link for RapidStart Services for Microsoft Dynamics NAV.

Search bar with search results.

Figure 1. Search bar with search results.

You should see a screen similar to the one below:

RapidStart menu screen.

Figure 2. RapidStart menu screen.

Step 1 – Configuration Worksheet

  1. Go to the RapidStart Menu.
  2. Select Configuration Worksheet – This is used to create the tables you need for of your imports.
  3. Select New.
  4. Select a Table as the Line Type. NOTE: The Line Type will always be Table.
  5. Enter the table number. If you do not know your table number, you can select the down arrow to see a list of available tables to choose from.
  6. You should now see a table you are going to use for your import.
  7. Click OK to close the screen.

Step 2 – Configuration Package

  1. Go to the RapidStart Menu.
  2. Select Configuration Worksheet.
  3. Go to the line created previously and highlight it.

Highlighted line created previously.

Figure 3. Highlighted line created previously.

  1. Click Actions.
  2. Assign a package.
  3. Create a new package. NOTE: If you already have a package created you can select that at this point
  4. Enter the code.
  5. Enter the Package Name
  6. Check Exclude Config. Tables and click OK

Creating a package.

Figure 4. Creating a package.

  1. Select the Package you created and click OK.

Package assigned to table.

Figure 5. Package assigned to table.

Step 3 – Configuration Template

  1. Go to the RapidStart Menu
  2. Select Configuration Templates.
  3. Select New.
  4. Enter the Code.
  5. Enter the Description.
  6. Enter your Table Number.

Editing the Configuration Template.

Figure 6. Editing the Configuration Template.

  1. Go to the lines section and click in the Field name.
  2. Select the items you want as part of your export and Import Process.

Select items to be part of the export/import process.

Figure 7. Select items to be part of the export/import process.

  1. Make sure the No. Field for the card has a check mark in the Mandatory field.
  2. Click OK to create your new template.

Step 4 – Edit Configuration Package

  1. Go to the RapidStart Menu
  2. Select Configuration Packages.
  3. Select the package created above.
  4. Go to the line section
  5. Highlight and select the No. of Fields Available number.
  6. You should now see a list of all of the available fields in this table.
  7. Click Edit List
    • If you are going to export all of the fields, you do not have to do anything at this point.
    • If you are only gong to export a few fields, click the Clear Include button and then check the Include Field box for those fields you wish to see and update.

Select fields to export.

Figure 8. Select fields to export.

  1. Click OK.
  2. Under Data Template select your template created above.

Select template.

Figure 9. Select template.

  1. Click OK.
  2. Click Apply Package.

Step 5 – Run Configuration Package

  1. Go to the RapidStart Menu.
  2. Select Configuration Packages.
  3. Select the package created above.
  4. Click Actions.
  5. Select Export to Excel.

You should see an exported sheet similar to the one below. This will be specific to the fields you selected above:

Excel workbook containing exported fields.

Figure 10. Excel workbook containing exported fields.

  1. Make the updates you want and save the workbook. NOTE: Do not add or remove any columns as you will not be able to re-import if you do
  2. After you have made the updates, select Import from Excel
  3. Select your updated worksheet.
  4. Once you have done this, you will notice you now have a value in the No. Of Package Records field.

Indication of the number of imported records from Excel workbook.

Figure 11. Indication of the number of imported records from Excel workbook.

  1. If you have error, you will see a red number in the No. Of Package errors field.
  2. Highlight the number and review the error.
  3. Under Actions, Select Show Error on the highlighted line. This will show you what needs to be fixed and re-imported to continue your import.

If necessary, display import errors for correction and re-import.

Figure 12. If necessary, display import errors for correction and re-import.

  1. Once you have no further errors, click Actions.
  2. Click Validate Package.
  3. Click Apply the Package.

You have now successfully created and used RapidStart to update NAV. If you have any questions about this procedure or have other export projects or RapidStart questions, please contact ArcherPoint.

Blog Tags: 
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube
Get Help Now