Web System Common Tools

Web System Applications Development

 Web System Database Web System PostgreSQL Tables Web System Manage fields Web System Manage constraints Web System Manage indexes Web System Manage triggers Web System SQL Tab Web System Single-row editing Web System Multirow editing in table mode Web System Import Web System Export Web System Table transfer - or Store Web System Composite Types Web System SQL Queries Web System Workflow Web System Dataset Design Web System Query Expressions Web System Where Conditions Web System Group by Expressions Web System Having Condition Web System Windows Clause Web System Order by Expressions Web System SQL Tab Web System Test a Query Web System Views Web System Functions Web System Datasources Web System Charts Web System Main type selection Web System Subtype selection Web System Datasource selection Web System General settings Web System Axis settings Web System Background settings Web System Margin settings Web System Color settings Web System Mark settings Web System QR Barcodes Web System Saving Web System Reports Web System Template Editor GYRE Web System Sections Web System Toolbar Web System Basic properties Web System Data formatting Web System Text Web System Data Web System Macro Web System Geometry Web System Line Web System Bezier curve Web System Image Web System Chart Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Report Generator Web System Report Schedule Web Site Builder Web System Content Management System (CMS) Web System Edit site Web System Themes and pages Web System Create and edit theme Web System Edit page Web System Web Form Builder / Content Editor (GYRE) Web System Toolbar Web System Events Web System Basic properties Web System Text field Web System Button Web System List Web System Combobox Web System Label Web System Checkbox Web System Radiobutton Web System Filler Web System Upload file Web System Additional tools (Gears) Web System Image Web System Flash video Web System Arrangement Web System Clipboard Web System History Web System Zoom Web System Import/export Web System Delete Web System Operations with objects Web System DNS Manager Web System SEO tools Web System App Analyzer Web System Reindex Web System Publish Web System Access Log Web System Checkout settings Web System PHP Scripts development (Actions) Web System Source Editor Web System API functions Web System Custom Scripts development (JS, CSS, XML, etc...) Web System Gears Web System SaaS Solution Manager

Web System Cook book

Web System Deprecated

Web System File Manager

The File Manager is the module that provides an interface to work with and control objects within your Account. To open the File Manager, select Tools->Files menu or click on any folder in Y-tree. Authorized YC users have access to documents stored on the server or in their individual directories anytime, from anywhere. Objects can be - files, tables, reports, images, actions, js, css, swf, etc. The most common operations performed on objects or groups of objects are: create, open, edit, view, rename, move, copy, delete.

Use the image below as a beginning guide for the general, functions provided by the File Manager.













(1) Edit Path
(2) Search or Advanced search for a File
(3) Move Object to trash
(4) Create a New Object
(5) Upload Files
(6) Google Docs or Google Picasa: Backup/Restore/Synch/Download/Import to Table
(7) More: Additional Options for a specific, selected File
(8) Show: Display types of Files based on checked criteria
(9) File Selector column
(10) Sort by Name
(11) Public or Private
(12) - (14) Additional Sort options
(15) Set the number of objects to Display, per page

Selecting a directory in the Y-tree on the left designates it as the current directory, displaying its contents in the File Manager on the right.
(1)  At the top of File Manager there is Path or Address bar, which shows current folder. You can edit the path by clicking Edit Path button.  In the image below, 'documents' is the current folder.


(2) Search: Use the search form to easily find an object or file by its name and/or context. You can also use wildcards for search:
* - any symbols (wildcard)
? - any symbol (one)

For example:
*my* - will find any file where name contains "my"
*.js - will find any js files.
a_??.jpg - will find a_11.jpg, a_aa.jpg, etc.

(3) Move to Trash:  To move an object to the trash, select the object in the File Selector Column (9) and click the trash.   Note: some objects like Tables are deleted immediately, bypassing the recycle (Trash) bin.  These objects cannot be restored from the Trash, though you have several options that you should consider before encountering this potential User error. {(1) periodically, create Table snapshots  (2) Make sure your entire Account is scheduled for Backup  (3) Use the ACL to create a Role which disallows deletion of Tables.  Assign that Role to users as required}.

(4) Create a New Object.  Selecting 'File' enable you to create any of; Text, CSS, Javascript, xml or html.
--- Text opens a very simple, plain text editor sililar to Notes. 
--- Selecting CSS, Javascript, xml or html opens the built in Youncycle editor.
Shown below (Image: Files, file type)


Image (Files, file type)

If you select 'Files' you will be given a choice of the type of 'File'.

Selecting any of the other types of New Files, such as Php Action, various types of Database Objects etc, in addition tonew Google Documents, Spreadsheets, Picasa images or Gmail messages. Selecting will take you to the specific Editor for that Type.  You can also reach those Editors by clicking the object category on the YTree or the top Menu (Tools) and selecting selecting the type of Tool.  Use the method you find most convenient.

(5) Upload Files: To Upload Files, it is usualy best to first navigate to you desired, final target Folder.  After you are 'in' the desired folder, click the Icon for Upload.  The Upload button allows users to upload their files to the server. You can upload one or more files in one pass. After uploading a file, it can be added to Google services. You can also upload zip-archives and check the Extract checkbox to automatically extract the archive after upload.

-- 1 -> Click the button, Select Files
-- 2  -> Locate the File on your Local Drive
-- 3  -> Select he desired File
-- 4  -> Click 'Open'

If you are uploading only 1 file, click Upload.  If you would like to upload multiple Files, continue Steps 2 and 3 until you are done - then Click Upload.  You Files will be uploaded with a success message upon completion.

To remove a file from your list, simply click the Red X.  Notice that the Files below have been designated as Public, which means that anyone that had the Path to the File, could download that File.  See below.

(6) Google Docs or Google Picasa: Backup/Restore/Synch/Download/Import to Table

Obviously, you will need a Google Account in order Backup/synch or otherwise use objects in a Google Account.   Google will check with you via a dialog to make sure it is OK to 'share' these objects.

When you mouseover the button, you will see Backup Google Docs & Backup Google Picasa, however the functions available exceed simple Backup.  Use the checkbox on the left ccolumn to select the specific objects, then click Backup Selected or simply Backup All. 

In the last (far right +) column of this dialog, there is a dropdown menu. For Spreadsheets you can select "Import to Table" or "Download as". For Documents, only "Download as" is available. These options become visible when you mouseover that ccolumn.

Download options for Google shown below.

If you select a Google Spreadsheet (in the Green + Column), you can Import that Spreadsheet into an SQL Table.

In the "Import to Table" dialog you can choose the Table name, folder and give a description.  We strongly recommend that a Description is supplied for yourself and other privileged users.   In addition, this is the dialog tused to designate the structure of your spreadsheet. The System attempts to analyze by scanning the first 10 records of the spreadsheet, but success is higher if you specify: "Headers are on row" and "Data starts on row" fields.  Try it & if it is not correct, you can fix it manually. In addition, you can fix column names if the system has determined it incorrectly.N

Note that Column Names should be all lower case, have no spaces or special characters. 'my_table' is OK.  'My Table' will  fail to import.

You will receive a Success message (if successful) and be able to locate your new SQL Table by clicking the YTree (Tables).  More exacting work is best done within the Tables Editor.  In addition, you will be able to Query the Table or use in websites or Templates (print documents & PDF).

(7) More: Additional Options for a specific, selected File

The More button will remain dimmed until you select an Object.  After selecting an Object, a menu with additional options becomes available.
- You can Copy an existing file and name
- Move a File to a different Folder
- Zip either 1 or a group of files.  Make sure the desired files are all selected.
- Downlad a specific File to your local drive
- Renmae a File
- Share a file with GMail, Twitter, Facebook, Hotmail or GooglePlus
- Change the Properties to include Name, Description, Folder, Public.  You can also retrieve the existing path to the object in this dialog.
- Upload/Restore to Google
- View in the YC Viewer (if appropriate).
- Convert (change an image type and Size).

Click the thumbnail to open all dialogs in a sepate window.

Each of the above opens a simple straightforward dialog, specific for that task.


(8) Show: Display types of Files based on checked criteria

The filter form (Show button) provides control over which files at a given location are visible and available for selection.

If you only want to see the list of Objects and not the containing Folders, make sure you click 'Don't include Folders', otherwise the Folders will display and you will need to click the Folder to drill to the actual Object.  Click the Apply button to enable your Filtered choices.


(9) File Selector column

Remember that at least one (1) object must be selected for the More button to undim and become accessible.

(10) Sort by Name (ascending or descending (Alpha).

(11) Public or Private - the eaisest way to change Files from Public or Private.  To change the 'Preset' for Uploading Files, go to Settings (top menu) -> Manage Account -> Account Details.  You can set the Global on Upload (Private/Public) in that GUI.

(12) - (14) Additional Sort options

(15) Sets the number of objects including Folders, to Display per page.  This paginaation feature can be reset at aany time and is specific for the User.