Direct and Indexed ProvideX (PVX) Files Home | FAQs & Troubleshooting

 

Direct and Indexed ProvideX files are data files used by the modules. ProvideX files are created by the ProvideX language system from Sage. The Visual Integrator module allows you to import data from any other application software using the ProvideX language. You can also use the Visual Integrator module to import data from Sage 100 data files to other Sage 100 data files.

Direct ProvideX files contain records that are logically sorted by predefined sort fields. Indexed files contain records stored in the order in which they were added to the file. In modules, most data files are Direct ProvideX files. Indexed files are used only to store line detail information, such as Sales Order lines.

Each numeric data field in a ProvideX file is identified by a column number. Each string-type data field is identified by a combination of a column number, starting character position, and field length. This information is assigned to the Column field and the Starting and Length fields for each data item using the Import Field Properties feature (on the Import Job Maintenance Data tab).

Note The Direct file type supports both the Direct ProvideX files and the Mkeyed ProvideX files using only a single key entry.

For more information, see Import File Types.