Forum


List Manager Support

List Manager support
Forums
Public write access is disabled. Please login

Import data from CSV / Users & Option field 11.01.2016 22:30

Hello,

I want my users to be allowed to put into the form only 2 fields (some external order number and choose one option field). On the basis on this input I need to update the list. If I download xls/csv file there is a User name, and name of the value of the option field. But to import data correctly I need the user id and the value of the option field.
So, as it looks for me...List Manager exports the csv/xls files with the name of the values but to import data from the backends it needs the file with the values. I don't see any sense or I missed something.

And one more thing....Is it also possible to update/overwrite data while importing? As I see there is totally new entry being created so I need to delete all the entries and import updated again? I see there was a suggestion in APR'14 (http://bit.ly/1UK0tkf) of such feature but I cannot find if it's implemented already.

Regards,

Re: Import data from CSV / Users & Option field 12.01.2016 19:52

Hello,
yes, you're right. Some versions ago, this function was working as you explain (it exported values, so you could use that same csv for importing again). A big number of users didn't want to work that way, they use the csv to create reports or to share the list, so they always want to see the names. So this function was changed accordingly. In order to export a list and then import it again (for ex for moving to another site), the option 'export' is the one to be used. It exports in xml format both the list structure and the data (this time, with the values), so it can be imported afterwards.

The add data with csv is intended to load new values at the list, is not a manager for updates. These options (load from csv,sql..) are used to make a first bulk upload of data. If you have at your csv the whole list again with all your values, and you want to 'reload' you have the option to 'empty list' before the new upload in order to avoid duplicates.

Regards
Moonsoft Team
www.moonsoft.es

Re: Import data from CSV / Users & Option field 12.01.2016 21:03

Hi,

can you please advise which file and how to edit it to export data in the backend with the values not the records name? I would be very grateful.

Regards

Re: Import data from CSV / Users & Option field 13.01.2016 11:39

Hi,

You should go to JOOMLA/administrator/components/com_listmanager/models/listing.php and search for 'getDataRecordsUnlimited' function and replace:

function getDataRecordsUnlimited() {
return $this->getDataRecordsWrapper(false,true);
}

with:

function getDataRecordsUnlimited() {
return $this->getDataRecordsWrapper(false,false);
}

If this doesn't work, please place a ticket at helpdesk and we'll take a look.

Regards,
Moonsoft Team
www.moonsoft.es

Re: Import data from CSV / Users & Option field 14.01.2016 17:19

Hi,

for the field of user it works correctly.
But the problem is with the option fields. It exports numeric value of each option but while import it does not read the value of chosen option.

Regards

Re: Import data from CSV / Users & Option field 15.01.2016 10:09

Hi,
the option fields have an internal id. At the export function
getDataRecordsWrapper
you must also change this internal id for the real 'value' of each option. You would need to query database to get this value, the table where option values are stored is listmanager_field_multivalue. You can ask for a custom version if you're not sure how to code this change.


Regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback