Register a CSV File as a Mashable
If needed, set connection information to the
Presto Server where you want to publish this mashable. See
Configuring the Connection to
Presto for instructions.
You can also use comma-separated-value (CSV) files to provide data for Presto mashables.
To register a CSV file as mashable
1. Click Register/Update a Spreadsheet Mashable in the Presto Toolbar. 2. Click Next in the welcome window of the Register Wizard.
3. Set the From local CSV file option and.
a. Click Browse and locate the CSV file that you want to use.
b. Select the character that is used as the separator between fields in this CSV file:
Comma | This (,) is the default separator. |
Pipe | | is also known as the upright bar symbol. |
Tab | Another common separator. |
Other | For any other separator character. Then enter the actual separator character in the open field. |
c. Clear the CSV file has column names option if the first row of the CSV file does not contain column names.
4. Review the data in the Data Preview window and click Next if this is correct.
5. Complete information for the mashable you are registering:
a. Enter a unique Name for this mashable.
Presto uses the mashable name to assign a unique identifer to mashables. Mashable names can contain characters from the character sets supported by the Presto Repository, numbers, spaces, tabs, line ends and these common symbols: _ ~ - * ' .
b. Optionally, select a Provider for this mashable, add Tags or enter a Description for this mashable.
You can also use the built-in provider: NONE.
c. Click Next.
6. Click OK once all information is correct.
Excel confirms that the mashable is successfully registered.