Add multiple rows in list

[Martyn Shiner-2]

New to Glom so excuse me if this sounds trivial.

I'd like to be able to add multiple rows to a table using copy and paste
'spreadsheet style'.

I'll try to give some background. My business partner has a forecast
spreadsheet which drives a bunch of Datapilots in OpenOffice (like pivot
tables in excel). I wanted to get the data into postgresql so it is secure
and can be shared between users. The reports feature in Glom is be perfect
for end user reports.

The test Glom app I've written has a single table (like the data tab in
the spreadsheet) with a bunch of reports. The admin user (not developer)
edits the data and imports actuals from our live system. However, I can't
work out how to to allow the selection of groups of rows (say sales of
product A for May 2009) in the list view and copy and paste them onto the
end of the list and then edit - like in spreadsheet. Any ideas? I guess it
would require python coding against a button but the list view currently
doesn't allow multiple record selection so I can't see how I could do it
this way.

Help appreciated
--

Regards

Martyn Shiner

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[Murray Cumming]

On Sat, 2009-09-26 at 19:29 +0100, Martyn Shiner wrote:

> . However, I can't
> work out how to to allow the selection of groups of rows (say sales of
> product A for May 2009) in the list view and copy and paste them onto
> the
> end of the list and then edit - like in spreadsheet. Any ideas? I
> guess it
> would require python coding against a button but the list view
> currently
> doesn't allow multiple record selection so I can't see how I could do
> it
> this way.

Well, you can't even copy and paste a single record in Glom right now. I
guess that could be implemented as a way to add a new record, generating
new primary key IDs if the primary key is autogenerated.

This would be much like what happens now if you export and then import.
I'd like exporting and importing to be scriptable via python, which
should be doable.

Exporting now exports all currently-found records. though I agree that
it would be nice to export selected rows too.


--
murrayc@...
www.murrayc.com
www.openismus.com

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list

[Martyn Shiner-2]

On Sun, 27 Sep 2009 15:07:40 +0200, Murray Cumming <murrayc@...>
wrote:

>
> Well, you can't even copy and paste a single record in Glom right now. I
> guess that could be implemented as a way to add a new record, generating
> new primary key IDs if the primary key is autogenerated.
>
> This would be much like what happens now if you export and then import.
> I'd like exporting and importing to be scriptable via python, which
> should be doable.
>
> Exporting now exports all currently-found records. though I agree that
> it would be nice to export selected rows too.

MY PKs are auto generated so this is not an issue. The python code can
access details about the record selected, right? I guess if there was some
way of selecting multiple records the python code could do the adding of
the new rows based on the selection.

--

Regards

Martyn Shiner

_______________________________________________
glom-devel-list mailing list
glom-devel-list@...
http://mail.gnome.org/mailman/listinfo/glom-devel-list