267
Views
11
Comments
Solved
Bootstrap Currency from Excel

I created an Entity which has a currency attribute. I cannot bootstrap it from excel. I tried general, number, currency, text type from excel but it never exports the data to Outsystems. It works if the attribute of the entity was Integer which I changed it back to Currency. But this seems a simple thing to do which suppose to work.

Did I miss something? Anyone experience the same issue? Any help is appreciated.

Rank: #410
Solution

So apparently I must dig deep to the processes tab and modify it there

mvp_badge
MVP
Rank: #14

what issue exactly?

do you get errors? 

The whole bootstrap works but you zeroes in the fields.

Can you share the excel and the oml?


Perhaps it's a decimal issue...




Rank: #19654

J. wrote:

what issue exactly?

do you get errors? 

The whole bootstrap works but you zeroes in the fields.

Can you share the excel and the oml?


Perhaps it's a decimal issue...




Hi J, 

    I am facing with this issue. Could you help me

Dilin.


Doc1.docx

Rank: #19654

dilin 1212 wrote:

J. wrote:

what issue exactly?

do you get errors? 

The whole bootstrap works but you zeroes in the fields.

Can you share the excel and the oml?


Perhaps it's a decimal issue...




Hi J, 

    I am facing with this issue. Could you help me

Dilin.




Rooms.xlsx

Rank: #35276

I had the same problem and eventually managed to make it work.
Dont know if thats what solved it, but I went to my excel structure and added the "price" currency attribute manually. Then I went to advanced -> bootstrap and it worked already.

Rank: #410

No error...but the column mapping is empty for currency. So the result all 0 for currency column. The last 2 columns are currency on Entity.

sample_invoice.xlsx

Rank: #410

This is the mapping....Sorry I cannot attach 2 files at the same post. So here it is.

Snapshot_2016-12-15_10-41-8.jpg

Rank: #410
Solution

So apparently I must dig deep to the processes tab and modify it there

Rank: #40021

I have the same problem, but I can't solve it.

I tried it in many currency units, but all are recognized as "Integer" type.


Could you help me.


Kawaguchi.


Rank: #223

I tried using Service Studio 10.0.1018.0 and it works like a charm 

regards

Rank: #40021

I am still not successful.

I tried various types ... changed the number of decimal places ...

Even files output by OutSystems are recognized as "Integer" type when imported.

Service Studio 11.6.16


Rank: #31590

S.Kawaguchi wrote:

I am still not successful.

I tried various types ... changed the number of decimal places ...

Even files output by OutSystems are recognized as "Integer" type when imported.

Service Studio 11.6.16


 

 Hi,

I had the same issue and solved it.

Go to  Structures in data tab, delete the Price Attribute in excel structure and right click and create Price Attribute manually, it will consider as currency. Then try importing your excel sheet which contains price attribute with currency to the entity and publish.

Hope it works!!