Support Thread

Can Existing Data Be Imported At Any Time After Forum Is Set Up

Can Existing Data Be Imported At Any Time After Forum Is Set Up — APG vNext Guide

Can Existing Data Be Imported At Any Time After Forum Is Set Up — a configuration and setup topic from the APG vNext support community.

Key Configuration Points

  • IIS App Pool: .NET 4.0 Integrated Pipeline mode is required.
  • Connection String: Verify SQL Server name, database, and credentials in web.config.
  • File Permissions: App pool identity needs read/write on the upfiles folder.
  • URL Rewriting: Install IIS URL Rewrite 2.0 module for clean SEO-friendly URLs.
  • Full-Text Search: Enable SQL Server Full-Text Indexing for forum search.

More Help

Importing Existing Data into APG vNext After Setup

Yes - data can be imported into APG vNext at any time after setup. APG vNext includes a built-in import framework that supports structured CSV/XML imports for members, threads, and posts. For migrations from other forum platforms (phpBB, vBulletin, Discourse), migration scripts are available on request.

What Can Be Imported

  • Members - username, email, registration date, group membership
  • Forums and categories - structure, descriptions, permissions
  • Threads and posts - title, HTML content, author, post date
  • File attachments with post associations

CSV Member Import Format

UserName,Email,DisplayName,RegistrationDate,GroupID
john.doe,[email protected],John Doe,2024-01-15,2

Bulk Post Import via SQL

INSERT INTO apg_Posts (ThreadID, AuthorID, PostContent, PostDate)
SELECT t.MappedThreadID, m.MappedMemberID, s.Content, s.OriginalDate
FROM   import_staging_posts s
JOIN   import_thread_map t ON t.OriginalThreadID = s.ThreadID
JOIN   import_member_map m ON m.OriginalMemberID = s.AuthorID;

Post-Import Steps

  • Rebuild full-text search: Admin Panel -> Tools -> Rebuild Full-Text Index
  • Recalculate member post counts: Admin Panel -> Tools -> Recalculate Counts

Related Resources

Importing Existing Data into APG vNext

Yes — APG vNext supports data import at any time, including after the forum is already set up and receiving live traffic. The import process adds data to the existing forum without overwriting or disrupting current content. You can import historical data from another platform (phpBB, vBulletin, Invision Community, etc.) alongside existing live posts.

Supported Import Sources

  • phpBB 3.x — members, posts, forums, private messages, attachments
  • vBulletin 4.x / 5.x — full data migration including reputation and custom fields
  • Invision Community (IPB) — forums, threads, members, and groups
  • SMF (Simple Machines Forum) — basic migration (members, posts, forums)
  • Generic XML/CSV — for custom sources using the APG vNext import schema

Import Process Overview

  1. Export data from the source platform (SQL dump + file exports)
  2. Map source categories/forums to APG vNext forum structure
  3. Run the APG vNext Import Wizard (Admin Panel → Tools → Import)
  4. Select source platform and provide database connection details
  5. Configure member ID conflict resolution (offset or merge by email)
  6. Run import in dry-run mode first to preview results
  7. Execute the live import
  8. Verify post counts, member counts, and attachment links after import

Handling Member ID Conflicts

When importing into a forum with existing members, Member IDs from the import source will conflict with existing APG vNext Member IDs. APG vNext resolves this by offsetting imported Member IDs by the highest existing ID + 1000:

-- Check highest existing MemberID before import:
SELECT MAX(MemberID) AS MaxMemberID FROM apg_Members;
-- APG vNext will offset imported IDs by: MaxMemberID + 1000

-- After import, verify no ID gaps:
SELECT COUNT(*) FROM apg_Members;
SELECT MIN(MemberID), MAX(MemberID) FROM apg_Members;

Post-Import URL Redirect Setup

After importing from another platform, old URLs (e.g., phpBB's viewtopic.php?t=1234) must redirect to the corresponding APG vNext URLs. Configure IIS URL Rewrite rules for each source platform's URL pattern:

<!-- web.config: redirect phpBB viewtopic.php URLs to APG vNext format -->
<rule name="phpBB Thread Redirect" stopProcessing="true">
  <match url="^viewtopic\.php$" />
  <conditions>
    <add input="{QUERY_STRING}" pattern="t=(\d+)" />
  </conditions>
  <action type="Redirect" url="/community/thread-{C:1}.aspx"
          redirectType="Permanent" />
</rule>

Performance Impact of Import on Live Traffic

Running a large data import on a forum that is already receiving live traffic can cause performance degradation during the import process, as the import writes large volumes of data to the same tables being read and written by live members. Schedule large imports during off-peak hours (e.g., overnight on a weekday) and monitor SQL Server performance during the import using Activity Monitor. For very large imports (1 million+ posts), consider taking the forum offline briefly or enabling read-only mode during the final import stages to ensure data consistency. APG vNext's import tool supports a maintenance mode that displays a friendly notice to members while the import completes, automatically ending when the import finishes successfully.

Importing Attachments and Uploaded Files

Data imports include not just database records (posts, members, threads) but also uploaded file attachments. APG vNext's import tool can copy attachment files from the source forum's upload directory to APG vNext's upfiles folder, updating database references automatically. For large attachment libraries (tens of gigabytes), the file copy can take significantly longer than the database migration — run it as a background job after the main database import completes. Attachment thumbnails need to be regenerated after import; APG vNext provides a bulk thumbnail regeneration tool in Admin Panel → Tools → Regenerate Thumbnails.

Related Resources

Looking for more help? Browse the support forum or check the Knowledge Base.