Windows > Third Party Plug-ins, Programs, and Skins
Guide: Data Fiddler (MC Library <-> Spreadsheet Import/Export/Update)
jmone:
--- Quote from: Arindelle on February 19, 2016, 08:21:54 am ---
in a spreadsheet program try saving as a *.CSV text file. Use the semi-colon as the field delimiter. JRiver uses the ";" as its default separator
you just have a text file in columns here. It can't parse anything
--- End quote ---
Thanks but I think David's format is correct. DataFiddler is using Tab Separated for input files to then make a MCWS call using CSV from that.
8139david:
Thanks to both for your help!
Arindelle's tip made the command apparently go through.
BUT it didn't update any field at all (including the field that was supposed to change, namely, 'First').
jmone:
The text file has to be Tab Delimited for DataFiddler. Changing the Delimiter to another (like ";") will not work. Your best bet is to cut it into some some batches till we find the particular data that is not working (I'm guessing it is one of the extended char sets)
8139david:
I tried all possible variations, on a very small file, nothing worked.
When the fields are separated by tabs, I get the error message above.
When they are separated by ; or , the scripts seems to run through but nothing is updated.
Some examples (I tried many variations):
Key,First
170510,PierreLaurent
170511,PierreLaurent
170512,PierreLaurent
"Key";"First"
"170510";"PierreLaurent"
"170511";"PierreLaurent"
"170512";"PierreLaurent"
8139david:
Thinking the keys I indicated where perhaps not good, I tried similar things with my first 3 keys (as recovered by exporting again my library and reading the keyfile in the txt file generated on demande), same problem: no change is made.
To be exact, I just used this text file (and variations, including tabs, with no success):
Key,First
1,tata
2,toto
3,tutu
PS: I also tried using a normal field, eg:
Key,Comment
1,tata
2,toto
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version