ࡱ > l n k 5@ bjbj22 X X ^ " " " 6 8 6 6 l ( 6 6 L $ R | " z " z z 6 L U , , , z 6 " L , z , $ , P J " U L u @ - , 0 6 A p 4 p ( U 6 6 U p " i , 6 6 d " 6 6 Importing Data With Notes WinSales Version: 3.x, 4.x Revised: 3/24/00 Problem: You have a field in your import file and containing notes and when you try to import into WinSales you get to a certain % into the file and WinSales is stopping the import with a message that you do not have exclusive use to the database. Solution: Some files that you may want to import into WinSales contain columns with notes that could include carriage-return/line-feed characters (record delimiters) that WinSales does not recognize. To solve this problem you need to alter the format of your incoming data before performing the import. There are many software tools that can be used to modify the format of your incoming data. This process describes a solution using Microsoft Excel: 1. Start Microsoft Excel. 2. Choose Open from the File menu. 3. Drill to the location of your file. Click on the down arrow next to List Files of Type: and choose All Files. Select the file and click OK. 4. Add a column to the end (far right) of the file by highlighting the column (click once at the top of the column) and choosing Columns from the Insert menu. 5. Click once in the first cell of the new column and type a tilde character (~). Fill the column with the tilde character (each row should have one) by selecting the value and dragging down through all the rows. 6. Choose Save As from the File menu. Click the down arrow next to Save File As Type: and choose CSV. Enter a file name making sure to use a .CSV extension and click OK. 7. Exit Excel. To import the data, refer to pages 75-81 of the Implementation and Reference Guide for instructions. When defining the import in WinSales, be sure to specify the following: 1. On the Import tab, from the Style: drop-down list, choose ASCII Delimited. 2. On the Options tab, at the Record Separator: field, enter a value of 126/13/10. Proceed normally with the rest of your import definition. FILENAME \p C:\tempTechnotes\sup061.doc Last printed PRINTDATE 1/27/2000 11:28 AM Silent Partner, Ltd 425-831-7915 HYPERLINK "mailto:support@winsales.com" support@silentpartner.com www.silentpartner.com K S $ 1 D N @ b , = V _ F G ` a w x пппֺꗅuq h^ h^ 0J CJ OJ QJ ^J aJ #j h^ CJ OJ QJ U^J aJ h^ CJ OJ QJ ^J aJ h3 h mH nH u j h3 Uh h3 h h3 6CJ h3 5>*CJ \ h3 CJ h3 5CJ h3 5CJ h3 CJ h3 !j h3 CJ UhmH nH u , 7 H I J K C D t u % & I J { | R S h ^ $^a$ a b b x y z { | } ~ gd^ $a$gd^ $ !#a$ $^a$ h ^ x y h3 5CJ h3 h^ h3 $^a$ # 0 P / =!"#$% n^u #N_(]PNG IHDR R 7Y gAMA pHYs + IDATxˏeUƿo}N=c[PD ,bƈ)Ab !/ )BHQ&LB@By8qmU]`{vUݿjխ:Z{.JBX%n@Ѹ47+G^;ՎFq,n{dhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhMdhԻ]#xg9Wq+R9S,Duזve~qaUtZ̿~ǧ6zqw]3gǙx#9u~lnAˑŞΓ#Wk \/.۳d:,mG;8 ggt`&|LTtܝo[ȁ+ǵ_Ҫ=e_[@_nYI$U/_ ,K-ÁwoޓpC,8Isyڛw7>nz$DžNNU-?UO5Xs3GGv j^yq㧭h9g:|ᴏpt7*8BVqnM\c^ q{=@}t|ҸgiA~ާƪdhMq&?OwE hF .df@R#N L. 3@0qu Fr3mY P