Tags

    CSV Import

    This construction is designed to load a csv file, parse its contents and load them into a database.

    A jar file (csvtag) is used from Cold Beans Software. The jar file is then placed into qilan/WEB-INF/lib/.

    The parent tag, forEachRow, defines the location and separator for the file. Each child tag, getField, obtains the field data and assigns it to an 'id'. The id is then assigned to a Qilan framework field using the java syntax, '<%=[id]%>. The syntax is defined by the tag. The last action is to then use a QUPDATE to insert each row into the database.


    Comments

    /groups/commonground/search/index.rss?tag=hotlist/groups/commonground/search/?tag=hotWhat’s HotHotListHot!?tag=hot0/groups/commonground/sidebar/HotListNo items tagged with hot.hot/groups/commonground/search/index.rss?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomelist/groups/commonground/search/?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomeRecent ChangesRecentChangesListUpdates?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcome0/groups/commonground/sidebar/RecentChangesListmodifiedDateallRecent ChangesRecentChangesListUpdateswiki/welcomeNo recent changes.reverse5search