Using advanced tools > About creating runtime solutions > Importing data into upgraded runtime solutions
 

Importing data into upgraded runtime solutions

Note  This feature is available when the Use advanced tools general preference is selected. See Using advanced tools.

If you have upgraded a customer's runtime solution, you can include scripts in the new runtime solution files that allow users to import records from the old runtime files. The old files must first be converted to the new file format.

Note  When creating your upgraded runtime solution, use a different extension than the one you used for your old runtime solution.

To prepare your upgraded solution for importing data:

1. Create a folder named "Old Solution Files" inside the folder that contains the new runtime solution database files.

2. Place copies of the old runtime solution database files in the Old Solution Files folder.

3. In each upgraded file, create a script to convert the old solution file and import records from it to the new file.

The functionality of the script should include:

Convert File [<filename of the old version of the solution file>]

Import Records [<old filename with the new solution's extension>]

Close File [<old filename with the new solution's extension>]

4. Add a button to activate the script.

5. Repeat steps 3 and 4 for each upgraded file.

6. Use the Developer Utilities to bind your upgraded solution files into the new runtime database solution.

7. Test your buttons in the runtime application.

Use sample data to make sure the records import properly and data is imported to the correct fields.

8. Distribute the new solution files that contain the buttons.

9. Provide instructions telling users how to import data into the new solution files.

Users can copy their old files into the Old Solution Files folder and use the buttons in the new files to convert the old files and import records from them into the new solution files.