12/1 - AbleCommerce Data Client Utility 7.0

A forum where issues related to the DataPort utility can be discussed.
User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by jmestep » Mon Apr 28, 2008 8:06 am

I just remembered I have a test site with that same hoster. I just tried it and it didn't work either. I'll check with them to see if something is blocking the program.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by compunerdy » Mon Apr 28, 2008 10:38 am

I had this same problem months ago and reported it to Mike. We couldnt figure out why it wouldnt work so I switched off a sharred hosting account.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by jmestep » Mon Apr 28, 2008 1:16 pm

You know, maybe it's because the sites aren't set with a dedicated ip address. I change one to that (have to do it anyway for SSL) and then try.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by jmestep » Tue Apr 29, 2008 5:15 am

I switched the sites to static ips and still can't connect with the dataport. Help, I've got 3000 products to import and need to keep the same category and product ids.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by Naveed » Tue Apr 29, 2008 9:03 am

jmestep wrote:I switched the sites to static ips and still can't connect with the dataport. Help, I've got 3000 products to import and need to keep the same category and product ids.
Can you please give access information to me so I can try to connect myself?

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by jmestep » Tue Apr 29, 2008 12:33 pm

I've pm'd it to you. Thanks
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Shopping Cart Admin » Tue Apr 29, 2008 1:31 pm

Hello Everyone,

Data Client utility is moving along nicely and we have an updated version as of 4/29/08. Please see the initial post for download information.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 3/28 - AbleCommerce Data Client Utility Beta 11

Post by Naveed » Wed Apr 30, 2008 9:41 am

jmestep wrote:I've pm'd it to you. Thanks
I checked it, and found that you store is not updated properly and it is using an old version of Client API dll.
You can check the dll versions at Admin -> Help -> About AbleCommerce page.

Your version is :

Code: Select all

CommerceBuilder.DataClient.Api: 1.0.0.0
Please upload the latest version of dll provided.
The latest version of dll is:

Code: Select all

CommerceBuilder.DataClient.Api: 1.0.0.17
You can download the latest version from:
Download Data Client Beta .17:
ftp://ftp.ablecommerce.com/evals/AbleCo ... 0.0.17.zip

The zip file contains the latest installer and the respective Client Api dll.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by jmestep » Wed Apr 30, 2008 10:09 am

Naveed,
Please try again. I had another site that I had updated the api yesterday and wasn't able to connect. The site I gave you the login for had only 40 catetories and products to re-do, so they are doing it by hand.
I still can't connect to the one I gave you.
I got the other site with 6500 products taken care of by importing to a test database, then uploading the tables with changed content to the real database after disabling constraints and auto incrementing.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Naveed » Wed Apr 30, 2008 10:20 am

Your provided site is launched on a shared domain or using dedicated IP address? Although it should work in all cases but there may be some configuration issues.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by compunerdy » Wed Apr 30, 2008 10:57 am

Like I said..I had the same issue and Mike Randolph and I couldnt figure it out. I had the site on a standard sharred hosting account with JoltDigital.

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Naveed » Wed Apr 30, 2008 11:40 am

Judy,

Is there anyway I can debug on your server?
I have one idea, if you please enable tracing in your web.config file.
While I send you an updated dll that I will use to debug the issue.

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Naveed » Wed Apr 30, 2008 11:45 am

To enable tracing find the trace tag in web.config and change it to:
<trace localOnly="false"/>

after that you can confirm it is enabled by visiting the url:
http://www.[YOURSITE].com/Trace.axd

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by jmestep » Wed Apr 30, 2008 12:50 pm

I've enabled trace.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
lasujah
Ensign (ENS)
Ensign (ENS)
Posts: 5
Joined: Sun Mar 23, 2008 10:31 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by lasujah » Mon May 05, 2008 1:15 am

I noticed that when exporting products in CSV format, it doesnt include its product template fields and data. Does anyone know how to add the custom fields from product template to CSV for import?

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Naveed » Mon May 05, 2008 1:57 am

lasujah wrote:I noticed that when exporting products in CSV format, it doesnt include its product template fields and data. Does anyone know how to add the custom fields from product template to CSV for import?
It is not possible to use DataPort to import or export CSV for other fields. You can only import/export the fields mentioned in the CSV template. And it is the basic information.

Here is a similar thread:
viewtopic.php?f=45&t=6915

James477
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Mon May 05, 2008 1:49 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by James477 » Mon May 05, 2008 1:54 pm

Hello, I am trying to install the Data Import utility on our development server to play around with the importing functionality. But whenever I try to connect to my site, I get a message that says "Invalid Response From The Server. Unknown Error." I'm sure that I have all of my info entered correctly. Is there anything I can do to get a more descriptive message? I've included a screen print below...

Image

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by compunerdy » Mon May 05, 2008 2:07 pm


James477
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Mon May 05, 2008 1:49 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by James477 » Mon May 05, 2008 2:22 pm

Thanks for the reply, but I had already tried that. It didn't work either...

Image

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by jmestep » Mon May 05, 2008 4:32 pm

Is your dev server local or a remote shared server? Some of us are having trouble with connection on a remote shared server and there hasn't been a resolution of the problem yet.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by jmestep » Tue May 06, 2008 7:40 am

There is hope coming for the shared server connection problem. Naveed has been working on it and sent me a patch to test that worked. I'm sure he will be posting the info shortly after he tests it himself on my site.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by Naveed » Tue May 06, 2008 12:20 pm

We have fixed the Login issue of DataPort for shared hosting accounts. May be a new build will be released today or tomorrow.

ryankivi1
Ensign (ENS)
Ensign (ENS)
Posts: 9
Joined: Tue May 06, 2008 3:00 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by ryankivi1 » Tue May 06, 2008 3:04 pm

Good Day,

Very interested in the ablecommerce cart. I need a data client utility such as this one provided, to handle the many variants of product options we have.

Is it possible to get the utility to upload multiple options, and their variants? I have been struggling to get it to work period, just wondering if it has the potential to do what I need.

Regards,

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by jmestep » Tue May 06, 2008 4:26 pm

The newer version of the utility handles options,but you have to use xml upload.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

poconnell
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Tue May 06, 2008 4:31 pm

Re: 4/29 - AbleCommerce Data Client Utility Beta .17

Post by poconnell » Tue May 06, 2008 4:47 pm

I am trying to upload a few thousand orders worth of legacy/historical data using DataPort version 1.0.0.17. I have built a valid XML input file that works for everything except associating order items to the correct shipment.

Since these are all "new" orders as far as the AbleCommerce store is concerned, I am not putting ID elements in the XML and the import correctly assigns new Ids and matches the nested elements to their correct parents (e.g. Orders show the correct OrderItems).

However, this does not work for the OrderShipmentId on the OrderItem. The OrderShipmentId is set to the OrderShipmentId of the first ordershipment created - for all OrderItems for all Orders in the file.


Any suggestions?

Thanks,
Pete

Locked