Host-to-Mac Data Transfer Data can be transferred from a PICK host computer ( or uniVerse, Prime, UniData etc.) to your Macintosh in several ways. The data can be converted to a format usable by spreadsheets and databases or it can be transferred directly with no conversion. Convert to Spreadsheet / Database Format This option converts data from the PICK host to spreadsheet or database format. Data sent to the Mac in a labels format can be directly loaded into a Macintosh database. (See the PROC below that will transfer the data in a labels format. This same data can be loaded into a Macintosh spreadsheet. Each label (or record) will become a new row in a spreadsheet. EXAMPLE: The following data is sent from the host to the Mac in a labels format (Only two labels are shown for simplicity:) JOHN'S ROADHOUSE 1211 EAST PINE SEATTLE, WA 99999 (206) 223-5555 JIM GATLIN MURRAYS PRINTSHOP 4782 NORTH PIKE SEATTLE, WA 77777 (206) 221-5555 JILL SCOTTS After conversion the labels can be loaded into a Mac database and will be in the same labels format. Of course your database can now turn the labels into a tables format if you desire. The same labels sent from the host can be loaded into your Mac spreadsheet. Each label becomes a row: JOHNÕS ROADHOUSE 1211 EAST PINE SEATTLE, WA 99999 MURRAYS PRINTSHOP 4782 NORTH PIKE SEATTLE, WA 77777 ================================================================== A PROC FOR TRANSFERRING DATA FROM HOST TO MAC In this example you are transferring data from a file named CUSTOMERS. You would like to transfer the company name, street, city, phone number and person to contact at each company. On your host computer, build the following PROC and call it LIST-CUSTOMERS. 001 PQ 002 HLIST-LABEL CUSTOMERS COMPANY STREET CITY PHONE CONTACT ID-SUPP COL-HDR-SUPP 003 STON 004 H1,5,1,0,20,0 Notes: Line 004 Label parameter meanings: 1, Number of label columns 5, Fields per record 1, Skip one line between records 0, Indent 20, Width of record (this would be the max width in a spreadsheet column) 0, Space Do not change the Number of label columns, Skip line between records, Indent or space. All other variables can be changed. The Fields per record entry in line 004 of the PROC should be the number of field names you entered in line 002. (COMPANY, STREET, CITY, PHONE, CONTACT) Now when you type LIST-CUSTOMERS you will get a list like this: <-- Blank line JOHN'S ROADHOUSE 1211 EAST PINE SEATTLE, WA 99999 (206) 223-5555 JIM GATLIN <-- Blank line MURRAYS PRINTSHOP 4782 NORTH PIKE SEATTLE, QA 77777 (206) 221-5555 JILL SCOTTS <-- Blank line etc... Select Host-To-Mac Transfer from the File Menu and enter the name of your PROC (LIST-CUSTOMERS in this case). Then enter 5 as the number of Fields per record and click OK. Your PICK data will be transferred to the Mac and converted to a tab delimited text file ready to be loaded into a spreadsheet or database on the Mac. ================================================================== Note: You can also use the CommToolBox file transfer tools to transfer data if your host supports protocols such as Xmodem, Ymodem, Zmodem, Kermit or FTP.