Thanks a lot for the advice! I'll get started on working the situation out today or tomorrow, and will report my results in this conversation.
/Oliver On Thu, Jun 12, 2008 at 7:45 PM, <[EMAIL PROTECTED]> wrote: > On 11 Jun 2008, at 16:59, Simon Rozet wrote: > >> Woops, forget to "reply to all"... sorry Reinier > >> >>> Importing is still on the todo list and is being looked at, >>> but that does not help you now. I think you are right in that >>> some sort of banner and editing the text about moving between >>> installation, can help prevent people from getting in >>> your situation. >> >> I juts spotted yaml_db [1] on github which may help. >> >> [1]: http://github.com/adamwiggins/yaml_db/tree/master > > Oliver, so sorry about this. It's all my fault really, because I tried > to implement importing but didn't manage to get anything working well. > We had already renamed the import/export page to just 'Export', but we > forgot to remove the text on the page. > > Anyway, I've downloaded the plugin Simon pointed to, and it works very > well (at least with SQLite3, which is what I've tested with). However, > your problem, if I understand it correctly, is that you don't have the > original database, but only the YAML dump file, created through our > export page. > > The format for the yaml_db plugin is a bit different from our format. > So, for the todos table, with a few contents, we have: > > --- > todos: > columns: > - id > - context_id > - project_id > - description > - notes > - created_at > - due > - completed_at > - user_id > - show_from > - state > records: > - - "1" > - "1" > - "2" > - Call Bill Gates to find out how much he makes per day > - > - 2006-06-03 14:36:02 > - "2006-06-24" > - > - "1" > - > - active > - - "2" > - "2" > - "3" > - Call dinosaur exterminator > - Ask him if I need to hire a skip for the corpses. > - 2006-06-10 14:36:02 > - "2006-06-24" > - > - "1" > - > - active > - - "3" > - "4" > - > - Buy milk > - > - 2006-06-10 14:36:02 > - > - > - "1" > - > - completed > - - "4" > - "4" > - > - Buy bread > - > - 2006-06-10 14:36:02 > - > - > - "1" > - > - completed > > > So we list the column names first, then the records, with the fields > in the same order. Each record is prefixed with two hyphens with a > space between them, and each field in that record with a single > hyphen. Each table is prefixed with a line containing just 3 hyphens. > I don't think it's impossible that we could (with some text munging) > convert one form to the other. Then in theory, you could just set up a > new SQLite3 db in config/database.yml, then run rake db:load. > > If I get some time, I'll see what I can do. In future, I think it > would be great to create a YAML dump using this plugin, so people > would have an easy import/export process, even if the import had to be > done at the commandline rather than through the web UI. > > cheers, > bsag > > -- > but she's a girl - the weblog of a female geek > http://www.rousette.org.uk > [EMAIL PROTECTED] > > _______________________________________________ > Tracks-discuss mailing list > [email protected] > http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss > _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
