Abrianto
Accueil Aller à l'Application

Import/Export Guide

Overview

Import and export functionality in Abrianto Collections CRM allows you to move data in and out of the system efficiently. Whether you’re migrating data from another system, bulk uploading accounts or debtors, or exporting data for reporting and record-keeping, this guide explains how to use these features effectively.

What Can Be Imported

Importable Data Types

Accounts

  • Individual accounts
  • Account balances and details
  • Account statuses
  • Agent assignments
  • Due dates

Debtors

  • Debtor profiles
  • Contact information
  • Company details
  • Multiple contacts
  • Communication preferences

Transactions

  • Payment records
  • Fee charges
  • Balance adjustments
  • Transaction notes

Contacts

  • Contact persons
  • Contact details
  • Contact roles
  • Contact history

Custom Data

  • Custom parameters
  • Custom values
  • User data
  • Configuration data

Import Process

Importing Accounts

Method 1: CSV Import

Step 1: Prepare CSV File

  1. Create or download CSV template
  2. Follow column requirements
  3. Fill in account information:
    • Account name
    • Outstanding balance
    • Due date
    • Agent assignment
    • Status
  4. Save CSV file

Step 2: Start Import

  1. Navigate to Import section
  2. Choose import type: Accounts
  3. Upload CSV file
  4. Click “Start Import”

Step 3: Review Import

  1. System validates data:
    • Checks for required fields
    • Validates data formats
    • Identifies potential errors
  2. Review validation results:
    • See which records pass
    • Identify errors
    • Review warnings

Step 4: Configure Import Options

  1. Set import options:
    • Update Existing: Update matching accounts
    • Create New: Only create new accounts
    • Skip Duplicates: Skip accounts that already exist
    • Map Fields: Map CSV columns to system fields
  2. Choose action for errors:
    • Skip error records
    • Log errors
    • Request review

Step 5: Complete Import

  1. Review import summary:
    • Total records processed
    • Successful records
    • Failed records
    • Error details
  2. Click “Complete Import”
  3. View import results

Method 2: API Import

Step 1: Prepare Data

  1. Format data as JSON
  2. Include all required fields
  3. Validate data structure
  4. Test with sample data

Step 2: Use Import API

  1. Navigate to import endpoint
  2. Send data with:
    • Authorization header
    • Import configuration
    • Data payload
  3. Receive import status

Step 3: Monitor Progress

  1. Check import status
  2. Monitor processing
  3. Review results

Importing Debtors

CSV Import Steps

  1. Navigate to Import section
  2. Choose import type: Debtors
  3. Upload CSV file
  4. Review validation
  5. Configure options
  6. Complete import

Data Requirements

Required columns:

  • Debtor name
  • Company name (if applicable)
  • Primary contact name
  • Primary contact phone
  • Primary contact email

Optional columns:

  • Multiple contacts
  • Custom parameters
  • Communication preferences
  • Account assignments

Importing Transactions

Transaction Import Format

  1. Prepare transaction data:
    • Account identifier
    • Transaction type (payment/fee/adjustment)
    • Amount
    • Transaction date
    • Payment method
    • Notes
  2. Upload transaction file
  3. System maps to transactions
  4. Review and complete

Bulk Import Best Practices

Data Preparation

  1. Clean and validate data
  2. Remove duplicates
  3. Standardize formats
  4. Remove special characters
  5. Test with sample data

Import Strategy

  1. Start with small batches
  2. Review results before large imports
  3. Keep backups of source data
  4. Use staging data when possible
  5. Test with development environment

Data Validation

  1. Check required fields
  2. Validate data formats
  3. Verify data relationships
  4. Check for duplicates
  5. Review error messages

Import Templates

Account Import Template

CSV Format:

AccountName,Balance,Status,Agent,DueDate,CustomParameter1,CustomParameter2
"ABC Corporation",$1,250.00,Active,agent1@example.com,2024-01-15,Value1,Value2

Column Descriptions:

  • AccountName: Name of the account
  • Balance: Outstanding balance amount
  • Status: Account status (Active, Paid, Overdue)
  • Agent: Agent email or ID
  • DueDate: When payment is due
  • CustomParameter1-2: Custom parameter values

Debtor Import Template

CSV Format:

DebtorName,CompanyName,ContactName,ContactPhone,ContactEmail,Industry,Region
"John Smith","ABC Corporation","John Doe","+1-555-0100","john@example.com",Retail,East

Column Descriptions:

  • DebtorName: Name of debtor
  • CompanyName: Company name
  • ContactName: Contact person name
  • ContactPhone: Contact phone number
  • ContactEmail: Contact email
  • Industry: Industry type
  • Region: Geographic region

Exporting Data

Exporting Accounts

CSV Export

  1. Navigate to Accounts section
  2. Apply filters if needed
  3. Click “Export” button
  4. Choose CSV format
  5. Click “Export”
  6. Download CSV file

Export Options:

  • Full Export: All account data
  • Selected Fields: Only specific columns
  • Selected Accounts: Only checked accounts
  • With Details: Include account details

PDF Export

  1. Navigate to Accounts section
  2. Apply filters
  3. Click “Export” button
  4. Choose PDF format
  5. Click “Export”
  6. Download PDF file

PDF Export Features:

  • Professional report format
  • Include account details
  • Include transaction history
  • Include custom parameters
  • Print-ready layout

Exporting Debtors

CSV Export

  1. Navigate to Debtors section
  2. Apply filters
  3. Click “Export” button
  4. Choose CSV format
  5. Click “Export”
  6. Download CSV file

Export Options:

  • Full Export: All debtor data
  • With Contacts: Include all contacts
  • With Accounts: Include account information
  • With History: Include interaction history

Exporting Transactions

Transaction Export

  1. Navigate to Transactions section
  2. Apply filters
  3. Click “Export” button
  4. Choose export format
  5. Click “Export”
  6. Download file

Transaction Fields:

  • Account number
  • Transaction type
  • Amount
  • Transaction date
  • Payment method
  • Agent
  • Notes

Exporting Custom Reports

Custom Report Export

  1. Run custom report
  2. View results
  3. Click “Export” button
  4. Choose export format
  5. Click “Export”
  6. Download file

Export Features:

  • Export report data
  • Export visualizations
  • Export aggregated results
  • Export raw data

Import/Export Best Practices

For Import

Data Preparation

  1. Use provided templates
  2. Clean and validate data
  3. Remove duplicates
  4. Standardize formats
  5. Test with sample data

Import Strategy

  1. Start with small batches
  2. Monitor import progress
  3. Review results before large imports
  4. Keep backups of source data
  5. Use staging data when possible

Error Handling

  1. Review error logs
  2. Fix errors in source data
  3. Retry imports
  4. Handle partial imports
  5. Document issues

For Export

Export Strategy

  1. Use appropriate export format
  2. Apply necessary filters
  3. Export relevant data only
  4. Use scheduled exports for regular data
  5. Archive exported data properly

Data Security

  1. Encrypt exported data
  2. Protect sensitive information
  3. Store exports securely
  4. Log export activities
  5. Implement access controls

File Management

  1. Use descriptive filenames
  2. Include date stamps
  3. Organize exported files
  4. Compress large exports
  5. Remove sensitive data from exports

Import/Export Troubleshooting

Import Issues

Import Fails to Start

  • Check file format is correct
  • Verify file size is within limits
  • Check file encoding is correct
  • Ensure all required fields are present

Import Fails Validation

  • Review validation errors
  • Fix data format issues
  • Remove invalid values
  • Add missing required fields
  • Use correct data types

Import Has Partial Results

  • Review partial results
  • Identify failed records
  • Fix and retry failed records
  • Consider manual entry for complex issues

Import Is Slow

  • Check data volume
  • Reduce batch size
  • Optimize data preparation
  • Use incremental imports
  • Check system performance

Export Issues

Export Fails

  • Check export permissions
  • Verify file size limits
  • Review export filters
  • Ensure system is operational

Export Is Slow

  • Reduce data range
  • Remove unnecessary fields
  • Optimize filters
  • Use scheduled exports

Export Format Issues

  • Verify file format compatibility
  • Check encoding settings
  • Review export options
  • Test with different formats

Security and Compliance

Data Security

Protected Data

  • Personally Identifiable Information (PII)
  • Financial data
  • Account credentials
  • System configuration
  • User authentication data

Security Measures

  • Encryption in transit
  • Encryption at rest
  • Access controls
  • Audit logging
  • Compliance reporting

Compliance Considerations

Regulatory Compliance

  • FDCPA requirements
  • State law requirements
  • Data privacy regulations
  • Financial reporting standards
  • Industry-specific regulations

Compliance Requirements

  • Export with consent
  • Protect sensitive data
  • Maintain audit trails
  • Implement access controls
  • Follow data retention policies

Import/Export Automation

Scheduled Imports

Creating Scheduled Imports

  1. Create import configuration
  2. Configure schedule:
    • Daily, weekly, monthly
    • Custom schedule
    • Time zone
    • Start date
  3. Set delivery options:
    • Email results
    • Download file
    • View in dashboard
  4. Save schedule

Managing Scheduled Imports

  1. View all scheduled imports
  2. Edit or delete schedules
  3. Pause or resume imports
  4. Monitor import status
  5. Review results

Scheduled Exports

Creating Scheduled Exports

  1. Create export configuration
  2. Configure schedule:
    • Daily, weekly, monthly
    • Custom schedule
    • Time zone
    • Start date
  3. Set delivery options:
    • Email file
    • Save to storage
    • Upload to database
  4. Save schedule

Managing Scheduled Exports

  1. View all scheduled exports
  2. Edit or delete schedules
  3. Pause or resume exports
  4. Monitor export status
  5. Review results

Getting Help

For support or questions about import/export:

  • Documentation: Check our comprehensive documentation library
  • Support Portal: Submit tickets through your support portal
  • Training Resources: Access video tutorials and guides
  • Contact Support: Reach out to our support team directly

Next Steps

Now that you understand import/export, explore: