Unwired Accelerator allows you create application elements that are based on files. The file must contain data arranged in a format that can be mapped to grid data. For example:
Delimited columns – data separated by commas, tabs, semicolons, colons, or spaces. Typically, delimited columns are in a .csv extension, which you can create when you save the contents of a spreadsheet application.
Fixed-size columns – data arranged in columns of a fixed size. Files with fixed-size columns can be saved and uploaded with a .txt extension.
Excel – Excel capture functionality is supported for BlackBerry and PDA online and offline clients, and for Smartphone offline clients.
Using either file type, you can create an application element that uses the grid-rule functionality of Unwired Accelerator.
Unwired Accelerator uses the uploaded copy of the file, not the copy that is local to the browser. In other words, changes to the original file have no impact on the application created from the uploaded file. For the changes to take effect, you must upload the application again.
Creating a file element
From the Mobile Development perspective, select File|New|Mobile Application.
When the Mobile Application Wizard appears, select the Launch Element Wizard then select File from the Element Type drop-down list, and click Finish.
Alternatively, right-click the Mobile Application status folder in which you want to create the mobile application, and select Create (status name) Mobile Application With|File Element.
In the File Element dialog, complete these options:
File To Upload – enter the full path or Browse to the file name of your source data.
If you upload a file with the same name as a previously uploaded file, the second file overwrites the first, unless you create a subdirectory below the upload directory and upload the second file to the subdirectory.
You cannot import or export a file mobile application across servers. See Importing and Exporting Mobile Application Elements.
Destination Location – accept the default location, which is created automatically.
Click Upload to the right of the Destination Location field. The program creates a \PortalDocs subdirectory beneath the directory you have specified as the temporary directory on the local machine. The file you upload is saved in a subdirectory beneath \PortalDocs that has your user name; for example, x:\temp\PortalDocs\masuper, where "x" is the drive where the temporary directory is located, and "masuper" is the name of the user that uploaded the file.
When the confirmation displays that the file was successfully uploaded to the Unwired Accelerator server, click OK.
File Name – leave blank. This field is automatically filled in once you click Upload.
This sets the character set found in the Content properties page. However, the preview may not show correctly unless you change the character set based on the file upload of the spreadsheet. Some character sets require you to install the corresponding language pack to preview the mobile application. Follow the Language Pack Installation wizard for instructions. See Creating HTML-based Elements
.
Delimited – reflects how source file content is arranged—data separated by a delimiter (such as a comma).
Delimiter – select the delimiter used in the source data file. For example, Comma.
Merge Repeated Delimiters – whether repeated delimiters should be replaced with a single delimiter. This is useful if your source data includes blank columns.
Text Quoter – specifies the quote character that is used to define a section of "as is" text that may include delimiters.
Fixed Width – select this option if the data is arranged in fixed-sized columns.
Excel file – this option is available if the File To Upload is an Excel spreadsheet. Select this option and select the Worksheet from the drop-down list.
Click Preview to see the result.
Click Next.
In the Rules dialog, enter the rules information if desired. See Using Rules and Record Layout.
Click Finish.
Save the mobile application.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com