There is nothing in the data that I can think of that would cause a problem.
I will try the NBN Access Data based zipped format and see how that behaves.

The zipped Access export was tested for 6.23  with some very large live datasets (certainly much  larger than  your database)  and nothing took as long as 24 hours, so this suggest that the process is stuck somewhere. I am going to run a further test with a 1million or so record database to see if I can duplicate the problem.

Could be something which is not working efficiently.  How much memory does your machine have and is it a desktop or a laptop ?

Hi

Certainly your machine seem to be up to the task, but an export of this size is going to involve many very complex queries and will in effect create a temporary table of equal size  to the original database, which is going to use a lot of resource.  Just because you are exporting all records it doesn't stop the process going through the very complex routines to work out what needs to be included.

As I don't know you data or your starting point I can't tell if there is a problem or not.  I can see why perhaps some 'references' may not have been exported. however, I am concerned that not all Surveys have gone over. If you start from a list of Surveys  defined say in the Export filter then they should all be included.  If you start by specify a list of species or sample then the Surveys will only get included if they actually have Taxon or  Biotope Occurrences. Is there anything about the missing Surveys which might account for them being excluded ?   

The aim of the export is share Observations between R6 systems. It is designed only  to include from the other tables the minimum required to give a complete structure.  The process is only exporting things like references, measurements etc. if they are actual used by the other data being exported. The process works through the database structure in the appropriate order working out from what has been extracted already what is needed in the next level. So for example if a Reference has not been used then it will not get extracted. This could be the reason why you are mssing some.  Similarly if you have entries in other tables, which are not actually used then they will not be exported.   

I don't think Survey tags are exported. The tag structure is something controlled by the receiving system and exporting these would mess up the structure in the receiving system. 

A number of things affect what is exported.

1. Confidential records are only exported if the Option is set to export Confidential.
2. Unchecked records are not exported
3. Unless Tools/Export Management is used  Failed/or Pending
Verification records (based on the Determination Type) will be excluded.
4. Records in Surveys with a Media type of Temporary will never be exported.
5. Records which fail the External validation checks will not export through XML Export, and will only export
through the Access zipped method if  'Do not validate' is chosen during 'Data Export' '     
6. Data in the two 'Private' fields on samples is not exported. 

   
If we can't explain the missing data then I will need a copy of your database to investigate.

Hi

Login as the default user (password will be 'password'). Go into Tools/User configuration  and remove the User set up with the new copy of R6 (ie not the imported one). You should now be able to delete this user from data entry Name/Addresses. Set up the imported person as  a user through Tools/User configuration. You should now be able to login as this user.