Csveditorpro2 4 18 – Csv Editor And Exporter

broken image


An XML tab let us export CSV files to XML format with various options, while the interesting Fixed Field Length Manager let us configure minimum and maximum field length, set values for all fields. CSV Editor Pro is a must-have app for anyone who want to edit CSV or TXT. It allows you to open any encoded CSV documents, automatically detect text encoding, and parse any encoded text. Moreover, CSV Editor Pro is the best choice for converting CSV into Microsoft Excel and Adobe PDF format. You can open various delimiter CSV files, only needing to choose from among the.

  1. Csv Editor Pro 2 4 18 – Csv Editor And Exporter List
  2. Csv Editor Pro 2 4 18 – Csv Editor And Exporter Data
  3. Csv Editor Pro 2 4 18 – Csv Editor And Exporter Pdf
-->

The WAImportExport tool is the drive preparation and repair tool that you can use with the Microsoft Azure Import/Export service. You can use this tool to copy data to the hard drives you are going to ship to an Azure datacenter. After an import job has completed, you can use this tool to repair any blobs that were corrupted, were missing, or conflicted with other blobs. After you receive the drives from a completed export job, you can use this tool to repair any files that were corrupted or missing on the drives. In this article, we go over the use of this tool.

Prerequisites

Requirements for WAImportExport.exe

  • Machine configuration
    • Windows 7, Windows Server 2008 R2, or a newer Windows operating system
    • .NET Framework 4 must be installed. See FAQ on how to check if .NET Framework is installed on the machine.
  • Storage account key - You need at least one of the account keys for the storage account.

Preparing disk for import job

  • BitLocker - BitLocker must be enabled on the machine running the WAImportExport tool. See the FAQ for how to enable BitLocker.
  • Disks accessible from machine on which WAImportExport Tool is run. See FAQ for disk specification.
  • Source files - The files you plan to import must be accessible from the copy machine, whether they are on a network share or a local hard drive.

Repairing a partially failed import job

  • Copy log file that is generated when Azure Import/Export service copies data between Storage Account and Disk. It is located in your target storage account.

Repairing a partially failed export job

  • Copy log file that is generated when Azure Import/Export service copies data between Storage Account and Disk. It is located in your source storage account.
  • Manifest file - [Optional] Located on exported drive that was returned by Microsoft.

Download and install WAImportExport

Download the latest version of WAImportExport.exe. Extract the zipped content to a directory on your computer.

Your next task is to create CSV files.

Prepare the dataset CSV file

What is dataset CSV

Dataset CSV file is the value of /dataset flag is a CSV file that contains a list of directories and/or a list of files to be copied to target drives. The first step to creating an import job is to determine which directories and files you are going to import. This can be a list of directories, a list of unique files, or a combination of those two. When a directory is included, all files in the directory and its subdirectories will be part of the import job.

For each directory or file to be imported, you must identify a destination virtual directory or blob in the Azure Blob service. You will use these targets as inputs to the WAImportExport tool. Directories should be delimited with the forward slash character '/'.

The following table shows some examples of blob targets:

Source file or directoryDestination blob or virtual directory
H:Videohttps://mystorageaccount.blob.core.windows.net/video
H:Photohttps://mystorageaccount.blob.core.windows.net/photo
K:TempFavoriteVideo.ISOhttps://mystorageaccount.blob.core.windows.net/favorite/FavoriteVideo.ISO
mysharejohnmusichttps://mystorageaccount.blob.core.windows.net/music

Sample dataset.csv

Dataset CSV file fields

Csv Editor Pro 2 4 18 – Csv Editor And Exporter List

FieldDescription
BasePath[Required]
The value of this parameter represents the source where the data to be imported is located. The tool will recursively copy all data located under this path.
Allowed Values: This has to be a valid path on local computer or a valid share path and should be accessible by the user. The directory path must be an absolute path (not a relative path). If the path ends with ', it represents a directory else a path ending without ' represents a file.
No regex is allowed in this field. If the path contains spaces, put it in '.
Example: 'c:DirectorycDirectoryFile.txt'
'FBaseFilesharePath.domain.netsharenamedirectory'
DstBlobPathOrPrefix[Required]
The path to the destination virtual directory in your Windows Azure storage account. The virtual directory may or may not already exist. If it does not exist, Import/Export service will create one.
Be sure to use valid container names when specifying destination virtual directories or blobs. Keep in mind that container names must be lowercase. For container naming rules, see Naming and Referencing Containers, Blobs, and Metadata. If only root is specified, the directory structure of the source is replicated in the destination blob container. If a different directory structure is desired than the one in source, multiple rows of mapping in CSV
You can specify a container, or a blob prefix like music/70s/. The destination directory must begin with the container name, followed by a forward slash '/', and optionally may include a virtual blob directory that ends with '/'.
When the destination container is the root container, you must explicitly specify the root container, including the forward slash, as $root/. Since blobs under the root container cannot include '/' in their names, any subdirectories in the source directory will not be copied when the destination directory is the root container.
Example
If the destination blob path is https://mystorageaccount.blob.core.windows.net/video, the value of this field can be video/
BlobType[Optional] block | page
Currently Import/Export service supports 2 kinds of Blobs. Page blobs and Block BlobsBy default all files will be imported as Block Blobs. And *.vhd and *.vhdx will be imported as Page BlobsThere is a limit on the block-blob and page-blob allowed size. See Storage scalability targets for more information.
Disposition[Optional] rename | no-overwrite | overwrite
This field specifies the copy-behavior during import i.e when data is being uploaded to the storage account from the disk. Available options are: rename|overwrite|no-overwrite.Defaults to 'rename' if nothing specified.
Rename: If an object with same name is present, creates a copy in destination.
Overwrite: overwrites the file with newer file. The file with last-modified wins.
No-overwrite: Skips writing the file if already present.
MetadataFile[Optional]
The value to this field is the metadata file which can be provided if the one needs to preserve the metadata of the objects or provide custom metadata. Path to the metadata file for the destination blobs. See Import/Export service Metadata and Properties File Format for more information
PropertiesFile[Optional]
Path to the property file for the destination blobs. See Import/Export service Metadata and Properties File Format for more information.

Prepare InitialDriveSet or AdditionalDriveSet CSV file

What is driveset CSV

The value of the /InitialDriveSet or /AdditionalDriveSet flag is a CSV file that contains the list of disks to which the drive letters are mapped so that the tool can correctly pick the list of disks to be prepared. If the data size is greater than a single disk size, the WAImportExport tool will distribute the data across multiple disks enlisted in this CSV file in an optimized way.

There is no limit on the number of disks the data can be written to in a single session. The tool will distribute data based on disk size and folder size. It will select the disk that is most optimized for the object-size. The data when uploaded to the storage account will be converged back to the directory structure that was specified in dataset file. In order to create a driveset CSV, follow the steps below.

Create basic volume and assign drive letter

In order to create a basic volume and assign a drive letter, by following the instructions for 'Simpler partition creation' given at Overview of Disk Management.

Sample InitialDriveSet and AdditionalDriveSet CSV file

Driveset CSV file fields

FieldsValue
DriveLetter[Required]
Each drive that is being provided to the tool as the destination needs have a simple NTFS volume on it and a drive letter assigned to it.
Example: R or r
FormatOption[Required] Format | AlreadyFormatted
Format: Specifying this will format all the data on the disk.
AlreadyFormatted: The tool will skip formatting when this value is specified.
SilentOrPromptOnFormat[Required] SilentMode | PromptOnFormat
SilentMode: Providing this value will enable user to run the tool in Silent Mode.
PromptOnFormat: The tool will prompt the user to confirm whether the action is really intended at every format.
If not set, command will abort and display error message: 'Incorrect value for SilentOrPromptOnFormat: none'
Encryption[Required] Encrypt | AlreadyEncrypted
The value of this field decides which disk to encrypt and which not to.
Encrypt: Tool will format the drive. If value of 'FormatOption' field is 'Format' then this value is required to be 'Encrypt'. If 'AlreadyEncrypted' is specified in this case, it will result into an error 'When Format is specified, Encrypt must also be specified'.
AlreadyEncrypted: Tool will decrypt the drive using the BitLockerKey provided in 'ExistingBitLockerKey' Field. If value of 'FormatOption' field is 'AlreadyFormatted', then this value can be either 'Encrypt' or 'AlreadyEncrypted'
ExistingBitLockerKey[Required] If value of 'Encryption' field is 'AlreadyEncrypted'
The value of this field is the BitLocker key that is associated with the particular disk.
This field should be left blank if the value of 'Encryption' field is 'Encrypt'. If BitLocker Key is specified in this case, it will result into an error 'BitLocker Key should not be specified'.
Example: 060456-014509-132033-080300-252615-584177-672089-411631

Preparing disk for import job

To prepare drives for an import job, call the WAImportExport tool with the PrepImport command. Which parameters you include depends on whether this is the first copy session, or a subsequent copy session.

First session

First Copy Session to Copy a Single/Multiple Directory to a single/multiple Disk (depending on what is specified in CSV file)WAImportExport tool PrepImport command for the first copy session to copy directories and/or files with a new copy session:

Example:

Add data in subsequent session

In subsequent copy sessions, you do not need to specify the initial parameters. You need to use the same journal file in order for the tool to remember where it left in the previous session. The state of the copy session is written to the journal file. Here is the syntax for a subsequent copy session to copy additional directories and or files:

Example:

Add drives to latest session

If the data did not fit in specified drives in InitialDriveset, one can use the tool to add additional drives to same copy session.

Note

The session id should match the previous session id. Journal file should match the one specified in previous session.

Example:

Exporter

Abort the latest session:

If a copy session is interrupted and it is not possible to resume (for example, if a source directory proved inaccessible), you must abort the current session so that it can be rolled back and new copy sessions can be started:

Example:

Only the last copy session, if terminated abnormally, can be aborted. Note that you cannot abort the first copy session for a drive. Instead you must restart the copy session with a new journal file.

Resume a latest interrupted session

If a copy session is interrupted for any reason, you can resume it by running the tool with only the journal file specified:

Example:

Important

When you resume a copy session, do not modify the source data files and directories by adding or removing files.

WAImportExport parameters

ParametersDescription
/j:Required
Path to the journal file. A journal file tracks a set of drives and records the progress in preparing these drives. The journal file must always be specified.
/logdir:Optional. The log directory.
Verbose log files as well as some temporary files will be written to this directory. If not specified, current directory will be used as the log directory. The log directory can be specified only once for the same journal file.
/id:Required
The session Id is used to identify a copy session. It is used to ensure accurate recovery of an interrupted copy session.
/ResumeSessionOptional. If the last copy session was terminated abnormally, this parameter can be specified to resume the session.
/AbortSessionOptional. If the last copy session was terminated abnormally, this parameter can be specified to abort the session.
/sn:Required
Only applicable for RepairImport and RepairExport. The name of the storage account.
/sk:Required
The key of the storage account.
/InitialDriveSet:Required When running the first copy session
A CSV file that contains a list of drives to prepare.
/AdditionalDriveSet:Required. When adding drives to current copy session.
A CSV file that contains a list of additional drives to be added.
/r:Required Only applicable for RepairImport and RepairExport.
Path to the file for tracking repair progress. Each drive must have one and only one repair file.
/d:Required. Only applicable for RepairImport and RepairExport. For RepairImport, one or more semicolon-separated directories to repair; For RepairExport, one directory to repair, e.g. root directory of the drive.
/CopyLogFile:Required Only applicable for RepairImport and RepairExport. Path to the drive copy log file (verbose or error).
/ManifestFile:Required Only applicable for RepairExport.
Path to the drive manifest file.
/PathMapFile:Optional. Only applicable for RepairImport.
Path to the file containing mappings of file paths relative to the drive root to locations of actual files (tab-delimited). When first specified, it will be populated with file paths with empty targets, which means either they are not found in TargetDirectories, access denied, with invalid name, or they exist in multiple directories. The path map file can be manually edited to include the correct target paths and specified again for the tool to resolve the file paths correctly.
/ExportBlobListFile:Required. Only applicable for PreviewExport.
Path to the XML file containing list of blob paths or blob path prefixes for the blobs to be exported. The file format is the same as the blob list blob format in the Put Job operation of the Import/Export service REST API.
/DriveSize:Required. Only applicable for PreviewExport.
Size of drives to be used for export. For example, 500 GB, 1.5 TB. Note: 1 GB = 1,000,000,000 bytes1 TB = 1,000,000,000,000 bytes
/DataSet:Required
A CSV file that contains a list of directories and/or a list of files to be copied to target drives.
/silentmodeOptional.
If not specified, it will remind you the requirement of drives and need your confirmation to continue.

Tool output

Sample drive manifest file

Sample journal file (XML) for each drive

Sample journal file (JRN) for session that records the trail of sessions

FAQ

General

What is WAImportExport tool?

The WAImportExport tool is the drive preparation and repair tool that you can use with the Microsoft Azure Import/Export service. You can use this tool to copy data to the hard drives you are going to ship to an Azure data center. After an import job has completed, you can use this tool to repair any blobs that were corrupted, were missing, or conflicted with other blobs. After you receive the drives from a completed export job, you can use this tool to repair any files that were corrupted or missing on the drives.

How does the WAImportExport tool work on multiple source dir and disks?

If the data size is greater than the disk size, the WAImportExport tool will distribute the data across the disks in an optimized way. The data copy to multiple disks can be done in parallel or sequentially. There is no limit on the number of disks the data can be written to simultaneously. The tool will distribute data based on disk size and folder size. It will select the disk that is most optimized for the object-size. The data when uploaded to the storage account will be converged back to the specified directory structure.

Where can I find previous version of WAImportExport tool?

WAImportExport tool has all functionalities that WAImportExport V1 tool had. WAImportExport tool allows users to specify multiple sources and write to multiple drives. Additionally, one can easily manage multiple source locations from which the data needs to be copied in a single CSV file. However, in case you need SAS support or want to copy single source to single disk, you can download WAImportExport V1 Tool and refer to WAImportExport V1 Reference for help with WAImportExport V1 usage.

What is a session ID?

The tool expects the copy session (/id) parameter to be the same if the intent is to spread the data across multiple disks. Maintaining the same name of the copy session will enable user to copy data from one or multiple source locations into one or multiple destination disks/directories. Maintaining same session id enables the tool to pick up the copy of files from where it was left the last time.

However, same copy session cannot be used to import data to different storage accounts.

When copy-session name is same across multiple runs of the tool, the logfile (/logdir) and storage account key (/sk) is also expected to be the same.

SessionId can consist of letters, 0~9, underscore (_), dash (-) or hash (#), and its length must be 3~30.

e.g. session-1 or session#1 or session_1

What is a journal file?

Each time you run the WAImportExport tool to copy files to the hard drive, the tool creates a copy session. The state of the copy session is written to the journal file. If a copy session is interrupted (for example, due to a system power loss), it can be resumed by running the tool again and specifying the journal file on the command line.

For each hard drive that you prepare with the Azure Import/Export Tool, the tool will create a single journal file with name '.xml' where drive Id is the serial number associated to the drive that the tool reads from the disk. You will need the journal files from all of your drives to create the import job. The journal file can also be used to resume drive preparation if the tool is interrupted.

What is a log directory?

The log directory specifies a directory to be used to store verbose logs as well as temporary manifest files. If not specified, the current directory will be used as the log directory. The logs are verbose logs.

Prerequisites

What are the specifications of my disk?

One or more empty 2.5-inch or 3.5-inch SATAII or III or SSD hard drives connected to the copy machine.

How can I enable BitLocker on my machine?

Simple way to check is by right-clicking on System drive. It will show you options for BitLocker if the capability is turned on. If it is off, you won't see it.

Here is an article on how to enable BitLocker

It is possible that your machine does not have TPM chip. If you do not get an output using tpm.msc, look at the next FAQ.

How to disable Trusted Platform Module (TPM) in BitLocker?

Note

Only if there is no TPM in their servers, you need to disable TPM policy. It is not necessary to disable TPM if there is a trusted TPM in user's server.

In order to disable TPM in BitLocker, go through the following steps:

  1. Launch Group Policy Editor by typing gpedit.msc on a command prompt. If Group Policy Editor appears to be unavailable, for enabling BitLocker first. See previous FAQ.
  2. Open Local Computer Policy > Computer Configuration > Administrative Templates > Windows Components> BitLocker Drive Encryption > Operating System Drives.
  3. Edit Require additional authentication at startup policy.
  4. Set the policy to Enabled and make sure Allow BitLocker without a compatible TPM is checked.

How to check if .NET 4 or higher version is installed on my machine?

All Microsoft .NET Framework versions are installed in following directory: %windir%Microsoft.NETFramework

Navigate to the above mentioned part on your target machine where the tool needs to run. Look for folder name starting with 'v4'. Absence of such a directory means .NET 4 is not installed on your machine. You can download .NET 4 on your machine using Microsoft .NET Framework 4 (Web Installer).

Limits

How many drives can I prepare/send at the same time?

There is no limit on the number of disks that the tool can prepare. However, the tool expects drive letters as inputs. That limits it to 25 simultaneous disk preparation. A single job can handle maximum of 10 disks at a time. If you prepare more than 10 disks targeting the same storage account, the disks can be distributed across multiple jobs.

Can I target more than one storage account?

Only one storage account can be submitted per job and in single copy session.

Capabilities

Does WAImportExport.exe encrypt my data?

Photostack 3 6 3 – instagram desktop client. Yes. BitLocker encryption is enabled and required for this process.

What will be the hierarchy of my data when it appears in the storage account?

Although data is distributed across disks, the data when uploaded to the storage account will be converged back to the directory structure specified in the dataset CSV file.

How many of the input disks will have active IO in parallel, when copy is in progress?

The tool distributes data across the input disks based on the size of the input files. That said, the number of active disks in parallel completely depends on the nature of the input data. Depending on the size of individual files in the input dataset, one or more disks may show active IO in parallel. See next question for more details.

How does the tool distribute the files across the disks?

WAImportExport Tool reads and writes files batch by batch, one batch contains max of 100000 files. This means that max 100000 files can be written parallel. Multiple disks are written to simultaneously if these 100000 files are distributed to multi drives. However whether the tool writes to multiple disks simultaneously or a single disk depends on the cumulative size of the batch. For instance, in case of smaller files, if all of 10,0000 files are able to fit in a single drive, tool will write to only one disk during the processing of this batch.

WAImportExport output

There are two journal files, which one should I upload to Azure portal?

.xml - For each hard drive that you prepare with the WAImportExport tool, the tool will create a single journal file with name .xml where DriveID is the serial number associated to the drive that the tool reads from the disk. You will need the journal files from all of your drives to create the import job in the Azure portal. This journal file can also be used to resume drive preparation if the tool is interrupted.

.jrn - The journal file with suffix .jrn contains the status for all copy sessions for a hard drive. It also contains the information needed to create the import job. You must always specify a journal file when running the WAImportExport tool, as well as a copy session ID.

Next steps

CSV file is a commonly used format that contains numbers and texts in a spreadsheet format. The datasets are in text form and each of the new lines is separated by commas that signify a new row of the database. It's simple and helps share huge amounts of data allowing you to view them from any location across the world.

However, to edit these files you would need a CSV editor that are spreadsheet software. This type of software allows you to change the files into cells that help transfer data among different databases. While there are many CSV editors available these days, not all are free.


Therefore, we have shortlisted some of the best CSV editors for Windows that are a mix of the free and paid.

CSVed

CSVed is a free program that can handle any type of CSV file with any type of separator. It has the ability to add, remove, edit, and include items, import and export data, delete duplicate data, connect and break columns, insert, remove, or re-align columns, and more.

And

Abort the latest session:

If a copy session is interrupted and it is not possible to resume (for example, if a source directory proved inaccessible), you must abort the current session so that it can be rolled back and new copy sessions can be started:

Example:

Only the last copy session, if terminated abnormally, can be aborted. Note that you cannot abort the first copy session for a drive. Instead you must restart the copy session with a new journal file.

Resume a latest interrupted session

If a copy session is interrupted for any reason, you can resume it by running the tool with only the journal file specified:

Example:

Important

When you resume a copy session, do not modify the source data files and directories by adding or removing files.

WAImportExport parameters

ParametersDescription
/j:Required
Path to the journal file. A journal file tracks a set of drives and records the progress in preparing these drives. The journal file must always be specified.
/logdir:Optional. The log directory.
Verbose log files as well as some temporary files will be written to this directory. If not specified, current directory will be used as the log directory. The log directory can be specified only once for the same journal file.
/id:Required
The session Id is used to identify a copy session. It is used to ensure accurate recovery of an interrupted copy session.
/ResumeSessionOptional. If the last copy session was terminated abnormally, this parameter can be specified to resume the session.
/AbortSessionOptional. If the last copy session was terminated abnormally, this parameter can be specified to abort the session.
/sn:Required
Only applicable for RepairImport and RepairExport. The name of the storage account.
/sk:Required
The key of the storage account.
/InitialDriveSet:Required When running the first copy session
A CSV file that contains a list of drives to prepare.
/AdditionalDriveSet:Required. When adding drives to current copy session.
A CSV file that contains a list of additional drives to be added.
/r:Required Only applicable for RepairImport and RepairExport.
Path to the file for tracking repair progress. Each drive must have one and only one repair file.
/d:Required. Only applicable for RepairImport and RepairExport. For RepairImport, one or more semicolon-separated directories to repair; For RepairExport, one directory to repair, e.g. root directory of the drive.
/CopyLogFile:Required Only applicable for RepairImport and RepairExport. Path to the drive copy log file (verbose or error).
/ManifestFile:Required Only applicable for RepairExport.
Path to the drive manifest file.
/PathMapFile:Optional. Only applicable for RepairImport.
Path to the file containing mappings of file paths relative to the drive root to locations of actual files (tab-delimited). When first specified, it will be populated with file paths with empty targets, which means either they are not found in TargetDirectories, access denied, with invalid name, or they exist in multiple directories. The path map file can be manually edited to include the correct target paths and specified again for the tool to resolve the file paths correctly.
/ExportBlobListFile:Required. Only applicable for PreviewExport.
Path to the XML file containing list of blob paths or blob path prefixes for the blobs to be exported. The file format is the same as the blob list blob format in the Put Job operation of the Import/Export service REST API.
/DriveSize:Required. Only applicable for PreviewExport.
Size of drives to be used for export. For example, 500 GB, 1.5 TB. Note: 1 GB = 1,000,000,000 bytes1 TB = 1,000,000,000,000 bytes
/DataSet:Required
A CSV file that contains a list of directories and/or a list of files to be copied to target drives.
/silentmodeOptional.
If not specified, it will remind you the requirement of drives and need your confirmation to continue.

Tool output

Sample drive manifest file

Sample journal file (XML) for each drive

Sample journal file (JRN) for session that records the trail of sessions

FAQ

General

What is WAImportExport tool?

The WAImportExport tool is the drive preparation and repair tool that you can use with the Microsoft Azure Import/Export service. You can use this tool to copy data to the hard drives you are going to ship to an Azure data center. After an import job has completed, you can use this tool to repair any blobs that were corrupted, were missing, or conflicted with other blobs. After you receive the drives from a completed export job, you can use this tool to repair any files that were corrupted or missing on the drives.

How does the WAImportExport tool work on multiple source dir and disks?

If the data size is greater than the disk size, the WAImportExport tool will distribute the data across the disks in an optimized way. The data copy to multiple disks can be done in parallel or sequentially. There is no limit on the number of disks the data can be written to simultaneously. The tool will distribute data based on disk size and folder size. It will select the disk that is most optimized for the object-size. The data when uploaded to the storage account will be converged back to the specified directory structure.

Where can I find previous version of WAImportExport tool?

WAImportExport tool has all functionalities that WAImportExport V1 tool had. WAImportExport tool allows users to specify multiple sources and write to multiple drives. Additionally, one can easily manage multiple source locations from which the data needs to be copied in a single CSV file. However, in case you need SAS support or want to copy single source to single disk, you can download WAImportExport V1 Tool and refer to WAImportExport V1 Reference for help with WAImportExport V1 usage.

What is a session ID?

The tool expects the copy session (/id) parameter to be the same if the intent is to spread the data across multiple disks. Maintaining the same name of the copy session will enable user to copy data from one or multiple source locations into one or multiple destination disks/directories. Maintaining same session id enables the tool to pick up the copy of files from where it was left the last time.

However, same copy session cannot be used to import data to different storage accounts.

When copy-session name is same across multiple runs of the tool, the logfile (/logdir) and storage account key (/sk) is also expected to be the same.

SessionId can consist of letters, 0~9, underscore (_), dash (-) or hash (#), and its length must be 3~30.

e.g. session-1 or session#1 or session_1

What is a journal file?

Each time you run the WAImportExport tool to copy files to the hard drive, the tool creates a copy session. The state of the copy session is written to the journal file. If a copy session is interrupted (for example, due to a system power loss), it can be resumed by running the tool again and specifying the journal file on the command line.

For each hard drive that you prepare with the Azure Import/Export Tool, the tool will create a single journal file with name '.xml' where drive Id is the serial number associated to the drive that the tool reads from the disk. You will need the journal files from all of your drives to create the import job. The journal file can also be used to resume drive preparation if the tool is interrupted.

What is a log directory?

The log directory specifies a directory to be used to store verbose logs as well as temporary manifest files. If not specified, the current directory will be used as the log directory. The logs are verbose logs.

Prerequisites

What are the specifications of my disk?

One or more empty 2.5-inch or 3.5-inch SATAII or III or SSD hard drives connected to the copy machine.

How can I enable BitLocker on my machine?

Simple way to check is by right-clicking on System drive. It will show you options for BitLocker if the capability is turned on. If it is off, you won't see it.

Here is an article on how to enable BitLocker

It is possible that your machine does not have TPM chip. If you do not get an output using tpm.msc, look at the next FAQ.

How to disable Trusted Platform Module (TPM) in BitLocker?

Note

Only if there is no TPM in their servers, you need to disable TPM policy. It is not necessary to disable TPM if there is a trusted TPM in user's server.

In order to disable TPM in BitLocker, go through the following steps:

  1. Launch Group Policy Editor by typing gpedit.msc on a command prompt. If Group Policy Editor appears to be unavailable, for enabling BitLocker first. See previous FAQ.
  2. Open Local Computer Policy > Computer Configuration > Administrative Templates > Windows Components> BitLocker Drive Encryption > Operating System Drives.
  3. Edit Require additional authentication at startup policy.
  4. Set the policy to Enabled and make sure Allow BitLocker without a compatible TPM is checked.

How to check if .NET 4 or higher version is installed on my machine?

All Microsoft .NET Framework versions are installed in following directory: %windir%Microsoft.NETFramework

Navigate to the above mentioned part on your target machine where the tool needs to run. Look for folder name starting with 'v4'. Absence of such a directory means .NET 4 is not installed on your machine. You can download .NET 4 on your machine using Microsoft .NET Framework 4 (Web Installer).

Limits

How many drives can I prepare/send at the same time?

There is no limit on the number of disks that the tool can prepare. However, the tool expects drive letters as inputs. That limits it to 25 simultaneous disk preparation. A single job can handle maximum of 10 disks at a time. If you prepare more than 10 disks targeting the same storage account, the disks can be distributed across multiple jobs.

Can I target more than one storage account?

Only one storage account can be submitted per job and in single copy session.

Capabilities

Does WAImportExport.exe encrypt my data?

Photostack 3 6 3 – instagram desktop client. Yes. BitLocker encryption is enabled and required for this process.

What will be the hierarchy of my data when it appears in the storage account?

Although data is distributed across disks, the data when uploaded to the storage account will be converged back to the directory structure specified in the dataset CSV file.

How many of the input disks will have active IO in parallel, when copy is in progress?

The tool distributes data across the input disks based on the size of the input files. That said, the number of active disks in parallel completely depends on the nature of the input data. Depending on the size of individual files in the input dataset, one or more disks may show active IO in parallel. See next question for more details.

How does the tool distribute the files across the disks?

WAImportExport Tool reads and writes files batch by batch, one batch contains max of 100000 files. This means that max 100000 files can be written parallel. Multiple disks are written to simultaneously if these 100000 files are distributed to multi drives. However whether the tool writes to multiple disks simultaneously or a single disk depends on the cumulative size of the batch. For instance, in case of smaller files, if all of 10,0000 files are able to fit in a single drive, tool will write to only one disk during the processing of this batch.

WAImportExport output

There are two journal files, which one should I upload to Azure portal?

.xml - For each hard drive that you prepare with the WAImportExport tool, the tool will create a single journal file with name .xml where DriveID is the serial number associated to the drive that the tool reads from the disk. You will need the journal files from all of your drives to create the import job in the Azure portal. This journal file can also be used to resume drive preparation if the tool is interrupted.

.jrn - The journal file with suffix .jrn contains the status for all copy sessions for a hard drive. It also contains the information needed to create the import job. You must always specify a journal file when running the WAImportExport tool, as well as a copy session ID.

Next steps

CSV file is a commonly used format that contains numbers and texts in a spreadsheet format. The datasets are in text form and each of the new lines is separated by commas that signify a new row of the database. It's simple and helps share huge amounts of data allowing you to view them from any location across the world.

However, to edit these files you would need a CSV editor that are spreadsheet software. This type of software allows you to change the files into cells that help transfer data among different databases. While there are many CSV editors available these days, not all are free.


Therefore, we have shortlisted some of the best CSV editors for Windows that are a mix of the free and paid.

CSVed

CSVed is a free program that can handle any type of CSV file with any type of separator. It has the ability to add, remove, edit, and include items, import and export data, delete duplicate data, connect and break columns, insert, remove, or re-align columns, and more.

It comes with a fully packed interface that features a navigation sidebar, chief document view above the compact editing window, and a four in one toolbar. This easy to use program offers a font manager, and also a portable version.

Price: free

CSVStar

Csv Editor Pro 2 4 18 – Csv Editor And Exporter Data

CSVStar is again a freeware that helps prepare, edit, and take care of CSV files. The interface represents function areas using colors and offers help through a PDF file with instructions. While creating templates, it's much easier to modify the Headers and Trailers with the help of the simple wizards.

Moreover, it offers several functions that help generate the CSV file fields automatically, based on conditions. You can also manage the templates easily that enables you to prepare more such identical files like that of the template. Furthermore, it works with multiple data varieties for its fields such as int, string, enum, etc.

Price: free

iMatrixitor

If you are looking for a CSV editor with comma and tab limited fields, iMatrixitor can be great for you. Aiseesoft hd converter 9 2 8 download free. It works with Unix / PC formats of Text and binary files that are stored both on the native hard disk and on the remote FTP server. The program can open /change/store local and FTP files and also provides support for 'save as' files between local and FTP. The program works with an external define file to format a kind of data file.

The program displays all fields and headers using external define file. It also offers a shared read/write mode, and also allows you to unlock while opening a file. It provides support for Windows and Unix format of new line and number. Moreover, it also offers a function that helps to open and save files from local disk and FTP server. Best of all, it automatically refreshes the opened files both on local disk and FTP server.

Price: free

CSVPad

A small and handy CSV editor and similar files, CSVPad is available to download for free. The program provides support for all types of formats that includes tab separated, colons, semicolons, pipes, dollars, etc. What's interesting is, that it takes care of the details as CSVPad automatically identifies and uses the accurate format all on its own, by default.

It opens the target files in a table, where you can browse or start searching on it, instantly, edit separate fields, and even prolong the file with updated records. For situations where the file structure isn't correct, you can also rearrange rows by adding new rows or columns, make copies or switch them, drag and drop, copy and paste them, or just shift your chosen rows/ columns to some new position.

It also comes with some surprise bonus features, such as 'Snapshot' that saves a table in JPG format, 'Search Online' option that opens a web page with the Google search results for the selected cell. Once you are finished, the file can be stored in CSV format or with the other compatible separators, for instance, tab/ colon/ semi-colon, and more, or exported as XLS, ODS, XML or HTML.

Price: free

LibreOffice Calc

LibreOffice is another free CSV editor that's responsive and easy to learn. It also features an extended range of advanced features liked by professionals across the world. It comes with integrated wizards that walk you through selecting and using wide range of advanced functions. It also allows you to download templates from the LibreOffice template library, for off-the-rack spreadsheet tools.

It makes it convenient for you to apply flexible cell formatting options, and other options like freely rotating contents, borders, templates, and more, using the different styles and direct formatting functions. It also lets you reuse the pre-made sheets and concentrate on the current work using the templates with integrated functions.

Price: free

CSVFileView

Although CSVFileView is just an editor, it still offers a lot more than anticipated. It's a simple and a free tool that lets you view and modify CSV files, despite a neat spreadsheet around. The tool has the ability to open CSV files, automatically identifying the delimiter and quote characters as an option, and also inserting few or all the lines.

The best part is, it puts up the file in a table, where you can sort, rearrange, or hide the columns based on your requirement. Moreover, the tool can also save your data in form of an HTML report, tab or a comma-delimited file, or in XML format. It also features some advanced options like in-depth control over the data you want to view. It also features a command line interface that helps automate the file conversions and other processes.

Price: free

CSV Buddy

CSV Buddy is a completely free CSV editing application that enables you to keep your CSV files ready to import using different types of software. This tool loads, saves, or exports files with multiple delimiters and using many other options. The best part is, it does not need a software to be installed. All you need to do is to extract the content in the zip file to your preferred folder.

You run the .EXE file from this new folder. You can then create a desktop shortcut for the tool for your convenience or on your start menu. Contexts 3 6 1 – fast window switcher systems. This program can be freely shared online in an uninterrupted form.

Price: free

Apache Open Office

Apache Open Office Calc is a spreadsheet program that's a lot similar to the LibreOffice suite. It's a highly responsive and easy to learn software, especially for the beginners. However, it's equally suitable for professionals who simply love the wide range of advanced features.

Among its major features are:

  • DataPilot – a leading technology that makes it easy to extract in raw data from corporate databases.
  • The Natural language formulas – allows you to make formulas using words like 'sales – costs', for example.
  • Intelligent Sum Button – helps add a sum function or a subtotal automatically, based on context.
  • Wizards walk you through how to select and use a wide range of leading spreadsheet functions, or download templates from the Templates library, and more.
  • Styles and Formatting – make it easy to apply flexible cell formatting options.
  • Scenario Manager – allows 'what if …' investigation just as you touch the button.
  • Solver component – lets you solve optimization problems where the optimum value of a specific spreadsheet cell has to be calculated.
  • Multiple users support – allows teamwork on spreadsheets.
  • Allows you to save the spreadsheets in OpenDocument format.

You can also send results to those who don't have a spreadsheet program installed. They can simply use the .pdf and there's no need to buy or install any added software.

Price: free

Ron's Editor Lite

Ron's Editor Lite is a dynamic tool that helps you view, look up, and edit files. The application can be used a plain grid. You can simply drag and drop a CSV file into the application and it shows up in a spreadsheet style view. You can then scroll along it, choose files, lines or columns, arrange the documents by particular fields, and much more.

It comes equipped with a filter system and a dynamic search tool that allows you to get deep down to the information you are looking for. Apart from basic editing (start typing in a field as required, or simply right-click for the options like edit rows, delete rows or columns, insert rows, etc., it also offers some bonus features that includes useful Cell Fill tools.

Price: free

CSVForm

CSVForm is another great free software to edit CSV files. It's a lightweight tool that's also portable. The only limitation is that it allows you to edit the only file at a time. Moreover, the software allows you to insert and delete data, input values, edit values, and much more. Best of all, it does not need to be installed and can be used out-of-the-box.

Price: free

ReCSV

ReCSV is a perfect tool to edit CSV files, as well as files with fixed width. One of its major advantages is that it automatically marks revelation for CSV files with single records. What's more? You can also Fixed Width file and Multi-Record CSV / Fixed width files with the help of a XML Schema. However, the editing capacity for XML and PO files is limited.

Price: free

CSv files are regularly used and so, you would need a powerful tool to help you work around with it. While there are any tools available these days, we have listed the best in the business. Choose the one suits your requirement the best, and get done with any complexity while handling CSV files.

Microsoft Notepad

Microsoft Notepad is one of the powerful and leading text editors available that's used for basic programming. This lightweight tool is also used for editing text format files. Although it's useful for basic functions, being a text editor, it still allows you to change the font, size, and script, and text. Moreover, it's handy for coding HTML and other formats. This integrated tool in the Windows is compatible with different files formats that include CSV, HTML, and CFG. Best of all, it can view and change contents saved in a CSV file format.

Price: free

Corel Quattro Pro

Designed by Corel, the Corel Quattro Pro program is now known as WordPerfect Office. It's a spreadsheet tool and is specially made for the professionals who investigated spreadsheets on a daily basis. While it features basic tools used for calculation, it's also a trusted CSV editor. Moreover, some of its features viz., the Perfect Expert Wizard and Quick-Fit are perfect to create on-the-go spreadsheets.

The software also comes packed with features like Precise Import and Export, PDF Creation with Fillable Fields for forms, Template-Preview, and so on. This software is a great option for office professionals and home user alike.

Csv Editor Pro 2 4 18 – Csv Editor And Exporter Pdf

Price: free trial available; pro versions start from $43.90

I find passion in writing Tech articles around Windows PC and softwares

Recommended for You:




broken image