Re: [gcd-software] Excel / Online Indexing

[Philip Rutledge]

I only started indexing in Feb/2010 but I quickly moved away from the online indexing forms to using Excel simply because I was indexing a lot of runs where the credits generally didn't change much from issue to issue and hence it was easier to set up a table in excel with a column for each issue and index in large batches then import into the system.  It would be nice to be able to combine the issue and sequence information into a single file for a single import rather than having to do it twice but that is a minor point.

So enhancements to the OI to allow entry for multiple issues at the same time would be welcome.  I also find that it is nice to be able to compare multiple series side-by-side to just ensure I'm consistent from issue to issue.  The spreadsheet/table format sounds ideal for this.

Of course the often discussed batch entry would be helpful to enter a single detail (eg: publisher imprint) for a run of issues would be another great enhancement.

Phil

On Tue, May 25, 2010 at 5:58 AM, Alexandros Diamantidis <ad...@hellug.gr> wrote:

* Will Allred [2010-05-25 00:35]:

> In fact, I indexed in Excel and Notepad you young
> whippersnappers.

By the way, indexing in Excel might be easier for some indexers or for
some tasks. Currently one might be able to do something like this by
exporting from Excel as a tab-separated file and importing it in the OI,
but it's a bit fiddly. I was thinking about offering an alternative
OI scheme presenting the issue details in a Javascript/DHTML
spreadsheet-like grid. There are libraries (either on top of jQuery UI
or stand-alone) that would make this not too difficult to implement.

Of course, if we can create an API to contribute data from ouside
applications, anybody will be able to create alternative indexing
interfaces which would be a big win...

[Jochen Garcke]

Am 27.05.2010 21:36, schrieb Philip Rutledge:
> I only started indexing in Feb/2010 but I quickly moved away from the
> online indexing forms to using Excel simply because I was indexing a lot
> of runs where the credits generally didn't change much from issue to
> issue and hence it was easier to set up a table in excel with a column
> for each issue and index in large batches then import into the system.
> It would be nice to be able to combine the issue and sequence
> information into a single file for a single import rather than having to
> do it twice but that is a minor point.

What do you mean by twice ? You can import the issue and story data from
one file ?!

Jochen

[Philip Rutledge]

oops... I incorrectly assumed that you had to have a separate upload for the issue and set of sequences... just checked the wiki and sure enough you can combine the info into a single file!

I jumped to this conclusion simply based on the structure of the web input.

doh!

Phil