Timeslips v11 or 2004 Export Information

Timeslips 2004 or Version 11 Export Information

When converting from Timeslips 2004 or Timeslips Version 11, perform the following steps, then click the Return to Procedures link to return to the main Timeslips Conversion Instructions.

2. Generate the Client Export file from within Timeslips.

From the menu options at the top of the Timeslips window, select Reports, then Reports, then the Client tab.
Double-click "User Defined Client Listing" in the Description column. The Report Entry window will be displayed.
Click the Selection tab.
1. In the Selected filters group, click the Look For tab.
2. If there are any items listed, select each item and click < until there are no items remaining.
3. Make sure to select "Client" in the Filter groups drop-down list in the Available filters group.
4. Select Nickname 1 in the Filters list box in the Available filters group.
5. Click >.
6. The Filter for Nickname 1 dialog box will be displayed.
  1. Select "text" in the The field contains drop-down box.
  2. Click OK.
7. In the Selected filters group, click the Or tab.
8. If there are any items listed, select each item and click < until there are no items remaining.
Click the Sorting tab.
1. In the Selected sort keys group, select each item in the list and then click < until there are no items in the Selected sort keys group.
2. Make sure to select "Client" in the Sort groups drop-down list in the Available sort keys group.
3. Select "Nickname 1" in the Sorts list box in the Available sort keys group.
4. Click >.
5. Make sure the Order column in the Selected sort keys group is set to "Ascending".
Click the Formats tab.
1. Click the folder icon on the "Report template file path" line of the right side of the Settings column.
2. The Select Report Template dialog box will be displayed.
  1. Select the path in which the "CLIENTA.RPT" and "CLIENTB.RPT" files were installed when the TSCONV program was installed.
  2. If you don’t plan to convert custom fields, select the "CLIENTA.RPT" file. If you plan to convert custom fields (see the "Timeslips Custom Fields" section for more information about custom fields), select the "CLIENTB.RPT" file.
  3. Click Open.
  4. If you selected the "CLIENTB.RPT" file, do the following steps. Otherwise, skip to step 6.
    1. You need to run the Timeslips Report Designer. From the main Timeslips window, select Reports, then Report Designer.
    2. Click Cancel to close the "Select a New report Style" window.
    3. Click File | Open.
    4. Make sure that the "Look in" field is the Timeslips Program Directory\Report Templates.
      Note: If the CLIENTB.RPT does not exist in the Report Templates directory, then it was installed into the Timeslips Program Directory. Simply change the "Look in" field.
    5. Select the CLIENTB.RPT.
    6. Click Open. You should see three rows on the screen. The first and third rows, which contain one field each, are not referenced in these instructions. The remaining steps pertain to the second row.
    7. Scroll the window to the right using the horizontal scroll button at the bottom of the Report Designer window until the last 2 fields in columns 22 and 23 are visible.
    8. Double-click the text "Custom Field" in column 22. The Format for Custom Field box will be displayed.
    9. Change the text in the Label box to be the name of the user field as noted from the Timeslips Custom Fields section.
    10. Select the Text/List tab.
    11. Make sure the Auto option is selected.
    12. Click OK.
    13. Double-click the text "Custom Field" in column 23. Again, the Format for Custom Field box will be displayed.
    14. Change the text in the Label box to be the name of the date field as noted from the Timeslips Custom Fields section.
    15. Select the Date tab.
    16. Make sure the Short USA format (MM/DD/YY) option is selected.
    17. Click OK.
    18. After editing column 23, double click into the blank field directly below and select Attributes | Format.
      1. A "Format for Client Details" window will open.
        Note: Depending on which field/column has the focus when you select Attributes | Format the name of the window can change. This doesn't matter as long as the title of the window is "Format for xxx" and there is a Columns tab.
      2. Select the Columns tab.
      3. Change all the rows in the "Keep if Empty" column to be "True".
      4. Click OK to close the "Format for xxx" window.
    19. From the menu options at the top of the Report Designer window, select File, and then Save.
    20. Select File, and then Exit. The Timeslips Report Designer program will be closed.
    21. Go back to the Timeslips program. The Report Entry window should still be open on the Formats tab with the "Report template file path" line highlighted.
3. Make sure the Settings column for the "Page break on primary sort" row is set to "No".
4. Make sure the Settings column for the "Show Selection Criteria" row is set to "No".

To import clients without their Accounts Receivable balance, please do the following steps. Otherwise skip to step 7.

From the main Timeslips window, select Reports, then Report Designer.
Click Cancel to close the "Select a New report Style" window.

Click File | Open.

Make sure that the "Look in" field is the Timeslips Program Directory\Report Templates.
Note: If ClientA.rpt and ClientB.rpt do not exist in the Report Templates directory, then they were installed into the Timeslips Program Directory. Simply change the "Look in" field.
Select either the ClientA.rpt or the ClientB.rpt, depending on which report you plan on using.
Select the middle row.
Note: There will be 3 rows, two of which have only one column. The row you must select is the middle row that has either 21 columns (ClientA.rpt) or 23 Columns (ClientB.rpt).

Right-click the top box of the following columns and select delete.
Note: This will not remove the column; it will merely remove the text from the top box.

Column #	Column Name
16	Current Period w/ Unapplied Payments
17	Period 1 Total
18	Period 2 Total
19	Period 3 Total
20	Period 4 Total
21	Total Balance

Note: If you use the CLIENTB.RPT template and choose to not convert Accounts Receivable balances, you may get unexpected results for your balances. This is because when you delete the 6 balance columns (i.e., columns 16 through 21) in Timeslips, even if you have the "keep if empty" check box checked on all 6 columns in the "Layout Options for Reports", it doesn't include these 6 columns in the CSV file. This causes TSCONV to see the two custom fields as columns 16 and 17 instead of column 22 and 23. To fix this, you must open the client export in Excel or some other CSV/spreadsheet program and manually add six blank columns between column 15 and 16 to end up with 23 total columns. After doing this, columns 16 through 21 will represent the 6 blank balance columns and columns 22 and 23 will represent the two custom fields.

From the menu options at the top of the Report Designer window, select File, and then Save.
Select File, and then Exit. The Timeslips Report Designer program will be closed.
Go back to the Timeslips program.

Click on the drop-down button next to the Print to field at the bottom of the window.
1. Select the "File - comma delimited (CSV)" option.
Click Print. The Save as window will be displayed.
1. In the Save in field, select the drive and file path where Tabs3 is installed.
2. Enter either "CLIENTA.TXT" (if you are using the CLIENTA template) or "CLIENTB.TXT" (if you are using the CLIENTB template) in the File Name field.
3. Make sure "Comma Separated Files" is selected in the Save as type field.
4. Make sure the Export Column Titles check box is cleared.
5. Make sure the Use Control Panel’s Regional Settings formatting check box is cleared.
6. Make sure "MM/DD/YY" is selected in the Date Format field.
7. Make sure "AM/PM - Default" is selected in the Time Format field.
8. Make sure "Default" is selected in the Duration Format field.
9. Make sure "0/1 - Default" is selected in the Boolean Format field.
10. Click Save. The client data will be exported
Close the Set Up Report window and click Yes if prompted to save the settings for this report.

3. Generate the Work-in-Process Export file from within Timeslips.

From the menu options at the top of the Timeslips window, select Reports, then Reports, then the Slips tab.
Double-click "User Defined Slip Listing" in the Description column.
Click the Selection tab.
1. In the Selected filters group, click the Look for tab.
2. If there are any items listed, select each item and click < until there are no items remaining.
3. Make sure to select "Slip" in the Filter groups drop-down list in the Available filters group.
4. Select "Billed" in the Filters list box in the Available filters group.
5. Click >.
6. The Filter for Billed dialog box will be displayed.
  1. Select the No option.
  2. Click OK.
7. In the Selected filters group, click the Or tab.
8. If there are any items listed, select each item and click < until there are no items remaining.
Click the Sorting tab.
1. In the Selected sort keys group, select each item in the list and then click < until there are no items in the Selected sort keys group.
2. Make sure to select "Client" in the Sort groups drop-down list in the Available sort keys group.
3. Select "Nickname 1" in the Sorts list box in the Available sort keys group.
4. Click >.
5. Make sure the Order column in the Selected sort keys group is set to "Ascending".
6. Make sure the Subtotal column in the Selected sort keys group is set to "No".
Click the Options tab.
1. Make sure the Settings column for the "Apply Client rounding" line is set to "No".
Click the Formats tab.
1. Click the folder icon on the "Report template file path" line of the right side of the Settings column.
2. The Select Report Template dialog box will be displayed.
  1. Select the path in which the "WIP.RPT" file was installed when the TSCONV program was installed.
  2. Click on the "WIP.RPT" file.
  3. Click Open.
3. Make sure the Settings column for the "Page break on primary sort" row is set to "No".
4. Make sure the Settings column for the "Show Selection Criteria" row is set to "No".
5. Click on the drop-down button next to the Print to field at the bottom of the window.
  1. Select the "File - comma delimited (CSV)" option.
6. Click Print. The Save as window will be displayed.
  1. In the Save in field, select the drive and file path where Tabs3 is installed.
  2. Enter the text "WIP.TXT" in the File Name field.
  3. Make sure "Comma Separated Files" is selected in the Save as type field.
  4. Make sure the Export Column Titles check box is cleared.
  5. Make sure the Use Control Panel’s Regional Settings formatting check box is cleared.
  6. Make sure "MM/DD/YY" is selected in the Date Format field.
  7. Make sure "AM/PM - Default" is selected in the Time Format field.
  8. Make sure "H:MM" is selected in the Duration Format field.
  9. Make sure "0/1 - Default" is selected in the Boolean Format field.
  10. Click Save. The work-in-process will be exported.
  11. After the report is finished exporting, the Exported slips dialog box will be displayed. Select "No" in response to the question "Do you want to mark the slips as exported?".
Close the Set Up Report window and click Yes if prompted to save the settings for this report.

Return to Procedures

2009/07