Topic: Exporting to the NBN, no dates
I am trying to send a data set to the NBN, but when I check the exported data there are no start and end dates. We are on version R6 6.22.2.274 and using NBN Exchange Addin v6.23.
|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Exporting to the NBN, no dates
I am trying to send a data set to the NBN, but when I check the exported data there are no start and end dates. We are on version R6 6.22.2.274 and using NBN Exchange Addin v6.23.
I have tried duplicating this problem using the same versions of R6 and the database as you are using, but without any success. Are all three date fields missing (Start_date, End_date,Date Type) or just the actual date fields ?
Just the Start_date and End_date fields that are missing.
Please can let let me know in detail how you did the export. Was it based on a report of some sort ?. Could you please try just a simple export of one Survey_Event by highlighting it and choosing export data form the tools menu, and select NBN Exchange Addin . This will give just a small file which can be easily checked. I need to know if the dates appear in this. Best checked by opening with notepad.
Yes that is the way I have been trying. I have exported a small survey which is attached, still missing the start_date and End_date. I also note that some of the Sitekeys are missing from this small dataset.
Thanks. This eliminates the source of the data as the problem. Will look further at what it could be. As far as I can see no date processing was changed in the last version of the addin.
Please could you check your default date format through Control panel, Region and language. The calculation of the date depends on these being set to English Uk (dd/MM/yyyy and dd MMMM yyyy)
The Region and Language settings are as follows
Format: English (United Kingdom)
Date and time formats
Short date: dd/MM/yyyy
Long date: dd MMMM yyyy
So much for that idea. Will keep trying.
I have set up an entirely new Pc with V6.22 and v6.23 of the Nbn Exchange Addin and still can't duplicate this. Please could you load the addin again. The OCX file is included in the attached - you might find you can just copy it into the addin folder to replace the one that is there. Otherwise you may need to unistall the existing one and install this one. .
Thanks Mike. It will probably be sometime next week before I’ll get a chance to have a go at this.
I am afraid that did not work. I removed the addin from within Recorder and also removed the file from the Addins folder.
No ides what is happening here. I will have to modify the addin to put out some messages showing what it is happening at the various stages in date processing.
Please could you try the attached XML report which will check if the date is being properly converted.
It should give a report which shows the date as held by recorder and the date in the date this converts to in the normal dd/mm/yyyy format. Copy the file into the report folder of R6. The report will appear under a Menu LC.
I have the xml file at last. I ran the report for 15 minutes and it had not come back with a report after that length of time, so aborted it. Will this report take some time to run before coming back with an answer?.
Please can you see if it will complete given time. I think it is just the size of the database which causing it to take a long time as the query is very straightforward.
I let it run this time and it came back with this error message “There is an error in the SQL code. The error message is: ’Arithmetic overflow error converting expression to date type int’”.
Hi thanks. That is helpful. Please can you try the attached.
Instant result this time, 128428 rows returned. And on a very quick scan through them, they all have a VDS & VDE in the correct format ddmmyyyy. As I did a very quick scan through the result is there anything in particular that I should look for.
At the moment I am not any further forward with this. I am going to have to put some diagnostic code into the addin to try and find out what is going on.
Please could you try the report at
http://forums.nbn.org.uk/viewtopic.php?id=5843
This uses the same code as NBN Extract and may show up why you have a problem.
Hi Mike neither ‘JNCC_NBNExport_Check’ or ‘JNCC_NBN2_Export_Check’ will run, they both give the error message ‘There is an error in the SQL code. The error message is. ‘Incorrect syntax near the keyword ‘Precision’’.
The problem with the report is that the syntax doesn't work in SQL Server 2000 (perhaps also not in 2005). This gave me a clue and and I could duplicate and identify the problem on a SQL Server 2000 installation. The solution requires updating a stored procedure - have you any method of doing this or getting it done ?
I’d have to get the IT people to do this for me.
I think I have the answer, but if IT need to be involved I would like to do some more testing, before supplying the fix.
Forum → How Do I... & Other Questions → Exporting to the NBN, no dates
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.