Jump to: navigation, search

Data Files/Big Data Files

Using the All Data Files screen you can import, modify, and create new data files of up to 50K rows of data.

Data Files

Importing a Data File

Import Data File

To import a data file:

  1. Click Import Data File.
  2. On the Import Data File screen, click Browse, browse your computer to locate the data file, and after locating it, click Open to import it.
  3. Depending on the file, select either Use the first row for data titles or Use column headers for data titles (A, B, C, etc.).
  4. Click Save.

Creating a New Data File

New Data File
  1. Click Create New Data File.
  2. On the New Data File screen, replace the default new data file name with one of your own, if desired.
  3. Using the Add Column button, add as many columns and their column headings as needed.
  4. Click Save.

Data File Properties

Data File Properties

To view and/or make changes to the properties of a data file, click Edit and then make changes to File Information, Structure, and Scheduled Delivery & Update Options entries as desired.

File Information

In the File Information section you do the following tasks:

  • File Name—Enter a new name, if desired, to rename the file
  • Last Modified—View the date the files was last modified
  • Rows of Data—View the number of data rows.
  • Download—To download the file, click on the Download link.
  • Re-Import—If need to update your data file, you can re-import a file from your computer to CX Builder. To do so, click the Re-Import link.
  • View Data—If you wish to view the data file with out having to download it, click the View Data link to view it in your browser. NOTE: Only the first 200 rows of the file display.
  • Clear All Data Rows—Click this link if you wish to delete all the data in the file leaving only the column headers.

Structure

In the Structure section you can rename, add/delete, or move columns up or down.

Scheduled Delivery & Update Options

In this section you can configure various delivery and update options.

  • Deliver only new rows of data – Checking this box causes the delivered file to contain only the new (previous days) rows of data.
  • Delete delivered rows after [ xx ] days – Checking this box enables automatic deletion of delivered rows after ‘xx’ days. This can useful to ensure that the data file never reaches its 50,000-row limit.
  • Enable Update—To update the data file:
    • Check this box, and either FTP or SFTP, so that CX Builder retrieves the data file from the associated server you designate in the Host/IP/URL field daily, and at the time you select in the Update daily at... drop-down menu.
    • Specify the values for Remote Directory, Username, and Password for the location. The remote filename must be the same as the name of the data file in CX Builder. In the Remote Directory field, you must use ( ./ ) if the file being updated resides on the root directory. If it's in a folder, the format is ( ./FolderName ). Click Execute Now to immediately retrieve the file.
  • Enable Delivery—To deliver the data file:
    • Check this box, and either FTP or SFTP, to have the data file delivered to the server you designate in the Host/IP/URL field daily at the time you select in the Update daily at... drop-down menu.
    • Specify the values for Remote Directory, Username, and Password for the location. The remote filename must be the same as the name of the data file in CX Builder. In the Remote Directory field, you must use ( ./ ) if the file needs to be delivered in the root directory. If there is a folder, the format is ( ./FolderName ). Select Prepend date to file name, if desired. Click Execute Now to immediately deliver the file.
  • Enable Email Delivery—Check this box to e-mail the data files to the specified e-mail address at the time you select in the Email daily at... drop-down menu. Click Execute Now to immediately e-mail the data files.

Note:

  • CX Builder now supports SSH packet compression when delivering data files via SFTP.

CX Builder - Big Data Files Feature

The Big Data Files feature currently supports data files of up to 100K rows. If your account is enabled for Big Data Files, you can use them in conjunction with the Big Data Page. When you click the CX Builder tab, you see the Big Data Files option next to the Data Files option.

Using the All Data Files screen for big data files you can import, modify, and create those data files.

Big Data Files
Important
The maximum size supported for big data files is 52.4288 MB

Importing a Big Data File

Import Big Data File

To import a big data file:

  1. Click Import Big Data File.
  2. On the Import Big Data File screen, click Browse, browse your computer to locate the data file, and after locating it, click Open to import it.
  3. Depending on the file, select either Use the first row for data titles or Use column headers for data titles (A, B, C, etc.).
  4. Click Save.

Creating a New Big Data File

New Big Data File
  1. Click Create New Big Data File.
  2. On the New Data File screen, replace the default new data file name with one of your own, if desired.
  3. Using the Add Column button, add as many columns and their column headings as needed.
  4. Click Save. The new file is added to the list of available data files.

Big Data File Properties

Big Data File Properties

To view and/or make changes to the properties of a data file, click Edit and then make changes to File Information, Structure, and Scheduled Delivery & Update Options entries as desired.

File Information

In the File Information section includes the following entries:

  • File Name – Enter a new name, if desired, to rename the file
  • Last Modified – View the date the files was last modified
  • Rows of Data – View the number of data rows.
  • Download – To download the file, click on the Download link.
  • Re-Import – If need to update your data file, you can re-import a file from your computer to CX Builder. To do so, click the Re-Import link.
  • View Data – If you wish to view the data file with out having to download it, click the View Data link to view it in your browser. NOTE: Only the first 200 rows of the file display.
  • Clear All Data Rows – Click this link if you wish to delete all the data in the file leaving only the column headers.

Structure

In the Structure section you can rename, add/delete, or move columns up or down.

Scheduled Delivery & Update Options

In this section you can configure various delivery and update options.

  • Deliver only new rows of data – Check this box if you want the delivered file to contain only the new (previous days) rows of data.
  • Delete delivered rows after [ xx ] days – Check this box to enable automatic deletion of delivered rows after ‘xx’ days (that you specify). This can useful to ensure that the data file never reaches its 50,000-row limit.
  • Enable Update—To update the big data file:
    • Check this box, {and either FTP or SFTP, so that CX Builder retrieves the file from the server you designate in the Host/IP/URL field daily at the time you select in the Update daily at... drop-down menu.
    • Specify the values for Remote Directory, Username, and Password for the location. The remote filename must be the same as the name of the data file in CX Builder. In the Remote Directory field, you must use ( ./ ) if the file being updated resides on the root directory. If it's in a folder, the format is ( ./FolderName ). Click Execute Now to immediately retrieve the file.
  • Enable Delivery—To deliver the big data file:
    • Check this box, and either FTP or SFTP, to have the data file delivered to the server you designate in the Host/IP/URL field daily at the time you select in the Update daily at... drop-down menu.
    • Specify the values for Remote Directory, Username, and Password for the location. The remote filename must be the same as the name of the data file in CX Builder. In the Remote Directory field, you must use ( ./ ) if the file needs to be delivered in the root directory. If there is a folder, the format is ( ./FolderName ). Select Prepend date to file name, if desired. Click Execute Now to immediately deliver the file.
  • Enable Email Delivery – Check this box to e-mail the data files to the specified e-mail address at the time you select in the Email daily at... drop-down menu. Click Execute Now to immediately e-mail the data files.


Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 13 May 2016, at 13:07.