To import clients:

  1. Open TO3000 3D and navigate to Advanced Settings > Queries. 

2. Click on "New" and a new window will open.

In "Query Name", type "Extract clients". In "Content", copy/paste the following query:

SELECT CL.CLIENT_NAME,
CL.CLIENT_EMAIL1,
CL.CLIENT_NAME +'\n'+  CL.CLIENT_STREET1 +'\n'+  CL.CLIENT_STREET2 +'\n'+  CL.CLIENT_CITY +'\n'+  CL.CLIENT_ZIP +'\n'+ CL.CLIENT_STATE +'\n'+  CO.coun_name +'\n'+  CL.CLIENT_PHONE1 +'\n'+  CL.CLIENT_VATNUM +'\n'+  CL.CLIENT_WWW,
CU.CURR_NAME,
iif(CL.CLIENT_PT_TYPE=1,0, CL.CLIENT_PT_DAYS) AS DAYS,
iif(CL.CLIENT_PT_TYPE=1 OR CL.CLIENT_PT_TYPE=2,1,0) AS EOM
FROM CLIENTS CL
LEFT OUTER JOIN COUNTRIES CO on CO.COUN_ID = CL.COUN_ID
LEFT OUTER JOIN CURR CU ON CU.CURR_ID = CL.CURR_ID 

3. Click on "OK" to save your new query.

4. Select the query "Extract clients" in the list and click on "Export Data". In the new popup window, select "CSV" in the "Export to" field and uncheck the "Open after export" option.

5. Open LSP.expert and navigate to Settings > Import/export. Click on the button to  import clients and select the file you just created.

To import jobs and invoices:

  1. Open TO3000 3D and navigate to Advanced Settings > Queries.

2. Click on "New" and a new window will open.

In "Query Name", type "Extract jobs and invoices". In "Content", copy/paste the following query:

SELECT 
J.CJOB_NAME,
CL.CLIENT_NAME,
S.SERV_NAME,
J.CJOB_VOLUME,
U.UNIT_NAME,
J.CJOB_DEADLINE,
J.CJOB_PONUMB,
iif(J.CJOB_ISCOMPLETED=0,NULL,J.CJOB_COMPLETED) AS CJOB_COMPLETED,
iif(I.CINV_GNUMB is null, null,CONCAT('I-',I.CINV_GNUMB)) AS INVOICE_NUMBER,
I.CINV_DATE,
iif(J.CJOB_FEE_KIND='free',0,J.CJOB_PRICE) AS UNITCOST,
iif(J.CJOB_FEE_KIND !='per unit',1,0) AS FIXEDPRICE,
CU.CURR_NAME,
ABS(I.CINV_DIS1_VALUE)/100+ABS(I.CINV_DIS2_VALUE)/100 AS DISCOUNT,
I.CINV_FACT_SETTL_DATE,
iif(I.CINV_TAX1_TITLE='None',NULL,I.CINV_TAX1_TITLE) AS TAX1,
I.CINV_TAX1_VALUE/100 AS TAX1_VALUE,
iif(I.CINV_TAX2_TITLE='None',NULL,I.CINV_TAX2_TITLE) AS TAX2,
I.CINV_TAX2_VALUE/100 AS TAX2_VALUE
FROM  
CJOBS J  
LEFT OUTER JOIN CINVOICES I ON J.CINV_ID = I.CINV_ID  
LEFT OUTER JOIN SERVICES S ON J.SERV_ID = S.SERV_ID
LEFT OUTER JOIN UNITS U ON J.UNIT_ID = U.UNIT_ID
LEFT OUTER JOIN CURR CU ON J.CURR_ID = CU.CURR_ID
LEFT OUTER JOIN CLIENTS CL ON J.CLIENT_ID = CL.CLIENT_ID

3. Click on "OK" to save your new query.

4. Select the query "Extract jobs and invoices" in the list and click on "Export Data". In the new popup window, select "CSV" in the "Export to" field and uncheck the "Open after export" option.

5. Open LSP.expert and navigate to Settings > Import/export. Click on the button to import jobs and invoices and select the file you just created.


Note that LSP.expert will show an error if you try to import more than 500 jobs/invoices/clients at once. If you receive such an error, you will have to split your exported file in multiple files of maximum 500 items.

Did this answer your question?