{"id":3499,"date":"2022-08-26T09:46:02","date_gmt":"2022-08-26T07:46:02","guid":{"rendered":"https:\/\/www.recordinformatica.it\/?page_id=3499"},"modified":"2023-02-20T09:47:37","modified_gmt":"2023-02-20T08:47:37","slug":"extract-data-from-as-400-spools_en","status":"publish","type":"page","link":"https:\/\/www.recordinformatica.it\/en\/extract-data-from-as-400-spools_en.htm","title":{"rendered":"Extract data from AS\/400 spools"},"content":{"rendered":"

[vc_row el_class=”fake_breadcrumbs”][vc_column][vc_column_text]Products><\/b><\/span>\u00a0 <\/b><\/span>AS\/400 Graphic Print<\/b><\/a>\u00a0<\/span><\/strong>><\/strong>\u00a0Extract CSV<\/span>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]\"\"<\/p>\n

Validoc Extract is the module that allows you to extract data<\/strong> archives from AS\/400<\/a> prints (iSeries – System i – IBM i).<\/p>\n

You can extract archives in a CSV<\/a> format that can be used with Excel<\/strong>, Access, or other PC programs.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]To obtain this result, you must indicate which fields must be extracted from the print. Once the initial settings have been determined, a CSV file will be extracted each time you print (or according to the conditions indicated) and saved on the local network according to the rules provided on AS\/400.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=”2189″ img_size=”full” alignment=”center”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]You can let Validoc perform an automatic extraction or manually define portions<\/strong> of the print to be extracted and their extraction conditions.<\/p>\n

The first case applies to a temporary extraction that is then re-examined by eliminating the useless data (headings, comments, delimiting lines, etc.).<\/p>\n

The second case applies to situations of repetitive extraction where a setting process is justified to obtain an already final result.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=”2191″ img_size=”full” alignment=”center”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]TXT Format<\/strong><\/p>\n

The Extract module allows you to save the AS\/400 prints on PC in TXT format for processing with Word or other text<\/strong> editors.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_single_image image=”2193″ img_size=”full” alignment=”center”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]Read all the details in the documents below<\/strong><\/p>\n