Very simple: using OpenBiblio's interface, try tab Reports. Let's choose Copy Search for example. Choose Format CSV before hitting the Submit button. Disadvantage: you only get data for columns defined in the report.
Tip: there are many other reports, also for download. And using a custom layout (that would have to be programmed), almost anything is possible.
Advanced: it's also possible to export the complete database, but you'll have to work outside OpenBiblio using SQL.
Thank you for the help! I do need the entire database but I don't think I have the advanced programing knowledge it sounds like is required. I will post on the sourceforge forum maybe someone can walk me through.
Hans van der Weij
Then you should tell us for what purpose the text file is needed!
It is not very complicated if you want to move your OpenBiblio database to a different webhost, or if you need a backup.
If you need to convert the OpenBiblio database to another (library) system, it can be more complicated. It depends on the other system and on the information you have in your database. It is probably not difficult if (almost) all the information of your records is visible in the Bibliography Edit pages.
Our school is converting to a system which needs to have the records as an Excel file in order to upload. I'd like to bring all the information which is visible in the Bibliography Edit pages over to the new system.
Any help is hugely appreciated!
Should I post this question/request on sourceforge? Or would you be willing to try for a few more posts to walk me through to an Excel file?
Use the export report as instructed in the third comment from above.
The report code is untested. The export is limited to fields from database table biblio, so it does not include fields like Edition, Publisher, ISBN, Physical description, etc.
If you also need those fields it's probably better to do the export outside OpenBiblio, using SQL. Then you should ask on the sourceforge forum, but probably it will take more than a few posts...
Hans van der Weij
The code works, Excel can import the exported csv file right when the extension is changed in .txt
Missed a column:
It would be possible to add columns with data from MARC fields / biblio_field table. This requires additional SQL for every column.
Thank you so much, I am back at the school today and will follow your instructions.
Again, I appreciate this so much!
Finally able to get password to get into our openbiblio file at the school. I added this report and ran one. It did contain most of what we need!
A few things though are not coming up - like the columns existed for the topical terms but no data came over. I think I understand why they didn't come up on the report and I am trying to search out the terms used for each biblio field so I could maybe edit slightly and stop bugging you.
I will keep searching through the forums for them but the fields I still need to come up on the report are:
-all the topical terms
-statement of responsibilty