# CommCare Export tool to MySQL Error

**URL:** <https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139>\
**Category:** Developers\
**Created:** [December 16, 2016, 5:30pm UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139 "2016-12-16T17:30:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ajay\_Singh](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/a/e9bcb4/32.png) [@Ajay\_Singh](https://forum.dimagi.com/u/Ajay_Singh)\
**Post date:** [December 16, 2016, 5:30pm UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139/1 "2016-12-16T17:30:50Z")

</div>

Hello Simon,

As shared in my earlier mail, regarding exporting CommCare data to MySQL  
using commcare-export tool,  
I have re-installed and re-configured complete python and commcare setup in  
my laptop, but the issue is as it is,

i.e. first export to MySQL, then adding some records in CommCare web, then  
exporting same form's data to existing table in MySQL, it is showing same  
error  
_"​Table 'registration' already exists"_, that I was facing previously. In  
my expectations, it should automatically sync incremental records.

Simon, now its too long way to hit same ground again and again, so I will  
request for your help,  
Lets take my machine's control over Google hangout and investigate the  
problem their in.

We propose and request this session for Monday, 19-Dec-2016.

Please share your contact number so that we can reach you. In next mail, I  
am sending you meeting invite for Monday, 19-Dec-2016, for remote session.

Please find my cell number in below signature panel.

> **···**
>
> -- Thanks, \*Ajay Singh\* \*Corporate\*\* Renaissance \*\*Group\* Cell (India): +91-9711628763​ Email: ajay.singh@crgoup.co.in
> 
> [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> 
> On Wed, Dec 14, 2016 at 2:17 AM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> 
> > Hi Simon,
> > 
> > Thanks for your suggestion and continuous support. That's your kindness.
> > 
> > I have followed the way you suggested, i.e. uninstalled and re-installed  
> > commcare-export, but sorry to say, the same issue still persists.
> > 
> > I am getting same error message, i.e.  
> > ​  
> > ​​  
> > "Table 'registration' already exists"
> > 
> > ​Next, I am thinking to uninstall the complete python setup​, including  
> > commcare-export from my laptop, and will do complete setup again.
> > 
> > Lets see, what will happen.
> > 
> > Please suggest.
> > 
> > --  
> > Thanks,  
> > _Ajay Singh_  
> > _Corporate_\* Renaissance \*_Group_  
> > Cell (India): +91-9711628763​  
> > Email: ajay.singh@crgoup.co.in
> > 
> > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > 
> > On Tue, Dec 13, 2016 at 6:14 PM, Simon Kelly [skelly@dimagi.com](mailto:skelly@dimagi.com) wrote:
> > 
> > > Hi Ayjay
> > > 
> > > I don't think this is a library issue. Nobody else using the tools has  
> > > had this issue. I'm sure it's something to do with the specific  
> > > configuration on your computer. It's possible that there are stale files  
> > > that need to be removed.
> > > 
> > > Please try uninstalling and re-installing commcare-export:
> > > 
> > > > pip uninstall commcare-export  
> > > > pip install commcare-export
> > > 
> > > On 12 December 2016 at 20:53, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > 
> > > > Hi Simon,
> > > > 
> > > > Thanks for your suggestion.
> > > > 
> > > > By using the given way (i.e. mysql+pymysql://root:root@localhost:3306/​myDbName),  
> > > > I am getting following error:
> > > > 
> > > > ## sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1050, u ​​ "Table 'registration' already exists") [SQL: u'\nCREATE TABLE `registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32) COLLATE utf8\_bin, \n\t`form.sevikaname` VARCHAR(32) COLLATE utf8\_bin, \n\t`form.awwnumber` VARCHAR(32) COLLATE utf8\_bin, \n\tstarted\_time VARCHAR(32) COLLATE utf8\_bin, \n\treceived\_on VARCHAR(32) COLLATE utf8\_bin, \n\tcaseid VARCHAR(32) COLLATE utf8\_bin, \n\tformid VARCHAR(41) COLLATE utf8\_bin, \n\t`form.beatid` VARCHAR(32) COLLATE utf8\_bin, \n\tcase\_name VARCHAR(32) COLLATE utf8\_bin, \n\t`form.coid` VARCHAR(32) COLLATE utf8\_bin, \n\tcompleted\_time VARCHAR(32) COLLATE utf8\_bin, \n\t`form.uniqueid` VARCHAR(32) COLLATE utf8\_bin, \n\tPRIMARY KEY (id)\n)\n\n']
> > > > 
> > > > I am using MySQL-Python Library 1.2.5, which was installed by the setup  
> > > > 'MySQL-python-1.2.5.win32-py2.7.exe'
> > > > 
> > > > Can you please suggest me the relevant MySQL-Python library, in which  
> > > > this issue was fixed.
> > > > 
> > > > I will also keep trying some other ways available in the internet (if  
> > > > any), and will update you accordingly.
> > > > 
> > > > --  
> > > > Ajay
> > > > 
> > > > On Monday, December 12, 2016 at 6:29:04 PM UTC+5:30, Simon Kelly wrote:
> > > > 
> > > > > The only other thing I can think of is that it's not using the correct  
> > > > > MySQL library. Please try change the connection url to the following:
> > > > > 
> > > > > mysql+pymysql://root:root@localhost:3306/​myDbName
> > > > > 
> > > > > On 12 December 2016 at 14:44, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > 
> > > > > > Hi Simon,
> > > > > > 
> > > > > > Thanks for your suggestion.
> > > > > > 
> > > > > > I have upgraded the commcare-export tool by following command:
> > > > > > 
> > > > > > ​  
> > > > > > pip install -U commcare-export
> > > > > > 
> > > > > > but still, it is giving me same error (as sent in previous mail's  
> > > > > > attached file), as follows:
> > > > > > 
> > > > > > _Note: I am sending last lines of error message:_
> > > > > > 
> > > > > > sqlalchemy.exc.OperationalError: (\_mysql\_exceptions.OperationalError)  
> > > > > > (1050, "Table 'registration' already exists") [SQL: u'\nCREATE TABLE  
> > > > > > `Registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32),  
> > > > > > \n\t`form.sevikaname` VARCHAR(32), \n\t`form.awwnumber` VARCHAR(32),  
> > > > > > \n\tstarted\_time VARCHAR(32), \n\treceived\_on VARCHAR(32), \n\tcaseid  
> > > > > > VARCHAR(32), \n\tformid VARCHAR(41), \n\t`form.beatid` VARCHAR(32),  
> > > > > > \n\tcase\_name VARCHAR(32), \n\t`form.coid` VARCHAR(32), \n\tcompleted\_time  
> > > > > > VARCHAR(32), \n\t`form.uniqueid` VARCHAR(32), \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > 
> > > > > > ​Please suggest the way forward to resolve this, as it is now become  
> > > > > > mission critical issue.​
> > > > > > 
> > > > > > For your current reference, please find below snapshot:
> > > > > > 
> > > > > > [image: Inline image 1]
> > > > > > 
> > > > > > --  
> > > > > > Thanks,  
> > > > > > _Ajay Singh_  
> > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > Cell (India): +91-9711628763​  
> > > > > > Email: ajay....@crgoup.co.in
> > > > > > 
> > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > 
> > > > > > On Mon, Dec 12, 2016 at 4:08 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > 
> > > > > > > Hi Ajay
> > > > > > > 
> > > > > > > The issue you're experiencing is a bug in the version of the export  
> > > > > > > tool you are using. Upgrading to the latest version will fix it:
> > > > > > > 
> > > > > > > ​​  
> > > > > > > pip install -U commcare-export
> > > > > > > 
> > > > > > > Thanks  
> > > > > > > Simon
> > > > > > > 
> > > > > > > On 9 December 2016 at 20:46, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > 
> > > > > > > > Hi Simon,
> > > > > > > > 
> > > > > > > > Please find below answers to your queries:
> > > > > > > > 
> > > > > > > > 1. Operating System: Windows 10 Pro
> > > > > > > > 
> > > > > > > > 2. Python Version and pip freeze  
> > > > > > > > [image: Inline image 1]
> > > > > > > > 
> > > > > > > > 3. Exact output is attached as file 'CommCare-Export\_Error.txt'.
> > > > > > > > 
> > > > > > > > Please analyse and suggest.
> > > > > > > > 
> > > > > > > > --  
> > > > > > > > Thanks,  
> > > > > > > > _Ajay Singh_  
> > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > 
> > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > 
> > > > > > > > On Fri, Dec 9, 2016 at 7:43 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > 
> > > > > > > > > What operating system are you using? Can you please show the output  
> > > > > > > > > of the following commands:
> > > > > > > > > 
> > > > > > > > > ```
> > > > > > > > > python --version
> > > > > > > > > pip freeze
> > > > > > > > > 
> > > > > > > > > ```
> > > > > > > > > 
> > > > > > > > > Please also send the exact output from the export tool.
> > > > > > > > > 
> > > > > > > > > Thanks.
> > > > > > > > > 
> > > > > > > > > On 9 December 2016 at 15:51, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > 
> > > > > > > > > > Hi Simon,
> > > > > > > > > > 
> > > > > > > > > > Please refer below the steps of my query:
> > > > > > > > > > 
> > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > 
> > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > error.
> > > > > > > > > > 
> > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting same  
> > > > > > > > > > form with some added records,  
> > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > 
> > > > > > > > > > And, I am running following command for export:
> > > > > > > > > > 
> > > > > > > > > > commcare-export --username AAAAAA --password ######  
> > > > > > > > > > --output-format sql --output mysql://root:root@localhost:3306/  
> > > > > > > > > > ​​  
> > > > > > > > > > myDbName --project my-test-proj --query D:  
> > > > > > > > > > ​​  
> > > > > > > > > > QueryFile.xlsx
> > > > > > > > > > 
> > > > > > > > > > Issue is coming only when, MySQL table already exists, and I am  
> > > > > > > > > > adding some more records in my form, then exporting the form's data. See  
> > > > > > > > > > step #3 above.
> > > > > > > > > > 
> > > > > > > > > > --  
> > > > > > > > > > Thanks,  
> > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > 
> > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > 
> > > > > > > > > > On Fri, Dec 9, 2016 at 6:52 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > 
> > > > > > > > > > > Please show the exact command you are running (without usernames  
> > > > > > > > > > > etc)
> > > > > > > > > > > 
> > > > > > > > > > > On 9 December 2016 at 15:00, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > > 
> > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > 
> > > > > > > > > > > > Please help us on the requested query.
> > > > > > > > > > > > 
> > > > > > > > > > > > --  
> > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > 
> > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > 
> > > > > > > > > > > > On Fri, Dec 9, 2016 at 1:48 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > 
> > > > > > > > > > > > > Thanks Simon.  
> > > > > > > > > > > > > Its all becomes possible because of prompt support from your  
> > > > > > > > > > > > > side.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Now the data is getting exported to MySQL table from CommCare  
> > > > > > > > > > > > > HQ.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Its Ok, but now, I am facing next challenge, and explaining  
> > > > > > > > > > > > > step by step:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > > > > error.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > From commcare-export tool behavior, I have observed that, it is  
> > > > > > > > > > > > > creating the table every time, you export the data.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > My expectation is,  
> > > > > > > > > > > > > if table does not exists, then it should create the table,  
> > > > > > > > > > > > > else if table exists, then it should insert new records in the  
> > > > > > > > > > > > > table, without showing error message like, "_Table Already  
> > > > > > > > > > > > > Exists_".
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Note: I am not using --since parameter, as I am looking for  
> > > > > > > > > > > > > automating this data export process, and can not do dynamic date change in  
> > > > > > > > > > > > > my command line.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Please suggest the resolution.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > --  
> > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > 
> > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > 
> > > > > > > > > > > > > On Thu, Dec 8, 2016 at 6:33 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > > Great that you got it working!
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > On 8 December 2016 at 14:54, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Many-many thanks for your prompt support and reply.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > I referred the documentation again, and modified my --query  
> > > > > > > > > > > > > > > file for 'id' field.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Now I got _succeeded_ in Commcare-Export to MySQL data  
> > > > > > > > > > > > > > > integration.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Once again, many thanks to Simon, Ben and Ethan, and whole  
> > > > > > > > > > > > > > > CommCare Support team.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 1:08 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > As is mentioned in the documentation: Note that for use  
> > > > > > > > > > > > > > > > with a SQL database, a field named id is _required_.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > On 8 December 2016 at 00:23, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Hi Ethan,
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Thank you.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > The URL,  
> > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb  
> > > > > > > > > > > > > > > > > has given me idea about installing MySQL-Python from pip  
> > > > > > > > > > > > > > > > > win, but unfortunately it did not worked for me.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > However, I surfed and got a site: [https://www.youtube.com/](https://www.youtube.com/)  
> > > > > > > > > > > > > > > > > watch?v=soeIgysM-XU
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > which has given me the idea to  
> > > > > > > > > > > > > > > > > install: MySQL-python-1.2.5.win32-py2.7.exe to resolve  
> > > > > > > > > > > > > > > > > MySQL issue, and I got succeeded to resolve MySQL error at my end.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Thank you. I moved one step ahead.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Now when I am using commcare-export to export data to  
> > > > > > > > > > > > > > > > > MySQL, it is automatically adding an 'id' field as primary key in MySQL  
> > > > > > > > > > > > > > > > > table, but there no such field or value coming from CommCare HQ or in my  
> > > > > > > > > > > > > > > > > --query file, so the insert statement is getting failed. Although the data  
> > > > > > > > > > > > > > > > > is downloading and showing on screen, but no inserts in MySQL.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Please refer below error message and suggest:
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:45 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Thanks Ethan,
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > I am going thru with the given URL and will update you on  
> > > > > > > > > > > > > > > > > > my progress.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:32 AM, Ethan Soergel \< [esoe...@dimagi.com](mailto:esoe...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Did you see my reply on December 2nd? I'll copy that  
> > > > > > > > > > > > > > > > > > > again here in case you missed it:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > It looks like that module may have some binary components
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > that need to be installed separately. Here is a stack overflow thread with  
> > > > > > > > > > > > > > > > > > > > a number of potential solutions to this issue:  
> > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > When I searched for your error message on google, I found  
> > > > > > > > > > > > > > > > > > > a number of reports of similar issues. "pip install mysql" might not be  
> > > > > > > > > > > > > > > > > > > enough, you may need to install some dependencies through your operating  
> > > > > > > > > > > > > > > > > > > system's package manager (apt-get, for Ubuntu), as suggested in the above  
> > > > > > > > > > > > > > > > > > > link. SQLAlchemy is a library used for interacting with SQL databases from  
> > > > > > > > > > > > > > > > > > > python programs.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > On Wed, Dec 7, 2016 at 1:36 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Hi Support team,
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > This is to put in revised followup, regarding  
> > > > > > > > > > > > > > > > > > > > CommCare-Export tool's data export to MySQL database;  
> > > > > > > > > > > > > > > > > > > > we have tried in many ways, as whatever available  
> > > > > > > > > > > > > > > > > > > > resources in your site as well as in github, but every time, we are facing  
> > > > > > > > > > > > > > > > > > > > issue related to 'sqlalchemy'.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > We have installed required libraries for MySQL, as  
> > > > > > > > > > > > > > > > > > > > suggested by Simon in last mail (  
> > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > "pip install pymysql"), but still issue not resolved.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Kindly suggest and help us to resolve, are we missing  
> > > > > > > > > > > > > > > > > > > > some steps related to configuration of 'sqlalchemy'?, also please elaborate  
> > > > > > > > > > > > > > > > > > > > as what is this 'sqlalchemy'?
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Will appreciate your quick help in this context, as it  
> > > > > > > > > > > > > > > > > > > > is long pending request at your end.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 9:29 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Thanks Simon,
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > I have installed MySQL libraries by using  
> > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > "pip install pymysql" command. It got installed  
> > > > > > > > > > > > > > > > > > > > > successfully.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > On running CommCare export command, I am getting below  
> > > > > > > > > > > > > > > > > > > > > error message.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > I am using following format for MySQL db URL:  
> > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 8:46 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > You can install the package with  
> > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > On 2 December 2016 at 16:40, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > Hi Support Team,
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > We are trying to export data from CommCare Export  
> > > > > > > > > > > > > > > > > > > > > > > tool to MySQL Database. We are using following DB URL format:
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > But the tool is giving following error message.  
> > > > > > > > > > > > > > > > > > > > > > > Please review and suggest the solution.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > * * *
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > You received this message because you are subscribed to  
> > > > > > > > > > > > > > > > > > > > the Google Groups "CommCare Developers" group.  
> > > > > > > > > > > > > > > > > > > > To unsubscribe from this group and stop receiving emails  
> > > > > > > > > > > > > > > > > > > > from it, send an email to commcare-developers+unsubscrib  
> > > > > > > > > > > > > > > > > > > > [e@googlegroups.com](mailto:e@googlegroups.com).  
> > > > > > > > > > > > > > > > > > > > For more options, visit [https://groups.google.com/d/op](https://groups.google.com/d/op)  
> > > > > > > > > > > > > > > > > > > > tout.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > 
> > > > > > > > > > > --  
> > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > 
> > > > > > > > > --  
> > > > > > > > > Simon Kelly  
> > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > 
> > > > > > > --  
> > > > > > > Simon Kelly  
> > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > 
> > > > > > --
> > > > > > 
> > > > > > * * *
> > > > > > 
> > > > > > You received this message because you are subscribed to the Google  
> > > > > > Groups "CommCare Developers" group.  
> > > > > > To unsubscribe from this group and stop receiving emails from it, send  
> > > > > > an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > 
> > > > > --  
> > > > > Simon Kelly  
> > > > > Senior Engineer | Dimagi South Africa
> > > > 
> > > > --
> > > > 
> > > > * * *
> > > > 
> > > > You received this message because you are subscribed to the Google  
> > > > Groups "CommCare Developers" group.  
> > > > To unsubscribe from this group and stop receiving emails from it, send  
> > > > an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > 
> > > --  
> > > Simon Kelly  
> > > Senior Engineer | Dimagi South Africa
> > > 
> > > --
> > > 
> > > * * *
> > > 
> > > You received this message because you are subscribed to a topic in the  
> > > Google Groups "CommCare Developers" group.  
> > > To unsubscribe from this topic, visit [https://groups.google.com/d/to](https://groups.google.com/d/to)  
> > > pic/commcare-developers/1Euu2eUUPB0/unsubscribe.  
> > > To unsubscribe from this group and all its topics, send an email to  
> > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).
> > > 
> > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Ajay\_Singh](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/a/e9bcb4/32.png) [@Ajay\_Singh](https://forum.dimagi.com/u/Ajay_Singh)\
**Post date:** [December 19, 2016, 12:48pm UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139/2 "2016-12-19T12:48:41Z")

</div>

Hello CommCare Support Team,

Please find below mail trail for history of the case, we are facing an  
issue with _commcare-export tool_, while exporting data to MySQL.  
Although its a long back going on discussion, please find below summary of  
the case:

> **···**
>
> ----------------------------------------------------------------------------------------------------- 1) If I am exporting the data for first time, it is getting exported to MySQL perfectly.
> 
> 1. If I am exporting the same data/form, 2nd time, without any  
> change/insert in my form, the commcare-export tool executing without any  
> error.
> 
> 2. Now, if I am adding more records in my form, and exporting same form  
> with some added records,  
> then commcare-export tool showing error message like, "_Table Already  
> Exists_". Yes table was created in step #1.
> 
> My expectation is, new records should be inserted without any such error  
> like "_Table Already Exists_".
> 
> I am running following command for export:
> 
> commcare-export --username AAAAAA --password ###### --output-format sql  
> --output mysql://root:root@localhost:3306/​​myDbName --project my-test-proj  
> --query D:\​​QueryFile.xlsx
> 
> ## Issue is coming only when, MySQL table already exists, and I am adding some more records in my form, then exporting the form's data. See step #3 above.
> 
> Requesting you, _please align someone from support team, who can take our  
> system in remote control, investigate our system, and can guide us, as  
> where we are lacking in the configuration of python and commcare-export  
> tool_.
> 
> This issue is now very critical for us and need to be closed asap.
> 
> Your prompt support will be highly appreciated.
> 
> --  
> Thanks,  
> _Ajay Singh_  
> _Corporate_\* Renaissance \*_Group_  
> Cell (India): +91-9711628763​  
> Email: ajay.singh@crgoup.co.in
> 
> [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> 
> On Fri, Dec 16, 2016 at 11:00 PM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> 
> > Hello Simon,
> > 
> > As shared in my earlier mail, regarding exporting CommCare data to MySQL  
> > using commcare-export tool,  
> > I have re-installed and re-configured complete python and commcare setup  
> > in my laptop, but the issue is as it is,
> > 
> > i.e. first export to MySQL, then adding some records in CommCare web,  
> > then exporting same form's data to existing table in MySQL, it is showing  
> > same error  
> > _"​Table 'registration' already exists"_, that I was facing previously.  
> > In my expectations, it should automatically sync incremental records.
> > 
> > Simon, now its too long way to hit same ground again and again, so I will  
> > request for your help,  
> > Lets take my machine's control over Google hangout and investigate the  
> > problem their in.
> > 
> > We propose and request this session for Monday, 19-Dec-2016.
> > 
> > Please share your contact number so that we can reach you. In next mail, I  
> > am sending you meeting invite for Monday, 19-Dec-2016, for remote session.
> > 
> > Please find my cell number in below signature panel.
> > 
> > --  
> > Thanks,  
> > _Ajay Singh_  
> > _Corporate_\* Renaissance \*_Group_  
> > Cell (India): +91-9711628763​  
> > Email: ajay.singh@crgoup.co.in
> > 
> > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > 
> > On Wed, Dec 14, 2016 at 2:17 AM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > 
> > > Hi Simon,
> > > 
> > > Thanks for your suggestion and continuous support. That's your kindness.
> > > 
> > > I have followed the way you suggested, i.e. uninstalled and re-installed  
> > > commcare-export, but sorry to say, the same issue still persists.
> > > 
> > > I am getting same error message, i.e.  
> > > ​  
> > > ​​  
> > > "Table 'registration' already exists"
> > > 
> > > ​Next, I am thinking to uninstall the complete python setup​, including  
> > > commcare-export from my laptop, and will do complete setup again.
> > > 
> > > Lets see, what will happen.
> > > 
> > > Please suggest.
> > > 
> > > --  
> > > Thanks,  
> > > _Ajay Singh_  
> > > _Corporate_\* Renaissance \*_Group_  
> > > Cell (India): +91-9711628763​  
> > > Email: ajay.singh@crgoup.co.in
> > > 
> > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > 
> > > On Tue, Dec 13, 2016 at 6:14 PM, Simon Kelly [skelly@dimagi.com](mailto:skelly@dimagi.com) wrote:
> > > 
> > > > Hi Ayjay
> > > > 
> > > > I don't think this is a library issue. Nobody else using the tools has  
> > > > had this issue. I'm sure it's something to do with the specific  
> > > > configuration on your computer. It's possible that there are stale files  
> > > > that need to be removed.
> > > > 
> > > > Please try uninstalling and re-installing commcare-export:
> > > > 
> > > > > pip uninstall commcare-export  
> > > > > pip install commcare-export
> > > > 
> > > > On 12 December 2016 at 20:53, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > > 
> > > > > Hi Simon,
> > > > > 
> > > > > Thanks for your suggestion.
> > > > > 
> > > > > By using the given way (i.e. mysql+pymysql://root:root@localhost:3306/​myDbName),  
> > > > > I am getting following error:
> > > > > 
> > > > > ## sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1050, u ​​ "Table 'registration' already exists") [SQL: u'\nCREATE TABLE `registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32) COLLATE utf8\_bin, \n\t`form.sevikaname` VARCHAR(32) COLLATE utf8\_bin, \n\t`form.awwnumber` VARCHAR(32) COLLATE utf8\_bin, \n\tstarted\_time VARCHAR(32) COLLATE utf8\_bin, \n\treceived\_on VARCHAR(32) COLLATE utf8\_bin, \n\tcaseid VARCHAR(32) COLLATE utf8\_bin, \n\tformid VARCHAR(41) COLLATE utf8\_bin, \n\t`form.beatid` VARCHAR(32) COLLATE utf8\_bin, \n\tcase\_name VARCHAR(32) COLLATE utf8\_bin, \n\t`form.coid` VARCHAR(32) COLLATE utf8\_bin, \n\tcompleted\_time VARCHAR(32) COLLATE utf8\_bin, \n\t`form.uniqueid` VARCHAR(32) COLLATE utf8\_bin, \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > 
> > > > > I am using MySQL-Python Library 1.2.5, which was installed by the  
> > > > > setup 'MySQL-python-1.2.5.win32-py2.7.exe'
> > > > > 
> > > > > Can you please suggest me the relevant MySQL-Python library, in which  
> > > > > this issue was fixed.
> > > > > 
> > > > > I will also keep trying some other ways available in the internet (if  
> > > > > any), and will update you accordingly.
> > > > > 
> > > > > --  
> > > > > Ajay
> > > > > 
> > > > > On Monday, December 12, 2016 at 6:29:04 PM UTC+5:30, Simon Kelly wrote:
> > > > > 
> > > > > > The only other thing I can think of is that it's not using the correct  
> > > > > > MySQL library. Please try change the connection url to the following:
> > > > > > 
> > > > > > mysql+pymysql://root:root@localhost:3306/​myDbName
> > > > > > 
> > > > > > On 12 December 2016 at 14:44, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > 
> > > > > > > Hi Simon,
> > > > > > > 
> > > > > > > Thanks for your suggestion.
> > > > > > > 
> > > > > > > I have upgraded the commcare-export tool by following command:
> > > > > > > 
> > > > > > > ​  
> > > > > > > pip install -U commcare-export
> > > > > > > 
> > > > > > > but still, it is giving me same error (as sent in previous mail's  
> > > > > > > attached file), as follows:
> > > > > > > 
> > > > > > > _Note: I am sending last lines of error message:_
> > > > > > > 
> > > > > > > sqlalchemy.exc.OperationalError: (\_mysql\_exceptions.OperationalError)  
> > > > > > > (1050, "Table 'registration' already exists") [SQL: u'\nCREATE TABLE  
> > > > > > > `Registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32),  
> > > > > > > \n\t`form.sevikaname` VARCHAR(32), \n\t`form.awwnumber` VARCHAR(32),  
> > > > > > > \n\tstarted\_time VARCHAR(32), \n\treceived\_on VARCHAR(32), \n\tcaseid  
> > > > > > > VARCHAR(32), \n\tformid VARCHAR(41), \n\t`form.beatid` VARCHAR(32),  
> > > > > > > \n\tcase\_name VARCHAR(32), \n\t`form.coid` VARCHAR(32), \n\tcompleted\_time  
> > > > > > > VARCHAR(32), \n\t`form.uniqueid` VARCHAR(32), \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > > 
> > > > > > > ​Please suggest the way forward to resolve this, as it is now become  
> > > > > > > mission critical issue.​
> > > > > > > 
> > > > > > > For your current reference, please find below snapshot:
> > > > > > > 
> > > > > > > [image: Inline image 1]
> > > > > > > 
> > > > > > > --  
> > > > > > > Thanks,  
> > > > > > > _Ajay Singh_  
> > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > Cell (India): +91-9711628763​  
> > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > 
> > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > 
> > > > > > > On Mon, Dec 12, 2016 at 4:08 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > 
> > > > > > > > Hi Ajay
> > > > > > > > 
> > > > > > > > The issue you're experiencing is a bug in the version of the export  
> > > > > > > > tool you are using. Upgrading to the latest version will fix it:
> > > > > > > > 
> > > > > > > > ​​  
> > > > > > > > pip install -U commcare-export
> > > > > > > > 
> > > > > > > > Thanks  
> > > > > > > > Simon
> > > > > > > > 
> > > > > > > > On 9 December 2016 at 20:46, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > 
> > > > > > > > > Hi Simon,
> > > > > > > > > 
> > > > > > > > > Please find below answers to your queries:
> > > > > > > > > 
> > > > > > > > > 1. Operating System: Windows 10 Pro
> > > > > > > > > 
> > > > > > > > > 2. Python Version and pip freeze  
> > > > > > > > > [image: Inline image 1]
> > > > > > > > > 
> > > > > > > > > 3. Exact output is attached as file 'CommCare-Export\_Error.txt'.
> > > > > > > > > 
> > > > > > > > > Please analyse and suggest.
> > > > > > > > > 
> > > > > > > > > --  
> > > > > > > > > Thanks,  
> > > > > > > > > _Ajay Singh_  
> > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > 
> > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > 
> > > > > > > > > On Fri, Dec 9, 2016 at 7:43 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > 
> > > > > > > > > > What operating system are you using? Can you please show the  
> > > > > > > > > > output of the following commands:
> > > > > > > > > > 
> > > > > > > > > > ```
> > > > > > > > > > python --version
> > > > > > > > > > pip freeze
> > > > > > > > > > 
> > > > > > > > > > ```
> > > > > > > > > > 
> > > > > > > > > > Please also send the exact output from the export tool.
> > > > > > > > > > 
> > > > > > > > > > Thanks.
> > > > > > > > > > 
> > > > > > > > > > On 9 December 2016 at 15:51, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > 
> > > > > > > > > > > Hi Simon,
> > > > > > > > > > > 
> > > > > > > > > > > ​​  
> > > > > > > > > > > Please refer below the steps of my query:
> > > > > > > > > > > 
> > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > 
> > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > > error.
> > > > > > > > > > > 
> > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > 
> > > > > > > > > > > And, I am running following command for export:
> > > > > > > > > > > 
> > > > > > > > > > > commcare-export --username AAAAAA --password ######  
> > > > > > > > > > > --output-format sql --output mysql://root:root@localhost:3306/  
> > > > > > > > > > > ​​  
> > > > > > > > > > > myDbName --project my-test-proj --query D:  
> > > > > > > > > > > ​​  
> > > > > > > > > > > QueryFile.xlsx
> > > > > > > > > > > 
> > > > > > > > > > > Issue is coming only when, MySQL table already exists, and I am  
> > > > > > > > > > > adding some more records in my form, then exporting the form's data. See  
> > > > > > > > > > > step #3 above.
> > > > > > > > > > > 
> > > > > > > > > > > --  
> > > > > > > > > > > Thanks,  
> > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > 
> > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > 
> > > > > > > > > > > On Fri, Dec 9, 2016 at 6:52 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > 
> > > > > > > > > > > > Please show the exact command you are running (without usernames  
> > > > > > > > > > > > etc)
> > > > > > > > > > > > 
> > > > > > > > > > > > On 9 December 2016 at 15:00, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > > > 
> > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Please help us on the requested query.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > --  
> > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > 
> > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > 
> > > > > > > > > > > > > On Fri, Dec 9, 2016 at 1:48 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > > Thanks Simon.  
> > > > > > > > > > > > > > Its all becomes possible because of prompt support from your  
> > > > > > > > > > > > > > side.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > Now the data is getting exported to MySQL table from CommCare  
> > > > > > > > > > > > > > HQ.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > Its Ok, but now, I am facing next challenge, and explaining  
> > > > > > > > > > > > > > step by step:
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > > > > > error.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > From commcare-export tool behavior, I have observed that, it  
> > > > > > > > > > > > > > is creating the table every time, you export the data.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > My expectation is,  
> > > > > > > > > > > > > > if table does not exists, then it should create the table,  
> > > > > > > > > > > > > > else if table exists, then it should insert new records in the  
> > > > > > > > > > > > > > table, without showing error message like, "_Table Already  
> > > > > > > > > > > > > > Exists_".
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > Note: I am not using --since parameter, as I am looking for  
> > > > > > > > > > > > > > automating this data export process, and can not do dynamic date change in  
> > > > > > > > > > > > > > my command line.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > Please suggest the resolution.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 6:33 PM, Simon Kelly \<[ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Great that you got it working!
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > On 8 December 2016 at 14:54, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Many-many thanks for your prompt support and reply.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > I referred the documentation again, and modified my --query  
> > > > > > > > > > > > > > > > file for 'id' field.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Now I got _succeeded_ in Commcare-Export to MySQL data  
> > > > > > > > > > > > > > > > integration.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Once again, many thanks to Simon, Ben and Ethan, and whole  
> > > > > > > > > > > > > > > > CommCare Support team.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 1:08 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > As is mentioned in the documentation: Note that for use  
> > > > > > > > > > > > > > > > > with a SQL database, a field named id is _required_.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > On 8 December 2016 at 00:23, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Hi Ethan,
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Thank you.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > The URL,  
> > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb  
> > > > > > > > > > > > > > > > > > has given me idea about installing MySQL-Python from pip  
> > > > > > > > > > > > > > > > > > win, but unfortunately it did not worked for me.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > However, I surfed and got a site: [https://www.youtube.com/](https://www.youtube.com/)  
> > > > > > > > > > > > > > > > > > watch?v=soeIgysM-XU
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > which has given me the idea to  
> > > > > > > > > > > > > > > > > > install: MySQL-python-1.2.5.win32-py2.7.exe to resolve  
> > > > > > > > > > > > > > > > > > MySQL issue, and I got succeeded to resolve MySQL error at my end.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Thank you. I moved one step ahead.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Now when I am using commcare-export to export data to  
> > > > > > > > > > > > > > > > > > MySQL, it is automatically adding an 'id' field as primary key in MySQL  
> > > > > > > > > > > > > > > > > > table, but there no such field or value coming from CommCare HQ or in my  
> > > > > > > > > > > > > > > > > > --query file, so the insert statement is getting failed. Although the data  
> > > > > > > > > > > > > > > > > > is downloading and showing on screen, but no inserts in MySQL.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Please refer below error message and suggest:
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:45 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Thanks Ethan,
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > I am going thru with the given URL and will update you on  
> > > > > > > > > > > > > > > > > > > my progress.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:32 AM, Ethan Soergel \< [esoe...@dimagi.com](mailto:esoe...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Did you see my reply on December 2nd? I'll copy that  
> > > > > > > > > > > > > > > > > > > > again here in case you missed it:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > It looks like that module may have some binary
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > components that need to be installed separately. Here is a stack overflow  
> > > > > > > > > > > > > > > > > > > > > thread with a number of potential solutions to this issue:  
> > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > When I searched for your error message on google, I  
> > > > > > > > > > > > > > > > > > > > found a number of reports of similar issues. "pip install mysql" might not  
> > > > > > > > > > > > > > > > > > > > be enough, you may need to install some dependencies through your operating  
> > > > > > > > > > > > > > > > > > > > system's package manager (apt-get, for Ubuntu), as suggested in the above  
> > > > > > > > > > > > > > > > > > > > link. SQLAlchemy is a library used for interacting with SQL databases from  
> > > > > > > > > > > > > > > > > > > > python programs.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > On Wed, Dec 7, 2016 at 1:36 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Hi Support team,
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > This is to put in revised followup, regarding  
> > > > > > > > > > > > > > > > > > > > > CommCare-Export tool's data export to MySQL database;  
> > > > > > > > > > > > > > > > > > > > > we have tried in many ways, as whatever available  
> > > > > > > > > > > > > > > > > > > > > resources in your site as well as in github, but every time, we are facing  
> > > > > > > > > > > > > > > > > > > > > issue related to 'sqlalchemy'.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > We have installed required libraries for MySQL, as  
> > > > > > > > > > > > > > > > > > > > > suggested by Simon in last mail (  
> > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > "pip install pymysql"), but still issue not resolved.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Kindly suggest and help us to resolve, are we missing  
> > > > > > > > > > > > > > > > > > > > > some steps related to configuration of 'sqlalchemy'?, also please elaborate  
> > > > > > > > > > > > > > > > > > > > > as what is this 'sqlalchemy'?
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Will appreciate your quick help in this context, as it  
> > > > > > > > > > > > > > > > > > > > > is long pending request at your end.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 9:29 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > Thanks Simon,
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > I have installed MySQL libraries by using  
> > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > "pip install pymysql" command. It got installed  
> > > > > > > > > > > > > > > > > > > > > > successfully.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > On running CommCare export command, I am getting below  
> > > > > > > > > > > > > > > > > > > > > > error message.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > I am using following format for MySQL db URL:  
> > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 8:46 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > You can install the package with  
> > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > On 2 December 2016 at 16:40, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > Hi Support Team,
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > We are trying to export data from CommCare Export  
> > > > > > > > > > > > > > > > > > > > > > > > tool to MySQL Database. We are using following DB URL format:
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > But the tool is giving following error message.  
> > > > > > > > > > > > > > > > > > > > > > > > Please review and suggest the solution.
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > * * *
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > You received this message because you are subscribed to  
> > > > > > > > > > > > > > > > > > > > > the Google Groups "CommCare Developers" group.  
> > > > > > > > > > > > > > > > > > > > > To unsubscribe from this group and stop receiving  
> > > > > > > > > > > > > > > > > > > > > emails from it, send an email to  
> > > > > > > > > > > > > > > > > > > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > > > > > > > > > > > > > > > For more options, visit [https://groups.google.com/d/op](https://groups.google.com/d/op)  
> > > > > > > > > > > > > > > > > > > > > tout.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > 
> > > > > > > > > > > > --  
> > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > 
> > > > > > > > > > --  
> > > > > > > > > > Simon Kelly  
> > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > 
> > > > > > > > --  
> > > > > > > > Simon Kelly  
> > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > 
> > > > > > > --
> > > > > > > 
> > > > > > > * * *
> > > > > > > 
> > > > > > > You received this message because you are subscribed to the Google  
> > > > > > > Groups "CommCare Developers" group.  
> > > > > > > To unsubscribe from this group and stop receiving emails from it,  
> > > > > > > send an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > 
> > > > > > --  
> > > > > > Simon Kelly  
> > > > > > Senior Engineer | Dimagi South Africa
> > > > > 
> > > > > --
> > > > > 
> > > > > * * *
> > > > > 
> > > > > You received this message because you are subscribed to the Google  
> > > > > Groups "CommCare Developers" group.  
> > > > > To unsubscribe from this group and stop receiving emails from it, send  
> > > > > an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > 
> > > > --  
> > > > Simon Kelly  
> > > > Senior Engineer | Dimagi South Africa
> > > > 
> > > > --
> > > > 
> > > > * * *
> > > > 
> > > > You received this message because you are subscribed to a topic in the  
> > > > Google Groups "CommCare Developers" group.  
> > > > To unsubscribe from this topic, visit [https://groups.google.com/d/to](https://groups.google.com/d/to)  
> > > > pic/commcare-developers/1Euu2eUUPB0/unsubscribe.  
> > > > To unsubscribe from this group and all its topics, send an email to  
> > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).
> > > > 
> > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Ajay\_Singh](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/a/e9bcb4/32.png) [@Ajay\_Singh](https://forum.dimagi.com/u/Ajay_Singh)\
**Post date:** [December 20, 2016, 8:02pm UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139/3 "2016-12-20T20:02:19Z")

</div>

Hi Support team,

We are waiting for your reply.

Please try to understand criticality of the issue we are facing currently.

> **···**
>
> -- Thanks, \*Ajay Singh\* \*Corporate\*\* Renaissance \*\*Group\* Cell (India): +91-9711628763​ Email: ajay.singh@crgoup.co.in
> 
> [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> 
> On Mon, Dec 19, 2016 at 6:18 PM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> 
> > Hello CommCare Support Team,
> > 
> > Please find below mail trail for history of the case, we are facing an  
> > issue with _commcare-export tool_, while exporting data to MySQL.  
> > Although its a long back going on discussion, please find below summary of  
> > the case:
> > 
> > * * *
> > 
> > * * *
> > 
> > 1. If I am exporting the data for first time, it is getting exported to  
> > MySQL perfectly.
> > 
> > 2. If I am exporting the same data/form, 2nd time, without any  
> > change/insert in my form, the commcare-export tool executing without any  
> > error.
> > 
> > 3. Now, if I am adding more records in my form, and exporting same form  
> > with some added records,  
> > then commcare-export tool showing error message like, "_Table Already  
> > Exists_". Yes table was created in step #1.
> > 
> > My expectation is, new records should be inserted without any such error  
> > like "_Table Already Exists_".
> > 
> > I am running following command for export:
> > 
> > commcare-export --username AAAAAA --password ###### --output-format sql  
> > --output mysql://root:root@localhost:3306/​​myDbName --project  
> > my-test-proj --query D:\​​QueryFile.xlsx
> > 
> > ## Issue is coming only when, MySQL table already exists, and I am adding some more records in my form, then exporting the form's data. See step #3 above.
> > 
> > * * *
> > 
> > Requesting you, _please align someone from support team, who can take our  
> > system in remote control, investigate our system, and can guide us, as  
> > where we are lacking in the configuration of python and commcare-export  
> > tool_.
> > 
> > This issue is now very critical for us and need to be closed asap.
> > 
> > Your prompt support will be highly appreciated.
> > 
> > --  
> > Thanks,  
> > _Ajay Singh_  
> > _Corporate_\* Renaissance \*_Group_  
> > Cell (India): +91-9711628763​  
> > Email: ajay.singh@crgoup.co.in
> > 
> > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > 
> > On Fri, Dec 16, 2016 at 11:00 PM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > 
> > > Hello Simon,
> > > 
> > > As shared in my earlier mail, regarding exporting CommCare data to MySQL  
> > > using commcare-export tool,  
> > > I have re-installed and re-configured complete python and commcare setup  
> > > in my laptop, but the issue is as it is,
> > > 
> > > i.e. first export to MySQL, then adding some records in CommCare web,  
> > > then exporting same form's data to existing table in MySQL, it is showing  
> > > same error  
> > > _"​Table 'registration' already exists"_, that I was facing previously.  
> > > In my expectations, it should automatically sync incremental records.
> > > 
> > > Simon, now its too long way to hit same ground again and again, so I will  
> > > request for your help,  
> > > Lets take my machine's control over Google hangout and investigate the  
> > > problem their in.
> > > 
> > > We propose and request this session for Monday, 19-Dec-2016.
> > > 
> > > Please share your contact number so that we can reach you. In next mail,  
> > > I am sending you meeting invite for Monday, 19-Dec-2016, for remote session.
> > > 
> > > Please find my cell number in below signature panel.
> > > 
> > > --  
> > > Thanks,  
> > > _Ajay Singh_  
> > > _Corporate_\* Renaissance \*_Group_  
> > > Cell (India): +91-9711628763​  
> > > Email: ajay.singh@crgoup.co.in
> > > 
> > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > 
> > > On Wed, Dec 14, 2016 at 2:17 AM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > 
> > > > Hi Simon,
> > > > 
> > > > Thanks for your suggestion and continuous support. That's your kindness.
> > > > 
> > > > I have followed the way you suggested, i.e. uninstalled and re-installed  
> > > > commcare-export, but sorry to say, the same issue still persists.
> > > > 
> > > > I am getting same error message, i.e.  
> > > > ​  
> > > > ​​  
> > > > "Table 'registration' already exists"
> > > > 
> > > > ​Next, I am thinking to uninstall the complete python setup​, including  
> > > > commcare-export from my laptop, and will do complete setup again.
> > > > 
> > > > Lets see, what will happen.
> > > > 
> > > > Please suggest.
> > > > 
> > > > --  
> > > > Thanks,  
> > > > _Ajay Singh_  
> > > > _Corporate_\* Renaissance \*_Group_  
> > > > Cell (India): +91-9711628763​  
> > > > Email: ajay.singh@crgoup.co.in
> > > > 
> > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > 
> > > > On Tue, Dec 13, 2016 at 6:14 PM, Simon Kelly [skelly@dimagi.com](mailto:skelly@dimagi.com) wrote:
> > > > 
> > > > > Hi Ayjay
> > > > > 
> > > > > I don't think this is a library issue. Nobody else using the tools has  
> > > > > had this issue. I'm sure it's something to do with the specific  
> > > > > configuration on your computer. It's possible that there are stale files  
> > > > > that need to be removed.
> > > > > 
> > > > > Please try uninstalling and re-installing commcare-export:
> > > > > 
> > > > > > pip uninstall commcare-export  
> > > > > > pip install commcare-export
> > > > > 
> > > > > On 12 December 2016 at 20:53, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > > > 
> > > > > > Hi Simon,
> > > > > > 
> > > > > > Thanks for your suggestion.
> > > > > > 
> > > > > > By using the given way (i.e. mysql+pymysql://root:root@localhost:3306/​myDbName),  
> > > > > > I am getting following error:
> > > > > > 
> > > > > > ## sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1050, u ​​ "Table 'registration' already exists") [SQL: u'\nCREATE TABLE `registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32) COLLATE utf8\_bin, \n\t`form.sevikaname` VARCHAR(32) COLLATE utf8\_bin, \n\t`form.awwnumber` VARCHAR(32) COLLATE utf8\_bin, \n\tstarted\_time VARCHAR(32) COLLATE utf8\_bin, \n\treceived\_on VARCHAR(32) COLLATE utf8\_bin, \n\tcaseid VARCHAR(32) COLLATE utf8\_bin, \n\tformid VARCHAR(41) COLLATE utf8\_bin, \n\t`form.beatid` VARCHAR(32) COLLATE utf8\_bin, \n\tcase\_name VARCHAR(32) COLLATE utf8\_bin, \n\t`form.coid` VARCHAR(32) COLLATE utf8\_bin, \n\tcompleted\_time VARCHAR(32) COLLATE utf8\_bin, \n\t`form.uniqueid` VARCHAR(32) COLLATE utf8\_bin, \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > 
> > > > > > I am using MySQL-Python Library 1.2.5, which was installed by the  
> > > > > > setup 'MySQL-python-1.2.5.win32-py2.7.exe'
> > > > > > 
> > > > > > Can you please suggest me the relevant MySQL-Python library, in which  
> > > > > > this issue was fixed.
> > > > > > 
> > > > > > I will also keep trying some other ways available in the internet (if  
> > > > > > any), and will update you accordingly.
> > > > > > 
> > > > > > --  
> > > > > > Ajay
> > > > > > 
> > > > > > On Monday, December 12, 2016 at 6:29:04 PM UTC+5:30, Simon Kelly wrote:
> > > > > > 
> > > > > > > The only other thing I can think of is that it's not using the  
> > > > > > > correct MySQL library. Please try change the connection url to the  
> > > > > > > following:
> > > > > > > 
> > > > > > > mysql+pymysql://root:root@localhost:3306/​myDbName
> > > > > > > 
> > > > > > > On 12 December 2016 at 14:44, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > 
> > > > > > > > Hi Simon,
> > > > > > > > 
> > > > > > > > Thanks for your suggestion.
> > > > > > > > 
> > > > > > > > I have upgraded the commcare-export tool by following command:
> > > > > > > > 
> > > > > > > > ​  
> > > > > > > > pip install -U commcare-export
> > > > > > > > 
> > > > > > > > but still, it is giving me same error (as sent in previous mail's  
> > > > > > > > attached file), as follows:
> > > > > > > > 
> > > > > > > > _Note: I am sending last lines of error message:_
> > > > > > > > 
> > > > > > > > sqlalchemy.exc.OperationalError: (\_mysql\_exceptions.OperationalError)  
> > > > > > > > (1050, "Table 'registration' already exists") [SQL: u'\nCREATE TABLE  
> > > > > > > > `Registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32),  
> > > > > > > > \n\t`form.sevikaname` VARCHAR(32), \n\t`form.awwnumber` VARCHAR(32),  
> > > > > > > > \n\tstarted\_time VARCHAR(32), \n\treceived\_on VARCHAR(32), \n\tcaseid  
> > > > > > > > VARCHAR(32), \n\tformid VARCHAR(41), \n\t`form.beatid` VARCHAR(32),  
> > > > > > > > \n\tcase\_name VARCHAR(32), \n\t`form.coid` VARCHAR(32), \n\tcompleted\_time  
> > > > > > > > VARCHAR(32), \n\t`form.uniqueid` VARCHAR(32), \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > > > 
> > > > > > > > ​Please suggest the way forward to resolve this, as it is now become  
> > > > > > > > mission critical issue.​
> > > > > > > > 
> > > > > > > > For your current reference, please find below snapshot:
> > > > > > > > 
> > > > > > > > [image: Inline image 1]
> > > > > > > > 
> > > > > > > > --  
> > > > > > > > Thanks,  
> > > > > > > > _Ajay Singh_  
> > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > 
> > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > 
> > > > > > > > On Mon, Dec 12, 2016 at 4:08 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > 
> > > > > > > > > Hi Ajay
> > > > > > > > > 
> > > > > > > > > The issue you're experiencing is a bug in the version of the export  
> > > > > > > > > tool you are using. Upgrading to the latest version will fix it:
> > > > > > > > > 
> > > > > > > > > ​​  
> > > > > > > > > pip install -U commcare-export
> > > > > > > > > 
> > > > > > > > > Thanks  
> > > > > > > > > Simon
> > > > > > > > > 
> > > > > > > > > On 9 December 2016 at 20:46, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > 
> > > > > > > > > > Hi Simon,
> > > > > > > > > > 
> > > > > > > > > > Please find below answers to your queries:
> > > > > > > > > > 
> > > > > > > > > > 1. Operating System: Windows 10 Pro
> > > > > > > > > > 
> > > > > > > > > > 2. Python Version and pip freeze  
> > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > 
> > > > > > > > > > 3. Exact output is attached as file 'CommCare-Export\_Error.txt'.
> > > > > > > > > > 
> > > > > > > > > > Please analyse and suggest.
> > > > > > > > > > 
> > > > > > > > > > --  
> > > > > > > > > > Thanks,  
> > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > 
> > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > 
> > > > > > > > > > On Fri, Dec 9, 2016 at 7:43 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > 
> > > > > > > > > > > What operating system are you using? Can you please show the  
> > > > > > > > > > > output of the following commands:
> > > > > > > > > > > 
> > > > > > > > > > > ```
> > > > > > > > > > > python --version
> > > > > > > > > > > pip freeze
> > > > > > > > > > > 
> > > > > > > > > > > ```
> > > > > > > > > > > 
> > > > > > > > > > > Please also send the exact output from the export tool.
> > > > > > > > > > > 
> > > > > > > > > > > Thanks.
> > > > > > > > > > > 
> > > > > > > > > > > On 9 December 2016 at 15:51, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > > 
> > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > 
> > > > > > > > > > > > ​​  
> > > > > > > > > > > > Please refer below the steps of my query:
> > > > > > > > > > > > 
> > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > 
> > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > > > error.
> > > > > > > > > > > > 
> > > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > 
> > > > > > > > > > > > And, I am running following command for export:
> > > > > > > > > > > > 
> > > > > > > > > > > > commcare-export --username AAAAAA --password ######  
> > > > > > > > > > > > --output-format sql --output mysql://root:root@localhost:3306/  
> > > > > > > > > > > > ​​  
> > > > > > > > > > > > myDbName --project my-test-proj --query D:  
> > > > > > > > > > > > ​​  
> > > > > > > > > > > > QueryFile.xlsx
> > > > > > > > > > > > 
> > > > > > > > > > > > Issue is coming only when, MySQL table already exists, and I am  
> > > > > > > > > > > > adding some more records in my form, then exporting the form's data. See  
> > > > > > > > > > > > step #3 above.
> > > > > > > > > > > > 
> > > > > > > > > > > > --  
> > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > 
> > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > 
> > > > > > > > > > > > On Fri, Dec 9, 2016 at 6:52 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > > 
> > > > > > > > > > > > > Please show the exact command you are running (without  
> > > > > > > > > > > > > usernames etc)
> > > > > > > > > > > > > 
> > > > > > > > > > > > > On 9 December 2016 at 15:00, Ajay Singh \<ajay....@crgroup.co.in wrote:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > Please help us on the requested query.
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > On Fri, Dec 9, 2016 at 1:48 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Thanks Simon.  
> > > > > > > > > > > > > > > Its all becomes possible because of prompt support from your  
> > > > > > > > > > > > > > > side.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Now the data is getting exported to MySQL table from CommCare  
> > > > > > > > > > > > > > > HQ.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Its Ok, but now, I am facing next challenge, and explaining  
> > > > > > > > > > > > > > > step by step:
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without  
> > > > > > > > > > > > > > > any change/insert in my form, the commcare-export tool executing without  
> > > > > > > > > > > > > > > any error.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > From commcare-export tool behavior, I have observed that, it  
> > > > > > > > > > > > > > > is creating the table every time, you export the data.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > My expectation is,  
> > > > > > > > > > > > > > > if table does not exists, then it should create the table,  
> > > > > > > > > > > > > > > else if table exists, then it should insert new records in  
> > > > > > > > > > > > > > > the table, without showing error message like, "_Table  
> > > > > > > > > > > > > > > Already Exists_".
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Note: I am not using --since parameter, as I am looking for  
> > > > > > > > > > > > > > > automating this data export process, and can not do dynamic date change in  
> > > > > > > > > > > > > > > my command line.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Please suggest the resolution.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 6:33 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Great that you got it working!
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > On 8 December 2016 at 14:54, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Many-many thanks for your prompt support and reply.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > I referred the documentation again, and modified my --query  
> > > > > > > > > > > > > > > > > file for 'id' field.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Now I got _succeeded_ in Commcare-Export to MySQL data  
> > > > > > > > > > > > > > > > > integration.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Once again, many thanks to Simon, Ben and Ethan, and whole  
> > > > > > > > > > > > > > > > > CommCare Support team.
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 1:08 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > As is mentioned in the documentation: Note that for use  
> > > > > > > > > > > > > > > > > > with a SQL database, a field named id is _required_.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > On 8 December 2016 at 00:23, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Hi Ethan,
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Thank you.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > The URL,  
> > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb  
> > > > > > > > > > > > > > > > > > > has given me idea about installing MySQL-Python from pip  
> > > > > > > > > > > > > > > > > > > win, but unfortunately it did not worked for me.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > However, I surfed and got a site:  
> > > > > > > > > > > > > > > > > > > [https://www.youtube.com/watch?v=soeIgysM-XU](https://www.youtube.com/watch?v=soeIgysM-XU)
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > which has given me the idea to  
> > > > > > > > > > > > > > > > > > > install: MySQL-python-1.2.5.win32-py2.7.exe to resolve  
> > > > > > > > > > > > > > > > > > > MySQL issue, and I got succeeded to resolve MySQL error at my end.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Thank you. I moved one step ahead.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Now when I am using commcare-export to export data to  
> > > > > > > > > > > > > > > > > > > MySQL, it is automatically adding an 'id' field as primary key in MySQL  
> > > > > > > > > > > > > > > > > > > table, but there no such field or value coming from CommCare HQ or in my  
> > > > > > > > > > > > > > > > > > > --query file, so the insert statement is getting failed. Although the data  
> > > > > > > > > > > > > > > > > > > is downloading and showing on screen, but no inserts in MySQL.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > Please refer below error message and suggest:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:45 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Thanks Ethan,
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > I am going thru with the given URL and will update you  
> > > > > > > > > > > > > > > > > > > > on my progress.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:32 AM, Ethan Soergel \< [esoe...@dimagi.com](mailto:esoe...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Did you see my reply on December 2nd? I'll copy that  
> > > > > > > > > > > > > > > > > > > > > again here in case you missed it:
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > It looks like that module may have some binary
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > components that need to be installed separately. Here is a stack overflow  
> > > > > > > > > > > > > > > > > > > > > > thread with a number of potential solutions to this issue:  
> > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > When I searched for your error message on google, I  
> > > > > > > > > > > > > > > > > > > > > found a number of reports of similar issues. "pip install mysql" might not  
> > > > > > > > > > > > > > > > > > > > > be enough, you may need to install some dependencies through your operating  
> > > > > > > > > > > > > > > > > > > > > system's package manager (apt-get, for Ubuntu), as suggested in the above  
> > > > > > > > > > > > > > > > > > > > > link. SQLAlchemy is a library used for interacting with SQL databases from  
> > > > > > > > > > > > > > > > > > > > > python programs.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > On Wed, Dec 7, 2016 at 1:36 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > Hi Support team,
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > This is to put in revised followup, regarding  
> > > > > > > > > > > > > > > > > > > > > > CommCare-Export tool's data export to MySQL database;  
> > > > > > > > > > > > > > > > > > > > > > we have tried in many ways, as whatever available  
> > > > > > > > > > > > > > > > > > > > > > resources in your site as well as in github, but every time, we are facing  
> > > > > > > > > > > > > > > > > > > > > > issue related to 'sqlalchemy'.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > We have installed required libraries for MySQL, as  
> > > > > > > > > > > > > > > > > > > > > > suggested by Simon in last mail (  
> > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"), but still issue not resolved.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > Kindly suggest and help us to resolve, are we missing  
> > > > > > > > > > > > > > > > > > > > > > some steps related to configuration of 'sqlalchemy'?, also please elaborate  
> > > > > > > > > > > > > > > > > > > > > > as what is this 'sqlalchemy'?
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > Will appreciate your quick help in this context, as it  
> > > > > > > > > > > > > > > > > > > > > > is long pending request at your end.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 9:29 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > Thanks Simon,
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > I have installed MySQL libraries by using  
> > > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql" command. It got installed  
> > > > > > > > > > > > > > > > > > > > > > > successfully.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > On running CommCare export command, I am getting  
> > > > > > > > > > > > > > > > > > > > > > > below error message.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > I am using following format for MySQL db URL:  
> > > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 8:46 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > You can install the package with  
> > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > On 2 December 2016 at 16:40, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > Hi Support Team,
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > We are trying to export data from CommCare Export  
> > > > > > > > > > > > > > > > > > > > > > > > > tool to MySQL Database. We are using following DB URL format:
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > But the tool is giving following error message.  
> > > > > > > > > > > > > > > > > > > > > > > > > Please review and suggest the solution.
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > * * *
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > You received this message because you are subscribed  
> > > > > > > > > > > > > > > > > > > > > > to the Google Groups "CommCare Developers" group.  
> > > > > > > > > > > > > > > > > > > > > > To unsubscribe from this group and stop receiving  
> > > > > > > > > > > > > > > > > > > > > > emails from it, send an email to  
> > > > > > > > > > > > > > > > > > > > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > > > > > > > > > > > > > > > > For more options, visit [https://groups.google.com/d/op](https://groups.google.com/d/op)  
> > > > > > > > > > > > > > > > > > > > > > tout.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > 
> > > > > > > > > > > > > --  
> > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > 
> > > > > > > > > > > --  
> > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > 
> > > > > > > > > --  
> > > > > > > > > Simon Kelly  
> > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > 
> > > > > > > > --
> > > > > > > > 
> > > > > > > > * * *
> > > > > > > > 
> > > > > > > > You received this message because you are subscribed to the Google  
> > > > > > > > Groups "CommCare Developers" group.  
> > > > > > > > To unsubscribe from this group and stop receiving emails from it,  
> > > > > > > > send an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > > 
> > > > > > > --  
> > > > > > > Simon Kelly  
> > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > 
> > > > > > --
> > > > > > 
> > > > > > * * *
> > > > > > 
> > > > > > You received this message because you are subscribed to the Google  
> > > > > > Groups "CommCare Developers" group.  
> > > > > > To unsubscribe from this group and stop receiving emails from it, send  
> > > > > > an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > 
> > > > > --  
> > > > > Simon Kelly  
> > > > > Senior Engineer | Dimagi South Africa
> > > > > 
> > > > > --
> > > > > 
> > > > > * * *
> > > > > 
> > > > > You received this message because you are subscribed to a topic in the  
> > > > > Google Groups "CommCare Developers" group.  
> > > > > To unsubscribe from this topic, visit [https://groups.google.com/d/to](https://groups.google.com/d/to)  
> > > > > pic/commcare-developers/1Euu2eUUPB0/unsubscribe.  
> > > > > To unsubscribe from this group and all its topics, send an email to  
> > > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).
> > > > > 
> > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Jonathan\_Jackson](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/j/278dde/32.png) [@Jonathan\_Jackson](https://forum.dimagi.com/u/Jonathan_Jackson)\
**Post date:** [December 20, 2016, 8:26pm UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139/4 "2016-12-20T20:26:21Z")

</div>

Hi Ajay -

Due to the holidays, much of the community is not online currently. I also  
want to clarify that the type of support you are requesting is not  
available from Dimagi as part of our stewardship of the open source  
community for CommCare. We do offer enhanced support for customers on our  
cloud subscriptions. One thing that may help generate a faster response is  
if you can replicate the errors you are having on a fresh machine / virtual  
machine with steps that are easy to replicate (maybe have a colleague run  
through them as well to verify its reproducible). As Simon mentioned, we  
haven't heard of this issue coming up before in the community and it is not  
considered a reproducible issue at this point.

-Jonathan

> **···**
>
> On Tue, Dec 20, 2016 at 3:02 PM, Ajay Singh wrote:
> 
> > Hi Support team,
> > 
> > We are waiting for your reply.
> > 
> > Please try to understand criticality of the issue we are facing currently.
> > 
> > --  
> > Thanks,  
> > _Ajay Singh_  
> > _Corporate_\* Renaissance \*_Group_  
> > Cell (India): +91-9711628763 \<+91%2097116%2028763\>​  
> > Email: ajay.singh@crgoup.co.in
> > 
> > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > 
> > On Mon, Dec 19, 2016 at 6:18 PM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > 
> > > Hello CommCare Support Team,
> > > 
> > > Please find below mail trail for history of the case, we are facing an  
> > > issue with _commcare-export tool_, while exporting data to MySQL.  
> > > Although its a long back going on discussion, please find below summary  
> > > of the case:
> > > 
> > > * * *
> > > 
> > > * * *
> > > 
> > > 1. If I am exporting the data for first time, it is getting exported to  
> > > MySQL perfectly.
> > > 
> > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > change/insert in my form, the commcare-export tool executing without any  
> > > error.
> > > 
> > > 3. Now, if I am adding more records in my form, and exporting same form  
> > > with some added records,  
> > > then commcare-export tool showing error message like, "_Table Already  
> > > Exists_". Yes table was created in step #1.
> > > 
> > > My expectation is, new records should be inserted without any such error  
> > > like "_Table Already Exists_".
> > > 
> > > I am running following command for export:
> > > 
> > > commcare-export --username AAAAAA --password ###### --output-format sql  
> > > --output mysql://root:root@localhost:3306/​​myDbName --project  
> > > my-test-proj --query D:\​​QueryFile.xlsx
> > > 
> > > ## Issue is coming only when, MySQL table already exists, and I am adding some more records in my form, then exporting the form's data. See step #3 above.
> > > 
> > > * * *
> > > 
> > > Requesting you, _please align someone from support team, who can take  
> > > our system in remote control, investigate our system, and can guide us, as  
> > > where we are lacking in the configuration of python and commcare-export  
> > > tool_.
> > > 
> > > This issue is now very critical for us and need to be closed asap.
> > > 
> > > Your prompt support will be highly appreciated.
> > > 
> > > --  
> > > Thanks,  
> > > _Ajay Singh_  
> > > _Corporate_\* Renaissance \*_Group_  
> > > Cell (India): +91-9711628763 \<+91%2097116%2028763\>​  
> > > Email: ajay.singh@crgoup.co.in
> > > 
> > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > 
> > > On Fri, Dec 16, 2016 at 11:00 PM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > 
> > > > Hello Simon,
> > > > 
> > > > As shared in my earlier mail, regarding exporting CommCare data to MySQL  
> > > > using commcare-export tool,  
> > > > I have re-installed and re-configured complete python and commcare setup  
> > > > in my laptop, but the issue is as it is,
> > > > 
> > > > i.e. first export to MySQL, then adding some records in CommCare web,  
> > > > then exporting same form's data to existing table in MySQL, it is showing  
> > > > same error  
> > > > _"​Table 'registration' already exists"_, that I was facing previously.  
> > > > In my expectations, it should automatically sync incremental records.
> > > > 
> > > > Simon, now its too long way to hit same ground again and again, so I  
> > > > will request for your help,  
> > > > Lets take my machine's control over Google hangout and investigate the  
> > > > problem their in.
> > > > 
> > > > We propose and request this session for Monday, 19-Dec-2016.
> > > > 
> > > > Please share your contact number so that we can reach you. In next mail,  
> > > > I am sending you meeting invite for Monday, 19-Dec-2016, for remote session.
> > > > 
> > > > Please find my cell number in below signature panel.
> > > > 
> > > > --  
> > > > Thanks,  
> > > > _Ajay Singh_  
> > > > _Corporate_\* Renaissance \*_Group_  
> > > > Cell (India): +91-9711628763 \<+91%2097116%2028763\>​  
> > > > Email: ajay.singh@crgoup.co.in
> > > > 
> > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > 
> > > > On Wed, Dec 14, 2016 at 2:17 AM, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > > 
> > > > > Hi Simon,
> > > > > 
> > > > > Thanks for your suggestion and continuous support. That's your kindness.
> > > > > 
> > > > > I have followed the way you suggested, i.e. uninstalled and  
> > > > > re-installed commcare-export, but sorry to say, the same issue still  
> > > > > persists.
> > > > > 
> > > > > I am getting same error message, i.e.  
> > > > > ​  
> > > > > ​​  
> > > > > "Table 'registration' already exists"
> > > > > 
> > > > > ​Next, I am thinking to uninstall the complete python setup​, including  
> > > > > commcare-export from my laptop, and will do complete setup again.
> > > > > 
> > > > > Lets see, what will happen.
> > > > > 
> > > > > Please suggest.
> > > > > 
> > > > > --  
> > > > > Thanks,  
> > > > > _Ajay Singh_  
> > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > Cell (India): +91-9711628763 \<+91%2097116%2028763\>​  
> > > > > Email: ajay.singh@crgoup.co.in
> > > > > 
> > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire Business  
> > > > > Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > 
> > > > > On Tue, Dec 13, 2016 at 6:14 PM, Simon Kelly [skelly@dimagi.com](mailto:skelly@dimagi.com) wrote:
> > > > > 
> > > > > > Hi Ayjay
> > > > > > 
> > > > > > I don't think this is a library issue. Nobody else using the tools has  
> > > > > > had this issue. I'm sure it's something to do with the specific  
> > > > > > configuration on your computer. It's possible that there are stale files  
> > > > > > that need to be removed.
> > > > > > 
> > > > > > Please try uninstalling and re-installing commcare-export:
> > > > > > 
> > > > > > > pip uninstall commcare-export  
> > > > > > > pip install commcare-export
> > > > > > 
> > > > > > On 12 December 2016 at 20:53, Ajay Singh [ajay.singh@crgroup.co.in](mailto:ajay.singh@crgroup.co.in) wrote:
> > > > > > 
> > > > > > > Hi Simon,
> > > > > > > 
> > > > > > > Thanks for your suggestion.
> > > > > > > 
> > > > > > > By using the given way (i.e. mysql+pymysql://root:root@localhost:3306/​myDbName),  
> > > > > > > I am getting following error:
> > > > > > > 
> > > > > > > ## sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1050, u ​​ "Table 'registration' already exists") [SQL: u'\nCREATE TABLE `registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32) COLLATE utf8\_bin, \n\t`form.sevikaname` VARCHAR(32) COLLATE utf8\_bin, \n\t`form.awwnumber` VARCHAR(32) COLLATE utf8\_bin, \n\tstarted\_time VARCHAR(32) COLLATE utf8\_bin, \n\treceived\_on VARCHAR(32) COLLATE utf8\_bin, \n\tcaseid VARCHAR(32) COLLATE utf8\_bin, \n\tformid VARCHAR(41) COLLATE utf8\_bin, \n\t`form.beatid` VARCHAR(32) COLLATE utf8\_bin, \n\tcase\_name VARCHAR(32) COLLATE utf8\_bin, \n\t`form.coid` VARCHAR(32) COLLATE utf8\_bin, \n\tcompleted\_time VARCHAR(32) COLLATE utf8\_bin, \n\t`form.uniqueid` VARCHAR(32) COLLATE utf8\_bin, \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > > 
> > > > > > > I am using MySQL-Python Library 1.2.5, which was installed by the  
> > > > > > > setup 'MySQL-python-1.2.5.win32-py2.7.exe'
> > > > > > > 
> > > > > > > Can you please suggest me the relevant MySQL-Python library, in which  
> > > > > > > this issue was fixed.
> > > > > > > 
> > > > > > > I will also keep trying some other ways available in the internet (if  
> > > > > > > any), and will update you accordingly.
> > > > > > > 
> > > > > > > --  
> > > > > > > Ajay
> > > > > > > 
> > > > > > > On Monday, December 12, 2016 at 6:29:04 PM UTC+5:30, Simon Kelly wrote:
> > > > > > > 
> > > > > > > > The only other thing I can think of is that it's not using the  
> > > > > > > > correct MySQL library. Please try change the connection url to the  
> > > > > > > > following:
> > > > > > > > 
> > > > > > > > mysql+pymysql://root:root@localhost:3306/​myDbName
> > > > > > > > 
> > > > > > > > On 12 December 2016 at 14:44, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > 
> > > > > > > > > Hi Simon,
> > > > > > > > > 
> > > > > > > > > Thanks for your suggestion.
> > > > > > > > > 
> > > > > > > > > I have upgraded the commcare-export tool by following command:
> > > > > > > > > 
> > > > > > > > > ​  
> > > > > > > > > pip install -U commcare-export
> > > > > > > > > 
> > > > > > > > > but still, it is giving me same error (as sent in previous mail's  
> > > > > > > > > attached file), as follows:
> > > > > > > > > 
> > > > > > > > > _Note: I am sending last lines of error message:_
> > > > > > > > > 
> > > > > > > > > sqlalchemy.exc.OperationalError: (\_mysql\_exceptions.OperationalError)  
> > > > > > > > > (1050, "Table 'registration' already exists") [SQL: u'\nCREATE TABLE  
> > > > > > > > > `Registration` (\n\tid VARCHAR(255) NOT NULL, \n\tusername VARCHAR(32),  
> > > > > > > > > \n\t`form.sevikaname` VARCHAR(32), \n\t`form.awwnumber` VARCHAR(32),  
> > > > > > > > > \n\tstarted\_time VARCHAR(32), \n\treceived\_on VARCHAR(32), \n\tcaseid  
> > > > > > > > > VARCHAR(32), \n\tformid VARCHAR(41), \n\t`form.beatid` VARCHAR(32),  
> > > > > > > > > \n\tcase\_name VARCHAR(32), \n\t`form.coid` VARCHAR(32), \n\tcompleted\_time  
> > > > > > > > > VARCHAR(32), \n\t`form.uniqueid` VARCHAR(32), \n\tPRIMARY KEY (id)\n)\n\n']
> > > > > > > > > 
> > > > > > > > > ​Please suggest the way forward to resolve this, as it is now  
> > > > > > > > > become mission critical issue.​
> > > > > > > > > 
> > > > > > > > > For your current reference, please find below snapshot:
> > > > > > > > > 
> > > > > > > > > [image: Inline image 1]
> > > > > > > > > 
> > > > > > > > > --  
> > > > > > > > > Thanks,  
> > > > > > > > > _Ajay Singh_  
> > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > 
> > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > 
> > > > > > > > > On Mon, Dec 12, 2016 at 4:08 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > 
> > > > > > > > > > Hi Ajay
> > > > > > > > > > 
> > > > > > > > > > The issue you're experiencing is a bug in the version of the  
> > > > > > > > > > export tool you are using. Upgrading to the latest version will fix it:
> > > > > > > > > > 
> > > > > > > > > > ​​  
> > > > > > > > > > pip install -U commcare-export
> > > > > > > > > > 
> > > > > > > > > > Thanks  
> > > > > > > > > > Simon
> > > > > > > > > > 
> > > > > > > > > > On 9 December 2016 at 20:46, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > 
> > > > > > > > > > > Hi Simon,
> > > > > > > > > > > 
> > > > > > > > > > > Please find below answers to your queries:
> > > > > > > > > > > 
> > > > > > > > > > > 1. Operating System: Windows 10 Pro
> > > > > > > > > > > 
> > > > > > > > > > > 2. Python Version and pip freeze  
> > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > 
> > > > > > > > > > > 3. Exact output is attached as file 'CommCare-Export\_Error.txt'.
> > > > > > > > > > > 
> > > > > > > > > > > Please analyse and suggest.
> > > > > > > > > > > 
> > > > > > > > > > > --  
> > > > > > > > > > > Thanks,  
> > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > 
> > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > 
> > > > > > > > > > > On Fri, Dec 9, 2016 at 7:43 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > 
> > > > > > > > > > > > What operating system are you using? Can you please show the  
> > > > > > > > > > > > output of the following commands:
> > > > > > > > > > > > 
> > > > > > > > > > > > ```
> > > > > > > > > > > > python --version
> > > > > > > > > > > > pip freeze
> > > > > > > > > > > > 
> > > > > > > > > > > > ```
> > > > > > > > > > > > 
> > > > > > > > > > > > Please also send the exact output from the export tool.
> > > > > > > > > > > > 
> > > > > > > > > > > > Thanks.
> > > > > > > > > > > > 
> > > > > > > > > > > > On 9 December 2016 at 15:51, Ajay Singh [ajay....@crgroup.co.in](mailto:ajay....@crgroup.co.in) wrote:
> > > > > > > > > > > > 
> > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > 
> > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > Please refer below the steps of my query:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without any  
> > > > > > > > > > > > > change/insert in my form, the commcare-export tool executing without any  
> > > > > > > > > > > > > error.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > 3. Now, if I am adding more records in my form, and exporting  
> > > > > > > > > > > > > same form with some added records,  
> > > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > And, I am running following command for export:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > commcare-export --username AAAAAA --password ######  
> > > > > > > > > > > > > --output-format sql --output mysql://root:root@localhost:3306/  
> > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > myDbName --project my-test-proj --query D:  
> > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > QueryFile.xlsx
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Issue is coming only when, MySQL table already exists, and I am  
> > > > > > > > > > > > > adding some more records in my form, then exporting the form's data. See  
> > > > > > > > > > > > > step #3 above.
> > > > > > > > > > > > > 
> > > > > > > > > > > > > --  
> > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > 
> > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image: Rapid-Fire  
> > > > > > > > > > > > > Business Intelligence & Analytics] [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > 
> > > > > > > > > > > > > On Fri, Dec 9, 2016 at 6:52 PM, Simon Kelly [ske...@dimagi.com](mailto:ske...@dimagi.com) wrote:
> > > > > > > > > > > > > 
> > > > > > > > > > > > > > Please show the exact command you are running (without  
> > > > > > > > > > > > > > usernames etc)
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > On 9 December 2016 at 15:00, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > Please help us on the requested query.
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > On Fri, Dec 9, 2016 at 1:48 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Thanks Simon.  
> > > > > > > > > > > > > > > > Its all becomes possible because of prompt support from your  
> > > > > > > > > > > > > > > > side.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Now the data is getting exported to MySQL table from  
> > > > > > > > > > > > > > > > CommCare HQ.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Its Ok, but now, I am facing next challenge, and explaining  
> > > > > > > > > > > > > > > > step by step:
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > 1. If I am exporting the data for first time, it is getting  
> > > > > > > > > > > > > > > > exported to MySQL perfectly.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > 2. If I am exporting the same data/form, 2nd time, without  
> > > > > > > > > > > > > > > > any change/insert in my form, the commcare-export tool executing without  
> > > > > > > > > > > > > > > > any error.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > 3. Now, if I am adding more records in my form, and  
> > > > > > > > > > > > > > > > exporting same form with some added records,  
> > > > > > > > > > > > > > > > then commcare-export tool showing error message like, "_Table  
> > > > > > > > > > > > > > > > Already Exists_". Yes table was created in step #1.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > From commcare-export tool behavior, I have observed that, it  
> > > > > > > > > > > > > > > > is creating the table every time, you export the data.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > My expectation is,  
> > > > > > > > > > > > > > > > if table does not exists, then it should create the table,  
> > > > > > > > > > > > > > > > else if table exists, then it should insert new records in  
> > > > > > > > > > > > > > > > the table, without showing error message like, "_Table  
> > > > > > > > > > > > > > > > Already Exists_".
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Note: I am not using --since parameter, as I am looking for  
> > > > > > > > > > > > > > > > automating this data export process, and can not do dynamic date change in  
> > > > > > > > > > > > > > > > my command line.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > Please suggest the resolution.
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 6:33 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > Great that you got it working!
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > On 8 December 2016 at 14:54, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Hi Simon,
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Many-many thanks for your prompt support and reply.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > I referred the documentation again, and modified my  
> > > > > > > > > > > > > > > > > > --query file for 'id' field.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Now I got _succeeded_ in Commcare-Export to MySQL data  
> > > > > > > > > > > > > > > > > > integration.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > Once again, many thanks to Simon, Ben and Ethan, and whole  
> > > > > > > > > > > > > > > > > > CommCare Support team.
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 1:08 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > As is mentioned in the documentation: Note that for use  
> > > > > > > > > > > > > > > > > > > with a SQL database, a field named id is _required_.
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > On 8 December 2016 at 00:23, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Hi Ethan,
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Thank you.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > The URL,  
> > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb  
> > > > > > > > > > > > > > > > > > > > has given me idea about installing MySQL-Python from pip  
> > > > > > > > > > > > > > > > > > > > win, but unfortunately it did not worked for me.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > However, I surfed and got a site:  
> > > > > > > > > > > > > > > > > > > > [https://www.youtube.com/watch?v=soeIgysM-XU](https://www.youtube.com/watch?v=soeIgysM-XU)
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > which has given me the idea to  
> > > > > > > > > > > > > > > > > > > > install: MySQL-python-1.2.5.win32-py2.7.exe to resolve  
> > > > > > > > > > > > > > > > > > > > MySQL issue, and I got succeeded to resolve MySQL error at my end.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Thank you. I moved one step ahead.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Now when I am using commcare-export to export data to  
> > > > > > > > > > > > > > > > > > > > MySQL, it is automatically adding an 'id' field as primary key in MySQL  
> > > > > > > > > > > > > > > > > > > > table, but there no such field or value coming from CommCare HQ or in my  
> > > > > > > > > > > > > > > > > > > > --query file, so the insert statement is getting failed. Although the data  
> > > > > > > > > > > > > > > > > > > > is downloading and showing on screen, but no inserts in MySQL.
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > Please refer below error message and suggest:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:45 AM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > Thanks Ethan,
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > I am going thru with the given URL and will update you  
> > > > > > > > > > > > > > > > > > > > > on my progress.
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > On Thu, Dec 8, 2016 at 12:32 AM, Ethan Soergel \< [esoe...@dimagi.com](mailto:esoe...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > Did you see my reply on December 2nd? I'll copy that  
> > > > > > > > > > > > > > > > > > > > > > again here in case you missed it:
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > It looks like that module may have some binary
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > components that need to be installed separately. Here is a stack overflow  
> > > > > > > > > > > > > > > > > > > > > > > thread with a number of potential solutions to this issue:  
> > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > [http://stackoverflow.com/quest](http://stackoverflow.com/quest)  
> > > > > > > > > > > > > > > > > > > > > > > ions/22252397/importerror-no-module-named-mysqldb
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > When I searched for your error message on google, I  
> > > > > > > > > > > > > > > > > > > > > > found a number of reports of similar issues. "pip install mysql" might not  
> > > > > > > > > > > > > > > > > > > > > > be enough, you may need to install some dependencies through your operating  
> > > > > > > > > > > > > > > > > > > > > > system's package manager (apt-get, for Ubuntu), as suggested in the above  
> > > > > > > > > > > > > > > > > > > > > > link. SQLAlchemy is a library used for interacting with SQL databases from  
> > > > > > > > > > > > > > > > > > > > > > python programs.
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > On Wed, Dec 7, 2016 at 1:36 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > Hi Support team,
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > This is to put in revised followup, regarding  
> > > > > > > > > > > > > > > > > > > > > > > CommCare-Export tool's data export to MySQL database;  
> > > > > > > > > > > > > > > > > > > > > > > we have tried in many ways, as whatever available  
> > > > > > > > > > > > > > > > > > > > > > > resources in your site as well as in github, but every time, we are facing  
> > > > > > > > > > > > > > > > > > > > > > > issue related to 'sqlalchemy'.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > We have installed required libraries for MySQL, as  
> > > > > > > > > > > > > > > > > > > > > > > suggested by Simon in last mail (  
> > > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"), but still issue not resolved.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > Kindly suggest and help us to resolve, are we missing  
> > > > > > > > > > > > > > > > > > > > > > > some steps related to configuration of 'sqlalchemy'?, also please elaborate  
> > > > > > > > > > > > > > > > > > > > > > > as what is this 'sqlalchemy'?
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > Will appreciate your quick help in this context, as  
> > > > > > > > > > > > > > > > > > > > > > > it is long pending request at your end.
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 9:29 PM, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > Thanks Simon,
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > I have installed MySQL libraries by using  
> > > > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql" command. It got installed  
> > > > > > > > > > > > > > > > > > > > > > > > successfully.
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > On running CommCare export command, I am getting  
> > > > > > > > > > > > > > > > > > > > > > > > below error message.
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > I am using following format for MySQL db URL:  
> > > > > > > > > > > > > > > > > > > > > > > > ​  
> > > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > On Fri, Dec 2, 2016 at 8:46 PM, Simon Kelly \< [ske...@dimagi.com](mailto:ske...@dimagi.com)\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > You can install the package with  
> > > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > > "pip install pymysql"
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > On 2 December 2016 at 16:40, Ajay Singh \< ajay....@crgroup.co.in\> wrote:
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > Hi Support Team,
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > We are trying to export data from CommCare Export  
> > > > > > > > > > > > > > > > > > > > > > > > > > tool to MySQL Database. We are using following DB URL format:
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > ​​  
> > > > > > > > > > > > > > > > > > > > > > > > > > mysql://username:password@host:port/database\_name
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > But the tool is giving following error message.  
> > > > > > > > > > > > > > > > > > > > > > > > > > Please review and suggest the solution.
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > [image: Inline image 1]
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > > > Thanks,  
> > > > > > > > > > > > > > > > > > > > > > > > > > _Ajay Singh_  
> > > > > > > > > > > > > > > > > > > > > > > > > > _Corporate_\* Renaissance \*_Group_  
> > > > > > > > > > > > > > > > > > > > > > > > > > Cell (India): +91-9711628763​  
> > > > > > > > > > > > > > > > > > > > > > > > > > Email: ajay....@crgoup.co.in
> > > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > > [image: CR Group] [http://www.crgroup.com/](http://www.crgroup.com/)[image:  
> > > > > > > > > > > > > > > > > > > > > > > > > > Rapid-Fire Business Intelligence & Analytics]  
> > > > > > > > > > > > > > > > > > > > > > > > > > [http://www.tableau.com/](http://www.tableau.com/)​
> > > > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > * * *
> > > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > > You received this message because you are subscribed  
> > > > > > > > > > > > > > > > > > > > > > > to the Google Groups "CommCare Developers" group.  
> > > > > > > > > > > > > > > > > > > > > > > To unsubscribe from this group and stop receiving  
> > > > > > > > > > > > > > > > > > > > > > > emails from it, send an email to  
> > > > > > > > > > > > > > > > > > > > > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > > > > > > > > > > > > > > > > > For more options, visit  
> > > > > > > > > > > > > > > > > > > > > > > [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > > > 
> > > > > > > > > > > > > > --  
> > > > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > > > 
> > > > > > > > > > > > --  
> > > > > > > > > > > > Simon Kelly  
> > > > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > > 
> > > > > > > > > > --  
> > > > > > > > > > Simon Kelly  
> > > > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > > > 
> > > > > > > > > --
> > > > > > > > > 
> > > > > > > > > * * *
> > > > > > > > > 
> > > > > > > > > You received this message because you are subscribed to the Google  
> > > > > > > > > Groups "CommCare Developers" group.  
> > > > > > > > > To unsubscribe from this group and stop receiving emails from it,  
> > > > > > > > > send an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > > > 
> > > > > > > > --  
> > > > > > > > Simon Kelly  
> > > > > > > > Senior Engineer | Dimagi South Africa
> > > > > > > 
> > > > > > > --
> > > > > > > 
> > > > > > > * * *
> > > > > > > 
> > > > > > > You received this message because you are subscribed to the Google  
> > > > > > > Groups "CommCare Developers" group.  
> > > > > > > To unsubscribe from this group and stop receiving emails from it,  
> > > > > > > send an email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > > > > > 
> > > > > > --  
> > > > > > Simon Kelly  
> > > > > > Senior Engineer | Dimagi South Africa
> > > > > > 
> > > > > > --
> > > > > > 
> > > > > > * * *
> > > > > > 
> > > > > > You received this message because you are subscribed to a topic in the  
> > > > > > Google Groups "CommCare Developers" group.  
> > > > > > To unsubscribe from this topic, visit [https://groups.google.com/d/to](https://groups.google.com/d/to)  
> > > > > > pic/commcare-developers/1Euu2eUUPB0/unsubscribe.  
> > > > > > To unsubscribe from this group and all its topics, send an email to  
> > > > > > [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).
> > > > > > 
> > > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > 
> > --
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "CommCare Developers" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [commcare-developers+unsubscribe@googlegroups.com](mailto:commcare-developers+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Simon\_Kelly](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/simon_kelly/32/494_2.png) [@Simon\_Kelly](https://forum.dimagi.com/u/Simon_Kelly)\
**Post date:** [April 10, 2019, 7:24am UTC](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3139/5 "2019-04-10T07:24:37Z")

</div>

Note this was responded to here: [CommCare Export tool to MySQL Error - #21 by Ajay\_Singh](https://forum.dimagi.com/t/commcare-export-tool-to-mysql-error/3119/21)