Import_asset_csv_to_matrix.php problems

(Andrew Harris) #1

I'm having problems with this import script. Creating new assets is working fine, but I can't get it to update existing assets. The documentation on this latter aspect is 'thin' and my guesses, so far, seem to have missed the target.

 

It appears to come down to the optional items in the command: (unique field name) (add edit delete field name).

So, my spreadsheet contains a column titled "SiteID" where I put the asset ID of the existing asset that I wish to update.

It also contains a column titled "Action" where I put the value "E" for edit. (Though this seems to be redundant given that I'm supplying the ID of an existing asset)

 

I then run my command which supplying the status tag (probably not necessary), and the labels for the unique ID, and the operation.

…[other parameters - all working fine]… 0 SiteID Action

 

But instead of editing the existing assets, I get a bunch of new ones created, (albeit with all the right parameters!).

 

Anyone got any ideas?

(Anthony Ponomarenko) #2

Hey there,

 

Can you let us know what version you are working with.

(Anthony Ponomarenko) #3

Also does the delete functionality of the script work?

 

That is why you have to have the value of E set, if you have D it should delete the asset.

 

If edit and delete do not work, this narrows down the issue significantly.

(Andrew Harris) #4

Anthony, it's a Squiz hosted v5.1.4.0 - I actually raised a support ticket for it #59688

Haven't tried the delete functionality.

(Anthony Ponomarenko) #5

Sweet, hopefully they can resolve it, if not it cross my path soon.