Problem loading external data
Posted: April 5th, 2013, 1:33 pm
I'm having a problem getting an external data file (master list of bank account numbers) to load correctly for a data entry template (to be used with 'loadcase'). The data was originally in stata format, but I exported to excel and saved as .prn. When I open this with its own dictionary, it loads without a problem. However, when I add its dictionary to the CSPro data entry template I'm developing (for checking account transactions) and try to run data entry, I get an error message. The data in the external file is uniquely identified by account number. The checking account template will also be identified by account number.
The error message I receive is the following:
Duplicate case ids: 'Label='
in file "...masterfile.dcf"
It fails to create an index, and so CSEntry will not load.
I would like to know what that message means, and suggestions for solving the problem.
From my own troubleshooting, I have established the following:
1. There are no duplicated account numbers in the data file
2. Neither the variable names nor labels are duplicated between the two dictionaries.
3. When I open the data file with its own dictionary, it opens without a problem. (and finds no duplicates)
4. The logic I've written for the new template compiles (though I don't think the logic has anything to do with the problem, since I get the error message before CSEntry actually opens).
5. I exported the data to CSPro format using its own dictionary and used that as the external data file (instead of the .prn file). This made no difference.
6. Both dictionaries have no record type, and only one ID variable (account number), which matches the data file.
If anyone has any insights into how to resolve this error I'd really appreciate it!
cheers,
Maria
The error message I receive is the following:
Duplicate case ids: 'Label='
in file "...masterfile.dcf"
It fails to create an index, and so CSEntry will not load.
I would like to know what that message means, and suggestions for solving the problem.
From my own troubleshooting, I have established the following:
1. There are no duplicated account numbers in the data file
2. Neither the variable names nor labels are duplicated between the two dictionaries.
3. When I open the data file with its own dictionary, it opens without a problem. (and finds no duplicates)
4. The logic I've written for the new template compiles (though I don't think the logic has anything to do with the problem, since I get the error message before CSEntry actually opens).
5. I exported the data to CSPro format using its own dictionary and used that as the external data file (instead of the .prn file). This made no difference.
6. Both dictionaries have no record type, and only one ID variable (account number), which matches the data file.
If anyone has any insights into how to resolve this error I'd really appreciate it!
cheers,
Maria