Import Data
Working with Bulk Data Import in Afina
The "Import Additional Data" section is the central hub of Afina account preparation. It is the place where every batch of profile values finds a home. Users get a smooth experience to push logins, passwords, tokens, identifiers, service parameters, and other data into accounts at scale. Furthermore, the section offers reliable management of column maps, account pairings, selective fields, AccountID lookups, and the data sets attached to each profile.
Once a sheet is loaded into the system, the table presents the entire batch on display. The best part is the convenience: a user can monitor each row, locate any specific record in seconds with the matching column, and apply the bulk write across many profiles in a single click.
Benefits of the Bulk Import Flow
- A wide list of column types is available in the XLSX file for every business need.
- Users can configure which columns travel into the accounts through proper checkbox selection.
- Downstream automation scenarios easily reach into a value through the
${name}construct. - The flow supports both individual record imports and quick bulk uploads at any moment.
- Any user can have a smooth experience while preparing accounts at scale with a unique configuration.
Once the import is saved, the freshly-built data joins the rest of the entries under each paired profile. From this point, a user can run scripts against the values, edit individual records, attach the data to a pipeline, mark older rows for cleanup, link the right column to a workflow, and send the prepared profiles into automation tasks. Thus, every newly-imported value becomes immediately operational.
Building the Excel File
A wide list of reasons exists to use the import feature in Afina. To start with, it offers brilliant speed for batch preparation. Then a user can shift focus to the reliability with already-prepared sheets. The feature is totally effective for setting up a working environment, deploying a large batch of accounts at once, or restoring a known good data set after a system change.
Furthermore, the first row at the top of the file provides uninterrupted access to column naming. A user picks the column flavor and writes the header label inside the first row. The platform takes care of the rest.
Moreover, the import feature supports a connected example file. So, a user can pull a known good sheet straight from the catalog whenever it is needed. After the example file is downloaded, the sheet settles into the local system and becomes immediately ready for launching, configuration, and use inside scripts. Download the example file: EXTRA_DATA.xlsx
Pairing Rows With Accounts
Different pairing scenarios are available for various business needs. Users can drop a row one at a time, or wipe a stack of unpaired entries at once. For routine cleanup, a user ticks the rows in the table with the checkboxes. The bulk option is located inside the matching column at the right side of the table.
Before an upload clicks through, a user should check that the targeted account is no longer wired into an active job, a script, or a workflow that is currently running. The reason is simple: an upload operation pulls related script references, tasks, additional data, and work history along with the account. Thus, an unintended upload may bring extra losses.
On the other hand, manual pairing is not always the right move. Many users prefer to keep an AccountID column inside the sheet, shift its position, swap its value, or switch the column to a fresh identifier. The positive part is that the row simply sits on the bench for a while without any data being permanently lost.
Selective Columns and Variable Use
Each profile in Afina can carry an extensive load of imported data. The data is exactly what scripts and automation jobs reach into during execution. Some examples are logins, passwords, seed phrases, tokens, identifiers, service values, and any other parameter that should look different from one profile to the next.
The best part of this functionality is reusability. One sheet can be used everywhere with consistent results. Each profile plugs in its own values whenever the script reaches the matching field. Instead of cloning the data per profile, a user simply prepares the columns correctly. Thus, automation becomes more flexible.
Furthermore, Afina offers two flavors of imported data: standard and encrypted. Encrypted values are reserved for sensitive material that should not sit around in plain text. Examples include passwords, private keys, seed phrases, and any other confidential value a user wants to keep secure.
Both kinds of data follow the ${name} reference pattern, where "name" matches the column header inside the sheet. The feature is impeccable for keeping a hundred profiles wired to the same data set in one shot. It is not limited here. Users can also pair the import with planned rotation windows, or stash a snapshot of the sheet before any major change is applied.