Actweb.acttax.com



ACT 7.0 TEST PLANPRC No.:210868Client: HarrisPRC Priority: AA Move ASAP? NObject Name(s): ?\\Apollo\act_webdev\warfiles\sit.war,Problem Description: SIT PORTAL - IF SIT_CODESET CSV_FILE_FORMAT_FOR_SIT_PORTAL = 2THEN WHEN IMPORTING THE CSV FILE FOR EACH DEALER TYPE, IGNORE COMMA'S IN ANY DATA FIELDS (FOR EXAMPLE: JIM, SMITH OR 10,000.00)IGNORE ROWS WHICH HAVE NULLS IN ROWS (EXAMPLE: ,,,,,,)Developer Notes: System: SitClient: Harris CountySummary:- Continue to ignore row 1, it has header information from the excel file- Ignore a comma if it is within the data in a column (example: Smith, Jim or 10,000.00)- Stop processing further if you encounter a row with null values. This is to prevent null rows and to ensure that the processing of the csv file does not take an extended amount of time.Solution: - Used the regular expression "[\s,]+/g,"")" to stop importing the data if encountering a row with null values - Used the regular expression "(".*?"|[^",\s]+)(?=\s*,|\s*$)" to ignore a comma in the dataTest:- Use the attached CSV files to testFiled Affected:import.jsp sit.war (Version 1.23)------------------------------------------------------------------------------------------DN - 12/12/2018- Updated the regular expression to catch the case if there is a space between 2 words- Updated the regular expression to catch the case if the row of values has a empty value in excel file- Increased the width of columns "Sale Date", "Entered Tax", "Calculated Tax", "Make"- If the value in the column "Entered Tax" is empty, it will be converted to $0.00Filed Affected:import.jspsitcommon.jssit.war (Version 1.25)Test Plan: Using the attached files (with the pref CSV_FILE_FORMAT_FOR_SIT_PORTAL set to ‘2’) verify that when the files are loaded, any null rows and commas are ignored. Then, change the pref to ‘1’ and load a file in the old format and verify it loads with no errors.Update client pref CSV_FILE_FORMAT_FOR_SIT_PORTAL to 2Create file for Motor Vehicle– row 1 has commas row 2 has blank fieldsUpload File loads successfullyUpdate required fieldsSales UploadedCreate file for Heavy Equipment row 1 has commas row 2 has blank fieldsUpload fileUpdate required fieldsSales UploadedCreate file for Manufactured Housing row 1 has commas row 2 has blank fieldsUpload fileUpdate required fieldsSales Uploaded Create file for Vessel row 1 has commas row 2 has blank fieldsUpload fileUpdate required fieldsSales UploadedUpdate client pref CSV_FILE_FORMAT_FOR_SIT_PORTAL to 1Create file for Motor VehicleUpload File loads successfullySales UploadedCreate file for Heavy Equipment Upload file Sales UploadedCreate file for Manufactured Housing Upload fileSales Uploaded Create file for Vessel Upload fileSales Uploaded ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download