Español
English
Forum
List Manager Support
List Manager supportForums
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.
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
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