This topic contains 4 replies, has 0 voices, and was last updated by Anonymous 2 years ago.
- June 22, 2016 at 9:57 am #735
I’m still using your application on a server and it’s working perfectly. I just have one question regarding tariffs imports (both customer/provider) that is still giving some “problems”.
When trying to import some rate files, sometimes I’m getting a white page after loading the CSV file, that means that there was a SQL error on PG. This is confirmed looking at postgres.log files.
The errors I found can be duplicated ID or duplicated Prefix.
I’m asking you if you can change the import procedure avoiding inserting the ID as column or if you can show SQL errors on result page so the errors can be identified by the “common user”. This will simplify too much the importing procedure.
BTW, thank you for your great work, your system is really cool!
- June 22, 2016 at 10:04 am #934
This is a known issue. I have to let this constraint to avoid unwanted routing/billing, but i need to change this script. The work is in progress, but not so easy.
- June 22, 2016 at 10:19 am #935
Yes, I know it’s not so easy as a programmer I can understand you. Sometimes there are functions that seems easy to do/fix but they involve too many variables to consider, anyway I have just some suggestions (if possible of course) in the meanwhile:
1. On provider rate view can you show somewhere in the page the last ID? The ID is clearly shown on Customer rates view
2. Can you show SQL errors instead of a blank page?
Thank you for your support
- June 22, 2016 at 1:26 pm #938
I have added the Id in provider rates view.
I will check for the others suggestions.
This how i manage :
– when i need to modify some rates, i select the right destination / provider ratecard and export the files. I change only the needed field and keep the others ones unchanged, and i import the modified file
– when i need to add new rate, i have empty file with hearders, and i keep the id field empty. The system will add the right value. So no need, to know the last id in DB.
- June 23, 2016 at 7:23 am #939
Great! Thanks! I will try to import a new rate without the ID because I actually never tested it.
Thank you for your fix and for your hard work, merçi beaucoup!
You must be logged in to reply to this topic.
- Click to share on Twitter (Opens in new window)
- Click to share on Facebook (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to share on Tumblr (Opens in new window)
- Click to share on WhatsApp (Opens in new window)
- Click to share on Reddit (Opens in new window)
- Click to share on Telegram (Opens in new window)