RODIS Export Issue

[SteveMcBill]

Rich,

Sorry to be a hassle but since Susan and I started using Gilbert-21 we have had an issue with the export to RODIS - one which I can work around but nonetheless one which it would be great if you could take a look at as and when you can find the time.

The problem is in the exported CSV file; the header (with all the column names) looks absolutely spot on BUT after re-saving the file as a .xls file and then try to import the file into RODIS (rECOrd, BioBank or GMLRC versions) it fails. I have been able to get around this by creating my own header (looks identical) in Excel and then copying the rows of data into the new file and re-saving it. This file then imports into RODIS with no problems whatsoever. I have no idea what is causing this at all.

Looks like Gilbert needs to save teh file out as an .xls file and the header needs looking at.

Hope you can help.

Cheers and have a good Xmas and New Year sunshine.

Steve.

[burkmarr]

Hi Steve,
Can you please email me a sample of the following:

1. CSV output.
2. Same CSV output saved to xls which fails to import.
3. Your modified version of above which loads correctly.

Can you zip these up and email to me at the usual address?

Rich

[burkmarr]

Hello Steve - the header in the sample you sent me is different from the headers generated by G21. Your successful file has 'Species' instead of 'Scientific Name' and 'Record Type' instead of 'Record type'. Could that be it? I could just change the output headers if so. I'm not going down the route of producing XLS instead of CSV - that is a sledgehammer to crack a nut: there must be simpler way. You could do a test by altering your successful headers and replacing 'Species' with 'Scientific Name' and 'Record Type' instead of 'Record type' and see if that will import. Let me know what happens.

[SteveMcBill]

Hi Rich, Well firstly, my apologies - I hadn't noticed the differences. Secondly, I have tried amending my changed header file to your column headings and it imports without problem.  However, I then edited original the CSV file from Gilbert-21 to change the headers and the ones in my header file and then saved it out of Excel as an XLS file.  Sadly it gave exactly the same error as before. so, it cannot be the column headers (very sad). Hope that helps though I doubt it was the answer you hoped for. Cheers and thanks. Steve                                                                                                                Steve J. McWilliam Guitar Tab: http://www.stevemcwilliam.co.uk/guitar/tab.htmYouTube Channel:  http://www.youtube.com/user/SteveMcBill ShutterStock Photos: http://submit.shutterstock.com/?ref=9329 rECOrd - (Cheshire's LRC): http://www.rECOrd-LRC.co.uk On Monday, 28 January 2019, 22:36:00 GMT, Rich Burkmar <notifications@github.com> wrote: Hello Steve - the header in the sample you sent me is different from the headers generated by G21. Your successful file has 'Species' instead of 'Scientific Name' and 'Record Type' instead of 'Record type'. Could that be it? I could just change the output headers if so. I'm not going down the route of producing XLS instead of CSV - that is a sledgehammer to crack a nut: there must be simpler way. You could do a test by altering your successful headers and replacing 'Species' with 'Scientific Name' and 'Record Type' instead of 'Record type' and see if that will import. Let me know what happens. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[burkmarr]

Attempted to address this problem in release 3.4.1 of Gilbert 21 but adding an Excel version of the RODIS export but unfortunately Steve Reports that this crashes on his computer when used.