12/1 - AbleCommerce Data Client Utility 7.0

[Naveed]

* csv upload: The text is "please select xml file" however it only allows you to select a CSV file.
* the radio buttons are too far over to the right, i lose about 3 pixels of them to the group box.

These are already fixed for the next release. Anyhow thanks for reporting

* Cant upload customer passwords
* Cant upload customer addresses
* Cant upload customer date of birth
* Cant upload customer telephone, fax

Yes there are these limitations when you are using CSV data import option, However you can use XML data import option to import this data.

cannot import what products on the order. This software is therefore pretty useless if you want to transfer data from an old store to this one.

From the old store if you mean some AC55 store, then you can import almost every thing except some configurations / settings which are not compatible between the AC55 and AC7. You can import Products data, as well as the Order data from AC55. To do this export you store data from AC55 and then use the AC55 import feature of the DataPort and let it do the work for you.

I'm needing to import our ~3000 customer list from another website. Any suggestions on how to do this would be excellent

From another website!!!
Best available option is still the Users CSV import. However you will not be able to import, password, addresses, DOB and Telephone, fax etc.

I agree with you that DataPort should be able to import "password, one address information including Telephone and Fax" etc. I am going to put a feature request for this, and hopefully the next release will solve this issue..

[Naveed]

Any word on when the next version will be out of QA? I really need the ESD import.

Sorry for the delay...
We have added some more features to the DataPort and QA process is taking time, We are testing it for the data provided by different customers and with aspects so that it can now be finalized. Going to release it very soon...

Although we trying to make sure to fix all bugs in DataPort. You can help us by sharing your data for a testing as well. This way we being able to find and fix any issues that you can encounter with the next release...

[Naveed]

Hello Mary E Freeze,

I just remembered that we already have data available for your "audiotech.com" store for testing..

If there is any more data, then you are welcome for sharing..

[Crestfoodservice]

I am having some trouble deploying my Ac7 store. Currently my store is AC55. Can someone walk me throught this?

[mkeith1]

Hi, I'm trying to import a .csv file of new items, with all of the fields, except productId, and I'm getting this error message:

We are sorry for the inconvenience, but an error has occurred while loading CSV datafile.
Error Message: An item with the same key has already been added.

How do i overcome this?

[Naveed]

We are sorry for the inconvenience, but an error has occurred while loading CSV datafile.
Error Message: An item with the same key has already been added.

It seems that your CSV file is not in correct format...

Can you please share your csv file. I do not require complete file but just a few records that can re-produce the issue...
You can even send me that in PM, but it is better to share it on this forum, so that others can also avoid such issues in future..

[jmestep]

This might be too late in development to ask- does the dataport utility incorporate the admin user permissions? For example, if someone has limited permissions, will they be able to access site data outside of their permissions area?

[mkeith1]

Naveed, below is the sample file in excel 2003 format. I couldn't load a .csv file, so just open it and save as a .csv.

2008 concert band example.xls

[Naveed]

Naveed, below is the sample file in excel 2003 format. I couldn't load a .csv file, so just open it and save as a .csv.

2008 concert band example.xls

The file you have attached is not in CSV format... Here is how I converted it to proper CSV.

1. I opened it in Excel 2003 and then From file menu I chooses "Save as" option.
2. From the "Save as" dialog I selected the "Save as type" as "CSV (Comma delimited)(*.csv)" file type.
3. Excel showed me a warning something like "Do you want to keep the workbook in this format?" with some other details, I selected "Yes".
4. And closed the Ms Excel. It then prompts me to "Save the changes", You can select "Yes" or "No" and follow as Step # 3.

5. It will now save your file in correct CSV format and you can use that to upload using DataPort.

Here is your file in CSV format. I tried to upload it and was successful... All 4 products imported.
------------------------------
StoreId,Name,Price,CostOfGoods,MSRP,Weight,Length,Width,Height,Manufacturer,Sku,ModelNumber,DisplayPage,TaxCode,Shippable,WarehouseId,Warehouse,InventoryModeId,InStock,InStockWarningLevel,ThumbnailUrl,ThumbnailAltText,ImageUrl,ImageAltText,Summary,Description,ExtendedDescription,Vendor,ProductTemplate,IsFeatured,IsProhibited,AllowReviews,AllowBackorder,WrapGroup,ExcludeFromFeed,HtmlHead,DisablePurchase,MinQuantity,MaxQuantity,VisibilityId,Theme,IconUrl,IconAltText,IsGiftCertificate,Categories,UseVariablePrice,MinimumPrice,MaximumPrice,SearchKeywords,HidePrice,MSExcelWorkAround
1,Redhawk / Sean O'Loughlin - Concert Band,45,0,0,2,,,,Carl Fischer,CFNY BPS52,,,Taxable,Yes,1,Music Mart,0,0,0,~/Assets/Images/PUB_CFNY_t.jpg,Redhawk / Sean O'Loughlin - Concert Band,~/Assets/Images/PUB_CFNY.jpg,Redhawk / Sean O'Loughlin - Concert Band,Concert Band Arrangement,Grace 1 Concert Band,,,,FALSE,FALSE,FALSE,FALSE,,FALSE,,FALSE,0,0,0,,~/Assets/Images/PUB_CFNY_i.jpg,Redhawk / Sean O'Loughlin - Concert Band,FALSE,"Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:2008 Concert Band,Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:Concert Band Grades 1-2",FALSE,0,0,,FALSE,Do not delete
1,"Santa's Noisy Workshop / Traditional, Arr. Larry Clark - Concert Band",45,0,0,2,,,,Carl Fischer,CFNY BPS54,,,Taxable,Yes,1,Music Mart,0,0,0,~/Assets/Images/PUB_CFNY_t.jpg,"Santa's Noisy Workshop / Traditional, Arr. Larry Clark - Concert Band",~/Assets/Images/PUB_CFNY.jpg,"Santa's Noisy Workshop / Traditional, Arr. Larry Clark - Concert Band",Concert Band Arrangement,Grace 1 Concert Band,,,,FALSE,FALSE,FALSE,FALSE,,FALSE,,FALSE,0,0,0,,~/Assets/Images/PUB_CFNY_i.jpg,"Santa's Noisy Workshop / Traditional, Arr. Larry Clark - Concert Band",FALSE,"Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:2008 Concert Band,Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:Concert Band Grades 1-2",FALSE,0,0,,FALSE,Do not delete
1,Shockwave / Larry Clark - Concert Band,45,0,0,2,,,,Carl Fischer,CFNY BPS51,,,Taxable,Yes,1,Music Mart,0,0,0,~/Assets/Images/PUB_CFNY_t.jpg,Shockwave / Larry Clark - Concert Band,~/Assets/Images/PUB_CFNY.jpg,Shockwave / Larry Clark - Concert Band,Concert Band Arrangement,Grace 1 Concert Band,,,,FALSE,FALSE,FALSE,FALSE,,FALSE,,FALSE,0,0,0,,~/Assets/Images/PUB_CFNY_i.jpg,Shockwave / Larry Clark - Concert Band,FALSE,"Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:2008 Concert Band,Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:Concert Band Grades 1-2",FALSE,0,0,,FALSE,Do not delete
1,Quadritium / Mike Forbes - Concert Band,45,0,0,2,,,,Carl Fischer,CFNY BPS53,,,Taxable,Yes,1,Music Mart,0,0,0,~/Assets/Images/PUB_CFNY_t.jpg,Quadritium / Mike Forbes - Concert Band,~/Assets/Images/PUB_CFNY.jpg,Quadritium / Mike Forbes - Concert Band,Concert Band Arrangement,Grace 1 Concert Band,,,,FALSE,FALSE,FALSE,FALSE,,FALSE,,FALSE,0,0,0,,~/Assets/Images/PUB_CFNY_i.jpg,Quadritium / Mike Forbes - Concert Band,FALSE,"Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:2008 Concert Band,Band/Orchestra/Ensemble:Concert Band/Symphonic Band Music:Concert Band Grades 1-2",FALSE,0,0,,FALSE,Do not delete

[Naveed]

This might be too late in development to ask- does the dataport utility incorporate the admin user permissions? For example, if someone has limited permissions, will they be able to access site data outside of their permissions area?

No, the DataPort does not care for admin user permissions.. Any type of admin user can connect using DataPort..

I have put an enhancement request to bugzilla to update the DataPort to only allow admin users of certain types to connect using DataPort.

[sohaib]

There is a proposed enhancement to add a new role 'DataPort' particularly for the data client utility.

[mkeith1]

Naveed, with regards to

The file you have attached is not in CSV format... Here is how I converted it to proper CSV.

1. I opened it in Excel 2003 and then From file menu I chooses "Save as" option.
2. From the "Save as" dialog I selected the "Save as type" as "CSV (Comma delimited)(*.csv)" file type.
3. Excel showed me a warning something like "Do you want to keep the workbook in this format?" with some other details, I selected "Yes".
4. And closed the Ms Excel. It then prompts me to "Save the changes", You can select "Yes" or "No" and follow as Step # 3

Yes, i know how to convert and .xls file to a .csv file, i've done this hundreds of times, (as Judy says, "Been There, Done That" ),
I was having problems uploading the .csv file to the list serve, not to our database using the dataport. this problem has only occurred recently, and i was hoping for an explanation, but I'm glad the import into your database was successful.

Also, for testing of the new dataport, if you like i can provide you with a MUCH larger file with thousands of records. I can provide this in an AC5.5 xml file.

[Naveed]

I was having problems uploading the .csv file to the list serve, not to our database using the dataport. this problem has only occurred recently, and i was hoping for an explanation

Unfortunately I am unable to understand the problem you are facing.. Please explain in more details....

By the way, in the file, are all of the necessary fields included for a successful, error free import?

Yes.
Here you can find more about the required fields for product CSV import:
http://wiki.ablecommerce.com/index.php/ ... CSV_import:

Also, for testing of the new dataport, if you like i can provide you with a MUCH larger file with thousands of records.

Thanks,
I hope it is a AC55 exported xml file. You can email me the file for testing..

[mkeith1]

while trying to load a new records file in .csv format this error occurred:

Authentication Error

Authentication Failed. An unknow error occured while processing request. Exception Message: There is an error in XML document (111, 30).
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(String requestXm.)
at ClientApiService.ProcessRequest(HttpContext Context)

any ideas what it means?

[KCarlson]

I have two issues. First, I am trying to download data for fulfillment on Data Port. I cannot see any easy way to get order item data out per order. I saw another thread on this, but did not see any suggestions or solutions. While I was looking at this, I was trying downloads, and are repeatedly getting this error.

Saved at: Wednesday, September 17, 2008
----------------------------

Title: Error occurred while exporting store
----------------------------

Summary: Some error has occurred while exporting store data.
----------------------------

Detailed Message: There is an error in XML document (8274, 42).
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
at System.Xml.Serialization.XmlSerializer.Deserialize(TextReader textReader)
at CommerceBuilder.DataClient.Api.EncodeHelper.Deserialize(String Xml, Type ThisType, Boolean defaultNull)
at CommerceBuilder.DataClient.Api.EncodeHelper.Deserialize(String Xml, Type ThisType)
at CommerceBuilder.DataClient.Client.Controls.StandardExportPanel.doExport()

[Naveed]

Please make sure you have uploaded the latest files provided with the DataPort v. 1.0.0.19 to your webserver at correct location..

[KCarlson]

I am pretty sure I have the latest. I noticed that the service release updated the ClientAPIService.ashx file. Should I replace that one with the one from the Data Port release from June?

[Naveed]

I am pretty sure I have the latest. I noticed that the service release updated the ClientAPIService.ashx file. Should I replace that one with the one from the Data Port release from June?

If you are able to successfully connect to your webserver using DataPort .19 then you dont need to worry about the wrong version of ClientAPIService.ashx file.

Can you export the customized orders, users, and products... Can you describe the situation in more detail in which the DataPort giving this error.. I think you are trying to download Orders using Customized Order Download feature.. If yes then what criteria you are using on first screen and in which format you are trying to download??

[gdelorey@mitcs.com]

I just got done setting up a 7.0 store and migrating all of my 5.5 data over. Everything worked great, but my order numbers are off by quite a bit. Is this a known bug or did I do something wrong?

Thanks,

: Greg

[Naveed]

my order numbers are off by quite a bit. Is this a known bug or did I do something wrong?

Thanks,

: Greg

Yes, this was one of the limitations, The preserve Id feature for OrderNumbers was not implemented for DataPort version 1.0.0.19

However there is a good news for the customers who want to move their stores to AC7. The next version contains this Preserve ID feature for Order Numbers. As we are testing the DataPort with great details and there are about 30-40 bug fixes regarding AC55 data import and many new enhancements :

Preserve ID feature for Users and Orders
Gift Certificates Import.
ESD's Import.
Updated/ Fixed Kit Products Import
OrderStatus Import Fix
Categories Sort Order Fix
Catalog Items Visibility Fix
And many other bug fixes.

And thanks to Katie for a complete user manual for migrating from AC55 to AC7, with all the steps and instructions.

There are many other enhancements like:
DataPort API and Store Version Detection
User CSV import/export with password and Address information

Testing of DataPort is in final phase, and we will be releasing it very soon..

[mkeith1]

Naveed said:

Please make sure you have uploaded the latest files provided with the DataPort v. 1.0.0.19 to your webserver at correct location..

I've been loading files in the same .csv format for last 3 month using version .19. This error occasionally pops up.

[Naveed]

I've been loading files in the same .csv format for last 3 month using version .19. This error occasionally pops up.

please share some .csv file with which you are able to reproduced the problem constantly..

[draneb]

Hello,

I notice it hasn't been too long since your post about the release of a new dataport utility.
I was just wondering if you have any more information since your last post?

I had a 5.5 store imported into AC 7 and my order numbers are all thrown off. I am looking to go live very soon (I am hoping perhaps a week) so now would be the time to try and get it right before I go live.

About the only thing I can do with dataport .19 is login successfully. I tried exporting one product just so I could see the format and I got an error. I tried to upload some products from 5.5 and got an error. I didn't write the error messages down because I thought I would just wait for the new release and hope that fixes everything.

Thank you,
Benard

[AbleBody]

Hi Mike/Logan,
Are we getting an updated Dataport utility soon? We are unable to export any products/categories out of the AC 7 store (the store is updated to latest Service Release 1 version) using this utility - we get the following error... pl. let us know when we can expect an updated version... thanks!

One thing I did was to filter by category on Step 1 to select one category...

-sri
sri@awcs.net

[jmestep]

I got a similar error the other day, but I thought something was wrong with our data. I'll try to remember/test to see what I was doing and run it again.