Batch Create for exchange rates

Copy to clipboard, then paste columns to your spreadsheet program
03 PM

Copy data from a spreadsheet and paste it into the text field below

and currency and rate fields are totally blank entries in the Exchange Rates listing:

Currencies, like many other things in Manager, are represented by 32-character hexadecimal strings. This has been addressed in other forum topics numerous times. Search and read to see how to proceed.

I have the same problem and I have now tried to find those 32-character hexadecimal codes you are referring to but without any luck…
Can I kindly ask you to guide us in the direction on how to find the code for USD for example?

I tried to Export valid entries and then import them again but that doesn’t work even…

Thank you.

Try navigating to screen showing them then add .json to the url


I tried that in two browsers (Chrome and Firefox) but it actually didn’t change anything…

Can someone share the code for USD and EUR? Why is there no list for this since that would help many people…?

Date Currency 1 ISK
20.12.18 US Dollar US$ 0.008361204
27.06.18 US Dollar US$ 0.009304057
31.05.18 US Dollar US$ 0.009482268
28.05.18 US Dollar US$ 0.009418857
30.04.18 US Dollar US$ 0.009874593
24.04.18 US Dollar US$ 0.009889241
23.04.18 US Dollar US$ 0.00990099
20.04.18 US Dollar US$ 0.009957184
04.04.18 US Dollar US$ 0.010080645
26.03.18 US Dollar US$ 0.010148163
28.02.18 US Dollar US$ 0.009859016
13.02.18 US Dollar US$ 0.009820289
22.01.18 US Dollar US$ 0.009717229

Sorry I have not had the time to test your specific task. There is however two ways of finding out the UUID used for data elements in Manager

  1. Look at the .json version of Manger web pages. This involves finding a page displaying the information you want and manager supports UUID display when looking at the .json version. So some trial and error.

  2. Using batch export. Data import and export both use UUID to identify some records. So if you create a record containing a reference to the data you want, when batch exported Manager will show the UUID for that data element. So using this approach involves creating or having data containing the references you want, finding an page it can be batch exported from then looking at the exported data to identify the UUID you want.

Dear Patch.

Thank you for your efforts but honestly I understand less than zero what you are talking about.
I do not find any “batch export” but I do find “Export” and when I click that option then I can’t see any 32-Character Hex codes for the currency nor do I see any difference if I ad .json at the end of the URL.

Can you or someone else simply tell me the codes for USD and EUR?

Thank you.

It is Batch Update, not Batch Export. Export is a different process, as you have learned.

Tut, can you share with me the code for USD and EUR?

Or maybe @lubos can help me out??
The batch import is utterly useless without a proper details on how to do that…

I don’t know whether the UUID is constant for different databases. As you have already been told, enter a transaction for each, then use Batch Update to see the UUID’s.

Tut, thank you. You finally got my brain to work…

For future readers of this post.
In order to find the Currency code:

  1. Goto settings - Exchange Rates
  2. Make sure there is at least one exchange rate entered for the currency you are looking for
  3. Press “Batch update” at the bottom
  4. Press the button “Copy to Clipboard”
    Now you have copied all the exchange rates from Manager to the clipboard. Now you can paste it into Excel or any other program and see the codes for the currency.
    Remember you can only update the existing codes and not add. If you want to add then go out of this menu and press “Batch Create” and paste your values there…

Now this wasn’t so hard was it? All it needs is decent step by step guide…

1 Like

There already is one. The presumption is that someone qualified to do this would be qualified to figure out how after reading it.

I guess you are getting a bit tired of the stupid users of Manager, like myself. Or what is your point here?
I pointed out that the “help” available was not enough for me to understand how to batch import exchange rates into Manager and I must say that I find your answers a bit arrogant and why not to try to understand that not everyone using Manager is an accounting specialist and we even know less about the perks and special tricks in Manager on how to do some things… It should be a simple thing to import the exchange rates but it was not…
Anyway, I thank you for the time you are spending on the forum and thank you for your assistance…

My point was that batch operations are not simple. When they involve UUID’s, 95% of users have already been left behind. So the Guides do not even mention them, because for the vast majority of Manager users, it would just add to their confusion. For the 5% who understand them, the solution is typically obvious.

Understanding batch operations has nothing to do with accounting knowledge. It requires some expertise in relational databases. The Guides are not intended to convey that type of skill. The developer’s goal is to make the program fully functional for people without software expertise, while still providing hooks for experts to use. You may have noticed, for example, that the batch operation buttons are dimmed, indicating they are not primary controls. The Guides are aimed at people with little expertise. They are not meant as detailed software documentation.