Import users from excel

[jsobrinho]

Hi guys,

I need to import a list of users, filters, and groups from excel, but I have a problem when I try to import the code 0123, this is a numeric value, so I am trying to input this value in Numeric value in excel, but when I import, in Nprniting show just 123.

At this moment, to solve this, I change my field in the data model, the code to TEXT(code) so, I can put this filter in Values column, and not ignore 0, but has another way? It's necessary to change the data type?

the same syntax in Values working, but I changed the data type to string.

[Frank_S]

I tested the import and it works fine even with a leading zero (testing on NPrinting April 2019):

Discount={0.06049999864772}

Imported filter in NPrinting console:

My source data in numeric and is interpreted accordingly.

Perhaps your source data is in fact text?

Anyway, hopefully this helps to guide you correctly.

[jsobrinho]

Thank you for an answer, but my source data is in fact numeric, and I changed to text.

[Daniel_Jenkins]

Hi @jsobrinho ,

I see this as working as intended. The numeric value of 0123 is in fact 123. Of course you can change the display format (in Excel for example)...

...to show leading zero's but the numeric value itself will be 123. I am not sure why you expect it to be otherwise.

HTH - Daniel.