Results 1 to 8 of 8
March 22nd, 2006, 02:06 PM #1
editing and re-saving
- Join Date
- March 11th, 2006
I'm really hoping you guys can give me some pointers here.
I have a php based site with a module that helps me to upload feeds.
Here's my dilemma...
When I have a feed that i get let's say from shareasale or linkshare, I have to edit it for a few things.
shareasale need to input code and LS I put in headers on the fields I want to show up.
I run everything on a MAC - (new MacbookPro) and my problem is when I open a feed in excel, let's say a pipe delimited feed, and I edit it for my code or whatever....when I go to save, I lose the pipe and it only let's me save as tab.
However, it seems to do something to the feed because I can't upload it even as tabbed - pipe - csv, anything.
Does anyone know what I'm doing wrong???
I guess you could say I'm trying to keep the feed in tact delimiter-wise.
But when you edit and re-save - the pipe goes bye-bye.
March 22nd, 2006, 03:15 PM #2
Excel is the problem. It will also remove delimiters from numbers at times. The microsoft version of CSV is different than everyone else's.
I use notepad to mainpulate things like the ShareASale ID - searches and replaces just fine.
If you're doing extensive reworks to things, either write some scripts to handle it or probe the merchant (especially if it's a new feed) to see if they can do the "corrections" beforehand (like funky special characters that get messed up).
April 6th, 2006, 10:40 AM #3Hey, Donuts, got a question...Originally Posted by Donuts
Would Wordpad do it any faster? Any help is very appreciated. Thanks.Mark (Satchel)
Webmaster / Sales Manager
April 6th, 2006, 10:51 AM #4Originally Posted by tsmgroup2Affiliate Marketing - The hardest easy money I ever made.
April 6th, 2006, 10:58 AM #5
Gordon mentioned a tool a while back. Might help as well.
This was the link ... http://www.snapfiles.com/get/csvdb.html================================================================
Been away, now I'm back. Not as much, but I'm back & starting from scratch. Where I was, was fantastic. Where I am now, less so. Things have changed, become harder. So have I. Game ON!!!
April 6th, 2006, 11:00 AM #6
A php script would be even faster. If you're running a web server on your desktop for instance, and can execute php/mysql locally while working (some people just upload feeds to the website server and don't also run a php server on their local machine for debugging). you can use a preg replace php script to do this work.
You can also do it on your server as well, but if you do it in mysql manually, it probably won't save you much time. If you set up a web page in a private folder though, for instance, that fires off the script (that replaces the default SAS text with your SAS aff id), it'd be a snap.
There's ways to automate the process as well, but it depends on what else you're doing to upload and edit the feed beforehand, so a simple answer that's best for you ain't easy to guess from my chair right now.
April 6th, 2006, 06:23 PM #7
Gotchya! Thank you all so much. I did switch to Wordpad and Wow! Your right, it is super fast compared to excel or notepad.
Got one more question for you all, as far as the Shareasale feeds, do I need to add the field names to the .csv file thru excel or is there an easier way to set this feed up so that I don't have to change my templates that I have currently?
You guys are a great help, and I would love additional resources or even a crash course on how I can automate the updating of this feeds.
Thank you again.Mark (Satchel)
Webmaster / Sales Manager
April 6th, 2006, 08:02 PM #8
Better yet you can do it from your terminal window:
perl -e 's/search/replace/' datafeed.txt > datafeed.txt
- ScottHatred stirs up strife, But love covers all transgressions.
By buyjewelry in forum Midnight Cafe'Replies: 7Last Post: February 29th, 2008, 11:44 AM
By ericak in forum Introduce YourselfReplies: 2Last Post: February 15th, 2006, 03:10 PM
By mobilebadboy in forum Midnight Cafe'Replies: 17Last Post: May 4th, 2005, 07:53 AM
By carpunky in forum WebMerge (Fourthworld.com)Replies: 3Last Post: February 27th, 2004, 01:22 PM