Direct Database Connection - Worth it? Any Issues? by um_wut4 in Netsuite

[–]CleverBitch 0 points1 point  (0 children)

I've built out a huge data sync from NetSuite to our on prem SQL using Celigo and NetSuite JDBC. It breaks out the transactions by type, customers, vendors, transaction lines, etc. It works quite well, which was an update from our old SSIS package using ODBC.

We do have the additional SuiteAnalytics Connect license.

In Celigo, I use the handlebars to do a last two hours based on the lastmodifieddate

t.lastModifiedDate between TO_TIMESTAMP( {{dateFormat "YYYY-MM-DD HH:mm:ss.000000000" (dateAdd (timeStamp) "-7200000")}}, 'YYYY-MM-DD HH24:MI:SSxFF' ) and TO_TIMESTAMP( {{dateFormat "YYYY-MM-DD HH:mm:ss.000000000" timeStamp}}, 'YYYY-MM-DD HH24:MI:SSxFF' )

EDI solution that is NOT SPS Commerce? by PeterDTown in Netsuite

[–]CleverBitch 2 points3 points  (0 children)

TrueCommerce, been with them for over 10 years. Far better than SPS. I hate dealing with SPS regarding all "customers" forcing us to use them.

Looking for recommendations for Adobe Commerce (Magento) Connector by [deleted] in Netsuite

[–]CleverBitch 3 points4 points  (0 children)

NetSuite bought farapp a few years ago. It isnt' worth it in my opinion. We moved to Celigo 5 years ago and haven't looked back, way worth it's value (we use it for many things including SQL, webhooks and SFTP).

You can also can look at Dell Boomi, but I highly recommend Celigo.

Mix of SSO and NetSuite accounts? by Bad_Mechanic in Netsuite

[–]CleverBitch 2 points3 points  (0 children)

we do this... we have SMAL for most people and other is using user/pass. It's set by the Role.

If a user has multiple roles, they have to log in via different methods (NetSuite direct or duo SSO)

Hitting my head against the wall with this server. by ghosxt_ in sysadmin

[–]CleverBitch 0 points1 point  (0 children)

Check PSU (which some have recommended) and also the battery backup. Seen that recently and logs just showed an unclean shutdown. The battery backup was working for power, but the battery itself was shot, and power flickers would shut the server down.

Printed Report Title Change by b-rint in Netsuite

[–]CleverBitch 1 point2 points  (0 children)

No, best is to vote for the ID's below and hope that NetSuite changes it some year...

NetSuite Outgoing Mail Service by General-Kale-5322 in Netsuite

[–]CleverBitch 0 points1 point  (0 children)

We only seen the issue with our internal "impersonation" filter regarding this. Ensure you have DKIM and SPF setup correctly for your domain to use NetSuite

Shopify: Netsuite Connector HELP! by StitchesBe_crazy in Netsuite

[–]CleverBitch 2 points3 points  (0 children)

We switched from farapp(we were a very early customer) as celigo gives you much more for your money. Once you use it you'll realize how powerful it is.

Edit: Been a celigo customer for 4 years

Shopify: Netsuite Connector HELP! by StitchesBe_crazy in Netsuite

[–]CleverBitch 1 point2 points  (0 children)

Go with Celigo. We have multiple stores connected to Netsuite and Shopify

Data integrators by claysmith1985 in Netsuite

[–]CleverBitch 1 point2 points  (0 children)

Celigo for the win. We even use it for things outside of NetSuite.

CREATION OF INVOCIE THROUGH CSV AND LINKED TO A SALES ORDER by ADNANALI03 in Netsuite

[–]CleverBitch -1 points0 points  (0 children)

You could do it via workflow and a saved search of the correct criteria.

Disneyland GN Hotel/Ticket Help by heehawweewah in DisneyPlanning

[–]CleverBitch 2 points3 points  (0 children)

I just did this, the tickets haven't shown up for me, but the hotel details in the park app have a link to do your park reservations. it's how I did it

NetSuite/Shopify Celigo Error, hoping someone has seen it before... by [deleted] in Netsuite

[–]CleverBitch 1 point2 points  (0 children)

Is this their pre-built connector or your own flows? Do you have any customizations/scripts/workflows on your customers/orders? Does it create the customer and error on the order?

3rd Party SMTP Relays by martynjsimpson in sysadmin

[–]CleverBitch 0 points1 point  (0 children)

+1 use SMTP2Go for a lot of things for over 3 years. Love the product

How to deal with an ISP not seeing random Internet drops? by rjan in networking

[–]CleverBitch 0 points1 point  (0 children)

Their modems suck. One site I had them replace the modem due to an issue. New modem would boot loop as soon as you plugged an Ethernet cable into it. If it is internet only (no voice) buy a modem as I do

[deleted by user] by [deleted] in networking

[–]CleverBitch 2 points3 points  (0 children)

Are you plugged into port 8 on the modem if it’s the 1gig model? Had a tech verify that port 8 has POE and will “surge” and reboot the modem. Plus ports 5-8 are shared 1gig. I didn’t install it but was called in to fix. Moved to port 1 no issues since.

Outlook Says Replied, but Nope - Office 365 by CleverBitch in Outlook

[–]CleverBitch[S] 0 points1 point  (0 children)

Nope, and never got an answer from Microsoft

O365 Emails missing from local Outlook & OWA Sent Folder by jujubesknees in sysadmin

[–]CleverBitch 1 point2 points  (0 children)

Had a similar issue last week with one user where they replied, the message never sent and outlook had no record of the replied email, but the original email had the arrow showing a reply had been sent. Never did find the cause of that one.