1. What is SQL to VCF conversion?
The SQL to VCF conversion feature on ConversionTab allows users to seamlessly transform SQL data into VCF (vCard) format, commonly used for contact information storage.
2. What are the input options for SQL data?
ConversionTab offers users two convenient ways to input their SQL data:
- Text Tab: Users can manually enter SQL data as a valid string in this tab.
- File Tab: Users can upload their SQL file through the 'Drop/Browse File' feature, making it easy to work with existing data.
3. What happens after entering SQL data?
Upon entering SQL data, users are directed to the 'Output Options' section, where the crucial process of mapping SQL attributes to vCard fields takes place. Accurate mapping is essential for ensuring that the resulting vCard file contains the desired contact information.
4. What are the special requirements for mapping Email, Phone, and Address?
Mapping Email, Phone, and Address attributes involves specific requirements to achieve correct conversions:
- Email: Users must select both the attribute type (e.g., Email Work) and the corresponding vCard field (e.g., EMAIL). This ensures that the email address is correctly categorized.
- Phone: Similar to Email, Phone mapping requires users to specify both the attribute type (e.g., Phone Home) and the desired vCard field (e.g., TEL).
- Address: Address mapping involves assigning the attribute type (e.g., Address Home) to the appropriate vCard field (e.g., ADR).
5. What is the 'Include' column?
The 'Include' column is a crucial part of the conversion process. It provides a checkbox for each vCard field. Users can check or uncheck these checkboxes to control whether specific vCard fields are included or excluded in the resulting vCard file. This gives users full control over which information is included based on their preferences.
6. What are the auto-mapped columns and their formats?
ConversionTab provides the convenience of auto-mapped columns and their corresponding formats:
| # | VCF Field | Mapping | Format |
|---|
| 0 | UID | UID | Unique Identifier |
| 1 | TITLE | Title | Title of Contact |
| 2 | FN | Full Name | Full Name of Contact |
| 3 | TEL | Phone Voice | Voice Phone Number |
| 4 | N | N | Name Components |
| 5 | EMAIL | Email Work | Email Address (Work) |
| 6 | CATEGORIES | CATEGORIES | Contact Categories |
| 7 | ADR | Address Home | Home Address |
| 8 | URL | URL | Website URL |
| 9 | NOTE | NOTE | Additional Notes |
| 10 | ORG | Organization | Organization Name |
| 11 | BDAY | Birthday | Date of Birth (YYYYMMDD) |
| 12 | GENDER | GENDER | Gender Information |
| 13 | ROLE | ROLE | Contact's Role |
| 14 | IMPP | IMPP | Instant Messaging Protocol |
| 15 | GEO | GEO | Geographical Coordinates |
This auto-mapping simplifies the conversion process by recognizing and configuring common attributes automatically.
7. How can I handle multi-valued fields like multiple email addresses?
For multi-valued fields, such as multiple email addresses, ConversionTab provides two methods:
- Combine in a Single Attribute: Users can include multiple values in a single SQL attribute, separating them using a specified separator (e.g., Email1, Email2, Email3).
- Add Rows: Alternatively, users can click the '+' button to add additional rows for each value.
This flexibility ensures that multi-valued fields are handled efficiently.
8. How do I get the VCF output?
Once the mapping and settings are complete, users can initiate the conversion process by clicking the 'Convert' button. The resulting VCF data is displayed in a textarea, providing users with two options:
- Copy: Users can copy the generated VCF data for use elsewhere.
- Download: Users can download the VCF file, with the option to specify a custom file name if desired.
This flexibility ensures that users can choose the most suitable method for accessing their converted data.
9. Is there an example XML and a way to reset the input/output data?
ConversionTab provides additional features to enhance the user experience:
- Example XML: Users can access a sample XML by clicking the 'Example' button, which populates the text area with sample data, making it easier to understand the conversion process.
- Reset Functionality: To clear input and output data, users can utilize the 'Clear' button, ensuring a clean slate for new conversions or adjustments.
