Importing Complex Data

Hi all,

I'm starting a contract project helping to convert an automated workflow-based system to BPM Online. Our Database is fully 3rd normal form with over 60 tables. In the grand scheme of things, it's a pretty small database, however for import into BPM Online, it seems to be pushing the limits when it comes to importing data.

BPM Online will be substantially customized with forms and workflow. 

At this point, I'm struggling with two different issues:

1. I've been told that Excel spreadsheets are the only way to import legacy data, and each spreadsheet can only be a maximum of 10 MB. Some of our tables have almost a million rows each and will be 20+ spreadsheets each. That means we'll have more than a hundred separate import runs.

2. A test loading one spreadsheet of one of our tables with 60 columns took an hour. It appears that we're looking at over 100 hours runtime, just to load our data.

This seems burdensome for import into an enterprise class appplication like BPM Online. Is there another approach?

BTW, I'm not sure which product and version we'll be on. I marked Enterprise.

Thanks in advance to all,

Bill