search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Users need to upload a new version of a database with data added offline #718

Open jajwilson opened 9 years ago

jajwilson commented 9 years ago

As we've found with the 19thC Professions Project, some users want to edit a db offline in software such as Access and then load it into ORDS where their project website is pulling their data. At present, they need to create a new database to do this as it is impossible to upload a db to overwrite and existing one.

We need to allow users to upload a db to overwrite and existing one via adding an 'upload and replace database' button. This should trigger a warning as to the consequences of the action and remind the user to set their old database to Milestone before commencing. The warning should also explain that if the database structure has changed then websites pulling data from the database may behave unexpectedly.

scottbw commented 9 years ago

I think there are several options here to consider:

  1. Upload and merge data: the schema is not modified, data is uploaded and merged with existing data.
  2. Upload and replace data: the schema is not modified, all existing data is deleted and replaced with new data
  3. Upload and replace both schema and data: all tables are dropped, then the import creates a new schema and imports new data.

It sounds like we're proposing (3), which should be quite simple to implement, but it may be worth clarifying with users whether they really wanted (1) or (2).

jajwilson commented 9 years ago

Thanks Scott,

I think that option 1 would certainly be the preferred option for users, especially as it would enable multiple users who are, say, away on fieldwork without regular internet connections to upload their own data when they do have network coverage without overwriting any separate contributions from their peers.

If this isn’t a much greater technical challenge than option 3, then this is what we should do. I suggested option 3 as a quick-fix which should be easy to implement and which solves the immediate problem that Kevin highlighted.

Dave, what’s your opinion on this? If option one will take 5 times or more time to implement than option #3 then maybe it’s best to do #3 as a high priority but add #1 to our road-list of future development?

James

From: scottbw [mailto:notifications@github.com] Sent: 02 October 2015 13:12 To: ox-it/ords ords@noreply.github.com Cc: James Wilson james.wilson@it.ox.ac.uk Subject: Re: [ords] Users need to upload a new version of a database with data added offline (#718)

I think there are several options here to consider:

  1. Upload and merge data: the schema is not modified, data is uploaded and merged with existing data.
  2. Upload and replace data: the schema is not modified, all existing data is deleted and replaced with new data
  3. Upload and replace both schema and data: all tables are dropped, then the import creates a new schema and imports new data.

It sounds like we're proposing (3), which should be quite simple to implement, but it may be worth clarifying with users whether they really wanted (1) or (2).

— Reply to this email directly or view it on GitHubhttps://github.com/ox-it/ords/issues/718#issuecomment-145000419.

jajwilson commented 8 years ago

Upping priority to high due to pressure from Software Solution team.