Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
en.osm.town is one of the many independent Mastodon servers you can use to participate in the fediverse.
An independent, community of OpenStreetMap people on the Fediverse/Mastodon. Funding graciously provided by the OpenStreetMap Foundation.

Administered by:

Server stats:

251
active users

en.osm.town: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

Public
RussEby

@villares

Biggest issue I have for Excel creating CSV files, is that Excel has a habit of adding empty rows at the bottom if the Excel file had rows deleted. The CSV will end up with rows with just commas on them.

The ERP we use will choke on those empty rows. I then need to remove them up in an editor.

Public
Alexandre B A Villares 🐍

@mdione @RussEby Marcos, don't be that guy... People have to work around stuff they have little control over and had no choice having to use most of the time. I can imagine why an old ERP is not expecting "empty" comma filled lines, and then, some "dev around ERPs" stuff I've seen is like adversarial adaptations, because the ERP vendor doesn't want you to integrate freely with it.

Public
Voz dos Direitos Digitais

@villares @mdione @RussEby as someone who created plenty ETL systems, I have to agree with him, the CRM should be able to handle that.

Quiet public *
Alexandre B A Villares 🐍

@vdd @mdione @RussEby ERP != CRM... and "should" to our benefit, surely... As I said, ERP vendors usually don't want interoperability, they want to sell you "another module"

Curious, what is ETL?

Quiet public
RussEby

@villares @vdd @mdione

Most of my CSVs, I create using Python and don't have issues.

Where the problem comes up is when others are trying to load a CSV and it shows 400 'failures' out of 900 and they were only trying to load 500 rows.

I have to explain that the 'failures' are the empty rows and can be ignored. Unless some of the records did fail and then I need to filter the results for them so they can corrected and reuploaded.

ExploreLive feeds
About