4 ms·
Needed to get data out of a CRM system for specific printed orders - when it was printed, who processed it, what was on the order etc. The process of authentic
by hennell 3y ago
Needed to get data out of a CRM system for specific printed orders - when it was printed, who processed it, what was on the order etc.
The process of authenticating with the CRM was complex and there wasn't a way to get anything at print time and most of the data was stored all over the place.
But I found the printed report knew almost everything I wanted, and you could add web images to the paperwork system. So I added a tiny image with variable names like "{order_number}.jpg?ref={XXX}&per={YYY}" and then one for each looped product like {order_number}/{sku}.jpg?count={X}&text=..." etc. After a few stupid issues (like no support for https, and numbers sometimes being european format) it was working and has remained solid ever since. Live time stamped data, updates if people print twice, gives us everything we wanted just by a very silly method.
- azalemeth 3y agoAs a European I'd like to know how our numbers are differently formatted to yours! (Did you mean dates? The never ending source of pain!)
- gia_ferrari 3y agoTo me (USA) 1,000 is one thousand and 1.000 is one, and to me (Italian) 1,000 is one and 1.000 is one thousand :)
- azalemeth 3y agoAhh, that one. Do'h!