data-importer

What is a good design pattern to implement a dynamic data importer tool?

We are planning to build a dynamic data import tool. Basically taking information on one end in a specified format (access, excel, csv) and upload it into an web service. The situation is that we do not know the export field names, so the application will need to be able to see the wsdl definition and map to the valid entries in the o...

Has anyone tried the trac to fogbugz conversion/import tool?

http://our.fogbugz.com/default.asp?W977 I suspect it will be a simple task, but just thought I would ask before I tried it. If you have used it, how did it go? Any caveats or things to help? Can the changes be undone automatically? Anything you would have done differently or configured in trac beforehand to make it go easier? By th...

Abinitio & Recommended Usage Scenarios for Data Import / Export Processes

I'm curious to find out if anyone has some real world experience using Abinitio for data imports, manipulation, exports and if you highly recommend it. I'm looking to solve a scalability issue with this process and would like some feedback if it solved these problems. I've heard that it's a great tool for doing this. ...

Is there a 3rd party .NET library/assembly that will parse & import files using a metadata-driven approach?

Hi, I need to parse a bunch of delimited flat files and import them into a database. I could build my own simple metadata-driven parser and importer but figure there must be something like this out there already? Thanks, Dave. ...

How to import initial data to database with Hibernate?

When deploying applications, I often use Hibernate’s capacity to create database schema in order to simplify the deployment. This is easily achievable by configuring hibernate.hbm2ddl.auto property. However, on occasion I also need to insert some initial data to database, for example root user. Is there a way I could achieve this via h...

Benefit of using API over protocol for application extension / plugin

The application I am working on supports importing data defined in different ASCII formats. I want to allow users to define their own ASCII based file formats which the application can import. I am considering two different approaches: API. Make a script API e.g. Lua, Python or JavaScript which allows constructing data. Importer will ...

Migrate SQL Server Tables to Sharepoint Lists

I have some tables (aprox 200) i want migrate and include in Sharepoint lists. I need a automatic process, anyone have a tool or code to generate sharepoint list based on tables? Or please give some links for can help me in my demand. ...

"Upload" a file from django shell

I need to import some data from a excel file and a folder with images, every row in the excel describes every entry and have a list of filenames in the folder (photos related to the entry). I've done a script which creates every entry in the database and saves it trough the django shell, but i have no idea how to instantiate a InMemoryU...