Display Serial Data and add QR with other value

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #144908

-- url of the page with the problem -- : mywebsite.com/mypage
-- HikaShop version -- : x.x.x
-- Joomla version -- : x.x
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

Hello,
How can I display the serial data and add on the same image a QR with some other values?
I am sending the user a login and password to specific account and let him generate auto-configuration for his mobile using the QR.

Thanks,
Ron

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #144960

Hi,

In the "attach serial" plugin you can add new "entries" and select the data you want to display for that entry.
It can be something already defined (like the "Serial Data") or it can be something dynamic depending the order, product, serial or order user.
www.hikashop.com/support/documentation.h...ns-attachserial-form

The plugin "attach serial" doesn't access to the Joomla user and it can't access to the password.
I am not sure of what your want to do exactly so it is difficult to me to provide you a precise answer.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145005

Hi Jerome,
Let me try to explain...
We are a VoIP providers and we sell Calling Cards and VoIP accounts using Hika Shop and Hika Serial.
we have different types of serial pak's uploaded the contain user/password and some other account information.

We added a new Phone Application to our system, this phone get's all configuration info from a QR and releasing the user from the need of dealing with configuration. at the same time we want the user to have the info in text view. i attached sample image containing fields for the account information and QR.
so we have one row of serial data that displays the account information and it works fine.
when we try to add QR code on the same "attach serial" we have 2 problems:
1 - how to add the text field to the same pack ? (must be the same user)
2. - how to display on the same image both, the text field and the QR

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145087

Hi,

In your attach serial configuration, you can add new "entries", so you can display the QRcode and the text, using two lines in the configuration.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145090

Excellent ... Fantastic .....
How ?
I tried and it didn't work for me, that is exactly why i asked in this forum, how i set the Pack to have this additional text for the QR and how will loo like the attached serial extra line to generate the QR?
Please guide me.

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145094

Hi,

Please provide me a screenshot of your attach serial configuration.
I do not understand what you do not understand.

We have two tutorial which could help you:
www.hikashop.com/support/documentation/2...serial-tutorial.html
www.hikashop.com/support/documentation/2...ticket-tutorial.html

But for the moment, because I do not understand what is your problem with the attach serial plugin, I just can't provide you an useful answer.
You just have to click on the "+" button to add a new entry line and configure the line like you want, with the format you want.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145102

Maybe i didn't explained it right, I will try again:
the outcome needs to be an image with 1 field containing the serial data (which is per-defined user and pin code) and a QR that contain a string with the user and pin code as well.
The pack should look like...?:
pack_name,serial_data,4QR_extra_data
withQR,999999999,aiAVvaw3,crc:999999999:aiAVvaw3@GATEIP-QR-PHONE

so the uploaded serials will have 2 sources
1 - will display the serial data field (999999999 aiAVvaw3)
2 - will display a QR code built up from another field (crc:999999999:aiAVvaw3@GATEIP-QR-PHONE)

The attached serial configuration to pick the serial data is working fine as long as there is no extra fields so my questions are:
1 - how would I write the new Pack and the uploaded file so the to add "4QR_extra_data" filed will show up on the serial list of the Pack
2. - Ho would I write the attached serial so this QR will pick the right data and display the QR on the image.

please let me know if i managed to explain the case.

Thank you.

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145167

Hi,

Thanks for the explanation.

So you are using the "serial data" and some information into the "extra data".
For the QRCode, I will recommend you to use the "dynamic text" container and give him this for the display content:

{serial.extradata.crc}

About the serial, you should have some like that during the export
"id";"serial_data";"pack";"serial_extradata"
308;"999999999,aiAVvaw3";"withQR";"a:1:{s:3:""crc"";s:34:""999999999:aiAVvaw3@GATEIP-QR-PHONE"";}"
The extra data is a serialized PHP array. It allow you to store a lot of information with the serial without having to create new columns in the database.
The plugin "attach serial" support the extra data and thankx to the link above, you can see how to access to a special extradata (using is namekey).

Hope these explanations will help you.
Do not hesitate to ask for precision if require.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145283

Jerome
Maybe i am not doing it right ... but nothing works for me.
I cannot upload into a pack and cannot generate this way.

the only way i managed to do it is:
when i create a serial manually (one by one) and place the crc:xxxx:xxxx@GATEIP-QR-PHONE
and on the attach serial using "Translation" and the field set to {serial_extradata}

I need help to set the csv file correctly so the crc data will be added to the extradata fied.

Thanks,

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145345

Hi,

You can use it for the CSV file.

"serial_data";"pack_name";"serial_extradata"
"999999999,aiAVvaw3";"withQR";"a:1:{s:3:""crc"";s:34:""999999999:aiAVvaw3@GATEIP-QR-PHONE"";}"
I test it though the import text (with the option to import it as a CSV file) and it worked fine.
If your CRC have always the same length, it should be easier for you to generate the serialized string for the extra data (you will just have to change the content, not the values around the crc content).

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145373

Jerome
Please try to import CSV file with few records - it's just not working.
when you enter a single line in the text box of the import - yes it works.
We need to upload 8 packages with no less then 500 records on each, we cannot do a single line text import, we needed to import files.

Thanks,
Ron.

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145387

Hi,

Can you please provide me a CSV sample ?
I made several tests for the CSV import and I find a potential bug. I just made a new 1.8.1 package.
After that, I used the test file attach here. It worked good for me.
So I have good feeling that with the modification, you should be able to import your 500 serials.

I will see to improve the import system in order to add the possibility to put extra_data as separated columns ; at this moment the export will create the array and do the serialization itself.
But it will be for the next release, 1.8.2 I guess.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145422

Hi Jerome,
I added 4 samples (data versions) of CSV files.
the main serial uploded fine, but the extra data not.

I really hope you can find a way to make it works, it's highly important.

Thank you.
Ron

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145443

Hi,

h3f1c2b8.csv
The file content is invalid. It is not a valid CSV file, the quotes are wrong, even in the csv header.

h803e08d.csv & h2480c3b.csv
It is not right for the quotes, most does not have quotes but only one have, it is not homogenized.
More than thant the quotes are wrong, there are too many double quoting in the extra data column.

h9d0f637.csv
It is the best file between the fours. The quotes are not perfect but it should be imported correctly.

After that, the content of the last column is not right.
As I told you, the extradata column should contain a serialized PHP array.
Like the CSV file, it should respect the rules. There is a ";s:34;" just before the CRC content, it indicates that the content just after is a String with a length of 34 characters.
But the CRC content is 39 characters length. So even if the content is right imported, the serialized content wouldn't be unserialized correctly by HikaSerial. And an empty result will be return.

I understand that you think there is an import problem but if the file does not respect the CSV format rules, HikaSerial won't be able to read the file correctly.

I understand that importing the extradata is not easy for the moment but like I said in my previous message, it is something that I will improve.
For the moment, we have to follow some strict rules in order to be sure that the serials will be right imported and right understand after the import.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
10 years 1 month ago #145461

Hi,

I finally finished the modification of the import system.
The extradata is now supported during the import and will serialized the data directly.
You can re-download HikaSerial 1.8.1 and use this kind of data during the import

serial_data,pack_name,extradata.crc,extradata.test
"999999999,aiAVvaw3","withQR","999999999:aiAVvaw3@GATEIP-QR-PHONE","test data"
"888888888,aiAVvaw3","withQR","1234567890:aiAVvaw3@GATEIP-QR-PHONE",""
"777777777,aiAVvaw3","withQR","6666666:aiAVvaw3@GATEIP-QR-PHONE",""

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: RonyG

Please Log in or Create an account to join the conversation.

  • Posts: 13
  • Thank you received: 0
10 years 1 month ago #145479

Jerome,
I have no words... Thank you.
Great support.
THANKS

Ron.

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.085 seconds
Powered by Kunena Forum