Forum


List Manager Support

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

SQL Upload a int(1) field 25.03.2015 22:48

The table I am trying to load ends with a field 'active' that is a 1 digit integer field. It will not load into my list. I have tried Yes/No type (0=No, 1=Yes), number field with and without decimal set to 1 (can't find an explanation of what decimal means) and it just will not load.

I am sure this is just a growing pain but I need to solve the issue. Thanks.

Re: SQL Upload a int(1) field 26.03.2015 09:30

Hi,
for uploading a 0/1 value you should type the column as number (decimals is the number of decimal places you want to store, so it should be set to 0 for this case).
If you type the column as Yes/No, then the value you should load is Yes or No (text).
We were able to upload the numeric column without problems, can you please provide an example row of the csv or the query you're launching for the upload?. You can place a private ticket at your helpdesk if you don't want to share data here.

Thanks, 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
FaLang translation system by Faboba

Our clients' feedback