Knowledgebase
How can I export all contacts for all of my clients? In Projetex I can only export the contacts of a single client.
Posted by Alexey Sokolov (AIT) on 25 June 2014 11:19 AM

We have developed a special query which will allow you to extract all your contacts for each of your clients. You can find this query below. To Load and use the query, please do the following:

1. Launch the Projetex Server Administrator.

2. Go to Corporate Settings > Queries.

3. Click the New button.

4. Specify a name for this query.

5. Paste the code below into the Content field.

6. Click OK.

7. Now your query is available to you.

8. Select this query from the list and click Export Data.

9. Select a file format and a location for your export file.

 ---------------------------------------------------------------------

SELECT c10.client_name, c3.ccon_name, c3.ccon_email1, c3.ccon_email2,
c3.ccon_phone1, c3.ccon_phone2
FROM clients c10, ccontacts c3
WHERE c3.client_id=c10.client_id
ORDER BY c10.client_name

 

(1 vote(s))
Helpful
Not helpful

Comments (2)
Ahmed Abdel Baset
02 December 2014 06:43 PM
what about the code of all freelancers ?
Mikhail Sergievskiy
08 February 2015 12:27 AM
The query for freelancers would be something like the following:
---------------------------------------
select r.res_name,
r.res_street1,
r.res_street2,
r.res_city,
r.res_state,
r.res_zip,
countries.coun_name,
r.res_email1,
r.res_email2,
r.res_phone1,
r.res_phone2,
r.res_fax,
r.res_www,
r.res_vatnum,
curr.curr_name


from resources r, curr, countries

where r.coun_id = countries.coun_id
and r.curr_id = curr.curr_id



-------------------------
The query does not include freelancer prices though; you would need to left join rprices table on resources.res_id = rprices.res_id and services.serv_id = rprices.serv_id. You can see an example of joining services and prices table here (for clients table): http://aithelp.com/index.php?/Knowledgebase/Article/View/726/0/export-clients-list
© AIT Translation Management Solutions, . Awesome Software Tools for Translators and Translation Agencies.
Privacy Policy | Data Processing Agreement