Act2Int - A tool to convert Actinic catalogs, to Interspire ones.
-
Discussion thread for the Act2Int converter, found here:
http://www.talkaboutselling.co.uk/showthread.php?t=52
Should now work with V8 and V9.
It can:
- rip product info out of the actinic database
- understand hidden products
- put most information from actinic, titles, desc. weights, prices, etc, etc.
- correctly build categories, and put items in them
- understand SPPP and MPPP and deal with them accordingly
- trim out actinic code and replace it with proper HTML.
- use the images from your website
it cant:
- understand about variations/choices yet
- loads of other stuff i'v not implimented.
to try:
0) open actinic at the site youe want to rip, leave it open. Dont touch it while ripping is happening.
1) unpack the folder, and run the file 'act2int.bat'.
2) it will buzz away and do stuff
3) when its finished, you can press enter to dismiss the command window
4) it generated a csv file.
5) go to import in interspire
6) tick 'Yes the file contains headers' on the upload interface. no other changes.
7) don't fiddle with the mappings, they are good, click next
8) ...
9) profit.
Please any feedback at this point would be greatly appreciated.
PLEASE NOTE that this version is capable of fetching the images for the products from your live site. when you import the feed, the interspire site will download all the images from your actinic catalog. this may be quite bandwidth intensive, depending on how many images you have.
in the default.php, there is a setting to choose wether you want the product image, or the extended info image, in the same place as the debug mode. i suggest you use debug mode to test image importing is working, before you dive in and import 100,000 products.
update notes:
- [feature] updated to rip images from the site
- [bug] fixed comma bug in prices over 1k
- [feature] fetches your acatalog url automagically. -
OK
seems to be a problem Gabe, i run the act2int file and the cmd screen appears and lists a few sections, not all only about 6, then it says pause press any key to continue, when you press any key it disappears.
the file generated only has about 10 products in it, it seems to have all the information except the image url has the url but no image name as in http://www.casupply.co.uk/acatalog
cheers
Darren -
Gabe,
I have the same image problem, looks like the extended info image = false is actually returning true, if I swap it to true I get my main product images. Darren, open the PHP file and change $TESTMODE to 'false'! -
many apologies, i was in test mode when i was, err, testing:
in the folder where you extract all the junk to, you'll find a file called 'default.php'. open it in a text editor, and you'll see some things at the top of the file.//diagnostic mode, output only 10 records.
$TESTMODE = true;
//the current system dsn
$ThisDSN = \"ActinicCatalog9\";
$UseExtendedImage = false;
These can be edited, to suit your requirements.//diagnostic mode, output only 10 records.
$TESTMODE = false;
//the current system dsn
$ThisDSN = \"ActinicCatalog8\";
$UseExtendedImage = true;
SPECIAL NOTE: dont but false or true in speechmarks, do it without.
this config does all records, of a currently open v8 catalog, with the standard images, instead of extendeds.
due to this, i'v found a buglet, the extended images is the wrong way round, false and true are wrong, set it to the other one you actually want, lol.
this will be corrected in the next version, thanks for the heads up.. -
i have noticed that the prices are wrong on the uktactical site.
vat is wrong in my feed? -
One other small thing, at the moment it doesn't seem to take into account deleted products. Not sure if it should or not, but maybe an option to include or exclude them would be useful.
-
-
Nice on Gabe - will have a play around with this on our other Actinic site and see what happens.
From a quick glance - it only appears to pick up .jpg file names for images, .gif and .png are ignored, and the image URL is given as http://www.domain.com/acatalog/ in the CSV if the image is anything but jpg.
I'll input what I can, as this is a very worthy cause, good work.:thumbsup: -
acompton said:Damn! And I spent hours writing my own converter!
muahahahaha -
I'm interested to know if either of yours can accommodate me?
*sniggers*
I mean, of course, can handle product options etc??
IIRC, Gabe's original didn't? -
dave_finlayson said:Oh for f**k sake Handy, can't take you anywhere!
pfft
you only WISH
:p
:D -
....................../´¯/)
....................,/¯../
.................../..../
............./´¯/'...'/´¯¯`·¸
........../'/.../..../......./¨¯\
........('(...´...´.... ¯~/'...')
.........\.................'...../
..........''...\.......... _.·´
............\..............(
..............\.............\... -
From my understanding - this only exports image URL's for .jpg images, .gif and .png, etc, show as http://www.domain.com/acatalog/
If a field contains symbols, the field name breaks and doesn't import the section/products properly.
EG. Section Name or Product Name with commas, the importer thinks the field is complete and doesn't export the next few fields.
For example:9,P,5,Basic T,\"100% Cotton\",1,5.11,,1,1,0,1,0,0,\"Clothing, Sample - With/Symbols\In - Name\",,,,http://www.domain.com/acatalog/
I have named the section in Actinic "Clothing, Sample - With/Symbols\In - Name"
I am looking at a fix, as this could save a lot of time - approx 2000 products are failing to import fully because of the product/section name with symbols in the name, or the images not being .jpg. -
acompton said:I don't think the ISC import allowed for product options. It also had other 'bugs'.
it does allow for variations. my code just isnt evolved enough to deal with it yet.
it supports the ref, image, desc, price shift etc.
:thumbsup: -
Good idea, that'll solve that problem.
OK, I've taken a default installation and run this - I have noted the 'sExtendedInfoImage' field of the database is being exported to the 'Product Image' field of the CSV, so must be a linking problem somewhere.
I seen a post somewhere a few days ago which allowed multiple images to be uploaded by CSV - I'm going to see if I can amend this to export both product image and extended image, AFAIK it is not currently doing this. -
the options in the code allow you to choose either the extended OR the product image.
with a bit of fiddling i ahve made it so that IF the extended exists, we use that, if not, we fall back to the product.
or, we just force product.
I have also fixed the 'deleted products' problem. it will be in the next release, on the google code page, when i can get round to it.
PLEASE contribute any changes you make that work. -
$cleanstring = ereg_replace(\"[^A-Za-z0-9 ]\", \"\", $dirtystring);
this allows only A-Z, a-z and 0-9 oh, and space.
everything else, gone. -
I have noticed with a default Actinic v9 install. Please see attached images.
The 'Starter Computer Bundle' and 'Professional Computer Bundle' are the only products with both Image FileName and sExtendedInfoImage values.
The issue is not related to other image formats at all, ignore me, I'm a muppet.
Anyway, as you can see from the attached, the CSV is only importing the ExtendedInfoImage, not the 'Image FileName', could it be because in the database, the regular image field is called 'Image FileName' (note the space) but 'ImageFileName' in default.php? Only one way to find out... -
so, the database format changed? can anyone confirm with an older version the the 'nic?
-
OK, this is what I've got amended so far, this is the default.php file - I have added a few extra str_replace commands as some extra characters were being added to the product description field in the CSV - presumably these were added to replace tags generated by Actinic when you put spaces or press enter to take a new paragraph in the WYSIWYDG editor.
Edit: Baws, had to re-upload, php isn't a valid extension for the forum, my bad.
Edit Part 2: Updated, images fixed. Now going to add extra info image as an 'additional' image as shown on interspired forum :) -
Surprisingly this works the way I wanted, it strips commas from the section name, so when importing the CSV to Interspire, Interspire doesn't get confused and think a Section called "Section Name 1, 2, 3" isnt called "Section Name 1" and that "2" and "3" belong to other fields.
Just updating, but think this version works, if it does, I shall attach it in a bit. -
The add-on from this thread will cater for regular and extended info image, could possibly be further amended to cater for Norman's Extra Image plugin for those of y'all that use it.
After applying the attached default.php file, our data set has now reduced "1487 products were not able to be fully imported so far" down to 635. I am just looking through the error messages but believe the majority are due to missing product images in Actinic in the first instance. -
Ruralweb said:Go for it grant - you obviously have the same moto as me ie don't get mad get even!
I don't need to get mad, or get even - because I know this product is far greater than Actinic, has much better vision (present and future) and always will be 5 years ahead of Actinic for the lifetime of both products, period. Unless you have particular requirements for which I may recommend Actinic (Store+Online, requiring Stock Control) - then it'll be Interspire all the way for me. -
Finally, the latest update will:
- Map product images across, unless they didn't exist in Actinic in the first instance, which is your fault, not mine :)
- Remove commas from Section/Product name, as to not break the Interspire import. Ref
- Remove Carriage Return and Line Break characters from Product Description, which Actinic hideously adds in the background.
That's all for now folks, but shall look in to importing 'extended info image' as one of the 'More Images' in Interspire. - Map product images across, unless they didn't exist in Actinic in the first instance, which is your fault, not mine :)
-
It would be cool if this could take the line breaks/carriage returns, and add these to the CSV in a format Interspire understands, so that paragraphs are exported across properly - in the current state, paragraphs become one big long paragraph. Having a look into this now :)
-
Gabriel Crowe said:Discussion thread for the Act2Int converter, found here:
http://www.talkaboutselling.co.uk/showthread.php?t=52
Should now work with V8 and V9.
When I run act2int I get an odbc data source name not found.
sql state im002 in sqlconnect
It must be something i'm doing wrong if other have got it working :-(
Walker -
walker said:When I run act2int I get an odbc data source name not found.
sql state im002 in sqlconnect
It must be something i'm doing wrong if other have got it working :-(
Walker
Are you using v9? If not, you will need to edit the default.php file:$ThisDSN = \"ActinicCatalog9\";
To...Replace X with your version number.$ThisDSN = \"ActinicCatalogX\";]
If this still doesn't work...which version of Actinic are you using, on which Operating System, and where is your Site1 folder located (ie. C:/Docs n Sets/Usrnm/Actinic vX/Site1) -
GrantG said:Are you using v9? If not, you will need to edit the default.php file:
$ThisDSN = \"ActinicCatalog9\";
To...Replace X with your version number.$ThisDSN = \"ActinicCatalogX\";]
If this still doesn't work...which version of Actinic are you using, on which Operating System, and where is your Site1 folder located (ie. C:/Docs n Sets/Usrnm/Actinic vX/Site1)
Ah !
I edited ThisDSN to remove the 9 at the end. I thought it had to match the
actual file name :wub:
What a silly Kings Bolllege Bambridge I am !
Thank you for that. I'll have another bash.
Howdy, Stranger!
It looks like you're new here. Click the social buttons to create your account or sign in.
Categories
- All Discussions784
- Tools For Selling Online
- ↳ Ecommerce Carts226
- ↳ Accounting Platforms1
- ↳ Payment Service Providers14
- ↳ Hosting companies2
- ↳ Hosted Solutions13
- ↳ Comparison & Directory Sites3
- SEO and Marketing
- ↳ Email Marketing1
- ↳ Paid SEO7
- ↳ Natural SEO23
- ↳ Google Analytics4
- ↳ Bricks and mortar advertising2
- ↳ Search Engine Tools & Moles10
- ↳ CMS & Blogs4
- ↳ Review Systems1
- Designer and Coders Forum
- ↳ CSS Help4
- ↳ Design & Layout Problems8
- ↳ Javascript Help5
- ↳ Photoshop and Photography3
- ↳ PHP fun and games.6
- EPOS & Inhouse Systems
- TAS Community
- ↳ General Ecommerce Help84
- ↳ Introduce Yourself41
- ↳ Members only0
- ↳ Software & Cool Finds26
- ↳ General Chat254
- ↳ Forum Suggestions31
- Private Area
In this Discussion
- acompton November 2009
- AlanJ April 2011
- Chunkford April 2010
- Darren November 2009
- dave_finlayson October 2009
- drounding April 2010
- Gabriel Crowe April 2010
- GrantG April 2011
- Quarm April 2010
- Ruralweb October 2010
- Titch December 2009
- traceyhand October 2009
- walker November 2009
- wesleythorne October 2010
