Categories
View Replies (7)

Resolved Column 'username' in field list is ambiguous

  1. Larancia
    Larancia
  2. RO CSVI
  3. Tuesday, 19 September 2017
  4.  Subscribe via email
Hi, what does it mean "Column 'username' in field list is ambiguous"?
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
On which export you are getting this error? which CSVI version you are using?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Larancia
Larancia
Accepted Answer Pending Moderation
yes on export...CSVI Pro 7.2.3
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you please tell me on which export operation? Is it VirtueMart User info export or any other? Or send me the export template XML file and i will check. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your export template and click continue. Download the XML file and post it.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Larancia
Larancia
Accepted Answer Pending Moderation
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<csvi>
<template>
<settings>
<action>
<![CDATA[ export ]]>
</action>
<component>
<![CDATA[ com_virtuemart ]]>
</component>
<operation>
<![CDATA[ userinfo ]]>
</operation>
<override>
<![CDATA[ ]]>
</override>
<exportto>
<option>
<![CDATA[ tofile ]]>
</option>
<option>
<![CDATA[ toftp ]]>
</option>
</exportto>
<output_empty_file>
<![CDATA[ yes ]]>
</output_empty_file>
<localpath>
<![CDATA[
/var/www/vhosts/http://quorestore.it/httpdocs/conquist/import
]]>
</localpath>
<ftphost>
<![CDATA[ ftp.mafrat.net ]]>
</ftphost>
<ftpport>
<![CDATA[ 21 ]]>
</ftpport>
<ftpusername>
<![CDATA[ ]]>
</ftpusername>
<ftppass>
<![CDATA[ ]]>
</ftppass>
<ftproot>
<![CDATA[ /conquist/import/ ]]>
</ftproot>
<ftpfile>
<![CDATA[ clienti_[Y][m][d]_[H][i][s].csv ]]>
</ftpfile>
<export_email_addresses>
<![CDATA[ ]]>
</export_email_addresses>
<export_email_addresses_cc>
<![CDATA[ ]]>
</export_email_addresses_cc>
<export_email_addresses_bcc>
<![CDATA[ ]]>
</export_email_addresses_bcc>
<export_email_subject>
<![CDATA[ ]]>
</export_email_subject>
<export_email_body>
<![CDATA[ ]]>
</export_email_body>
<database_username>
<![CDATA[ ]]>
</database_username>
<database_password>
<![CDATA[ ]]>
</database_password>
<database_host>
<![CDATA[ ]]>
</database_host>
<database_portno>
<![CDATA[ ]]>
</database_portno>
<database_name>
<![CDATA[ ]]>
</database_name>
<database_table>
<![CDATA[ ]]>
</database_table>
<primary_key_source>
<![CDATA[ name ]]>
</primary_key_source>
<primary_key_target>
<![CDATA[ id ]]>
</primary_key_target>
<create_new_columns>
<![CDATA[ yes ]]>
</create_new_columns>
<export_filename>
<![CDATA[ clienti_[Y][m][d]_[H][i][s].csv ]]>
</export_filename>
<export_file>
<![CDATA[ csv ]]>
</export_file>
<field_delimiter>
<![CDATA[ , ]]>
</field_delimiter>
<text_enclosure>
<![CDATA[ ]]>
</text_enclosure>
<include_column_headers>
<![CDATA[ yes ]]>
</include_column_headers>
<signature>
<![CDATA[ no ]]>
</signature>
<publish_state>
<![CDATA[ ]]>
</publish_state>
<recordstart>
<![CDATA[ ]]>
</recordstart>
<recordend>
<![CDATA[ ]]>
</recordend>
<export_date_format>
<![CDATA[ d/m/Y H:i:s ]]>
</export_date_format>
<export_price_format_decimal>
<![CDATA[ 2 ]]>
</export_price_format_decimal>
<export_price_format_decsep>
<![CDATA[ . ]]>
</export_price_format_decsep>
<export_price_format_thousep>
<![CDATA[ ]]>
</export_price_format_thousep>
<header>
<![CDATA[ ]]>
</header>
<body>
<![CDATA[ ]]>
</body>
<footer>
<![CDATA[ ]]>
</footer>
<userinfo_address>
<![CDATA[ BT ]]>
</userinfo_address>
<vendors>
<option>
<![CDATA[ none ]]>
</option>
</vendors>
<userinfomdatestart>
<![CDATA[ ]]>
</userinfomdatestart>
<userinfomdateend>
<![CDATA[ ]]>
</userinfomdateend>
<blocked>
<![CDATA[ ]]>
</blocked>
<activated>
<![CDATA[ ]]>
</activated>
<shopper_groups>
<option>
<![CDATA[ no ]]>
</option>
<option>
<![CDATA[ 2 ]]>
</option>
</shopper_groups>
<groupbyfields>
<![CDATA[ {"name":["username"]} ]]>
</groupbyfields>
<sortfields>
<![CDATA[ ]]>
</sortfields>
<use_system_limits>
<![CDATA[ no ]]>
</use_system_limits>
<max_execution_time>
<![CDATA[ ]]>
</max_execution_time>
<memory_limit>
<![CDATA[ ]]>
</memory_limit>
<csvi_template_id>
<![CDATA[ yes ]]>
</csvi_template_id>
<tags>
<![CDATA[ ]]>
</tags>
</settings>
<template_name>
<![CDATA[ clienti ]]>
</template_name>
<advanced>
<![CDATA[ 0 ]]>
</advanced>
<action>
<![CDATA[ export ]]>
</action>
<frontend>
<![CDATA[ 1 ]]>
</frontend>
<secret>
<![CDATA[ ]]>
</secret>
<log>
<![CDATA[ 1 ]]>
</log>
<lastrun>
<![CDATA[ 2017-09-19 07:40:08 ]]>
</lastrun>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<ordering>
<![CDATA[ 0 ]]>
</ordering>
<fields>
<field>
<field_name>
<![CDATA[ name ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 1 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ username ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 2 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ email ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 3 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ password ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 4 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ first_name ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 5 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ last_name ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 6 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ address_1 ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 7 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ zip ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 8 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ city ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 9 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ phone_1 ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 10 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ carta_fidelity ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 15 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ usergroup_name ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 16 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ address_type ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 17 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ address_type_name ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 18 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ Sesso ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 19 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ DataNascita ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 20 ]]>
</ordering>
</field>
<field>
<field_name>
<![CDATA[ Civico ]]>
</field_name>
<xml_node>
<![CDATA[ ]]>
</xml_node>
<table_name>
<![CDATA[ ]]>
</table_name>
<column_header>
<![CDATA[ ]]>
</column_header>
<default_value>
<![CDATA[ ]]>
</default_value>
<enabled>
<![CDATA[ 1 ]]>
</enabled>
<sort>
<![CDATA[ 0 ]]>
</sort>
<cdata>
<![CDATA[ 1 ]]>
</cdata>
<ordering>
<![CDATA[ 21 ]]>
</ordering>
</field>
</fields>
</template>
</csvi>
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you try to load the attached patch file from CSVI maintenance menu and then try the export? See if the error is gone.

patch_vm_users_2017_09_19.zip
Attachments (1)
patch_vm_users_2017_09_19.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Larancia
Larancia
Accepted Answer Pending Moderation
Now work
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Glad to know it worked.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!