Currency column migrated without decimal separator with SPMT

NIEUWKAMER Pieter 25 Reputation points
2023-04-20T13:42:27.0833333+00:00

I need to migrate a SharePoint list from SP2016 onprem to SP online. The list has several currency columns. Records that have currency with ,00 after the decimal like separator € 1000,00 are migrated correctly. Currency that have numbers behind the decimal separator like € 1000,99 are migrated wrong. e.g:
€ 1000,00 in the source list is € 1000,00 in the destination list.
€ 1000,99 in the source list is € 100099,00 in the destination list. How do I make sure all decimal numbers are migrated correctly. For information, Default language on both sites is English and the locale in the regional settings is German (Germany)
I already tried with the locale also on English but that doesn't make a defference. Screenshot source list:
User's image

Screenshot destination list: User's image

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,795 questions
{count} votes

Accepted answer
  1. Emily Du-MSFT 42,341 Reputation points Microsoft Vendor
    2023-04-24T09:47:40.4266667+00:00

    I'm glad to hear you solve the problem, if you have any issue about SharePoint, you are welcome to raise a ticket in this forum.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". So, I would make a brief summary of this thread:

    [Currency column migrated without decimal separator with SPMT]

    Issue Symptom:

    OP need to migrate a SharePoint list from SP2016 on Prem to SP online. The list has several currency columns. Records that have currency with ,00 after the decimal like separator € 1000,00 are migrated correctly. Currency that has numbers behind the decimal separator like € 1000,99 are migrated wrong. e.g.:
    € 1000,00 in the source list is € 1000,00 in the destination list. € 1000,99 in the source list is € 100099,00 in the destination list.

    Current status:

    In Europe that's a point for thousand and a comma for decimals. So, OP checked 2016 server and there it was different from client where I run SPMT. OP changed those formatting settings on client, so they were the same as on the server and then the migration was performed correctly. So, turns out all locale and formatting settings need to be the same on the source server and the client you run SPMT on.

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Emily Du-MSFT 42,341 Reputation points Microsoft Vendor
    2023-04-24T05:55:02.31+00:00

    I have migrated a list with currency column from SharePoint 2016 to SharePoint Online. It worked well. Following pictures are currency column settings and test results.

    Currency column settings:

    column

    SharePoint 2016:

    1

    SharePoint Online:

    2

    My SharePoint Migration Tool is public preview (4.1.125.2), please download this version then have a test again.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.