Import/Export File Problem
The application has detected a problem and cannot proceed with importing
or exporting the data.
Solution
Decide which error condition applies to your situation. Write down each
error message you receive, so that you have a complete list of the corrections
you need to make in the import or export file.
File access
If the message indicates that the application cannot access, find, initialize,
create, or open a file, or that the file does not exist or is not a script,
or that a file I/O error has occurred, it means that the file as you specified
it is not available for use.
- If you are on a network,
confirm with your system administrator that you have the correct access
rights to the file.
- Check that you have specified
the correct path (drive and folder) and filename.
- If you are exporting,
go to the system prompt and make sure the file is not a read-only file.
If it is, follow the instructions in your operating system manual to remove
the designation.
- If you are exporting,
check the available file space in the target folder. If you do not have
enough free space, delete or move unneeded files.
- Try again to import or
export the data.
If the message recurs, exit Sage HRMS and Windows, reset your computer by pressing the Ctrl, Alt, and
Delete keys simultaneously, then retry the import or export.
File layout or contents
If the message indicates that the file contains incorrect field or record
types, or that data cannot be converted, it means that the file layout
is not correct or the fields are improperly defined or the wrong fields
have been selected.
- If you are importing and
the import file contains errors, go to the application where you created
the import file, then correct the errors. After you have made the corrections,
retry the import.
- Be sure the import file
contains all the fields required by the importing function you are trying
to use, and that it uses the correct file layout. Check each piece of
data to be sure it is formatted and entered as required by the file format
you are using. Make sure the record type is correct.
- If you are importing and
the wrong fields have been selected for import, select the correct fields,
then retry the import.
Note: If
importing failed, the system creates a restart record. The restart record
must be removed before another import can be completed successfully. You
can remove the record either by correcting the error that caused the restart
record in the first place, or by deleting the record in Restart Maintenance
without correcting the error.
- If you are exporting and
the data cannot be converted, the file is damaged. Follow the online Help
instructions for Damaged
Data.
File format
If the message indicates that the file does not have the selected Type,
or has too many fields or records, or an unexpected end-of-file, or an
invalid field title, it means that the Type you selected is incorrect
for the file designation.
- Select the correct Type
(CSV File, Single CSV File, Excel 2000, dBase 5.0, ODBC, XML, Access,
or Excel 5.0).
- Try again to import the
data.