Nomatter how hard I try, I cannot seem to create a fetch CSV pipe. It always results in nulls. I think this is caused by something that is wrong behond my reach and not because I'm doing something wrong.
One of the indications is that the rename object is not picking up the atributes of the fetch csv object, despite them showing in the debugger.
I've tried the folliowing things:
1) Create a YQL CSV query and attach the rename function. The rename function comes back with the default attributes, not those in the YQL query.
2) Altered the CSV link in an fetch CSV example. For some reason, those pipes keep getting the old CSV fetch and the rename function does not show the new attributes.
3) Rebuild exactly the same example from scratch, using the datasource (csv) from the example. IS NOT POSSIBLE.
4) Created a new Yahoo profile. Is not working.
5) Deleted the rename object from the example, and put it in again. Rename is no longer showing the right attributes despite it reporting "updating".
May be I don't understand the principles of pipes, but I desparately need help with this…
Your problem is with those columns where the heading contains a dot. If you cannot change the column headings in the source then set the CSV to skip the first row and then select "Use the following column names:". You can then leave the column names blank to get the default Pipes column names or create your own.
Thats true, but this is because the left hand side of the rename object doesn't contain the attributes of the csv, so there's no point. However yours doesn't also (1) thus I tried recreating
yours under 1
First I removed the rename, when that didnt give any effect, I even removed the fetch CSV, IT STILL worked for a while and then somehow it started reporting the correct way.
So far my conclusions are:
1) At random, it either works or it doesn't. Mostly it doesn't. I don't know how to reproduce that. I tried saving the pipe and going back to my pipes instead of directly running it, but it doesn't make any difference.
2) When you alter the pipe, it doesnt pick up those alterations in the actual query
3) It keeps runing the original query, even if I destroy the query internally.
4) I doesn't pickup the attributes from the CSV in for instance rename, although this is obviously the intention (because its updatingvalues after connection of fetch_csv and rename).
Because I at forehand don't know if the query will work and most of the times it doesn't I cannot use it, because I can't be trying forever. Moreover complex queries are impossible this way.
What kind of buggy BS product is this?
6) I switched from safari to firefox and it seems to work better. I will work with firefox for a while tot see if this gives reliable results
Aha, sorry about that.
However the fact that rename (and other objects) do not pickup the attributes of the fetch object and the delay of 15 minutes makes it quite difficult to test a complicated query. I guess the best thing to do is to break it into little peaces first. If you make a mistake (like I did twice) it could be a while before you can actually discover it.
Thanks for your help! I may ask your help with the real queries I want to make. This is a painstakingly tedious learning curve.