Data Tools only work for Windows XP. Click Here for a solution

Question: I have a source text file that contains two fields/columns. In the first column there are product SKUs, each of which is repeated on multiple rows. The second column contains the SIZEs of each of the products that I have in stock. For example, if I have 6 different SIZEs of one SKU, there are 6 rows for that SKU in my source file. How can I combine the data into a target text file that contains just one row for each SKU and each of the available SIZEs on that same row and in size order and separated by a vertical bar?

The format of the source file looks like this:

""SKU"",""SIZE""

""1111A"",8

""1111A"",6

""1111A"",16

""1111A"",12

""1112B"",13

""1112B"",8

""1112B"",5

""1112B"",16

""1112B"",12

""1113C"",6

""1113C"",8

""1113C"",14

I would like the format of the target file to look like this:

1111A 6|8|12|16

1112B 5|8|12|13|16

1113C 6|8|14

Answer: Using the Data Loader to CSV Text or...

Question: For the past 2 days I get an ""Overflow (6)"" error message when I launch my DataTools product for the first time each morning. What is causing the error, and how can it be fixed?

Answer: The Cause The error is usually the result of “corrupted” window dimension/location values in the “settings” file for the product. This is sometimes caused when the application is closed (intentionally or not) with one or more of the application's windows in a position that is outside the visual boundaries of your computer screen.

The Solution The solution to the problem depends on which of the DataTools products is affected. Each product within a ""category"" (i.e., Extractors, Loaders, Parsers, etc.) creates/edits and uses a unique ""settings"" file each time the product is launched and closed. The ""settings"" files reside in the following path, depending on the operating system of your workstation on which DataTools is installed, as follows:

On Windows XP:

C:\Documents and Settings\[YOUR_USERNAME]\Application...

Question: I have a C-ISAM file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format?

Answer: Using the Data Parser for C-ISAM, you can define the structure of the data records by using the visual parser window, and once the data is parsed and unpacked, export the data to a CSV text file.

Objectives There are two objectives in this DataTools HowTo, as follows:

Use the Data Parser for C-ISAM to define the schema/structure of a fixed-length C-ISAM data file Export the unpacked data to a CSV text file format Skill Level Basic to Intermediate Skill Set Data Parser Built-in visual parsing interface Basic understanding of C-ISAM data storage formats Design Considerations The principal design consideration is to follow the procedural steps below in the order in which they are specified in this HowTo. A secondary consideration is to follow...

Question: I have a Btrieve data file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format?

Answer: Using the Data Parser for Btrieve, you can define the structure of the data records by using the visual parser window, and once the data is parsed and unpacked, export the data to a CSV text file.

Objective There are two objectives in this DataTools HowTo, as follows:

Use the Data Parser for Btrieve to define the schema/structure of a fixed-length Btrieve data file Export the unpacked data to a CSV text file format Skill Level Basic to Intermediate Skill Set Data Parser Built-in visual parsing interface Basic understanding of Btrieve and packed data storage formats Design Considerations NOTE: Before you begin the procedures in this HowTo, you must have a Btrieve or Pervasive.SQL Engine installed and configured on your system, and...

Question: I have a source file that contains packed and binary data. How can I parse and define the structure of the file and export the unpacked data to a CSV text file format?

Answer: Using the Data Parser for Binary, you can define the structure of the data records by using the visual parser window, and once the data is parsed and unpacked, export the data to a CSV text file.

Objective There are two objectives in this DataTools HowTo, as follows:

Use the Data Parser for Binary to define the schema/structure of a fixed-length data file Export the unpacked data to a CSV text file format Skill Level Basic to Intermediate Skill Set Data Parser Built-in visual parsing interface Basic understanding of binary and packed data storage formats Design Considerations The principal design consideration is to follow the procedural steps below in the order in which they are specified in this HowTo. A secondary consideration is to...