]po[ CSV Import

This package allows for comfortable import of data in CSV (Comma Separated Values) format into ]po[ objects for:

 

Package Documentation

Procedure Files

tcl/intranet-csv-import-parser-procs.tcl        
tcl/intranet-csv-import-procs.tcl        

Procedures

csv_norm       Performs normalization including trim, tolower, replace non-ascii with "_". 
im_csv_import_check_list_of_lists       Check that the parameter is a list of lists with all lines having the same length. 
im_csv_import_guess_im_company        
im_csv_import_guess_im_conf_item        
im_csv_import_guess_im_hour        
im_csv_import_guess_im_project        
im_csv_import_guess_im_risk        
im_csv_import_guess_im_ticket        
im_csv_import_guess_map       Returns the best guess for a DynField for the field. 
im_csv_import_guess_parser       Returns the best guess for a parser for the given field as a list with: <ul> <li>The parser name, <li>the parser args and <li>the field name to map to </ul> 
im_csv_import_label_from_object_type       Returns the main navbar lable for the object_type 
im_csv_import_object_fields       Returns a list of database columns for the specified object type. 
im_csv_import_parser_boolean       Boolean - argument is mapped to SQL boolean: 't' or 'f' 
im_csv_import_parser_category       Parses a category into a category_id 
im_csv_import_parser_company_name       Returns a company_id from im_companies 
im_csv_import_parser_conf_item_parent_nrs       Returns a project_id from a list of project_nr's 
im_csv_import_parser_cost_center       Parses a cost center into a cost_center_id 
im_csv_import_parser_date       Generic date parser - front-end for all available date formats 
im_csv_import_parser_date_american       Parses a American date format like '12/31/2011' as the 31st of December, 2011 
im_csv_import_parser_date_european       Parses a European date format like '08.06.2011' as the 8th of June, 2011 
im_csv_import_parser_date_european_slashes       Parses a European date format like '08/06/2011' as the 8th of June, 2011 
im_csv_import_parser_date_iso       Parses ISO date format like '2011-06-08' as the 8th of June, 2011 
im_csv_import_parser_hard_coded       Empty parser - returns the argument 
im_csv_import_parser_no_change       Dummy parser without transformation 
im_csv_import_parser_number       Parses a generic number. 
im_csv_import_parser_number_american       Parses a European number format like '20.000,00' as twenty thousand 
im_csv_import_parser_number_european       Parses a European number format like '20.000,00' as twenty thousand 
im_csv_import_parser_project_name       Returns a project_id from project_name 
im_csv_import_parser_project_nr       Returns a project_id from project_nr 
im_csv_import_parser_project_parent_nrs       Returns a project_id from a list of project_nr's 
im_csv_import_parser_user_name       Returns a user_id from parties 
im_csv_import_parsers       Returns the list of available parsers 

SQL Files

sql/postgresql/upgrade/upgrade-4.0.3.0.0-4.0.3.0.2.sql        

Content Pages

www/
     examples/
           im_company.csv
           im_conf_item.csv
           im_hour.csv
           im_project.csv
           im_risk.csv
      import-2.adp
      import-2.tcl Starts the analysis process for the file imported
      import-im_company.tcl Starts the analysis process for the file imported
      import-im_conf_item.tcl Starts the analysis process for the file imported
      import-im_hour.tcl
      import-im_membership.tcl Starts the analysis process for the file imported
      import-im_project.tcl Starts the analysis process for the file imported
      import-im_risk.tcl Starts the analysis process for the file imported
      import-im_ticket.tcl Starts the analysis process for the file imported
      index.adp
      index.tcl Serve the user a form to upload a new file or URL
     reports/
           export-projects.tcl Report listing all main projects in the system with all available fields + DynFields from projects and customers
 

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com