[MCN-L] Exporting Data into a Nice Looking Excel Document

[Kate Blanch]

Hi all,
I'm seeking some popular wisdom regarding tools or methods to help us export 
SQL data into nicely formatted Excel documents. While our driving purpose is to 
create user-friendly exhibition checklists, this solution would assist us in so 
many other information-sharing projects.

Background:
We have a SQL database.
Non-technical users need an interface to query or isolate a data set (users 
could provide a unique ID, but they can't edit SQL view parameters, if you get 
my drift).
Data (including ThumbBLOB images) need to be delivered or exported into a 
somewhat well-formatted Excel spreadsheet that maintains its grid alignment.

Presently we run a Crystal report and export the Crystal report to an Excel 
Data Only format, but the labor involved in reformatting a raw spreadsheet 
every time the data is refreshed is sinking us.
We're open to considering almost any variety of solutions (Excel macros, Visual 
Basic, Crystal Reports, SQL Server Reporting services, .NET, PHP, XML - or 
anything else that works!)

If anyone has good (or bad) experience or advice, it would be very helpful! I 
may be missing something obvious, but I'm not finding a lot of channels for 
solving this problem.

Many thanks!

Kate Blanch
Administrator, Museum Databases
410.547.9000 x.266 | kbla...@thewalters.org

The Walters Art Museum
600 North Charles Street, Baltimore, MD 21201-5185
thewalters.orghttp://thewalters.org/



___
You are currently subscribed to mcn-l, the listserv of the Museum Computer 
Network (http://www.mcn.edu)

To post to this list, send messages to: mcn-l@mcn.edu

To unsubscribe or change mcn-l delivery options visit:
http://mcn.edu/mailman/listinfo/mcn-l

The MCN-L archives can be found at:
http://www.mail-archive.com/mcn-l@mcn.edu/

[MCN-L] Job Opportunity: Imaging Technician Assistant at the Getty Research Institute

[Chris Edwards]

Im hiring for an Imaging Technician Assistant in the Digital Services 
Department at the Getty Research Institute.

The position requires a high school degree and 0-2 years experience.  Ideally 
Id like someone who has digitization experience, better yet, digitization 
experience in a library and/or experience with special collections items.  This 
position will be working primarily in our Digitization on Demand workflow 
(patron requests), will be running a DTRCAM with CaptureOne, and will be 
expected to achieve a dependable throughput of material to support our patron's 
and researcher's needs.  Bonus points are given to individuals with CaptureOne 
experience or certification.

If you know anyone in the greater LA area who would be a good fit for this job, 
please forward the information on.

The posting can be found at: 
https://jobs-getty.icims.com/jobs/2549/imaging-technician-assistant/job

Thanks!

Chris
___
You are currently subscribed to mcn-l, the listserv of the Museum Computer 
Network (http://www.mcn.edu)

To post to this list, send messages to: mcn-l@mcn.edu

To unsubscribe or change mcn-l delivery options visit:
http://mcn.edu/mailman/listinfo/mcn-l

The MCN-L archives can be found at:
http://www.mail-archive.com/mcn-l@mcn.edu/