Community
Showing results for 
Search instead for 
Do you mean 
Reply

export to csv

Copper Super Contributor
Posts: 128
Country: USA

export to csv

exporting db to csv

process csv file in excel

then delete all contacts in act db

importing new modified csv back into empty act database

the onlything dublicated are the users as far as i can tell

 

having said all  this i noticed that data listed in the "Activities"  tab has not been imported.

 

Question: Does exporting to comma delimited csv file no include ALL data in ALL fields.

And if so should  I not be able to import same data to same empty database.

Excluding maybe database users data that gets duplicated.

 

The data in question was stored within a normal contact.

 

thanks inadvance

 

 

 

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Copper Super Contributor
Posts: 128
Country: USA

Re: export to csv

saw this

 

http://community.act.com/t5/Act/Export-Tasklist-Activities-to-Excel-text-file-in-Act-2008/m-p/76909/...

 

 

but cannot get to the answer here:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1353...

server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: export to csv

The export to csv can export all the fields in the Contact table. None of the fields in the Activities, History, Groups, Companies or Oppertunities tables are included in the csv export,

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 128
Country: USA

Re: export to csv

what add-on will export/import everything
thank you kindly
server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: export to csv

http://www.jltechnical.com/exporter.htm

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 128
Country: USA

Re: export to csv

will it do imports????
unless i am wrong
was looking at oak....from your site
server stats: Ms Svr Std 2k8, Ms SQL Svr 2k8 R2 build 10.50.4302, ACT! Premium (Web) 2014 v16.0.291.0_HotFix5, 16GIG Memory
http://www.act.com/support/getting-started-documentation
http://www.act.com/support/downloads/act-premium-v16
http://kb.swiftpage.com/app/answers/detail/a_id/36097kwAdministrator%27s%20Guide
Copper Elite Contributor
Posts: 232
Country: Germany

Re: export to csv

Hi softy

 

you may want to look at our datasuite, it can import/export and has a very flexible setup.

you can also descide what feature set you need for the import/export as we do have different versions from basic up to Ultimate

 

regards

 

ACC since 1995
Developer of Addons for ACT

CrmAddon Factory
+1 203 541 0040