3/10 AbleCommerce Data Client Utility 7.0.2

[calvis]

Hello calvis,

Please confirm that your AC55 xml data does not contain the duplicate records? Are you sure that the users are duplicated and disabled when importing?

Any symptoms which users got duplicated? I mean is there any pattern?

Hi Naveed,

I took time this evening to investigate this more thoroughly.

I checked for duplicate records in the XML. There are none. However, I did discover a pattern. The email address in the record that contains the customer details is not being populated. Also many of the usernames have a leading space. In our version of Able we don't have the ability to disable users, so I am not sure why the duplicate records are being disabled.

Would you like to review our .xml file? If so, please send me a PM on how to send the file to you. The file is 19 megs compressed, and 336 megs uncompressed.

Thanks,

[calvis]

Hi Naveed,

Have you given any more thought to my issue?

Right now I have been focusing on design issues, but this is going rear its ugly head when I move the data over.

Hello calvis,

Please confirm that your AC55 xml data does not contain the duplicate records? Are you sure that the users are duplicated and disabled when importing?

Any symptoms which users got duplicated? I mean is there any pattern?

Hi Naveed,

I took time this evening to investigate this more thoroughly.

I checked for duplicate records in the XML. There are none. However, I did discover a pattern. The email address in the record that contains the customer details is not being populated. Also many of the usernames have a leading space. In our version of Able we don't have the ability to disable users, so I am not sure why the duplicate records are being disabled.

Would you like to review our .xml file? If so, please send me a PM on how to send the file to you. The file is 19 megs compressed, and 336 megs uncompressed.

Thanks,

[Naveed]

Please send me some sample data. It will be best to extract just a few user records (from ac55 xml) for sample. Sending you my email in PM.

[Naveed]

Hi Naveed,

Have you given any more thought to my issue?

Right now I have been focusing on design issues, but this is going rear its ugly head when I move the data over.

Thanks for the sample data. I am now able to reproduce the issue consistently and reported a new bug. This issue will be solved with next release.

[Naveed]

Have you given any more thought to my issue?

Right now I have been focusing on design issues, but this is going rear its ugly head when I move the data over.

Hello calvis,

Your mentioned issue is identified and fixed. The fix will however will be available for next release for DataPort.

There was a bug in user import routine due to which for user records having legacy passwords are duplicated. And the duplicate record is disabled and have not have no additional data.

There are however two workarounds:

1. As your AC55 store is not updated as well and using legacy passwords system. So, update your AC5x store to latest available AC55 builds before exporting the data. After update export your AC55 data and it will be correctly imported.

2. You can safely delete the duplicate records from database using a simple query like:

Code: Select all

DELETE FROM ac_Users WHERE IsApproved = 0  AND PrimaryAddressId IS NULL AND LastActivityDate IS NULL AND LastLoginDate IS NULL

[calvis]

Hi Naveed,

Thanks for the prompt fixing of the issue. I look forward to testing out in the next release.

[mfreeze]

I have a 5.5 CFMX site with 34 kits defined. When I export the 5.5 data then import it into 7.02, The 'kits' portion of the import log says 34 kits were imported but if I go to Find Kits, they are not there.

I checked the 5.5 XML and there are really 34 kits in the file. I looked at the database and none of the kit related tables have data related to these kits. We manually added 1 kit and it works fine.

What happened to the kits that were supposedly imported?

[mfreeze]

Any ideas on the failure to import kits?

[Naveed]

Any ideas on the failure to import kits?

There were some data consistencies with your AC5x data. Like there were a number of products where the OptionMatrix node exists while the same product does not have any options. Actually for AC5x there were no database integrity constraints implemented at database end, and these type of data inconsistencies may occurs for AC5x stores.

Now in your particular case when trying to import option matrix (data for different variants) for products which even does not have any options, an exception is thrown. And that particular exception preventing successful completion of import. I have fixed the issue and can now successfully import your data without any errors....

The fix however will be available for next release of DataPort.

[bemara579]

Why does DataPort REQUIRE you to import the product name field as an identifier if I have the friggin productId?? If I have a productId and price on my spreadsheet that I want to upload, why is the name relevant to this??! Can you please take off this lame restriction?

Also, do you have any idea when the next DataPort release is? I am waiting to being able to update products by sku number instead of productId+name. Thanks.

[Naveed]

Also, do you have any idea when the next DataPort release is? I am waiting to being able to update products by sku number instead of productId+name. Thanks.

We want to release the next version of DataPort (DataPort for 7.0.3 stores) with the release of AbleCommerce vs. 7.0.3. The next version of DataPort will let you define your own match fields while updating using CSV. And you will also be able to do import/update using any number of fields without any restrictions. So, it will be possible for you to update your products by SKU (or by using any other key as match field).

Both AbleCommerce 7.0.3 and DataPort for 7.0.3 are under QA. So, I hope there is not much time remaining...

[bemara579]

Naveed, that sounds genius! I can't wait!!

[bemara579]

I see AbleCommerce 7.0.3 was just released yesterday. Where can I get the new DataPort version? It is not in the ftp.

[calvis]

Waiting for this as well.

Thanks

[bemara579]

Still no updates... any status on this??

[mfreeze]

I have a number of clients who are waiting for a 7.0.3 dataport and new clients who will need it that are waiting to see which release we should install. Any idea when this will be available?

[bemara579]

bump

[gilmoor]

I am trying to upload a mass number of gift certificates at one time. More than 100. Does this utility, or another, allow me to create a csv (or another type of file) and let me upload the data to process (create and notify the bearer) the gift certificate?

[Naveed]

I am trying to upload a mass number of gift certificates at one time. More than 100. Does this utility, or another, allow me to create a csv (or another type of file) and let me upload the data to process (create and notify the bearer) the gift certificate?

You can use xml import(upload) feature to upload gift certificates. Here is the xml format for file containing one gift certificate:

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<AbleCommerceExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ExportVersion>7.0.0</ExportVersion>
  <ExportBuildNumber>[SVNREV]</ExportBuildNumber>
  <Store>
    <StoreId>1</StoreId>    
    <GiftCertificates>
	  <GiftCertificate>
        <Name>My gift certificate</Name>
        <OrderItemId>0</OrderItemId>
        <GiftCertificateId>0</GiftCertificateId>
        <StoreId>1</StoreId>
        <SerialNumber>7804809259190665</SerialNumber>
        <CreatedBy>0</CreatedBy>
        <CreateDate>2009-06-17T09:48:42</CreateDate>
        <ExpirationDate>0001-01-01T00:00:00</ExpirationDate>
        <Balance>39.00</Balance>
        <Transactions>
          <Transaction>
            <GiftCertificateTransactionId>0</GiftCertificateTransactionId>
            <GiftCertificateId>0</GiftCertificateId>
            <OrderId>0</OrderId>
            <TransactionDate>2009-06-17T09:48:42</TransactionDate>
            <Amount>39.00</Amount>
            <Description>Gift certificate created manually.</Description>
          </Transaction>
          <Transaction>
            <GiftCertificateTransactionId>0</GiftCertificateTransactionId>
            <GiftCertificateId>0</GiftCertificateId>
            <OrderId>0</OrderId>
            <TransactionDate>2009-06-17T09:48:42</TransactionDate>
            <Amount>39.00</Amount>
            <Description>Gift certificate activated.</Description>
          </Transaction>
        </Transactions>
      </GiftCertificate>
    </GiftCertificates>
  </Store>
</AbleCommerceExport>

[Naveed]

bump

I have a number of clients who are waiting for a 7.0.3 dataport and new clients who will need it that are waiting to see which release we should install. Any idea when this will be available?

Please be patient!
We are trying hard to release new build of DataPort as early as possible. We have added some new complex features in the new version of DataPort and the QA team is taking some time to test it properly from all aspects.

[dooleymort]

It looks like over a month has passed since the release of AbleCommerce 7.0.3.
Are we still waiting?

I just finished installing the AbleCommerce7.0.3 on my live server. I then had my 7.0.2 version on my dev server time out, so we had to upgrade before we could get the development key to work. Now I can't use DataPort and therefore can't get any of my data, since I use it daily to update my products from a feed!

Is there really no DataPort to work with the 7.0.3 version?!?!

[calvis]

It looks like over a month has passed since the release of AbleCommerce 7.0.3.
Are we still waiting?

I just finished installing the AbleCommerce7.0.3 on my live server. I then had my 7.0.2 version on my dev server time out, so we had to upgrade before we could get the development key to work. Now I can't use DataPort and therefore can't get any of my data, since I use it daily to update my products from a feed!

Is there really no DataPort to work with the 7.0.3 version?!?!

There is a beta version at this link:

viewtopic.php?p=48997#p48997

[Naveed]

Is there really no DataPort to work with the 7.0.3 version?!?!

A beta version of DataPort for 7.0.3 is available. I you want to give it a try then you can find the download link at this location:
viewtopic.php?f=61&t=11427