Import from excel or access ?

fenixen

I was wondering if this application can import/extract info from excel spreadsheets or access tables?

Can i for example import table information about map coordinates and get them to show on the google map thingy ? :)

seth

You can write scripts to import data from these sources. For Excel you generally process exported delimited text files. For Access, you usually process exported delimited text files, or use ODBC.

There is no automated system for doing this in the current version - you must write your own import scripts. Automating this to the greatest extent possible is an active area of development for us.

seth

fenixen

do you have any scripts for either excel or access at hand which I can take a look at? I don't have any scripting experience myself.

Remi -

Bouvet ASA

seth

Yeah, I do.

I owe a couple of other people sample scripts as well but am really behind... too much travel lately. I will try to get you something to look at in the next couple of days. I expect to have quite a bit of time in airports tomorrow and Wednesday :-)

seth

fenixen

Superb, take your time :)

seth

I apologize for my taking so incredibly long to dust off a script... just too many things go on here.

Anyway, here's a script with comments for you to look at: http://opencollection.org/examples/import_delimited_data_into_oc_example.php.txt

It was originally written to import filmographic data from ProCite, a bibliographic tool, into OpenCollection. ProCite exports tab-delimited data just like Excel, Access and Filemaker, so this script is just as applicable to those tools.

If there is interest I can also post an example of a script that migrates data from Microsoft SQL Server databases to OpenCollection.

seth

derek

Can you repost the sample script? This seems to be a broken link.

stefan

http://collectiveaccess.org/examples/import_delimited_data_into_oc_example.php.txt

aarding

The links for these scripts seem to be out of date. Is there a central/new location at which I can find them? Thanks, Aurora.

seth

Those are ancient version 0.55 scripts. The threat at http://www.collectiveaccess.org/forum/topic.php?id=516#post-2620 has some newer ones you can work from.