SharepointSource Number Error

[Burn Sys]

When i use sharepoint source pointing to a List, Number fields are rightpadded with "0"

Connection:


Flow:


Sharepoint Source pointing to a custom List:



The field MiCode Does not match with data on sharepoint:






Column Settings:


Column settings:


I tryied SSIS 2005 and 2014, and With Sharepoint 2010 and 2013, always the same results.

any ideas?

[Ivan Peev]

Hi,

We are not modifying the data returned by SharePoint. What you see is what is being reported by the SharePoint server.

[Burn Sys]

I linked the source list from access, and the server is returning the right numbers:

[Ivan Peev]

Do you use SharePoint web services in Excel or you are reading directly from the SharePoint database?

[Burn Sys]

I Didi this:



It creates a linked table in acces from sharepoint.

[Ivan Peev]

I don't understand anything from the screens. It is all in Spanish.

[Burn Sys]

Sorry Ivan! let me write you an english detailed description.

Thanks for the help!

[Burn Sys]

Ivan, here goes the full explanation.

I Created a TestList in Sharepoint 2010.

My test list has 2 columns, "Title" and "NumberField"

The TestList with 3 records:


(Look at the values in "NumberField" column, 1,2, 10)

NumberField Configuration:



Example of one record:



Just for testing, i exported the list to Access:

(as you can see, it's a linked table to sharepoint and numberField values are consistent with sharepoint)

To do another test i retrived the list using sharepoint API in .NET:

Again, sharepoint is returning the correct values.

Then i created a SSIS 2013 package (also did it with SSIS 2005) and created a CozyRoc Sharepoint Source:
Connection:


Source:


But when i ran the package, The column NumberFields, get completed with "0" at right, in such a way i can't even divide by 100000, becouse for example, value "1" and Value "10" are converted to "100000000000000" indistincly.



I tryied this with Sharepoint 2013, and 2010, and with SSIS 2014 and 2005, always with the same results.

Hope you can understand my problem and thanks in advance!!

[Ivan Peev]

When you export to Access file, it is no longer using the SharePoint web services to view the data in Excel. You are viewing the data from the Access database. To confirm what is the response from SharePoint, please prepare Fiddler log file (saz) for the process where you see the incorrect values in SSIS. Make sure you enable HTTPS decryption option in the Fiddler options. Then post a copy or send to sup...@cozyroc.com the Fiddler log file you have created for further analysis. Thank you!

[Burn Sys]

Hi.here goes the log:

Take a look at the image. the numbers are returned from sharepoint in the correct format

Vs: 

Thanks for your time!

[Burn Sys]

I am starting to think it has something to do with Regional Configuration, and confusing "." with ","

[Burn Sys]

This is my regional config:

[Ivan Peev]

You can set what culture is used for parsing the incoming values from SharePoint by setting the LocaleID parameter on the SharePoint Destination component.

[Burn Sys]

It was that!

I changed the LocalId from Spanish to English and it solved the problem

thanks for the support!!