Stored Values

[MemphisFlash]

i have a spreadsheet with various stored values that i am trying to integrate onto the one click screen.
(i know how to do this) , but this sheet does not seem to work.
can someone confirm i have the right setup please

Capture.PNG

Capture.PNG

[ODPaul82]

Do you have 1 written at the top when you do the export to CSV
It's used to define the import specification

GHSS.PNG

[MemphisFlash]

yep, everything is as it should be,
i scrape and create loads of columns from spreadsheets, just this one is giving me grief.

[ODPaul82]

Just as a theory as it's only thing I can think of looking at with that, the % values you're storing as text, am wondering whether it's double-quoting around those when you're pulling them through, ie. ""0%"" rather than "0%"
I don't think the selection names need quotes around them either

[sniffer66]

When you tick "Note Stored Value creation in the markets log" on the CSV import rule, params tab, do you get all the SV's shown as imported ? That would be my first step

and obviously, "Check File for Errors"

[MemphisFlash]

Just as a theory as it's only thing I can think of looking at with that, the % values you're storing as text, am wondering whether it's double-quoting around those when you're pulling them through, ie. ""0%"" rather than "0%"
I don't think the selection names need quotes around them either

Good spot on the quotation marks around the name of the horse, it should be a *.
it works fine now

thank you

Tom