migrating DB's

[squire06]

We are currently using an outdated PowerPage 2000 solution for our enterprise and are looking into migrating to PageGate. What's the easiest way to migrate over the DB tables from PowerPage 2000 to PageGate? Any suggestions would be greatly appreciated!

[Tech Support]

If you can export from PowerPage2000 into a Comma Separated Values file, you should be able to then open that CSV file in Excel to edit it. It is possible to import information from a CSV but getting it into a format that can be imported into PageGate might be more than a little tricky.

The reason being is that PageGate can only import comma separated values files, which (of course) Excel can read and create. The trick is that due to the fact we use the Microsoft Jet Engine Database standard, we have to be incredibly picky about what goes in what field.

Here is the exact format you'll want to use:

"401","recipient","Full Name","ID/PIN","carrier_name_in_pagegate","","240",#FALSE#,"999",#FALSE#,#TRUE#,#FALSE#,#FALSE#,#TRUE#,#FALSE#,#FALSE#,#TRUE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,"0",#FALSE#,"",#FALSE#,"","","","","","","","","","","","","","","",#FALSE#,#FALSE#,#TRUE#,"",#FALSE#,#FALSE#,"",#FALSE#,"","","","",#FALSE#,"10:00:00
PM","8:00:00 AM"

I know, it's a long string, but the only truly important things in that long long string are the first 8 or so values. The rest are mostly background information that the database uses to reference other command functions of PageGate and which modules should this person have, etc.

I hope that helps but if you need anything else, let me know.