http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/23432.aspxWed, 01 Oct 2014 21:08:12 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:23432Method_Inderdeep0http://forums.method.me/cs/forums/thread/23432.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=23432<p><span id="mce_0_start" style="overflow:hidden;">Hello StWilson3,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Here&#39;s my answer. Firstly, yes Method can handle that much amount of information without any issues. But in terms of Importing <span id="mce_2_start" style="overflow:hidden;">I</span>&nbsp;would highly recommend to start importing in a small batches in order to make sure importing is smooth. Here are few tips that I&nbsp;<span id="mce_0_start" style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;"></span></span>would like to share with you.</p> <p><span id="mce_3_start" style="overflow:hidden;">- Try importing 3000 customers first and see if they goes through smoothly, repeat it one more time to make sure your data is importing successfully. Once both<span id="mce_4_start" style="overflow:hidden;"> the</span> imports <span id="mce_5_start" style="overflow:hidden;">are successful, you can increase the number of customers with each import.</span></span></p> <p><span id="mce_3_start" style="overflow:hidden;">- If all the information is going to one table then Yes<span id="mce_6_start" style="overflow:hidden;">,</span> you can definitely do it in one shot<span id="mce_7_start" style="overflow:hidden;"> by putting the value in the corresponding fields of the Table. For more info please refer to this video Tutorials on <span id="mce_8_start" style="overflow:hidden;"></span><a href="http://www.youtube.com/watch?v=z1q9YW_erfs&amp;list=PLG5Qmoh21vN47-N8kN4Is8n8UIZxFkOK0&amp;index=1" target="_blank">Importing/Exporting Customers<span id="mce_8_end" style="overflow:hidden;"></span></a></span></span></p> <p><span id="mce_3_start" style="overflow:hidden;"></span><span id="mce_13_start" style="overflow:hidden;">- Unfortunately, there is no estimated time for the process, but if the number of records are more it is likely to take long time. Once you complete your first batch you will get idea how long it will take to update all those records. <span id="mce_14_start" style="overflow:hidden;">(</span>Please do not try to update huge number of records like 10,000 or more.<span id="mce_15_start" style="overflow:hidden;">)</span></span></p> <p><span id="mce_13_start" style="overflow:hidden;"></span>- A<span id="mce_2_start" style="overflow:hidden;"></span>s far as importing is concern, <span id="mce_1_start" style="overflow:hidden;">browser palys an important role. Mozilla firefox&nbsp;<span id="mce_2_end" style="overflow:hidden;"><span id="mce_12_start" style="overflow:hidden;">is very reliable browser and&nbsp;<span id="mce_3_end" style="overflow:hidden;"></span><span id="mce_16_start" style="overflow:hidden;">we never come across any issues while using Mozilla Firefox.</span></span></span></span></p> <p></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span id="mce_17_start" style="overflow:hidden;"></span>-Inder</span></span></span></span></p>http://forums.method.me/cs/forums/thread/23431.aspxWed, 01 Oct 2014 20:24:08 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:23431StWilson30http://forums.method.me/cs/forums/thread/23431.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=23431<p><span style="overflow:hidden;" id="mce_0_start"></span><span style="overflow:hidden;" id="mce_1_start">We have about 66,000 customer records to import into method. Each one of these will also have a related set of information imported (serial number<span style="overflow:hidden;" id="mce_3_start">, version,</span> and product info)<span style="overflow:hidden;" id="mce_2_start"> into a</span><span style="overflow:hidden;" id="mce_2_end"></span> custom table that we have created<span style="overflow:hidden;" id="mce_4_start"> and linked to the customer info</span>. Many <span style="overflow:hidden;" id="mce_5_start">of the customers </span>will have two or more <span style="overflow:hidden;" id="mce_6_start">registration </span>entries.<br /><br />1. Will method function normally with this amount of <span style="overflow:hidden;" id="mce_8_start"></span>info<span style="overflow:hidden;" id="mce_7_start"></span>rmation<span style="overflow:hidden;" id="mce_8_end"></span> or will it get bogged down every time we try to do something.<span style="overflow:hidden;" id="mce_12_start"></span><br /><span style="overflow:hidden;" id="mce_9_start"></span><br />2. As far as importing goes, I <span style="overflow:hidden;" id="mce_10_start">believe</span><span style="overflow:hidden;" id="mce_10_end"></span> I have to do a two-step import process - once to get the customers in and then another one to get the registration info imported for the customer. <br />- Any idea how long it would take to import this amount of data? <br />- Can I do it at one shot or does it need to be broken up? <br /><br />I saw an older post in the forum that they recommended using groups of 500. Not sure if this is still the case. Not really looking forward to going through the process of importing 132 different files to get the customers in, and at least that many for the second import.</span><span style="overflow:hidden;" id="mce_11_start"></span></p>