EasyPopulate 4.0 Support Thread

[kezerb]

Yes, I downloaded it about 12 hours ago so I think it's the latest updated version

[kezerb]

I'm not entirely sure how I fixed it but I deleted ALL easy populate files from EP4 and previous versions as well and re installed. It's now working

[kezerb]

Sorry blonde moment, delete this post please

[homebre]

Homebre,

Sorry, this is not my version of EasyPopulate that you have installed. I am no longer helping to support the other version, sorry.

-chadd

Reposted, in case it wasn't obvious who I was talking to:

Chadd,

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

[Darkwander]

Sorry, I have not. I am rather swamped right now too, so I don't know when I'll get a chance to dive into it....

Hey Chad, i had a play with this today, it seems that if we change the dates in the easy populate file to American (M/D/Y) it seems to upload fine, regardless of what the settings say, i am guessing it isnt pullling the date order from the options or something..

[chadderuski]

Reposted, in case it wasn't obvious who I was talking to:

Chadd,

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

Yes, EasyPopulate 4.0 ... 4.0 is my re-written version. There are other version from other programmers/modders, but this thread in only for my 4.0 version currently only available at GITHUB because I'm still in **beta** ... once EP4 exits beta I will submit to the zencart team.

-chadd

[chadderuski]

Hey Chad, i had a play with this today, it seems that if we change the dates in the easy populate file to American (M/D/Y) it seems to upload fine, regardless of what the settings say, i am guessing it isnt pullling the date order from the options or something..

Ya know, it's been some time since I fiddled with that code. There was a LOT of funkiness with the date handling code and I MAY have just standardized it and said "to hell" with the configuration settings! Opps Sorry if it's created any confusion!

-chadd

[Darkwander]

Ya know, it's been some time since I fiddled with that code. There was a LOT of funkiness with the date handling code and I MAY have just standardized it and said "to hell" with the configuration settings! Opps Sorry if it's created any confusion!

-chadd

Err no biggy mate, at least we know what is going on and how to temp fix the problem. You planning on taking another look later down the track or should I set file maker to export as American date for the time been... Rlol

[chadderuski]

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

Well, it could be weeks, or a couple months before I get free time to fix this (and some other minor things). So don't wait on me for now. But your work is appreciated, and I should review this code carefully before exiting beta.

Thanks!
chadd

[reetp]

One small point that I have come across which has caused me no end of pain ! I have had a look for solutions but haven't noticed anything relevant.

I had a piece of code to extract required fields from an XML file and write them to a CSV file for import.

I was originally using fputcsv for this but I discovered that it has a mind of it's own when deciding what fields to use quote marks and not.

I have now had to go the long way round and use fput and some jiggling to make sure each field is written with quote marks.

Is there any real reason why quote marks are needed ??

For anyone interested, here is how I did it. I used some other code I found online and modified it slightly. I don't guarantee that it will be perfect but it does seem to work. Should have more error checking.

function sendCSV($data_array, $enclosure, $field_sep, $record_sep)
{

	dumbescape(false, $enclosure);
	$data_array=array_map('dumbescape',$data_array);
	//return
	$uploadFile = "output" . (12*1024*1024) . ".csv";
	$file = fopen($uploadFile, 'a+');
	fputs($file, $enclosure	. implode($enclosure . $field_sep . $enclosure, $data_array) . $enclosure . $record_sep);
	fclose($file);
}

function dumbescape($in, $enclosure=false)
{
	static $enc;
	if ($enclosure===false) {
		return str_replace($enc, '\\' . $enc, $in);
	}
	$enc=$enclosure;
}

Then

sendCSV($my_array,  '"',  ','  ,  "\n");

I know it is probably slow (and a lot slower than fputcsv) but this will give correctly formatted CSV for EP 4. Any suggestions on improving this would be gratefully appreciated :-)

If anyone wants more info on how I got the fields out of XML then I can post the rest. Again, it's not professional (because I'm not a professional !) but it works for me.



B. Rgds
John