Editing
Migrating Aiga records
(section)
Jump to navigation
Jump to search
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===Export=== Result sets from above SQL should be saved as CSV and pushed to a subfolder in the Kotahi Teams environment.<ref>One subfolder per team/service.</ref> Since all of this work has to be done on the actual Aiga VM, this is not necessarily as easy as it sounds. Firstly, SQL runs should ideally be done outside of business hours so as not to compromise Aiga app performance. Second, just using SSMS and doing something basic like exporting to CSV is usually excruciating. As a final gripe, we did draft some logic to parse out a user-friendly display name for each file but it turns out that SQL server doesn't even respect regex so that's just... wow.
Summary:
Please note that all contributions to Kautepedia are considered to be released under the Creative Commons Attribution-NonCommercial-ShareAlike (see
Kautepedia:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Navigation menu
Personal tools
British English
Not logged in
Talk
Contributions
Log in
Namespaces
Page
Discussion
British English
Views
Read
Edit
Edit source
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
What links here
Related changes
Special pages
Page information