1. soura123
  2. RO CSVI
  3. Thursday, 14 March 2019
  4.  Subscribe via email
hello
i had 5.21 version and i update to 7.11
so i had to create every template from scratch
everything working great just some notices and issues i have now that i didnt on 5.21 version

1. i attach log.. on exoirt orders i have set a shopperfield customer_comments that does export the data of shiipping column http://prntscr.com/mxquy8
but i want to export the billing column (normaly is the same thing, but i use to edit comment for the shipping company)
i try billing_customer_notes but empty... so this is my first issue
2. the second issue is that the order export does not ordering the orders from latest to older , i dont remeber how i fix this on the 5.21 version, my first column is the virtuemart_order_id

thanks in advanced
Accepted Answer Pending Moderation
Hello,

So I created a template as well for orders using a custom field and the billing_Remark and Remark columns both have my billing data in it. Is any field filled or are all fields empty? Does changing the Order address type make any difference?

As for your second issue, have a look at the Use of group by and sort by fields tutorial.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
i fix the second issue
i group and sort every template by virtuemart_order_id
and it is ok
...
for the first issue what ever i tried nothing works
http://prntscr.com/mxwnfd
it exports the right column only
and i want the left one (the one that i edit and save)
i try every field (maybe sth happen) http://prntscr.com/mxwo5f
but still i get only
http://prntscr.com/mxwogk
what ever is written on the right column
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
i try this:
i made an order i add a comment:
"im john and im well"
i make an export and all fileds of comments are blank
then i go to my order and i change on the billing section the comment to sth else and i save the order
i make again export and now the fields that is blank is the billing fields and it export the shipping comment (the original)
this is a little bit strange do you think?
i attach the last log file
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

One issue I still see in the debug log is this:
AND `user_info1`.`address_type` = 'BT'
This means you are asking to export only the BT (billing) rows. This leaves out the ST (shipping) rows. If you set the Order address type to Don't use do you get more data in your export file?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
i set the address type to dont use
but didnt change anything to comment (i attach the log)
i use the billing sectiong because user wrote lowercase miss spelling etc.. so i edit correctly the address and others on the billing section (and the comments) and use those to export and fix the vouchers for shipping
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
solved
thanks to rolandd and his patch
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

The patch will be included in the next release of CSVI.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
although with this patch when i import order update history i get this: multiple times
http://prntscr.com/myc6d5
tommorow i will send you a log file of this if it done it again
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,

Are you sure it is related to the patch? The patch is in regards to the export and this is the import. What is the screenshot of? I don't get where this is in VirtueMart.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
before the patch the import was ok
it is inside the virtuemart order on the comment
i have enalbe log and when i get the new voucher and do it again i will send the log
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
ok this continues the problem i described
i attach the log to check
this is what happened
http://prntscr.com/n02mjz

this is my setup
http://prntscr.com/n02mrl
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
you have the time to check it out?
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,

Speaking of the devil ;) I was just checking it out but the information is very limited, there is no debug log either. Are you doing an order import or an order item import?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
i m doing http://prntscr.com/n11uan
is the log file i attach wrong? what i have to send to check it?
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,

The log file is not wrong. I overlooked it because of the screenprints in the message. I am getting old :)

What you see about unknown order status is because you are not including an order status. By using the custom table import you circumvent all the checks we build into the order import.

Since you are doing your own import, you have to make sure all the requirements are met. One of them is that you need to include the order_status_code field. Add that field and see how it goes.

The custom table does no integrity checking because it has no clue about the table requirements.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
the weird is that on 5.21 version (years now) it was working with no such problems
and on other sites i have the same setup with 7.11 and make an import in one line no multiples///
basically i dont need a status code i just want that text i import and i copy paste after to trigger the mail to shopper with that text... i just dont want so many imports with no use and make the order list too long and so difficult to use
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,

Are you using the same VirtueMart version with that 5.21 version?

CSVI is not doing anything extra here, only what you ask it to do. That is add 1 line in the order status table. You can see that in the debug log as well
INSERT INTO `proteon_virtuemart_order_histories` (`virtuemart_order_id`,`comments`) VALUES  ('59489','Σας ενημερώνουμε ότι η παραγγελία σας έχει αποσταλεί. Αναζητήστε online την παραγγελία σας μέσω της Γενικής Ταχυδρομικής πατώντας εδώ: http://www.taxydromiki.gr/track/4030678304. Σε περίπτωση που χρειαστείτε οποιαδήποτε επιπλέον πληροφορία μην διστάσετε να επικοινωνήσετε μαζί μας στο τηλέφωνο 2811 754464 ή μέσω μηνύματος στο email info@proteon.gr. Ευχαριστούμε πολύ, Η ομάδα του proteon.gr.Σας ευχαριστούμε πολύ για την εμπιστοσύνη σας. Προκειμένου να γίνουμε ακόμα καλύτεροι θα παρακαλούσαμε για την δική σας βοήθεια:Εάν μείνατε ευχαριστημένοι από την εξυπηρέτηση μας, θα εκτιμούσαμε πολύ, αν αφιερώνατε λίγο από τον χρόνο σας, γράφοντας μία θετική κριτική για το κατάστημα μας πατώντας το ακόλουθο link: https://bit.ly/2z4nSe2')


For every record there is a line like that. I don't see how you can get multiple lines for the same order unless that order was imported multiple times.

This is also VirtueMart saying they are missing this order status and not CSVI.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
i set file for configuration to NO and skip first line to YES
and it is fixed
go figure
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,

That settings uses your template fields that you linked to the template rather than using what it finds in the import file.

Glad to hear it is solved :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 19
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!