Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Import users from excel

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?

numeric value excel.png

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

Labels (1)
3 Replies
Frank_S
Support
Support

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

Discount={0.06049999864772}

numeric leading zero.PNG

Imported filter in NPrinting console:

filter in console.PNG

 

 

 

 

 

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.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jsobrinho
Creator
Creator
Author

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

Daniel_Jenkins
Specialist III
Specialist III

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)...

LeadingZero.png

...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.