<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Migrate contacts to new company in FA]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=9205</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9205&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Migrate contacts to new company in FA.]]></description>
		<lastBuildDate>Sun, 05 Feb 2023 20:01:47 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=42043#p42043</link>
			<description><![CDATA[<p>I think that will work.&nbsp; Personally, I would probably just mysql -u root - p, and insert the records in a new table.&nbsp; :-)</p><div class="quotebox"><cite>mawulitse wrote:</cite><blockquote><p>I was missing two tables, and found them based on this thread:<br />https://frontaccounting.com/punbb/viewtopic.php?id=7241</p><p>Below are the steps for anyone with basic knowledge like me.</p><p>1. Using phpMyAdmin or similar tool, identify the company prefixes. In this example I want to transfer the data from Company 0 to Company 1.</p><p>2. Using the RENAME feature under Operations, move the following tables to different names (delete might work but something could go wrong)<br />&nbsp; &nbsp; 1_crm_contacts&nbsp; &nbsp; &nbsp;--&gt; x1_crm_contacts<br />&nbsp; &nbsp; 1_crm_persons&nbsp; &nbsp; &nbsp; --&gt; x1_crm_persons<br />&nbsp; &nbsp; 1_cust_branch&nbsp; &nbsp; &nbsp; &nbsp;--&gt; x1_cust_branch<br />&nbsp; &nbsp; 1_debtors_master&nbsp; --&gt; x1_debtors_master<br />&nbsp; &nbsp; 1_suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; x1_suppliers&nbsp; &nbsp;</p><p>3. Use the COPY feature under Operations to bring the data from the original company to the new company:<br />&nbsp; &nbsp; 0_crm_contacts&nbsp; &nbsp; &nbsp;--&gt; 1_crm_contacts<br />&nbsp; &nbsp; 0_crm_persons&nbsp; &nbsp; &nbsp; --&gt; 1_crm_persons&nbsp; <br />&nbsp; &nbsp; 0_cust_branch&nbsp; &nbsp; &nbsp; &nbsp;--&gt; 1_cust_branch<br />&nbsp; &nbsp; 0_debtors_master&nbsp; --&gt; 1_debtors_master<br />&nbsp; &nbsp; 0_suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; 1_suppliers</p><p>That&#039;s it. Company 1 should now have all the contacts from Company 0.</p></blockquote></div>]]></description>
			<author><![CDATA[null@example.com (MacKenzie)]]></author>
			<pubDate>Sun, 05 Feb 2023 20:01:47 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=42043#p42043</guid>
		</item>
		<item>
			<title><![CDATA[Re: Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=39232#p39232</link>
			<description><![CDATA[<p>I was missing two tables, and found them based on this thread:<br />https://frontaccounting.com/punbb/viewtopic.php?id=7241</p><p>Below are the steps for anyone with basic knowledge like me.</p><p>1. Using phpMyAdmin or similar tool, identify the company prefixes. In this example I want to transfer the data from Company 0 to Company 1.</p><p>2. Using the RENAME feature under Operations, move the following tables to different names (delete might work but something could go wrong)<br />&nbsp; &nbsp; 1_crm_contacts&nbsp; &nbsp; &nbsp;--&gt; x1_crm_contacts<br />&nbsp; &nbsp; 1_crm_persons&nbsp; &nbsp; &nbsp; --&gt; x1_crm_persons<br />&nbsp; &nbsp; 1_cust_branch&nbsp; &nbsp; &nbsp; &nbsp;--&gt; x1_cust_branch<br />&nbsp; &nbsp; 1_debtors_master&nbsp; --&gt; x1_debtors_master<br />&nbsp; &nbsp; 1_suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; x1_suppliers&nbsp; &nbsp;</p><p>3. Use the COPY feature under Operations to bring the data from the original company to the new company:<br />&nbsp; &nbsp; 0_crm_contacts&nbsp; &nbsp; &nbsp;--&gt; 1_crm_contacts<br />&nbsp; &nbsp; 0_crm_persons&nbsp; &nbsp; &nbsp; --&gt; 1_crm_persons&nbsp; <br />&nbsp; &nbsp; 0_cust_branch&nbsp; &nbsp; &nbsp; &nbsp;--&gt; 1_cust_branch<br />&nbsp; &nbsp; 0_debtors_master&nbsp; --&gt; 1_debtors_master<br />&nbsp; &nbsp; 0_suppliers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&gt; 1_suppliers</p><p>That&#039;s it. Company 1 should now have all the contacts from Company 0.</p>]]></description>
			<author><![CDATA[null@example.com (mawulitse)]]></author>
			<pubDate>Mon, 08 Mar 2021 00:32:38 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=39232#p39232</guid>
		</item>
		<item>
			<title><![CDATA[Re: Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=39231#p39231</link>
			<description><![CDATA[<div class="quotebox"><cite>notrinos wrote:</cite><blockquote><p>All contacts for both suppliers and customers are recorded in two tables: <strong>crm_contacts</strong> and <strong>crm_person</strong><br />If customers, suppliers data are the same in both company then copy the said two tables and modify table prefix will achieve your goal.</p></blockquote></div><p>@Phuong, thanks for the tips.&nbsp; I copied the three CRM tables from the old company to the new, but the contacts don&#039;t show up when I open the new company in FA.&nbsp; However, when I run a backup of the new company and select &quot;view backup&quot; I see the tables with the copied details.</p><p>What am I missing?&nbsp; Is there another file or table that needs to be updated?</p>]]></description>
			<author><![CDATA[null@example.com (mawulitse)]]></author>
			<pubDate>Sun, 07 Mar 2021 23:01:53 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=39231#p39231</guid>
		</item>
		<item>
			<title><![CDATA[Re: Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=39181#p39181</link>
			<description><![CDATA[<p>All contacts for both suppliers and customers are recorded in two tables: <strong>crm_contacts</strong> and <strong>crm_person</strong><br />If customers, suppliers data are the same in both company then copy the said two tables and modify table prefix will achieve your goal.</p>]]></description>
			<author><![CDATA[null@example.com (notrinos)]]></author>
			<pubDate>Fri, 26 Feb 2021 13:00:10 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=39181#p39181</guid>
		</item>
		<item>
			<title><![CDATA[Re: Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=39179#p39179</link>
			<description><![CDATA[<p>Sort of copying relative tables is easy for you.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Fri, 26 Feb 2021 12:00:04 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=39179#p39179</guid>
		</item>
		<item>
			<title><![CDATA[Migrate contacts to new company in FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=39175#p39175</link>
			<description><![CDATA[<p>I had to create a new company database from an old one due to some inconsistencies in the old database.&nbsp; Everything stays the same - customers, suppliers, CoA, company info.</p><p>I need a simple way to transfer the customer and supplier contacts from the old company to the new one.&nbsp; I have seen the &quot;Manual Import of Customers&quot; entry in the wiki page, but there seems to be no export option in FA, and I&#039;m not too conversant with SQL.</p><p>Can I copy the relevant DB tables and rename the company ID?&nbsp; Any pointers would be appreciated.</p>]]></description>
			<author><![CDATA[null@example.com (mawulitse)]]></author>
			<pubDate>Wed, 24 Feb 2021 16:08:22 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=39175#p39175</guid>
		</item>
	</channel>
</rss>
